PESQL(1)
NAME
pesql - pe sql command query
SYNOPSIS
pesql [-v] [-d] [-L] [-Oname] sql_cmd
DESCRIPTION
pesql queries a database, via dsds_svc, for the given sql
command.
pesql was mainly intended as a test program to test the
REQSQL call to dsds_svc which will be used by dohrsc and
other "pe map builder" programs which need information from
the database.
pesql is also a useful utility for ad hoc queries.
pesql is run as a pvm (Parallel Virtual Machine) task. A pvm
daemon will be started on the host if needed. A dsds_svc
will be started if needed.
sql_cmd is the sql command to execute. It must be enclosed
in quotes. For example: "select * from partn_avail". If you
also use the "where col_name = 'string'" syntax, you must
enclose string in single quotes (i.e. 'string').
OPTIONS
-v The verbose flag.
-d The debug flag. Runs the dsds_svc in debug mode with a
dbx window.
-L The local flag. Run local dsds_svc. Don't use pe_rpc.
This is for development use only and requires a pass-
word.
-Oname
The Oracle db to query instead of the default mdi_2X
db.
EXAMPLES
csh> pesql -Omdi_2 "select * from dsds_main where series_name = 'Fg0'"
dsds_svc currently running for db=mdi_2
Registered with dsds_svc as uid=159666
current_client: KEYTYP_LONG 270768992
pe_rpc_tid: KEYTYP_INT 263367
orig_pe_tid: KEYTYP_INT 268400
status_num: KEYTYP_INT 0
req_num: KEYTYP_INT 37
sql_cmd: KEYTYP_STRING select * from dsds_main where series_name =
pe_tid: KEYTYP_INT 266329
USER: KEYTYP_STRING jim
num_columns: KEYTYP_INT 29
column_0: KEYTYP_STRING PROG_NAME
column_1: KEYTYP_STRING PROG_NUM
column_2: KEYTYP_STRING LEVEL_NAME
column_3: KEYTYP_STRING LEVEL_NUM
column_4: KEYTYP_STRING SERIES_NAME
column_5: KEYTYP_STRING SERIES_NUM
column_6: KEYTYP_STRING SVC_VERSION
column_7: KEYTYP_STRING SVC_NAME
column_8: KEYTYP_STRING ONLINE_STATUS
column_9: KEYTYP_STRING ONLINE_LOC
column_10: KEYTYP_STRING ARCHIVE_STATUS
column_11: KEYTYP_STRING HISTORY_COMMENT
column_12: KEYTYP_STRING BYTES
column_13: KEYTYP_STRING DS_INDEX
column_14: KEYTYP_STRING CREATE_UID
column_15: KEYTYP_STRING CREAT_DATE
column_16: KEYTYP_STRING T_FIRST
column_17: KEYTYP_STRING T_LAST
column_18: KEYTYP_STRING USERNAME
column_19: KEYTYP_STRING ARCH_TAPE
column_20: KEYTYP_STRING ARCH_TAPE_POS
column_21: KEYTYP_STRING ARCH_TAPE_FN
column_22: KEYTYP_STRING ARCH_TAPE_DATE
column_23: KEYTYP_STRING WARNINGS
column_24: KEYTYP_STRING STATUS
column_25: KEYTYP_STRING SAFE_TAPE
column_26: KEYTYP_STRING SAFE_TAPE_POS
column_27: KEYTYP_STRING SAFE_TAPE_FN
column_28: KEYTYP_STRING SAFE_TAPE_DATE
PROG_NAME_0: KEYTYP_STRING cat
PROG_NUM_0: KEYTYP_STRING -1
LEVEL_NAME_0: KEYTYP_STRING lev0
LEVEL_NUM_0: KEYTYP_STRING 1
SERIES_NAME_0: KEYTYP_STRING Fg0
SERIES_NUM_0: KEYTYP_STRING -1
SVC_VERSION_0: KEYTYP_STRING V1R0B0
SVC_NAME_0: KEYTYP_STRING ingest_svc
ONLINE_STATUS_0: KEYTYP_STRING N
ONLINE_LOC_0: KEYTYP_STRING /PDS1/D72603
ARCHIVE_STATUS_0: KEYTYP_STRING Y
HISTORY_COMMENT_0: KEYTYP_STRING
BYTES_0: KEYTYP_STRING 544256
DS_INDEX_0: KEYTYP_STRING 1245
CREATE_UID_0: KEYTYP_STRING 10009
CREAT_DATE_0: KEYTYP_STRING 02-MAY-95
T_FIRST_0: KEYTYP_STRING -1
T_LAST_0: KEYTYP_STRING -1
USERNAME_0: KEYTYP_STRING mark
ARCH_TAPE_0: KEYTYP_STRING 2105001
ARCH_TAPE_POS_0: KEYTYP_STRING 12877
ARCH_TAPE_FN_0: KEYTYP_STRING 43
ARCH_TAPE_DATE_0: KEYTYP_STRING 18-AUG-95
WARNINGS_0: KEYTYP_STRING
STATUS_0: KEYTYP_STRING
SAFE_TAPE_0: KEYTYP_STRING
SAFE_TAPE_POS_0: KEYTYP_STRING
SAFE_TAPE_FN_0: KEYTYP_STRING
SAFE_TAPE_DATE_0: KEYTYP_STRING
PROG_NAME_1: KEYTYP_STRING cat
PROG_NUM_1: KEYTYP_STRING -1
LEVEL_NAME_1: KEYTYP_STRING lev0
LEVEL_NUM_1: KEYTYP_STRING 2
SERIES_NAME_1: KEYTYP_STRING Fg0
SERIES_NUM_1: KEYTYP_STRING -1
SVC_VERSION_1: KEYTYP_STRING V1R0B0
SVC_NAME_1: KEYTYP_STRING ingest_svc
ONLINE_STATUS_1: KEYTYP_STRING N
ONLINE_LOC_1: KEYTYP_STRING /PDS1/D115100
ARCHIVE_STATUS_1: KEYTYP_STRING Y
HISTORY_COMMENT_1: KEYTYP_STRING
BYTES_1: KEYTYP_STRING 544256
DS_INDEX_1: KEYTYP_STRING 1251
CREATE_UID_1: KEYTYP_STRING 10014
CREAT_DATE_1: KEYTYP_STRING 02-MAY-95
T_FIRST_1: KEYTYP_STRING -1
T_LAST_1: KEYTYP_STRING -1
USERNAME_1: KEYTYP_STRING mark
ARCH_TAPE_1: KEYTYP_STRING 2105001
ARCH_TAPE_POS_1: KEYTYP_STRING 12790
ARCH_TAPE_FN_1: KEYTYP_STRING 33
ARCH_TAPE_DATE_1: KEYTYP_STRING 18-AUG-95
WARNINGS_1: KEYTYP_STRING
STATUS_1: KEYTYP_STRING
SAFE_TAPE_1: KEYTYP_STRING
SAFE_TAPE_POS_1: KEYTYP_STRING
SAFE_TAPE_FN_1: KEYTYP_STRING
SAFE_TAPE_DATE_1: KEYTYP_STRING
num_rows: KEYTYP_INT 2
Deregistered with dsds_svc as uid=159666
pesql Normal Completion
csh>
FILES
none
BUGS
AUTHOR
Jim Aloise
HISTORY
1996-06-14 SOI Version 1.3.0
1994-11-30 SOI Version 0.9.0