.
contact contact


query3k utility

» Usage | Notes | Examples | See also
 
.
  The Eloquence QUERY3K utility is intended as a replacement for the MPE QUERY/iX utility. It may be used to access Eloquence database contents without programming.

Usage

usage: query3k [options]

QUERY3K command-line options:
 
   BATCH       (also implies NOINTER, NODUPLIC)
   [no]DUPLICactive
   NOFORCEDUPLICactive
   HELP
   [no]INTERactive
   NOFORCEINTERactive
   NOCI        disallow CI commands
   NOTPI       disable all Third Party Indexing
   SESSION     (also implies INTERACTIVE, DUPLICATIVE)
   VERBOSE     enable verbose mode
   VERSION     output QUERY3K version
   VERSIONS    output QUERY3K version details
   XEQ filename

QUERY3K is designed to be closely compatible and to require only minimal changes to existing QUERY scripts. However, as QUERY3K does not run on top of MPE some minor changes may be required to adapt your existing QUERY scripts to the system environment.

The options (which may be specified with or without leading hyphen) are:

-help
The -help option displays a brief help text.

BATCH
The BATCH option makes query3k behave as if run in a batch job. This impacts the displaying of prompts, input echo, progress messages, or program aborting behavior on errors, for example.

SESSION
The SESSION option makes query3k behave as if run in a session. This impacts the displaying of prompts, input echo, progress messages, or program aborting behavior on errors, for example.

[NO]DUPLICactive
The [NO]DUPLICactive option is only used for diagnostic purposes.

NOFORCEDUPLICactive
The NOFORCEDUPLICactive option is only used for diagnostic purposes.

[NO]INTERactive
The [NO]INTERactive option is only used for diagnostic purposes.

NOFORCEINTERactive
The NOFORCEINTERactive option is only used for diagnostic purposes.

NOCI
The NOCI option disables the use of ": commands" in the query3k session.

NOTPI
The NOTPI option disables the use of TPI calls.

VERBOSE
The VERBOSE option enables verbose messages such as progress messages for FIND, SUBSET or MULTIFIND commands (also see HELP VERBOSE vs HELP TERSE inside query3k).

VERSION
The VERSION option displays the query3k version number.

VERSIONS
The VERSION option displays the query3k program and library version numbers

XEQ filename
The XEQ option executes a query3k script. Also see HELP XEQ inside query3k.

Notes

The options BATCH, SESSION, [NO]DUPLICactive, NOFORCEDUPLICactive, [NO]INTERactive, and NOFORCEINTERactive are mostly useful for diagnostic purposes. The query3k program checks whether it is run from an interactive terminal (or with redirected stdin) and uses reasonable defaults accordingly. Some commands are only available or behave differently when query3k is run in an interactive terminal session.

Examples

The example below displays query3k program and library version numbers:
$ query3k -versions

QUERY3K application revision:
     B.08.20.00 (20110525)

Eloquence library revision:
     IMAGE3K B.08.20.00
     ELOQDB  B.08.20.00

SORT:
     Redstone SORT 2005-03-30
The example below invokes query3k interactively:
$ query3k

B.08.20.00 Eloquence QUERY3K  MON, AUG 18, 2014,  2:20 PM 
Copyright 2004-2013 Marxmeier Software AG
Copyright 2004 Hewlett-Packard Development Company, L.P.

>base=toydb
PASSWORD = >>
MODE = >>5

>form sets

DATA BASE: TOYDB                        MON, AUG 18, 2014,  2:28 PM

DATA BASE LANGUAGE ATTRIBUTE: NATIVE-3000

                            ITEM   CURRENT   ENTRY    ENTRY   BLOCKING
SETS:                 TYPE  COUNT  CAPACITY  COUNT    LENGTH  FACTOR

   PRODUCTS           M     5      1456      10       15      0
   CUSTOMERS          M     10     229       8        130     0
   ORDER-MASTER       A     1      1456      15       4       0
   INVOICES           D     7      1149      1        20      0
   ORDERS             D     3      1771      15       9       0
   ORDER-DETAILS      D     4      1771      15       10      0

>exit
The example below invokes query3k with a script file:
$ query3k XEQ script

See also

Eloquence QUERY3K utility documentation.


 
 
 
  Privacy | GDPR / DSGVO | Webmaster | Terms of use | Impressum Revision: 2014-08-18  
  Copyright © 1995-2024 Marxmeier Software AG