| New news...
The 16 bit drivers in the same configuration (NT 4.0 with 2.10.11) work
fine... the problem with inconsistant results seems to be a problem with
the 32 bit driver only.
The customer is running MSAccess 2.0 (which is a 16-bit application), but
aren't the 32 bit drivers supposed to work with 16 bit apps?
Here is a client log from a 32 bit session displaying the wrong results. I
will post a good client log from the 16 bit app in the next reply... anyone
have any ideas?
Log file generated by C:\WINNT\System32\sqsapi32.dll
Oracle Sql/Services Version 7.00
ASSOCIATE LEVEL LOG
----SQLSRV_ASSOCIATE
--------SQLSRV_ASSOCIATE ID: 2491458
--------NODE: pos_mrs.wsdot.wa.gov, USERNAME: arcsuser, SQLCODE: 0,
SQLERRD[0] 0
--------NETWORK TRANSPORT: TCP/IP
PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:00:00 on 16-May-1997
----PACKET ID: 1, PACKET SEQUENCE: 0
--------SQLSRV_ASSOCIATE
------------CLIENT PROTOCOL VERSION
----------------len: 2, value: 14
------------USERNAME
----------------SQLSRV_ASCII_STRING, len: 8
--------------------len: 8, value: arcsuser
------------PASSWORD
----------------SQLSRV_VARCHAR, len: 10
--------------------len: 10, value: <password>
------------READ BUFFER SIZE
----------------len: 2, value: 5000
------------WRITE BUFFER SIZE
----------------len: 2, value: 5000
------------SERVICE NAME
----------------SQLSRV_ASCII_STRING, len: 5
--------------------len: 5, value: MRSDB
------------DECLARE TRANSACTION STATEMENT
----------------SQLSRV_ASCII_STRING, len: 54
--------------------len: 54, value: DECLARE TRANSACTION READ ONLY WAIT
CONSISTEN
--------------------CY LEVEL 2
------------APPLICATION NAME
----------------SQLSRV_ASCII_STRING, len: 8
--------------------len: 8, value: MSACCESS
--------END OF MESSAGE
PROTOCOL LEVEL LOG CLIENT: read at 09:00:00 on 16-May-1997
----PACKET ID: 1, PACKET SEQUENCE: 0
--------SQLSRV_ASSOCIATE ACK
------------CLIENT PROTOCOL VERSION
----------------len: 2, value: 14
------------ASSOCIATE ID
----------------len: 2, value: 0
------------DEC SQL VERSION
----------------SQLSRV_ASCII_STRING, len: 7
--------------------len: 7, value: V6.1-04
------------RDB ENG VERSION
----------------SQLSRV_ASCII_STRING, len: 7
--------------------len: 7, value: V6.1-04
------------SERVER PROTOCOL VERSION
----------------len: 2, value: 8
------------SQLSRV SERVER VERSION
----------------SQLSRV_ASCII_STRING, len: 7
--------------------len: 7, value: V6.1-02
------------EXCECUTOR PID
----------------SQLSRV_GENERALIZED_NUMBER, len: 4
--------------------len: 4, value: 3649
------------SERVICE ATTRIBUTES
----------------len: 2, value: 1
------------STATUS
----------------SQLSRV_GENERALIZED_NUMBER, len: 1
--------------------len: 1, value: 0
--------END OF MESSAGE
ROUTINE LEVEL LOG at 09:00:00 on 16-May-1997
----SQLSRV_GET_ASSOCIATE_INFO
ROUTINE LEVEL LOG at 09:00:00 on 16-May-1997
----SQLSRV_GET_ASSOCIATE_INFO
ROUTINE LEVEL LOG at 09:00:00 on 16-May-1997
----SQLSRV_GET_ASSOCIATE_INFO
ROUTINE LEVEL LOG at 09:00:00 on 16-May-1997
----SQLSRV_EXECUTE_IMMEDIATE
--------SQL STATEMENT
------------len: 54, value: DECLARE TRANSACTION READ ONLY WAIT CONSISTENCY
LEVEL
------------ 2
PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:00:00 on 16-May-1997
----PACKET LENGTH: 68
PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:00:00 on 16-May-1997
----PACKET ID: 2, PACKET SEQUENCE: 0
--------SQLSRV_EXECUTE_IMMEDIATE
------------SQL STATEMENT
----------------SQLSRV_ASCII_STRING, len: 54
--------------------len: 54, value: DECLARE TRANSACTION READ ONLY WAIT
CONSISTEN
--------------------CY LEVEL 2
--------END OF MESSAGE
PROTOCOL LEVEL LOG CLIENT: read at 09:00:00 on 16-May-1997
----PACKET LENGTH: 20
PROTOCOL LEVEL LOG CLIENT: read at 09:00:00 on 16-May-1997
----PACKET ID: 2, PACKET SEQUENCE: 0
--------SQLSRV_EXECUTE_IMMEDIATE ACK
------------STATUS
----------------SQLSRV_GENERALIZED_NUMBER, len: 1
--------------------len: 1, value: 0
------------EXECUTE PARAMETER
----------------SQLSRV_GENERALIZED_NUMBER, len: 1
--------------------len: 1, value: 0
--------END OF MESSAGE
ROUTINE LEVEL LOG at 09:00:00 on 16-May-1997
----SQLSRV_PREPARE
--------SQL STATEMENT
------------len: 35, value: SELECT Config, nValue FROM MSysConf
PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:00:00 on 16-May-1997
----PACKET LENGTH: 49
PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:00:00 on 16-May-1997
----PACKET ID: 3, PACKET SEQUENCE: 0
--------SQLSRV_PREPARE
------------SQL STATEMENT
----------------SQLSRV_ASCII_STRING, len: 35
--------------------len: 35, value: SELECT Config, nValue FROM MSysConf
--------END OF MESSAGE
PROTOCOL LEVEL LOG CLIENT: read at 09:00:00 on 16-May-1997
----PACKET LENGTH: 97
PROTOCOL LEVEL LOG CLIENT: read at 09:00:00 on 16-May-1997
----PACKET ID: 3, PACKET SEQUENCE: 0
--------ERROR ACK
------------ERROR_VALUE_TAG
----------------SQLSRV_GENERALIZED_NUMBER, len: 5
--------------------len: 5, value: -1041
------------SPECIFIC_ERROR_TAG
----------------SQLSRV_GENERALIZED_NUMBER, len: 1
--------------------len: 1, value: 0
------------SPECIFIC_ERROR_TEXT_TAG
----------------SQLSRV_ASCII_STRING, len: 69
--------------------len: 69, value: %SQL-F-RELNOTDEF, Table MSYSCONF is
not defi
--------------------ned in database or schema
--------END OF MESSAGE
ROUTINE LEVEL LOG at 09:00:00 on 16-May-1997
----SQLSRV_EXECUTE_IMMEDIATE
--------SQL STATEMENT
------------len: 54, value: DECLARE TRANSACTION READ ONLY WAIT CONSISTENCY
LEVEL
------------ 2
PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:00:00 on 16-May-1997
----PACKET LENGTH: 68
PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:00:00 on 16-May-1997
----PACKET ID: 4, PACKET SEQUENCE: 0
--------SQLSRV_EXECUTE_IMMEDIATE
------------SQL STATEMENT
----------------SQLSRV_ASCII_STRING, len: 54
--------------------len: 54, value: DECLARE TRANSACTION READ ONLY WAIT
CONSISTEN
--------------------CY LEVEL 2
--------END OF MESSAGE
PROTOCOL LEVEL LOG CLIENT: read at 09:00:00 on 16-May-1997
----PACKET LENGTH: 106
PROTOCOL LEVEL LOG CLIENT: read at 09:00:00 on 16-May-1997
----PACKET ID: 4, PACKET SEQUENCE: 0
--------ERROR ACK
------------ERROR_VALUE_TAG
----------------SQLSRV_GENERALIZED_NUMBER, len: 2
--------------------len: 2, value: -1
------------SPECIFIC_ERROR_TAG
----------------SQLSRV_GENERALIZED_NUMBER, len: 1
--------------------len: 1, value: 0
------------SPECIFIC_ERROR_TEXT_TAG
----------------SQLSRV_ASCII_STRING, len: 81
--------------------len: 81, value: %SQL-F-NO_DCLTXN, You cannot declare a
trans
--------------------action while a transaction is active.
--------END OF MESSAGE
ROUTINE LEVEL LOG at 09:00:00 on 16-May-1997
PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:00:00 on 16-May-1997
----PACKET LENGTH: 14
PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:00:00 on 16-May-1997
----PACKET ID: 5, PACKET SEQUENCE: 0
--------SQLSRV_TRANSACT
------------TRANSACTION TYPE
----------------len: 2, value: 1
--------END OF MESSAGE
PROTOCOL LEVEL LOG CLIENT: read at 09:00:00 on 16-May-1997
----PACKET LENGTH: 15
PROTOCOL LEVEL LOG CLIENT: read at 09:00:00 on 16-May-1997
----PACKET ID: 5, PACKET SEQUENCE: 0
--------SQLSRV_TRANSACT ACK
------------STATUS
----------------SQLSRV_GENERALIZED_NUMBER, len: 1
--------------------len: 1, value: 0
--------END OF MESSAGE
ROUTINE LEVEL LOG at 09:00:00 on 16-May-1997
----SQLSRV_EXECUTE_IMMEDIATE
--------SQL STATEMENT
------------len: 54, value: DECLARE TRANSACTION READ ONLY WAIT CONSISTENCY
LEVEL
------------ 2
PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:00:00 on 16-May-1997
----PACKET LENGTH: 68
PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:00:00 on 16-May-1997
----PACKET ID: 6, PACKET SEQUENCE: 0
--------SQLSRV_EXECUTE_IMMEDIATE
------------SQL STATEMENT
----------------SQLSRV_ASCII_STRING, len: 54
--------------------len: 54, value: DECLARE TRANSACTION READ ONLY WAIT
CONSISTEN
--------------------CY LEVEL 2
--------END OF MESSAGE
PROTOCOL LEVEL LOG CLIENT: read at 09:00:00 on 16-May-1997
----PACKET LENGTH: 20
PROTOCOL LEVEL LOG CLIENT: read at 09:00:00 on 16-May-1997
----PACKET ID: 6, PACKET SEQUENCE: 0
--------SQLSRV_EXECUTE_IMMEDIATE ACK
------------STATUS
----------------SQLSRV_GENERALIZED_NUMBER, len: 1
--------------------len: 1, value: 0
------------EXECUTE PARAMETER
----------------SQLSRV_GENERALIZED_NUMBER, len: 1
--------------------len: 1, value: 0
--------END OF MESSAGE
ROUTINE LEVEL LOG at 09:00:00 on 16-May-1997
----SQLSRV_PREPARE
--------SQL STATEMENT
------------len: 403, value: SELECT DDAL$DBKEY ,TERMINAL_ID ,TERMINAL
,STATION_F
------------IRST_DIG_NUM ,CITY ,RECEIPT_HEADER_LINE1 ,RECEIPT_HEADER_LINE2
,RECE
------------IPT_HEADER_LINE3 ,RECEIPT_HEADER_LINE4 ,RECEIPT_HEADER_LINE5
,RECEIP
------------T_FOOTER_LINE1 ,RECEIPT_FOOTER_LINE2 ,WORKING_FUND_AMOUNT
,SALES_DAY
------------_START_TIME ,SALES_DAY_END_TIME ,CASH_PICKUP_WARNING_AMOUNT
,CASH_PI
------------CKUP_LIMIT_AMOUNT ,CASH_DECLARE_TOLERANCE_AMOUNT
,POS_DATABASE_ID F
------------ROM TERMINAL
PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:00:00 on 16-May-1997
----PACKET LENGTH: 417
PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:00:00 on 16-May-1997
----PACKET ID: 7, PACKET SEQUENCE: 0
--------SQLSRV_PREPARE
------------SQL STATEMENT
----------------SQLSRV_ASCII_STRING, len: 403
--------------------len: 403, value: SELECT DDAL$DBKEY ,TERMINAL_ID
,TERMINAL ,S
--------------------TATION_FIRST_DIG_NUM ,CITY ,RECEIPT_HEADER_LINE1
,RECEIPT_HE
--------------------ADER_LINE2 ,RECEIPT_HEADER_LINE3 ,RECEIPT_HEADER_LINE4
,RECE
--------------------IPT_HEADER_LINE5 ,RECEIPT_FOOTER_LINE1
,RECEIPT_FOOTER_LINE2
-------------------- ,WORKING_FUND_AMOUNT ,SALES_DAY_START_TIME
,SALES_DAY_END_T
--------------------IME ,CASH_PICKUP_WARNING_AMOUNT
,CASH_PICKUP_LIMIT_AMOUNT ,C
--------------------ASH_DECLARE_TOLERANCE_AMOUNT ,POS_DATABASE_ID FROM
TERMINAL
--------END OF MESSAGE
PROTOCOL LEVEL LOG CLIENT: read at 09:00:00 on 16-May-1997
----PACKET LENGTH: 679
PROTOCOL LEVEL LOG CLIENT: read at 09:00:00 on 16-May-1997
----PACKET ID: 7, PACKET SEQUENCE: 0
--------SQLSRV_PREPARE ACK
------------STATEMENT ID
----------------SQLSRV_GENERALIZED_NUMBER, len: 7
--------------------len: 7, value: 1000006
------------SQLERRD[1]
----------------SQLSRV_GENERALIZED_NUMBER, len: 1
--------------------len: 1, value: 1
------------SELECT LIST SQLDA
----------------len: 2, value: 19
------------SQLVAR
----------------len: 2, value: 0
------------SQLTYPE
----------------len: 2, value: 129
------------SQLLEN
----------------len: 2, value: 8
------------SQLNAME
----------------SQLSRV_ASCII_STRING, len: 10
--------------------len: 10, value: DDAL$DBKEY
------------SQLVAR
----------------len: 2, value: 1
------------SQLTYPE
----------------len: 2, value: 130
------------SQLLEN
----------------len: 2, value: 11
------------SQLNAME
----------------SQLSRV_ASCII_STRING, len: 11
--------------------len: 11, value: TERMINAL_ID
------------SQLVAR
----------------len: 2, value: 2
------------SQLTYPE
----------------len: 2, value: 132
------------SQLLEN
----------------len: 2, value: 50
------------SQLNAME
----------------SQLSRV_ASCII_STRING, len: 8
--------------------len: 8, value: TERMINAL
------------SQLVAR
----------------len: 2, value: 3
------------SQLTYPE
----------------len: 2, value: 129
------------SQLLEN
----------------len: 2, value: 12
------------SQLNAME
----------------SQLSRV_ASCII_STRING, len: 21
--------------------len: 21, value: STATION_FIRST_DIG_NUM
------------SQLVAR
----------------len: 2, value: 4
------------SQLTYPE
----------------len: 2, value: 132
------------SQLLEN
----------------len: 2, value: 50
------------SQLNAME
----------------SQLSRV_ASCII_STRING, len: 4
--------------------len: 4, value: CITY
------------SQLVAR
----------------len: 2, value: 5
------------SQLTYPE
----------------len: 2, value: 132
------------SQLLEN
----------------len: 2, value: 50
------------SQLNAME
----------------SQLSRV_ASCII_STRING, len: 20
--------------------len: 20, value: RECEIPT_HEADER_LINE1
------------SQLVAR
----------------len: 2, value: 6
------------SQLTYPE
----------------len: 2, value: 132
------------SQLLEN
----------------len: 2, value: 50
------------SQLNAME
----------------SQLSRV_ASCII_STRING, len: 20
--------------------len: 20, value: RECEIPT_HEADER_LINE2
------------SQLVAR
----------------len: 2, value: 7
------------SQLTYPE
----------------len: 2, value: 132
------------SQLLEN
----------------len: 2, value: 50
------------SQLNAME
----------------SQLSRV_ASCII_STRING, len: 20
--------------------len: 20, value: RECEIPT_HEADER_LINE3
------------SQLVAR
----------------len: 2, value: 8
------------SQLTYPE
----------------len: 2, value: 132
------------SQLLEN
----------------len: 2, value: 50
------------SQLNAME
----------------SQLSRV_ASCII_STRING, len: 20
--------------------len: 20, value: RECEIPT_HEADER_LINE4
------------SQLVAR
----------------len: 2, value: 9
------------SQLTYPE
----------------len: 2, value: 132
------------SQLLEN
----------------len: 2, value: 50
------------SQLNAME
----------------SQLSRV_ASCII_STRING, len: 20
--------------------len: 20, value: RECEIPT_HEADER_LINE5
------------SQLVAR
----------------len: 2, value: 10
------------SQLTYPE
----------------len: 2, value: 132
------------SQLLEN
----------------len: 2, value: 50
------------SQLNAME
----------------SQLSRV_ASCII_STRING, len: 20
--------------------len: 20, value: RECEIPT_FOOTER_LINE1
------------SQLVAR
----------------len: 2, value: 11
------------SQLTYPE
----------------len: 2, value: 132
------------SQLLEN
----------------len: 2, value: 50
------------SQLNAME
----------------SQLSRV_ASCII_STRING, len: 20
--------------------len: 20, value: RECEIPT_FOOTER_LINE2
------------SQLVAR
----------------len: 2, value: 12
------------SQLTYPE
----------------len: 2, value: 130
------------SQLLEN
----------------len: 2, value: 524
------------SQLNAME
----------------SQLSRV_ASCII_STRING, len: 19
--------------------len: 19, value: WORKING_FUND_AMOUNT
------------SQLVAR
----------------len: 2, value: 13
------------SQLTYPE
----------------len: 2, value: 131
------------SQLLEN
----------------len: 2, value: 529
------------SQLNAME
----------------SQLSRV_ASCII_STRING, len: 20
--------------------len: 20, value: SALES_DAY_START_TIME
------------SQLVAR
----------------len: 2, value: 14
------------SQLTYPE
----------------len: 2, value: 131
------------SQLLEN
----------------len: 2, value: 529
------------SQLNAME
----------------SQLSRV_ASCII_STRING, len: 18
--------------------len: 18, value: SALES_DAY_END_TIME
------------SQLVAR
----------------len: 2, value: 15
------------SQLTYPE
----------------len: 2, value: 130
------------SQLLEN
----------------len: 2, value: 524
------------SQLNAME
----------------SQLSRV_ASCII_STRING, len: 26
--------------------len: 26, value: CASH_PICKUP_WARNING_AMOUNT
------------SQLVAR
----------------len: 2, value: 16
------------SQLTYPE
----------------len: 2, value: 130
------------SQLLEN
----------------len: 2, value: 524
------------SQLNAME
----------------SQLSRV_ASCII_STRING, len: 24
--------------------len: 24, value: CASH_PICKUP_LIMIT_AMOUNT
------------SQLVAR
----------------len: 2, value: 17
------------SQLTYPE
----------------len: 2, value: 130
------------SQLLEN
----------------len: 2, value: 524
------------SQLNAME
----------------SQLSRV_ASCII_STRING, len: 29
--------------------len: 29, value: CASH_DECLARE_TOLERANCE_AMOUNT
------------SQLVAR
----------------len: 2, value: 18
------------SQLTYPE
----------------len: 2, value: 130
------------SQLLEN
----------------len: 2, value: 11
------------SQLNAME
----------------SQLSRV_ASCII_STRING, len: 15
--------------------len: 15, value: POS_DATABASE_ID
--------END OF MESSAGE
ROUTINE LEVEL LOG at 09:00:00 on 16-May-1997
----SELECT LIST SQLDA
--------SQLDA: SQLD 19
--------[0].SQLTYPE: SQLSRV_ASCII_STRING, SQLLEN: 8
------------SQLNAME: DDAL$DBKEY
--------[1].SQLTYPE: SQLSRV_GENERALIZED_NUMBER, SIZE 11, SCALE 0
------------SQLNAME: TERMINAL_ID
--------[2].SQLTYPE: SQLSRV_VARCHAR, SQLLEN: 50
------------SQLNAME: TERMINAL
--------[3].SQLTYPE: SQLSRV_ASCII_STRING, SQLLEN: 12
------------SQLNAME: STATION_FIRST_DIG_NUM
--------[4].SQLTYPE: SQLSRV_VARCHAR, SQLLEN: 50
------------SQLNAME: CITY
--------[5].SQLTYPE: SQLSRV_VARCHAR, SQLLEN: 50
------------SQLNAME: RECEIPT_HEADER_LINE1
--------[6].SQLTYPE: SQLSRV_VARCHAR, SQLLEN: 50
------------SQLNAME: RECEIPT_HEADER_LINE2
--------[7].SQLTYPE: SQLSRV_VARCHAR, SQLLEN: 50
------------SQLNAME: RECEIPT_HEADER_LINE3
--------[8].SQLTYPE: SQLSRV_VARCHAR, SQLLEN: 50
------------SQLNAME: RECEIPT_HEADER_LINE4
--------[9].SQLTYPE: SQLSRV_VARCHAR, SQLLEN: 50
------------SQLNAME: RECEIPT_HEADER_LINE5
--------[10].SQLTYPE: SQLSRV_VARCHAR, SQLLEN: 50
------------SQLNAME: RECEIPT_FOOTER_LINE1
--------[11].SQLTYPE: SQLSRV_VARCHAR, SQLLEN: 50
------------SQLNAME: RECEIPT_FOOTER_LINE2
--------[12].SQLTYPE: SQLSRV_GENERALIZED_NUMBER, SIZE 12, SCALE 2
------------SQLNAME: WORKING_FUND_AMOUNT
--------[13].SQLTYPE: SQLSRV_GENERALIZED_DATE, SIZE 17, TYPE 2
------------SQLNAME: SALES_DAY_START_TIME
--------[14].SQLTYPE: SQLSRV_GENERALIZED_DATE, SIZE 17, TYPE 2
------------SQLNAME: SALES_DAY_END_TIME
--------[15].SQLTYPE: SQLSRV_GENERALIZED_NUMBER, SIZE 12, SCALE 2
------------SQLNAME: CASH_PICKUP_WARNING_AMOUNT
--------[16].SQLTYPE: SQLSRV_GENERALIZED_NUMBER, SIZE 12, SCALE 2
------------SQLNAME: CASH_PICKUP_LIMIT_AMOUNT
--------[17].SQLTYPE: SQLSRV_GENERALIZED_NUMBER, SIZE 12, SCALE 2
------------SQLNAME: CASH_DECLARE_TOLERANCE_AMOUNT
--------[18].SQLTYPE: SQLSRV_GENERALIZED_NUMBER, SIZE 11, SCALE 0
------------SQLNAME: POS_DATABASE_ID
ROUTINE LEVEL LOG at 09:00:00 on 16-May-1997
----SQLSRV_ALLOCATE_SQLDA_DATA
ROUTINE LEVEL LOG at 09:00:00 on 16-May-1997
----SQLSRV_OPEN_CURSOR
--------CURSOR NAME
------------SQL_CUR113AF60
--------STATEMENT ID
------------1000006
PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:00:00 on 16-May-1997
----PACKET LENGTH: 43
PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:00:00 on 16-May-1997
----PACKET ID: 8, PACKET SEQUENCE: 0
--------SQLSRV_OPEN_CURSOR
------------CURSOR NAME
----------------SQLSRV_ASCII_STRING, len: 14
--------------------len: 14, value: SQL_CUR113AF60
------------STATEMENT ID
----------------SQLSRV_GENERALIZED_NUMBER, len: 7
--------------------len: 7, value: 1000006
------------CURSOR MODE
----------------len: 2, value: 2
--------END OF MESSAGE
PROTOCOL LEVEL LOG CLIENT: read at 09:00:00 on 16-May-1997
----PACKET LENGTH: 30
PROTOCOL LEVEL LOG CLIENT: read at 09:00:00 on 16-May-1997
----PACKET ID: 8, PACKET SEQUENCE: 0
--------SQLSRV_OPEN_CURSOR ACK
------------SQLERRD[1]
----------------SQLSRV_GENERALIZED_NUMBER, len: 1
--------------------len: 1, value: 0
------------SQLERRD[3]
----------------SQLSRV_GENERALIZED_NUMBER, len: 1
--------------------len: 1, value: 9
------------SQLERRD[4]
----------------SQLSRV_GENERALIZED_NUMBER, len: 1
--------------------len: 1, value: 0
------------SQLERRD[5]
----------------SQLSRV_GENERALIZED_NUMBER, len: 1
--------------------len: 1, value: 0
--------END OF MESSAGE
ROUTINE LEVEL LOG at 09:00:00 on 16-May-1997
----SQLSRV_FETCH
--------CURSOR NAME
------------SQL_CUR113AF60
PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:00:00 on 16-May-1997
----PACKET LENGTH: 28
PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:00:00 on 16-May-1997
----PACKET ID: 9, PACKET SEQUENCE: 0
--------SQLSRV_FETCH
------------CURSOR NAME
----------------SQLSRV_ASCII_STRING, len: 14
--------------------len: 14, value: SQL_CUR113AF60
--------END OF MESSAGE
PROTOCOL LEVEL LOG CLIENT: read at 09:00:00 on 16-May-1997
----PACKET LENGTH: 542
PROTOCOL LEVEL LOG CLIENT: read at 09:00:00 on 16-May-1997
----PACKET ID: 9, PACKET SEQUENCE: 0
--------SQLSRV_FETCH ACK
------------FETCH ROW NUMBER
----------------SQLSRV_GENERALIZED_NUMBER, len: 1
--------------------len: 1, value: 1
------------SELECT LIST DATA
----------------len: 2, value: 19
------------SQLVAR
----------------len: 2, value: 0
------------SQLDATA
----------------SQLSRV_ASCII_STRING, len: 8
--------------------len: 8, value: Non-printable data
------------SQLIND
----------------len: 2, value: 0
------------SQLVAR
----------------len: 2, value: 1
------------SQLDATA
----------------SQLSRV_GENERALIZED_NUMBER, len: 2
--------------------len: 2, value: 10
------------SQLIND
----------------len: 2, value: 0
------------SQLVAR
----------------len: 2, value: 2
------------SQLDATA
----------------SQLSRV_VARCHAR, len: 49
--------------------len: 49, value: Pier 50
--------------------
------------SQLIND
----------------len: 2, value: 0
------------SQLVAR
----------------len: 2, value: 3
------------SQLDATA
----------------SQLSRV_ASCII_STRING, len: 12
--------------------len: 12, value: X
------------SQLIND
----------------len: 2, value: 0
------------SQLVAR
----------------len: 2, value: 4
------------SQLDATA
----------------SQLSRV_VARCHAR, len: 7
--------------------len: 7, value: Seattle
------------SQLIND
----------------len: 2, value: 0
------------SQLVAR
----------------len: 2, value: 5
------------SQLDATA
----------------SQLSRV_VARCHAR, len: 13
--------------------len: 13, value: W.S.F.
------------SQLIND
----------------len: 2, value: 0
------------SQLVAR
----------------len: 2, value: 6
------------SQLDATA
----------------SQLSRV_VARCHAR, len: 49
--------------------len: 49, value: Pier 50 - Seattle
--------------------
------------SQLIND
----------------len: 2, value: 0
------------SQLVAR
----------------len: 2, value: 7
------------SQLDATA
----------------SQLSRV_VARCHAR, len: 49
--------------------len: 49, value: PASSENGER
--------------------
------------SQLIND
----------------len: 2, value: 0
------------SQLVAR
----------------len: 2, value: 8
------------SQLDATA
----------------SQLSRV_VARCHAR, len: 49
--------------------len: 49, value: TOLLS COLLECTED HERE
--------------------
------------SQLIND
----------------len: 2, value: 0
------------SQLVAR
----------------len: 2, value: 9
------------SQLDATA
----------------SQLSRV_VARCHAR, len: 0
------------SQLIND
----------------len: 2, value: -1
------------SQLVAR
----------------len: 2, value: 10
------------SQLDATA
----------------SQLSRV_VARCHAR, len: 0
------------SQLIND
----------------len: 2, value: -1
------------SQLVAR
----------------len: 2, value: 11
------------SQLDATA
----------------SQLSRV_VARCHAR, len: 0
------------SQLIND
----------------len: 2, value: -1
------------SQLVAR
----------------len: 2, value: 12
------------SQLDATA
----------------SQLSRV_GENERALIZED_NUMBER, len: 8
--------------------len: 8, value: 10000.00
------------SQLIND
----------------len: 2, value: 0
------------SQLVAR
----------------len: 2, value: 13
------------SQLDATA
----------------SQLSRV_GENERALIZED_DATE, len: 16
--------------------len: 16, value: 0000000005000000
------------SQLIND
----------------len: 2, value: 0
------------SQLVAR
----------------len: 2, value: 14
------------SQLDATA
----------------SQLSRV_GENERALIZED_DATE, len: 16
--------------------len: 16, value: 0000000003000000
------------SQLIND
----------------len: 2, value: 0
------------SQLVAR
----------------len: 2, value: 15
------------SQLDATA
----------------SQLSRV_GENERALIZED_NUMBER, len: 6
--------------------len: 6, value: 800.00
------------SQLIND
----------------len: 2, value: 0
------------SQLVAR
----------------len: 2, value: 16
------------SQLDATA
----------------SQLSRV_GENERALIZED_NUMBER, len: 7
--------------------len: 7, value: 1000.00
------------SQLIND
----------------len: 2, value: 0
------------SQLVAR
----------------len: 2, value: 17
------------SQLDATA
----------------SQLSRV_GENERALIZED_NUMBER, len: 4
--------------------len: 4, value: 5.00
------------SQLIND
----------------len: 2, value: 0
------------SQLVAR
----------------len: 2, value: 18
------------SQLDATA
----------------SQLSRV_GENERALIZED_NUMBER, len: 0
------------SQLIND
----------------len: 2, value: -1
--------END OF MESSAGE
ROUTINE LEVEL LOG at 09:00:00 on 16-May-1997
----SELECT LIST SQLDA
--------SQLDA: SQLD 19
------------[0].SQLTYPE: SQLSRV_ASCII_STRING, SQLIND: 0
----------------len: 8, value: Non-printable data
------------[1].SQLTYPE: SQLSRV_GENERALIZED_NUMBER, SQLIND: 0
----------------len: 2, value: 10
------------[2].SQLTYPE: SQLSRV_VARCHAR, SQLIND: 0
----------------len: 49, value: Pier 50
----------------
------------[3].SQLTYPE: SQLSRV_ASCII_STRING, SQLIND: 0
----------------len: 12, value: X
------------[4].SQLTYPE: SQLSRV_VARCHAR, SQLIND: 0
----------------len: 7, value: Seattle
------------[5].SQLTYPE: SQLSRV_VARCHAR, SQLIND: 0
----------------len: 13, value: W.S.F.
------------[6].SQLTYPE: SQLSRV_VARCHAR, SQLIND: 0
----------------len: 49, value: Pier 50 - Seattle
----------------
------------[7].SQLTYPE: SQLSRV_VARCHAR, SQLIND: 0
----------------len: 49, value: PASSENGER
----------------
------------[8].SQLTYPE: SQLSRV_VARCHAR, SQLIND: 0
----------------len: 49, value: TOLLS COLLECTED HERE
----------------
------------[9].SQLTYPE: SQLSRV_VARCHAR, SQLIND: -1
----------------len: 0, value:
------------[10].SQLTYPE: SQLSRV_VARCHAR, SQLIND: -1
----------------len: 0, value:
------------[11].SQLTYPE: SQLSRV_VARCHAR, SQLIND: -1
----------------len: 0, value:
------------[12].SQLTYPE: SQLSRV_GENERALIZED_NUMBER, SQLIND: 0
----------------len: 8, value: 10000.00
------------[13].SQLTYPE: SQLSRV_GENERALIZED_DATE, SQLIND: 0
----------------len: 16, value: 0000000005000000
------------[14].SQLTYPE: SQLSRV_GENERALIZED_DATE, SQLIND: 0
----------------len: 16, value: 0000000003000000
------------[15].SQLTYPE: SQLSRV_GENERALIZED_NUMBER, SQLIND: 0
----------------len: 6, value: 800.00
------------[16].SQLTYPE: SQLSRV_GENERALIZED_NUMBER, SQLIND: 0
----------------len: 7, value: 1000.00
------------[17].SQLTYPE: SQLSRV_GENERALIZED_NUMBER, SQLIND: 0
----------------len: 4, value: 5.00
------------[18].SQLTYPE: SQLSRV_GENERALIZED_NUMBER, SQLIND: -1
----------------len: 0, value:
ROUTINE LEVEL LOG at 09:00:00 on 16-May-1997
----SQLSRV_CLOSE_CURSOR
--------CURSOR NAME
------------SQL_CUR113AF60
PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:00:00 on 16-May-1997
----PACKET LENGTH: 28
PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:00:00 on 16-May-1997
----PACKET ID: 10, PACKET SEQUENCE: 0
--------SQLSRV_CLOSE_CURSOR
------------CURSOR NAME
----------------SQLSRV_ASCII_STRING, len: 14
--------------------len: 14, value: SQL_CUR113AF60
--------END OF MESSAGE
PROTOCOL LEVEL LOG CLIENT: read at 09:00:00 on 16-May-1997
----PACKET LENGTH: 10
PROTOCOL LEVEL LOG CLIENT: read at 09:00:00 on 16-May-1997
----PACKET ID: 10, PACKET SEQUENCE: 0
--------SQLSRV_CLOSE_CURSOR ACK
--------END OF MESSAGE
ROUTINE LEVEL LOG at 09:00:00 on 16-May-1997
----SQLSRV_RELEASE_STATEMENT
--------STATEMENT ID
------------[0] 1000006
PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:00:00 on 16-May-1997
----PACKET LENGTH: 29
PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:00:00 on 16-May-1997
----PACKET ID: 11, PACKET SEQUENCE: 0
--------SQLSRV_RELEASE_STATEMENT
------------STATEMENT COUNT
----------------len: 2, value: 1
------------AUTO COMMIT
----------------len: 2, value: 1
------------STATEMENT ID
----------------SQLSRV_GENERALIZED_NUMBER, len: 7
--------------------len: 7, value: 1000006
--------END OF MESSAGE
PROTOCOL LEVEL LOG CLIENT: read at 09:00:00 on 16-May-1997
----PACKET LENGTH: 19
PROTOCOL LEVEL LOG CLIENT: read at 09:00:00 on 16-May-1997
----PACKET ID: 11, PACKET SEQUENCE: 0
--------SQLSRV_RELEASE_STATEMENT ACK
------------STATUS
----------------SQLSRV_GENERALIZED_NUMBER, len: 1
--------------------len: 1, value: 0
------------STATEMENT COUNT
----------------len: 2, value: 1
--------END OF MESSAGE
ROUTINE LEVEL LOG at 09:00:00 on 16-May-1997
----SQLSRV_FREE_SQLDA_DATA
ROUTINE LEVEL LOG at 09:00:00 on 16-May-1997
----SQLSRV_EXECUTE_IMMEDIATE
--------SQL STATEMENT
------------len: 54, value: DECLARE TRANSACTION READ ONLY WAIT CONSISTENCY
LEVEL
------------ 2
PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:00:00 on 16-May-1997
----PACKET LENGTH: 68
PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:00:00 on 16-May-1997
----PACKET ID: 12, PACKET SEQUENCE: 0
--------SQLSRV_EXECUTE_IMMEDIATE
------------SQL STATEMENT
----------------SQLSRV_ASCII_STRING, len: 54
--------------------len: 54, value: DECLARE TRANSACTION READ ONLY WAIT
CONSISTEN
--------------------CY LEVEL 2
--------END OF MESSAGE
PROTOCOL LEVEL LOG CLIENT: read at 09:00:00 on 16-May-1997
----PACKET LENGTH: 20
PROTOCOL LEVEL LOG CLIENT: read at 09:00:00 on 16-May-1997
----PACKET ID: 12, PACKET SEQUENCE: 0
--------SQLSRV_EXECUTE_IMMEDIATE ACK
------------STATUS
----------------SQLSRV_GENERALIZED_NUMBER, len: 1
--------------------len: 1, value: 0
------------EXECUTE PARAMETER
----------------SQLSRV_GENERALIZED_NUMBER, len: 1
--------------------len: 1, value: 0
--------END OF MESSAGE
ROUTINE LEVEL LOG at 09:00:00 on 16-May-1997
----SQLSRV_PREPARE
--------SQL STATEMENT
------------len: 403, value: SELECT DDAL$DBKEY ,TERMINAL_ID ,TERMINAL
,STATION_F
------------IRST_DIG_NUM ,CITY ,RECEIPT_HEADER_LINE1 ,RECEIPT_HEADER_LINE2
,RECE
------------IPT_HEADER_LINE3 ,RECEIPT_HEADER_LINE4 ,RECEIPT_HEADER_LINE5
,RECEIP
------------T_FOOTER_LINE1 ,RECEIPT_FOOTER_LINE2 ,WORKING_FUND_AMOUNT
,SALES_DAY
------------_START_TIME ,SALES_DAY_END_TIME ,CASH_PICKUP_WARNING_AMOUNT
,CASH_PI
------------CKUP_LIMIT_AMOUNT ,CASH_DECLARE_TOLERANCE_AMOUNT
,POS_DATABASE_ID F
------------ROM TERMINAL
PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:00:00 on 16-May-1997
----PACKET LENGTH: 417
PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:00:00 on 16-May-1997
----PACKET ID: 13, PACKET SEQUENCE: 0
--------SQLSRV_PREPARE
------------SQL STATEMENT
----------------SQLSRV_ASCII_STRING, len: 403
--------------------len: 403, value: SELECT DDAL$DBKEY ,TERMINAL_ID
,TERMINAL ,S
--------------------TATION_FIRST_DIG_NUM ,CITY ,RECEIPT_HEADER_LINE1
,RECEIPT_HE
--------------------ADER_LINE2 ,RECEIPT_HEADER_LINE3 ,RECEIPT_HEADER_LINE4
,RECE
--------------------IPT_HEADER_LINE5 ,RECEIPT_FOOTER_LINE1
,RECEIPT_FOOTER_LINE2
-------------------- ,WORKING_FUND_AMOUNT ,SALES_DAY_START_TIME
,SALES_DAY_END_T
--------------------IME ,CASH_PICKUP_WARNING_AMOUNT
,CASH_PICKUP_LIMIT_AMOUNT ,C
--------------------ASH_DECLARE_TOLERANCE_AMOUNT ,POS_DATABASE_ID FROM
TERMINAL
--------END OF MESSAGE
PROTOCOL LEVEL LOG CLIENT: read at 09:00:00 on 16-May-1997
----PACKET LENGTH: 679
PROTOCOL LEVEL LOG CLIENT: read at 09:00:00 on 16-May-1997
----PACKET ID: 13, PACKET SEQUENCE: 0
--------SQLSRV_PREPARE ACK
------------STATEMENT ID
----------------SQLSRV_GENERALIZED_NUMBER, len: 7
--------------------len: 7, value: 1000007
------------SQLERRD[1]
----------------SQLSRV_GENERALIZED_NUMBER, len: 1
--------------------len: 1, value: 1
------------SELECT LIST SQLDA
----------------len: 2, value: 19
------------SQLVAR
----------------len: 2, value: 0
------------SQLTYPE
----------------len: 2, value: 129
------------SQLLEN
----------------len: 2, value: 8
------------SQLNAME
----------------SQLSRV_ASCII_STRING, len: 10
--------------------len: 10, value: DDAL$DBKEY
------------SQLVAR
----------------len: 2, value: 1
------------SQLTYPE
----------------len: 2, value: 130
------------SQLLEN
----------------len: 2, value: 11
------------SQLNAME
----------------SQLSRV_ASCII_STRING, len: 11
--------------------len: 11, value: TERMINAL_ID
------------SQLVAR
----------------len: 2, value: 2
------------SQLTYPE
----------------len: 2, value: 132
------------SQLLEN
----------------len: 2, value: 50
------------SQLNAME
----------------SQLSRV_ASCII_STRING, len: 8
--------------------len: 8, value: TERMINAL
------------SQLVAR
----------------len: 2, value: 3
------------SQLTYPE
----------------len: 2, value: 129
------------SQLLEN
----------------len: 2, value: 12
------------SQLNAME
----------------SQLSRV_ASCII_STRING, len: 21
--------------------len: 21, value: STATION_FIRST_DIG_NUM
------------SQLVAR
----------------len: 2, value: 4
------------SQLTYPE
----------------len: 2, value: 132
------------SQLLEN
----------------len: 2, value: 50
------------SQLNAME
----------------SQLSRV_ASCII_STRING, len: 4
--------------------len: 4, value: CITY
------------SQLVAR
----------------len: 2, value: 5
------------SQLTYPE
----------------len: 2, value: 132
------------SQLLEN
----------------len: 2, value: 50
------------SQLNAME
----------------SQLSRV_ASCII_STRING, len: 20
--------------------len: 20, value: RECEIPT_HEADER_LINE1
------------SQLVAR
----------------len: 2, value: 6
------------SQLTYPE
----------------len: 2, value: 132
------------SQLLEN
----------------len: 2, value: 50
------------SQLNAME
----------------SQLSRV_ASCII_STRING, len: 20
--------------------len: 20, value: RECEIPT_HEADER_LINE2
------------SQLVAR
----------------len: 2, value: 7
------------SQLTYPE
----------------len: 2, value: 132
------------SQLLEN
----------------len: 2, value: 50
------------SQLNAME
----------------SQLSRV_ASCII_STRING, len: 20
--------------------len: 20, value: RECEIPT_HEADER_LINE3
------------SQLVAR
----------------len: 2, value: 8
------------SQLTYPE
----------------len: 2, value: 132
------------SQLLEN
----------------len: 2, value: 50
------------SQLNAME
----------------SQLSRV_ASCII_STRING, len: 20
--------------------len: 20, value: RECEIPT_HEADER_LINE4
------------SQLVAR
----------------len: 2, value: 9
------------SQLTYPE
----------------len: 2, value: 132
------------SQLLEN
----------------len: 2, value: 50
------------SQLNAME
----------------SQLSRV_ASCII_STRING, len: 20
--------------------len: 20, value: RECEIPT_HEADER_LINE5
------------SQLVAR
----------------len: 2, value: 10
------------SQLTYPE
----------------len: 2, value: 132
------------SQLLEN
----------------len: 2, value: 50
------------SQLNAME
----------------SQLSRV_ASCII_STRING, len: 20
--------------------len: 20, value: RECEIPT_FOOTER_LINE1
------------SQLVAR
----------------len: 2, value: 11
------------SQLTYPE
----------------len: 2, value: 132
------------SQLLEN
----------------len: 2, value: 50
------------SQLNAME
----------------SQLSRV_ASCII_STRING, len: 20
--------------------len: 20, value: RECEIPT_FOOTER_LINE2
------------SQLVAR
----------------len: 2, value: 12
------------SQLTYPE
----------------len: 2, value: 130
------------SQLLEN
----------------len: 2, value: 524
------------SQLNAME
----------------SQLSRV_ASCII_STRING, len: 19
--------------------len: 19, value: WORKING_FUND_AMOUNT
------------SQLVAR
----------------len: 2, value: 13
------------SQLTYPE
----------------len: 2, value: 131
------------SQLLEN
----------------len: 2, value: 529
------------SQLNAME
----------------SQLSRV_ASCII_STRING, len: 20
--------------------len: 20, value: SALES_DAY_START_TIME
------------SQLVAR
----------------len: 2, value: 14
------------SQLTYPE
----------------len: 2, value: 131
------------SQLLEN
----------------len: 2, value: 529
------------SQLNAME
----------------SQLSRV_ASCII_STRING, len: 18
--------------------len: 18, value: SALES_DAY_END_TIME
------------SQLVAR
----------------len: 2, value: 15
------------SQLTYPE
----------------len: 2, value: 130
------------SQLLEN
----------------len: 2, value: 524
------------SQLNAME
----------------SQLSRV_ASCII_STRING, len: 26
--------------------len: 26, value: CASH_PICKUP_WARNING_AMOUNT
------------SQLVAR
----------------len: 2, value: 16
------------SQLTYPE
----------------len: 2, value: 130
------------SQLLEN
----------------len: 2, value: 524
------------SQLNAME
----------------SQLSRV_ASCII_STRING, len: 24
--------------------len: 24, value: CASH_PICKUP_LIMIT_AMOUNT
------------SQLVAR
----------------len: 2, value: 17
------------SQLTYPE
----------------len: 2, value: 130
------------SQLLEN
----------------len: 2, value: 524
------------SQLNAME
----------------SQLSRV_ASCII_STRING, len: 29
--------------------len: 29, value: CASH_DECLARE_TOLERANCE_AMOUNT
------------SQLVAR
----------------len: 2, value: 18
------------SQLTYPE
----------------len: 2, value: 130
------------SQLLEN
----------------len: 2, value: 11
------------SQLNAME
----------------SQLSRV_ASCII_STRING, len: 15
--------------------len: 15, value: POS_DATABASE_ID
--------END OF MESSAGE
ROUTINE LEVEL LOG at 09:00:00 on 16-May-1997
----SELECT LIST SQLDA
--------SQLDA: SQLD 19
--------[0].SQLTYPE: SQLSRV_ASCII_STRING, SQLLEN: 8
------------SQLNAME: DDAL$DBKEY
--------[1].SQLTYPE: SQLSRV_GENERALIZED_NUMBER, SIZE 11, SCALE 0
------------SQLNAME: TERMINAL_ID
--------[2].SQLTYPE: SQLSRV_VARCHAR, SQLLEN: 50
------------SQLNAME: TERMINAL
--------[3].SQLTYPE: SQLSRV_ASCII_STRING, SQLLEN: 12
------------SQLNAME: STATION_FIRST_DIG_NUM
--------[4].SQLTYPE: SQLSRV_VARCHAR, SQLLEN: 50
------------SQLNAME: CITY
--------[5].SQLTYPE: SQLSRV_VARCHAR, SQLLEN: 50
------------SQLNAME: RECEIPT_HEADER_LINE1
--------[6].SQLTYPE: SQLSRV_VARCHAR, SQLLEN: 50
------------SQLNAME: RECEIPT_HEADER_LINE2
--------[7].SQLTYPE: SQLSRV_VARCHAR, SQLLEN: 50
------------SQLNAME: RECEIPT_HEADER_LINE3
--------[8].SQLTYPE: SQLSRV_VARCHAR, SQLLEN: 50
------------SQLNAME: RECEIPT_HEADER_LINE4
--------[9].SQLTYPE: SQLSRV_VARCHAR, SQLLEN: 50
------------SQLNAME: RECEIPT_HEADER_LINE5
--------[10].SQLTYPE: SQLSRV_VARCHAR, SQLLEN: 50
------------SQLNAME: RECEIPT_FOOTER_LINE1
--------[11].SQLTYPE: SQLSRV_VARCHAR, SQLLEN: 50
------------SQLNAME: RECEIPT_FOOTER_LINE2
--------[12].SQLTYPE: SQLSRV_GENERALIZED_NUMBER, SIZE 12, SCALE 2
------------SQLNAME: WORKING_FUND_AMOUNT
--------[13].SQLTYPE: SQLSRV_GENERALIZED_DATE, SIZE 17, TYPE 2
------------SQLNAME: SALES_DAY_START_TIME
--------[14].SQLTYPE: SQLSRV_GENERALIZED_DATE, SIZE 17, TYPE 2
------------SQLNAME: SALES_DAY_END_TIME
--------[15].SQLTYPE: SQLSRV_GENERALIZED_NUMBER, SIZE 12, SCALE 2
------------SQLNAME: CASH_PICKUP_WARNING_AMOUNT
--------[16].SQLTYPE: SQLSRV_GENERALIZED_NUMBER, SIZE 12, SCALE 2
------------SQLNAME: CASH_PICKUP_LIMIT_AMOUNT
--------[17].SQLTYPE: SQLSRV_GENERALIZED_NUMBER, SIZE 12, SCALE 2
------------SQLNAME: CASH_DECLARE_TOLERANCE_AMOUNT
--------[18].SQLTYPE: SQLSRV_GENERALIZED_NUMBER, SIZE 11, SCALE 0
------------SQLNAME: POS_DATABASE_ID
ROUTINE LEVEL LOG at 09:00:00 on 16-May-1997
----SQLSRV_ALLOCATE_SQLDA_DATA
ROUTINE LEVEL LOG at 09:00:00 on 16-May-1997
----SQLSRV_OPEN_CURSOR
--------CURSOR NAME
------------SQL_CUR113AF60
--------STATEMENT ID
------------1000007
PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:00:00 on 16-May-1997
----PACKET LENGTH: 43
PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:00:00 on 16-May-1997
----PACKET ID: 14, PACKET SEQUENCE: 0
--------SQLSRV_OPEN_CURSOR
------------CURSOR NAME
----------------SQLSRV_ASCII_STRING, len: 14
--------------------len: 14, value: SQL_CUR113AF60
------------STATEMENT ID
----------------SQLSRV_GENERALIZED_NUMBER, len: 7
--------------------len: 7, value: 1000007
------------CURSOR MODE
----------------len: 2, value: 2
--------END OF MESSAGE
PROTOCOL LEVEL LOG CLIENT: read at 09:00:00 on 16-May-1997
----PACKET LENGTH: 30
PROTOCOL LEVEL LOG CLIENT: read at 09:00:00 on 16-May-1997
----PACKET ID: 14, PACKET SEQUENCE: 0
--------SQLSRV_OPEN_CURSOR ACK
------------SQLERRD[1]
----------------SQLSRV_GENERALIZED_NUMBER, len: 1
--------------------len: 1, value: 0
------------SQLERRD[3]
----------------SQLSRV_GENERALIZED_NUMBER, len: 1
--------------------len: 1, value: 9
------------SQLERRD[4]
----------------SQLSRV_GENERALIZED_NUMBER, len: 1
--------------------len: 1, value: 0
------------SQLERRD[5]
----------------SQLSRV_GENERALIZED_NUMBER, len: 1
--------------------len: 1, value: 0
--------END OF MESSAGE
ROUTINE LEVEL LOG at 09:00:00 on 16-May-1997
----SQLSRV_FETCH
--------CURSOR NAME
------------SQL_CUR113AF60
PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:00:00 on 16-May-1997
----PACKET LENGTH: 28
PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:00:00 on 16-May-1997
----PACKET ID: 15, PACKET SEQUENCE: 0
--------SQLSRV_FETCH
------------CURSOR NAME
----------------SQLSRV_ASCII_STRING, len: 14
--------------------len: 14, value: SQL_CUR113AF60
--------END OF MESSAGE
PROTOCOL LEVEL LOG CLIENT: read at 09:00:00 on 16-May-1997
----PACKET LENGTH: 542
PROTOCOL LEVEL LOG CLIENT: read at 09:00:00 on 16-May-1997
----PACKET ID: 15, PACKET SEQUENCE: 0
--------SQLSRV_FETCH ACK
------------FETCH ROW NUMBER
----------------SQLSRV_GENERALIZED_NUMBER, len: 1
--------------------len: 1, value: 1
------------SELECT LIST DATA
----------------len: 2, value: 19
------------SQLVAR
----------------len: 2, value: 0
------------SQLDATA
----------------SQLSRV_ASCII_STRING, len: 8
--------------------len: 8, value: Non-printable data
------------SQLIND
----------------len: 2, value: 0
------------SQLVAR
----------------len: 2, value: 1
------------SQLDATA
----------------SQLSRV_GENERALIZED_NUMBER, len: 2
--------------------len: 2, value: 10
------------SQLIND
----------------len: 2, value: 0
------------SQLVAR
----------------len: 2, value: 2
------------SQLDATA
----------------SQLSRV_VARCHAR, len: 49
--------------------len: 49, value: Pier 50
--------------------
------------SQLIND
----------------len: 2, value: 0
------------SQLVAR
----------------len: 2, value: 3
------------SQLDATA
----------------SQLSRV_ASCII_STRING, len: 12
--------------------len: 12, value: X
------------SQLIND
----------------len: 2, value: 0
------------SQLVAR
----------------len: 2, value: 4
------------SQLDATA
----------------SQLSRV_VARCHAR, len: 7
--------------------len: 7, value: Seattle
------------SQLIND
----------------len: 2, value: 0
------------SQLVAR
----------------len: 2, value: 5
------------SQLDATA
----------------SQLSRV_VARCHAR, len: 13
--------------------len: 13, value: W.S.F.
------------SQLIND
----------------len: 2, value: 0
------------SQLVAR
----------------len: 2, value: 6
------------SQLDATA
----------------SQLSRV_VARCHAR, len: 49
--------------------len: 49, value: Pier 50 - Seattle
--------------------
------------SQLIND
----------------len: 2, value: 0
------------SQLVAR
----------------len: 2, value: 7
------------SQLDATA
----------------SQLSRV_VARCHAR, len: 49
--------------------len: 49, value: PASSENGER
--------------------
------------SQLIND
----------------len: 2, value: 0
------------SQLVAR
----------------len: 2, value: 8
------------SQLDATA
----------------SQLSRV_VARCHAR, len: 49
--------------------len: 49, value: TOLLS COLLECTED HERE
--------------------
------------SQLIND
----------------len: 2, value: 0
------------SQLVAR
----------------len: 2, value: 9
------------SQLDATA
----------------SQLSRV_VARCHAR, len: 0
------------SQLIND
----------------len: 2, value: -1
------------SQLVAR
----------------len: 2, value: 10
------------SQLDATA
----------------SQLSRV_VARCHAR, len: 0
------------SQLIND
----------------len: 2, value: -1
------------SQLVAR
----------------len: 2, value: 11
------------SQLDATA
----------------SQLSRV_VARCHAR, len: 0
------------SQLIND
----------------len: 2, value: -1
------------SQLVAR
----------------len: 2, value: 12
------------SQLDATA
----------------SQLSRV_GENERALIZED_NUMBER, len: 8
--------------------len: 8, value: 10000.00
------------SQLIND
----------------len: 2, value: 0
------------SQLVAR
----------------len: 2, value: 13
------------SQLDATA
----------------SQLSRV_GENERALIZED_DATE, len: 16
--------------------len: 16, value: 0000000005000000
------------SQLIND
----------------len: 2, value: 0
------------SQLVAR
----------------len: 2, value: 14
------------SQLDATA
----------------SQLSRV_GENERALIZED_DATE, len: 16
--------------------len: 16, value: 0000000003000000
------------SQLIND
----------------len: 2, value: 0
------------SQLVAR
----------------len: 2, value: 15
------------SQLDATA
----------------SQLSRV_GENERALIZED_NUMBER, len: 6
--------------------len: 6, value: 800.00
------------SQLIND
----------------len: 2, value: 0
------------SQLVAR
----------------len: 2, value: 16
------------SQLDATA
----------------SQLSRV_GENERALIZED_NUMBER, len: 7
--------------------len: 7, value: 1000.00
------------SQLIND
----------------len: 2, value: 0
------------SQLVAR
----------------len: 2, value: 17
------------SQLDATA
----------------SQLSRV_GENERALIZED_NUMBER, len: 4
--------------------len: 4, value: 5.00
------------SQLIND
----------------len: 2, value: 0
------------SQLVAR
----------------len: 2, value: 18
------------SQLDATA
----------------SQLSRV_GENERALIZED_NUMBER, len: 0
------------SQLIND
----------------len: 2, value: -1
--------END OF MESSAGE
ROUTINE LEVEL LOG at 09:00:00 on 16-May-1997
----SELECT LIST SQLDA
--------SQLDA: SQLD 19
------------[0].SQLTYPE: SQLSRV_ASCII_STRING, SQLIND: 0
----------------len: 8, value: Non-printable data
------------[1].SQLTYPE: SQLSRV_GENERALIZED_NUMBER, SQLIND: 0
----------------len: 2, value: 10
------------[2].SQLTYPE: SQLSRV_VARCHAR, SQLIND: 0
----------------len: 49, value: Pier 50
----------------
------------[3].SQLTYPE: SQLSRV_ASCII_STRING, SQLIND: 0
----------------len: 12, value: X
------------[4].SQLTYPE: SQLSRV_VARCHAR, SQLIND: 0
----------------len: 7, value: Seattle
------------[5].SQLTYPE: SQLSRV_VARCHAR, SQLIND: 0
----------------len: 13, value: W.S.F.
------------[6].SQLTYPE: SQLSRV_VARCHAR, SQLIND: 0
----------------len: 49, value: Pier 50 - Seattle
----------------
------------[7].SQLTYPE: SQLSRV_VARCHAR, SQLIND: 0
----------------len: 49, value: PASSENGER
----------------
------------[8].SQLTYPE: SQLSRV_VARCHAR, SQLIND: 0
----------------len: 49, value: TOLLS COLLECTED HERE
----------------
------------[9].SQLTYPE: SQLSRV_VARCHAR, SQLIND: -1
----------------len: 0, value:
------------[10].SQLTYPE: SQLSRV_VARCHAR, SQLIND: -1
----------------len: 0, value:
------------[11].SQLTYPE: SQLSRV_VARCHAR, SQLIND: -1
----------------len: 0, value:
------------[12].SQLTYPE: SQLSRV_GENERALIZED_NUMBER, SQLIND: 0
----------------len: 8, value: 10000.00
------------[13].SQLTYPE: SQLSRV_GENERALIZED_DATE, SQLIND: 0
----------------len: 16, value: 0000000005000000
------------[14].SQLTYPE: SQLSRV_GENERALIZED_DATE, SQLIND: 0
----------------len: 16, value: 0000000003000000
------------[15].SQLTYPE: SQLSRV_GENERALIZED_NUMBER, SQLIND: 0
----------------len: 6, value: 800.00
------------[16].SQLTYPE: SQLSRV_GENERALIZED_NUMBER, SQLIND: 0
----------------len: 7, value: 1000.00
------------[17].SQLTYPE: SQLSRV_GENERALIZED_NUMBER, SQLIND: 0
----------------len: 4, value: 5.00
------------[18].SQLTYPE: SQLSRV_GENERALIZED_NUMBER, SQLIND: -1
----------------len: 0, value:
ROUTINE LEVEL LOG at 09:00:00 on 16-May-1997
----SQLSRV_FETCH
--------CURSOR NAME
------------SQL_CUR113AF60
PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:00:00 on 16-May-1997
----PACKET LENGTH: 28
PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:00:00 on 16-May-1997
----PACKET ID: 16, PACKET SEQUENCE: 0
--------SQLSRV_FETCH
------------CURSOR NAME
----------------SQLSRV_ASCII_STRING, len: 14
--------------------len: 14, value: SQL_CUR113AF60
--------END OF MESSAGE
PROTOCOL LEVEL LOG CLIENT: read at 09:00:00 on 16-May-1997
----PACKET LENGTH: 544
PROTOCOL LEVEL LOG CLIENT: read at 09:00:00 on 16-May-1997
----PACKET ID: 16, PACKET SEQUENCE: 0
--------SQLSRV_FETCH ACK
------------FETCH ROW NUMBER
----------------SQLSRV_GENERALIZED_NUMBER, len: 1
--------------------len: 1, value: 2
------------SELECT LIST DATA
----------------len: 2, value: 19
------------SQLVAR
----------------len: 2, value: 0
------------SQLDATA
----------------SQLSRV_ASCII_STRING, len: 8
--------------------len: 8, value: Non-printable data
------------SQLIND
----------------len: 2, value: 0
------------SQLVAR
----------------len: 2, value: 1
------------SQLDATA
----------------SQLSRV_GENERALIZED_NUMBER, len: 2
--------------------len: 2, value: 11
------------SQLIND
----------------len: 2, value: 0
------------SQLVAR
----------------len: 2, value: 2
------------SQLDATA
----------------SQLSRV_VARCHAR, len: 49
--------------------len: 49, value: Colman Dock
--------------------
------------SQLIND
----------------len: 2, value: 0
------------SQLVAR
----------------len: 2, value: 3
------------SQLDATA
----------------SQLSRV_ASCII_STRING, len: 12
--------------------len: 12, value: S
------------SQLIND
----------------len: 2, value: 0
------------SQLVAR
----------------len: 2, value: 4
------------SQLDATA
----------------SQLSRV_VARCHAR, len: 7
--------------------len: 7, value: Seattle
------------SQLIND
----------------len: 2, value: 0
------------SQLVAR
----------------len: 2, value: 5
------------SQLDATA
----------------SQLSRV_VARCHAR, len: 13
--------------------len: 13, value: W.S.F.
------------SQLIND
----------------len: 2, value: 0
------------SQLVAR
----------------len: 2, value: 6
------------SQLDATA
----------------SQLSRV_VARCHAR, len: 49
--------------------len: 49, value: Seattle
--------------------
------------SQLIND
----------------len: 2, value: 0
------------SQLVAR
----------------len: 2, value: 7
------------SQLDATA
----------------SQLSRV_VARCHAR, len: 49
--------------------len: 49, value: VEHICLE AND PASSENGER
--------------------
------------SQLIND
----------------len: 2, value: 0
------------SQLVAR
----------------len: 2, value: 8
------------SQLDATA
----------------SQLSRV_VARCHAR, len: 49
--------------------len: 49, value: TOLLS COLLECTED HERE
--------------------
------------SQLIND
----------------len: 2, value: 0
------------SQLVAR
----------------len: 2, value: 9
------------SQLDATA
----------------SQLSRV_VARCHAR, len: 0
------------SQLIND
----------------len: 2, value: -1
------------SQLVAR
----------------len: 2, value: 10
------------SQLDATA
----------------SQLSRV_VARCHAR, len: 0
------------SQLIND
----------------len: 2, value: -1
------------SQLVAR
----------------len: 2, value: 11
------------SQLDATA
----------------SQLSRV_VARCHAR, len: 0
------------SQLIND
----------------len: 2, value: -1
------------SQLVAR
----------------len: 2, value: 12
------------SQLDATA
----------------SQLSRV_GENERALIZED_NUMBER, len: 8
--------------------len: 8, value: 60000.00
------------SQLIND
----------------len: 2, value: 0
------------SQLVAR
----------------len: 2, value: 13
------------SQLDATA
----------------SQLSRV_GENERALIZED_DATE, len: 16
--------------------len: 16, value: 0000000004280000
------------SQLIND
----------------len: 2, value: 0
------------SQLVAR
----------------len: 2, value: 14
------------SQLDATA
----------------SQLSRV_GENERALIZED_DATE, len: 16
--------------------len: 16, value: 0000000002550000
------------SQLIND
----------------len: 2, value: 0
------------SQLVAR
----------------len: 2, value: 15
------------SQLDATA
----------------SQLSRV_GENERALIZED_NUMBER, len: 7
--------------------len: 7, value: 1200.00
------------SQLIND
----------------len: 2, value: 0
------------SQLVAR
----------------len: 2, value: 16
------------SQLDATA
----------------SQLSRV_GENERALIZED_NUMBER, len: 7
--------------------len: 7, value: 1500.00
------------SQLIND
----------------len: 2, value: 0
------------SQLVAR
----------------len: 2, value: 17
------------SQLDATA
----------------SQLSRV_GENERALIZED_NUMBER, len: 4
--------------------len: 4, value: 5.00
------------SQLIND
----------------len: 2, value: 0
------------SQLVAR
----------------len: 2, value: 18
------------SQLDATA
----------------SQLSRV_GENERALIZED_NUMBER, len: 1
--------------------len: 1, value: 6
------------SQLIND
----------------len: 2, value: 0
--------END OF MESSAGE
ROUTINE LEVEL LOG at 09:00:00 on 16-May-1997
----SELECT LIST SQLDA
--------SQLDA: SQLD 19
------------[0].SQLTYPE: SQLSRV_ASCII_STRING, SQLIND: 0
----------------len: 8, value: Non-printable data
------------[1].SQLTYPE: SQLSRV_GENERALIZED_NUMBER, SQLIND: 0
----------------len: 2, value: 11
------------[2].SQLTYPE: SQLSRV_VARCHAR, SQLIND: 0
----------------len: 49, value: Colman Dock
----------------
------------[3].SQLTYPE: SQLSRV_ASCII_STRING, SQLIND: 0
----------------len: 12, value: S
------------[4].SQLTYPE: SQLSRV_VARCHAR, SQLIND: 0
----------------len: 7, value: Seattle
------------[5].SQLTYPE: SQLSRV_VARCHAR, SQLIND: 0
----------------len: 13, value: W.S.F.
------------[6].SQLTYPE: SQLSRV_VARCHAR, SQLIND: 0
----------------len: 49, value: Seattle
----------------
------------[7].SQLTYPE: SQLSRV_VARCHAR, SQLIND: 0
----------------len: 49, value: VEHICLE AND PASSENGER
----------------
------------[8].SQLTYPE: SQLSRV_VARCHAR, SQLIND: 0
----------------len: 49, value: TOLLS COLLECTED HERE
----------------
------------[9].SQLTYPE: SQLSRV_VARCHAR, SQLIND: -1
----------------len: 0, value:
------------[10].SQLTYPE: SQLSRV_VARCHAR, SQLIND: -1
----------------len: 0, value:
------------[11].SQLTYPE: SQLSRV_VARCHAR, SQLIND: -1
----------------len: 0, value:
------------[12].SQLTYPE: SQLSRV_GENERALIZED_NUMBER, SQLIND: 0
----------------len: 8, value: 60000.00
------------[13].SQLTYPE: SQLSRV_GENERALIZED_DATE, SQLIND: 0
----------------len: 16, value: 0000000004280000
------------[14].SQLTYPE: SQLSRV_GENERALIZED_DATE, SQLIND: 0
----------------len: 16, value: 0000000002550000
------------[15].SQLTYPE: SQLSRV_GENERALIZED_NUMBER, SQLIND: 0
----------------len: 7, value: 1200.00
------------[16].SQLTYPE: SQLSRV_GENERALIZED_NUMBER, SQLIND: 0
----------------len: 7, value: 1500.00
------------[17].SQLTYPE: SQLSRV_GENERALIZED_NUMBER, SQLIND: 0
----------------len: 4, value: 5.00
------------[18].SQLTYPE: SQLSRV_GENERALIZED_NUMBER, SQLIND: 0
----------------len: 1, value: 6
ROUTINE LEVEL LOG at 09:00:00 on 16-May-1997
----SQLSRV_FETCH
--------CURSOR NAME
------------SQL_CUR113AF60
PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:00:00 on 16-May-1997
----PACKET LENGTH: 28
PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:00:00 on 16-May-1997
----PACKET ID: 17, PACKET SEQUENCE: 0
--------SQLSRV_FETCH
------------CURSOR NAME
----------------SQLSRV_ASCII_STRING, len: 14
--------------------len: 14, value: SQL_CUR113AF60
--------END OF MESSAGE
PROTOCOL LEVEL LOG CLIENT: read at 09:00:00 on 16-May-1997
----PACKET LENGTH: 506
PROTOCOL LEVEL LOG CLIENT: read at 09:00:00 on 16-May-1997
----PACKET ID: 17, PACKET SEQUENCE: 0
--------SQLSRV_FETCH ACK
------------FETCH ROW NUMBER
----------------SQLSRV_GENERALIZED_NUMBER, len: 1
--------------------len: 1, value: 3
------------SELECT LIST DATA
----------------len: 2, value: 19
------------SQLVAR
----------------len: 2, value: 0
------------SQLDATA
----------------SQLSRV_ASCII_STRING, len: 8
--------------------len: 8, value: Non-printable data
------------SQLIND
----------------len: 2, value: 0
------------SQLVAR
----------------len: 2, value: 1
------------SQLDATA
----------------SQLSRV_GENERALIZED_NUMBER, len: 2
--------------------len: 2, value: 12
------------SQLIND
----------------len: 2, value: 0
------------SQLVAR
----------------len: 2, value: 2
------------SQLDATA
----------------SQLSRV_VARCHAR, len: 9
--------------------len: 9, value: Bremerton
------------SQLIND
----------------len: 2, value: 0
------------SQLVAR
----------------len: 2, value: 3
------------SQLDATA
----------------SQLSRV_ASCII_STRING, len: 12
--------------------len: 12, value: B
------------SQLIND
----------------len: 2, value: 0
------------SQLVAR
----------------len: 2, value: 4
------------SQLDATA
----------------SQLSRV_VARCHAR, len: 9
--------------------len: 9, value: Bremerton
------------SQLIND
----------------len: 2, value: 0
------------SQLVAR
----------------len: 2, value: 5
------------SQLDATA
----------------SQLSRV_VARCHAR, len: 13
--------------------len: 13, value: W.S.F.
------------SQLIND
----------------len: 2, value: 0
------------SQLVAR
----------------len: 2, value: 6
------------SQLDATA
----------------SQLSRV_VARCHAR, len: 49
--------------------len: 49, value: Bremerton
--------------------
------------SQLIND
----------------len: 2, value: 0
------------SQLVAR
----------------len: 2, value: 7
------------SQLDATA
----------------SQLSRV_VARCHAR, len: 49
--------------------len: 49, value: PASSENGER TOLLS NOT
--------------------
------------SQLIND
----------------len: 2, value: 0
------------SQLVAR
----------------len: 2, value: 8
------------SQLDATA
----------------SQLSRV_VARCHAR, len: 49
--------------------len: 49, value: COLLECTED HERE
--------------------
------------SQLIND
----------------len: 2, value: 0
------------SQLVAR
----------------len: 2, value: 9
------------SQLDATA
----------------SQLSRV_VARCHAR, len: 0
------------SQLIND
----------------len: 2, value: -1
------------SQLVAR
----------------len: 2, value: 10
------------SQLDATA
----------------SQLSRV_VARCHAR, len: 0
------------SQLIND
----------------len: 2, value: -1
------------SQLVAR
----------------len: 2, value: 11
------------SQLDATA
----------------SQLSRV_VARCHAR, len: 0
------------SQLIND
----------------len: 2, value: -1
------------SQLVAR
----------------len: 2, value: 12
------------SQLDATA
----------------SQLSRV_GENERALIZED_NUMBER, len: 8
--------------------len: 8, value: 23000.00
------------SQLIND
----------------len: 2, value: 0
------------SQLVAR
----------------len: 2, value: 13
------------SQLDATA
----------------SQLSRV_GENERALIZED_DATE, len: 16
--------------------len: 16, value: 0000000004150000
------------SQLIND
----------------len: 2, value: 0
------------SQLVAR
----------------len: 2, value: 14
------------SQLDATA
----------------SQLSRV_GENERALIZED_DATE, len: 16
--------------------len: 16, value: 0000000002000000
------------SQLIND
----------------len: 2, value: 0
------------SQLVAR
----------------len: 2, value: 15
------------SQLDATA
----------------SQLSRV_GENERALIZED_NUMBER, len: 7
--------------------len: 7, value: 1200.00
------------SQLIND
----------------len: 2, value: 0
------------SQLVAR
----------------len: 2, value: 16
------------SQLDATA
----------------SQLSRV_GENERALIZED_NUMBER, len: 7
--------------------len: 7, value: 1500.00
------------SQLIND
----------------len: 2, value: 0
------------SQLVAR
----------------len: 2, value: 17
------------SQLDATA
----------------SQLSRV_GENERALIZED_NUMBER, len: 4
--------------------len: 4, value: 5.00
------------SQLIND
----------------len: 2, value: 0
------------SQLVAR
----------------len: 2, value: 18
------------SQLDATA
----------------SQLSRV_GENERALIZED_NUMBER, len: 1
--------------------len: 1, value: 4
------------SQLIND
----------------len: 2, value: 0
--------END OF MESSAGE
ROUTINE LEVEL LOG at 09:00:00 on 16-May-1997
----SELECT LIST SQLDA
--------SQLDA: SQLD 19
------------[0].SQLTYPE: SQLSRV_ASCII_STRING, SQLIND: 0
----------------len: 8, value: Non-printable data
------------[1].SQLTYPE: SQLSRV_GENERALIZED_NUMBER, SQLIND: 0
----------------len: 2, value: 12
------------[2].SQLTYPE: SQLSRV_VARCHAR, SQLIND: 0
----------------len: 9, value: Bremerton
------------[3].SQLTYPE: SQLSRV_ASCII_STRING, SQLIND: 0
----------------len: 12, value: B
------------[4].SQLTYPE: SQLSRV_VARCHAR, SQLIND: 0
----------------len: 9, value: Bremerton
------------[5].SQLTYPE: SQLSRV_VARCHAR, SQLIND: 0
----------------len: 13, value: W.S.F.
------------[6].SQLTYPE: SQLSRV_VARCHAR, SQLIND: 0
----------------len: 49, value: Bremerton
----------------
------------[7].SQLTYPE: SQLSRV_VARCHAR, SQLIND: 0
----------------len: 49, value: PASSENGER TOLLS NOT
----------------
------------[8].SQLTYPE: SQLSRV_VARCHAR, SQLIND: 0
----------------len: 49, value: COLLECTED HERE
----------------
------------[9].SQLTYPE: SQLSRV_VARCHAR, SQLIND: -1
----------------len: 0, value:
------------[10].SQLTYPE: SQLSRV_VARCHAR, SQLIND: -1
----------------len: 0, value:
------------[11].SQLTYPE: SQLSRV_VARCHAR, SQLIND: -1
----------------len: 0, value:
------------[12].SQLTYPE: SQLSRV_GENERALIZED_NUMBER, SQLIND: 0
----------------len: 8, value: 23000.00
------------[13].SQLTYPE: SQLSRV_GENERALIZED_DATE, SQLIND: 0
----------------len: 16, value: 0000000004150000
------------[14].SQLTYPE: SQLSRV_GENERALIZED_DATE, SQLIND: 0
----------------len: 16, value: 0000000002000000
------------[15].SQLTYPE: SQLSRV_GENERALIZED_NUMBER, SQLIND: 0
----------------len: 7, value: 1200.00
------------[16].SQLTYPE: SQLSRV_GENERALIZED_NUMBER, SQLIND: 0
----------------len: 7, value: 1500.00
------------[17].SQLTYPE: SQLSRV_GENERALIZED_NUMBER, SQLIND: 0
----------------len: 4, value: 5.00
------------[18].SQLTYPE: SQLSRV_GENERALIZED_NUMBER, SQLIND: 0
----------------len: 1, value: 4
ROUTINE LEVEL LOG at 09:00:00 on 16-May-1997
----SQLSRV_FETCH
--------CURSOR NAME
------------SQL_CUR113AF60
PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:00:00 on 16-May-1997
----PACKET LENGTH: 28
PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:00:00 on 16-May-1997
----PACKET ID: 18, PACKET SEQUENCE: 0
--------SQLSRV_FETCH
------------CURSOR NAME
----------------SQLSRV_ASCII_STRING, len: 14
--------------------len: 14, value: SQL_CUR113AF60
--------END OF MESSAGE
PROTOCOL LEVEL LOG CLIENT: read at 09:00:00 on 16-May-1997
----PACKET LENGTH: 522
PROTOCOL LEVEL LOG CLIENT: read at 09:00:00 on 16-May-1997
----PACKET ID: 18, PACKET SEQUENCE: 0
--------SQLSRV_FETCH ACK
------------FETCH ROW NUMBER
----------------SQLSRV_GENERALIZED_NUMBER, len: 1
--------------------len: 1, value: 4
------------SELECT LIST DATA
----------------len: 2, value: 19
------------SQLVAR
----------------len: 2, value: 0
------------SQLDATA
----------------SQLSRV_ASCII_STRING, len: 8
--------------------len: 8, value: Non-printable data
------------SQLIND
----------------len: 2, value: 0
------------SQLVAR
----------------len: 2, value: 1
------------SQLDATA
----------------SQLSRV_GENERALIZED_NUMBER, len: 2
--------------------len: 2, value: 13
------------SQLIND
----------------len: 2, value: 0
------------SQLVAR
----------------len: 2, value: 2
------------SQLDATA
----------------SQLSRV_VARCHAR, len: 17
--------------------len: 17, value: Bainbridge Island
------------SQLIND
----------------len: 2, value: 0
------------SQLVAR
----------------len: 2, value: 3
------------SQLDATA
----------------SQLSRV_ASCII_STRING, len: 12
--------------------len: 12, value: W
------------SQLIND
----------------len: 2, value: 0
------------SQLVAR
----------------len: 2, value: 4
------------SQLDATA
----------------SQLSRV_VARCHAR, len: 17
--------------------len: 17, value: Bainbridge Island
------------SQLIND
----------------len: 2, value: 0
------------SQLVAR
----------------len: 2, value: 5
------------SQLDATA
----------------SQLSRV_VARCHAR, len: 13
--------------------len: 13, value: W.S.F.
------------SQLIND
----------------len: 2, value: 0
------------SQLVAR
----------------len: 2, value: 6
------------SQLDATA
----------------SQLSRV_VARCHAR, len: 49
--------------------len: 49, value: Bainbridge Island
--------------------
------------SQLIND
----------------len: 2, value: 0
------------SQLVAR
----------------len: 2, value: 7
------------SQLDATA
----------------SQLSRV_VARCHAR, len: 49
--------------------len: 49, value: PASSENGER TOLLS NOT
--------------------
------------SQLIND
----------------len: 2, value: 0
------------SQLVAR
----------------len: 2, value: 8
------------SQLDATA
----------------SQLSRV_VARCHAR, len: 49
--------------------len: 49, value: COLLECTED HERE
--------------------
------------SQLIND
----------------len: 2, value: 0
------------SQLVAR
----------------len: 2, value: 9
------------SQLDATA
----------------SQLSRV_VARCHAR, len: 0
------------SQLIND
----------------len: 2, value: -1
------------SQLVAR
----------------len: 2, value: 10
------------SQLDATA
----------------SQLSRV_VARCHAR, len: 0
------------SQLIND
----------------len: 2, value: -1
------------SQLVAR
----------------len: 2, value: 11
------------SQLDATA
----------------SQLSRV_VARCHAR, len: 0
------------SQLIND
----------------len: 2, value: -1
------------SQLVAR
----------------len: 2, value: 12
------------SQLDATA
----------------SQLSRV_GENERALIZED_NUMBER, len: 8
--------------------len: 8, value: 36800.00
------------SQLIND
----------------len: 2, value: 0
------------SQLVAR
----------------len: 2, value: 13
------------SQLDATA
----------------SQLSRV_GENERALIZED_DATE, len: 16
--------------------len: 16, value: 0000000004300000
------------SQLIND
----------------len: 2, value: 0
------------SQLVAR
----------------len: 2, value: 14
------------SQLDATA
----------------SQLSRV_GENERALIZED_DATE, len: 16
--------------------len: 16, value: 0000000002000000
------------SQLIND
----------------len: 2, value: 0
------------SQLVAR
----------------len: 2, value: 15
------------SQLDATA
----------------SQLSRV_GENERALIZED_NUMBER, len: 7
--------------------len: 7, value: 1200.00
------------SQLIND
----------------len: 2, value: 0
------------SQLVAR
----------------len: 2, value: 16
------------SQLDATA
----------------SQLSRV_GENERALIZED_NUMBER, len: 7
--------------------len: 7, value: 1500.00
------------SQLIND
----------------len: 2, value: 0
------------SQLVAR
----------------len: 2, value: 17
------------SQLDATA
----------------SQLSRV_GENERALIZED_NUMBER, len: 4
--------------------len: 4, value: 5.00
------------SQLIND
----------------len: 2, value: 0
------------SQLVAR
----------------len: 2, value: 18
------------SQLDATA
----------------SQLSRV_GENERALIZED_NUMBER, len: 1
--------------------len: 1, value: 4
------------SQLIND
----------------len: 2, value: 0
--------END OF MESSAGE
ROUTINE LEVEL LOG at 09:00:00 on 16-May-1997
----SELECT LIST SQLDA
--------SQLDA: SQLD 19
------------[0].SQLTYPE: SQLSRV_ASCII_STRING, SQLIND: 0
----------------len: 8, value: Non-printable data
------------[1].SQLTYPE: SQLSRV_GENERALIZED_NUMBER, SQLIND: 0
----------------len: 2, value: 13
------------[2].SQLTYPE: SQLSRV_VARCHAR, SQLIND: 0
----------------len: 17, value: Bainbridge Island
------------[3].SQLTYPE: SQLSRV_ASCII_STRING, SQLIND: 0
----------------len: 12, value: W
------------[4].SQLTYPE: SQLSRV_VARCHAR, SQLIND: 0
----------------len: 17, value: Bainbridge Island
------------[5].SQLTYPE: SQLSRV_VARCHAR, SQLIND: 0
----------------len: 13, value: W.S.F.
------------[6].SQLTYPE: SQLSRV_VARCHAR, SQLIND: 0
----------------len: 49, value: Bainbridge Island
----------------
------------[7].SQLTYPE: SQLSRV_VARCHAR, SQLIND: 0
----------------len: 49, value: PASSENGER TOLLS NOT
----------------
------------[8].SQLTYPE: SQLSRV_VARCHAR, SQLIND: 0
----------------len: 49, value: COLLECTED HERE
----------------
------------[9].SQLTYPE: SQLSRV_VARCHAR, SQLIND: -1
----------------len: 0, value:
------------[10].SQLTYPE: SQLSRV_VARCHAR, SQLIND: -1
----------------len: 0, value:
------------[11].SQLTYPE: SQLSRV_VARCHAR, SQLIND: -1
----------------len: 0, value:
------------[12].SQLTYPE: SQLSRV_GENERALIZED_NUMBER, SQLIND: 0
----------------len: 8, value: 36800.00
------------[13].SQLTYPE: SQLSRV_GENERALIZED_DATE, SQLIND: 0
----------------len: 16, value: 0000000004300000
------------[14].SQLTYPE: SQLSRV_GENERALIZED_DATE, SQLIND: 0
----------------len: 16, value: 0000000002000000
------------[15].SQLTYPE: SQLSRV_GENERALIZED_NUMBER, SQLIND: 0
----------------len: 7, value: 1200.00
------------[16].SQLTYPE: SQLSRV_GENERALIZED_NUMBER, SQLIND: 0
----------------len: 7, value: 1500.00
------------[17].SQLTYPE: SQLSRV_GENERALIZED_NUMBER, SQLIND: 0
----------------len: 4, value: 5.00
------------[18].SQLTYPE: SQLSRV_GENERALIZED_NUMBER, SQLIND: 0
----------------len: 1, value: 4
ROUTINE LEVEL LOG at 09:00:00 on 16-May-1997
----SQLSRV_FETCH
--------CURSOR NAME
------------SQL_CUR113AF60
PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:00:00 on 16-May-1997
----PACKET LENGTH: 28
PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:00:00 on 16-May-1997
----PACKET ID: 19, PACKET SEQUENCE: 0
--------SQLSRV_FETCH
------------CURSOR NAME
----------------SQLSRV_ASCII_STRING, len: 14
--------------------len: 14, value: SQL_CUR113AF60
--------END OF MESSAGE
PROTOCOL LEVEL LOG CLIENT: read at 09:00:00 on 16-May-1997
----PACKET LENGTH: 508
PROTOCOL LEVEL LOG CLIENT: read at 09:00:00 on 16-May-1997
----PACKET ID: 19, PACKET SEQUENCE: 0
--------SQLSRV_FETCH ACK
------------FETCH ROW NUMBER
----------------SQLSRV_GENERALIZED_NUMBER, len: 1
--------------------len: 1, value: 5
------------SELECT LIST DATA
----------------len: 2, value: 19
------------SQLVAR
----------------len: 2, value: 0
------------SQLDATA
----------------SQLSRV_ASCII_STRING, len: 8
--------------------len: 8, value: Non-printable data
|
|
Here is the 16 bit client log that displays the results that are expected...
Log file generated by C:\WINNT\system\SQSAPIW.DLL
Oracle Sql/Services Version 7.00
ASSOCIATE LEVEL LOG
----SQLSRV_ASSOCIATE
--------SQLSRV_ASSOCIATE ID: 31070018
--------NODE: pos_mrs.wsdot.wa.gov, USERNAME: arcsuser, SQLCODE: 0,
SQLERRD[0] 0
--------NETWORK TRANSPORT: TCP/IP
PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:00:00 on 16-May-1997
----PACKET ID: 1, PACKET SEQUENCE: 0
--------SQLSRV_ASSOCIATE
------------CLIENT PROTOCOL VERSION
----------------len: 2, value: 14
------------USERNAME
----------------SQLSRV_ASCII_STRING, len: 8
--------------------len: 8, value: arcsuser
------------PASSWORD
----------------SQLSRV_VARCHAR, len: 10
--------------------len: 10, value: <password>
------------READ BUFFER SIZE
----------------len: 2, value: 5000
------------WRITE BUFFER SIZE
----------------len: 2, value: 5000
------------SERVICE NAME
----------------SQLSRV_ASCII_STRING, len: 5
--------------------len: 5, value: MRSDB
------------DECLARE TRANSACTION STATEMENT
----------------SQLSRV_ASCII_STRING, len: 54
--------------------len: 54, value: DECLARE TRANSACTION READ ONLY WAIT
CONSISTEN
--------------------CY LEVEL 2
------------APPLICATION NAME
----------------SQLSRV_ASCII_STRING, len: 8
--------------------len: 8, value: MSACCESS
--------END OF MESSAGE
PROTOCOL LEVEL LOG CLIENT: read at 09:00:00 on 16-May-1997
----PACKET ID: 1, PACKET SEQUENCE: 0
--------SQLSRV_ASSOCIATE ACK
------------CLIENT PROTOCOL VERSION
----------------len: 2, value: 14
------------ASSOCIATE ID
----------------len: 2, value: 0
------------DEC SQL VERSION
----------------SQLSRV_ASCII_STRING, len: 7
--------------------len: 7, value: V6.1-04
------------RDB ENG VERSION
----------------SQLSRV_ASCII_STRING, len: 7
--------------------len: 7, value: V6.1-04
------------SERVER PROTOCOL VERSION
----------------len: 2, value: 8
------------SQLSRV SERVER VERSION
----------------SQLSRV_ASCII_STRING, len: 7
--------------------len: 7, value: V6.1-02
------------EXCECUTOR PID
----------------SQLSRV_GENERALIZED_NUMBER, len: 4
--------------------len: 4, value: 3842
------------SERVICE ATTRIBUTES
----------------len: 2, value: 1
------------STATUS
----------------SQLSRV_GENERALIZED_NUMBER, len: 1
--------------------len: 1, value: 0
--------END OF MESSAGE
ROUTINE LEVEL LOG at 09:00:00 on 16-May-1997
----SQLSRV_GET_ASSOCIATE_INFO
ROUTINE LEVEL LOG at 09:00:00 on 16-May-1997
----SQLSRV_GET_ASSOCIATE_INFO
ROUTINE LEVEL LOG at 09:00:00 on 16-May-1997
----SQLSRV_GET_ASSOCIATE_INFO
ROUTINE LEVEL LOG at 09:00:00 on 16-May-1997
----SQLSRV_EXECUTE_IMMEDIATE
--------SQL STATEMENT
------------len: 54, value: DECLARE TRANSACTION READ ONLY WAIT
CONSISTENCY LEVEL
------------ 2
PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:00:00 on 16-May-1997
----PACKET LENGTH: 68
PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:00:00 on 16-May-1997
----PACKET ID: 2, PACKET SEQUENCE: 0
--------SQLSRV_EXECUTE_IMMEDIATE
------------SQL STATEMENT
----------------SQLSRV_ASCII_STRING, len: 54
--------------------len: 54, value: DECLARE TRANSACTION READ ONLY WAIT
CONSISTEN
--------------------CY LEVEL 2
--------END OF MESSAGE
PROTOCOL LEVEL LOG CLIENT: read at 09:00:00 on 16-May-1997
----PACKET LENGTH: 20
PROTOCOL LEVEL LOG CLIENT: read at 09:00:00 on 16-May-1997
----PACKET ID: 2, PACKET SEQUENCE: 0
--------SQLSRV_EXECUTE_IMMEDIATE ACK
------------STATUS
----------------SQLSRV_GENERALIZED_NUMBER, len: 1
--------------------len: 1, value: 0
------------EXECUTE PARAMETER
----------------SQLSRV_GENERALIZED_NUMBER, len: 1
--------------------len: 1, value: 0
--------END OF MESSAGE
ROUTINE LEVEL LOG at 09:00:00 on 16-May-1997
----SQLSRV_PREPARE
--------SQL STATEMENT
------------len: 35, value: SELECT Config, nValue FROM MSysConf
PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:00:00 on 16-May-1997
----PACKET LENGTH: 49
PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:00:00 on 16-May-1997
----PACKET ID: 3, PACKET SEQUENCE: 0
--------SQLSRV_PREPARE
------------SQL STATEMENT
----------------SQLSRV_ASCII_STRING, len: 35
--------------------len: 35, value: SELECT Config, nValue FROM MSysConf
--------END OF MESSAGE
PROTOCOL LEVEL LOG CLIENT: read at 09:00:00 on 16-May-1997
----PACKET LENGTH: 97
PROTOCOL LEVEL LOG CLIENT: read at 09:00:00 on 16-May-1997
----PACKET ID: 3, PACKET SEQUENCE: 0
--------ERROR ACK
------------ERROR_VALUE_TAG
----------------SQLSRV_GENERALIZED_NUMBER, len: 5
--------------------len: 5, value: -1041
------------SPECIFIC_ERROR_TAG
----------------SQLSRV_GENERALIZED_NUMBER, len: 1
--------------------len: 1, value: 0
------------SPECIFIC_ERROR_TEXT_TAG
----------------SQLSRV_ASCII_STRING, len: 69
--------------------len: 69, value: %SQL-F-RELNOTDEF, Table MSYSCONF is
not defi
--------------------ned in database or schema
--------END OF MESSAGE
ROUTINE LEVEL LOG at 09:00:00 on 16-May-1997
----SQLSRV_EXECUTE_IMMEDIATE
--------SQL STATEMENT
------------len: 54, value: DECLARE TRANSACTION READ ONLY WAIT
CONSISTENCY LEVEL
------------ 2
PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:00:00 on 16-May-1997
----PACKET LENGTH: 68
PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:00:00 on 16-May-1997
----PACKET ID: 4, PACKET SEQUENCE: 0
--------SQLSRV_EXECUTE_IMMEDIATE
------------SQL STATEMENT
----------------SQLSRV_ASCII_STRING, len: 54
--------------------len: 54, value: DECLARE TRANSACTION READ ONLY WAIT
CONSISTEN
--------------------CY LEVEL 2
--------END OF MESSAGE
PROTOCOL LEVEL LOG CLIENT: read at 09:00:00 on 16-May-1997
----PACKET LENGTH: 106
PROTOCOL LEVEL LOG CLIENT: read at 09:00:00 on 16-May-1997
----PACKET ID: 4, PACKET SEQUENCE: 0
--------ERROR ACK
------------ERROR_VALUE_TAG
----------------SQLSRV_GENERALIZED_NUMBER, len: 2
--------------------len: 2, value: -1
------------SPECIFIC_ERROR_TAG
----------------SQLSRV_GENERALIZED_NUMBER, len: 1
--------------------len: 1, value: 0
------------SPECIFIC_ERROR_TEXT_TAG
----------------SQLSRV_ASCII_STRING, len: 81
--------------------len: 81, value: %SQL-F-NO_DCLTXN, You cannot declare
a trans
--------------------action while a transaction is active.
--------END OF MESSAGE
ROUTINE LEVEL LOG at 09:00:00 on 16-May-1997
PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:00:00 on 16-May-1997
----PACKET LENGTH: 14
PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:00:00 on 16-May-1997
----PACKET ID: 5, PACKET SEQUENCE: 0
--------SQLSRV_TRANSACT
------------TRANSACTION TYPE
----------------len: 2, value: 1
--------END OF MESSAGE
PROTOCOL LEVEL LOG CLIENT: read at 09:00:00 on 16-May-1997
----PACKET LENGTH: 15
PROTOCOL LEVEL LOG CLIENT: read at 09:00:00 on 16-May-1997
----PACKET ID: 5, PACKET SEQUENCE: 0
--------SQLSRV_TRANSACT ACK
------------STATUS
----------------SQLSRV_GENERALIZED_NUMBER, len: 1
--------------------len: 1, value: 0
--------END OF MESSAGE
ROUTINE LEVEL LOG at 09:00:00 on 16-May-1997
----SQLSRV_EXECUTE_IMMEDIATE
--------SQL STATEMENT
------------len: 54, value: DECLARE TRANSACTION READ ONLY WAIT
CONSISTENCY LEVEL
------------ 2
PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:00:00 on 16-May-1997
----PACKET LENGTH: 68
PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:00:00 on 16-May-1997
----PACKET ID: 6, PACKET SEQUENCE: 0
--------SQLSRV_EXECUTE_IMMEDIATE
------------SQL STATEMENT
----------------SQLSRV_ASCII_STRING, len: 54
--------------------len: 54, value: DECLARE TRANSACTION READ ONLY WAIT
CONSISTEN
--------------------CY LEVEL 2
--------END OF MESSAGE
PROTOCOL LEVEL LOG CLIENT: read at 09:00:00 on 16-May-1997
----PACKET LENGTH: 20
PROTOCOL LEVEL LOG CLIENT: read at 09:00:00 on 16-May-1997
----PACKET ID: 6, PACKET SEQUENCE: 0
--------SQLSRV_EXECUTE_IMMEDIATE ACK
------------STATUS
----------------SQLSRV_GENERALIZED_NUMBER, len: 1
--------------------len: 1, value: 0
------------EXECUTE PARAMETER
----------------SQLSRV_GENERALIZED_NUMBER, len: 1
--------------------len: 1, value: 0
--------END OF MESSAGE
ROUTINE LEVEL LOG at 09:00:00 on 16-May-1997
----SQLSRV_PREPARE
--------SQL STATEMENT
------------len: 403, value: SELECT DDAL$DBKEY ,TERMINAL_ID ,TERMINAL
,STATION_F
------------IRST_DIG_NUM ,CITY ,RECEIPT_HEADER_LINE1
,RECEIPT_HEADER_LINE2 ,RECE
------------IPT_HEADER_LINE3 ,RECEIPT_HEADER_LINE4 ,RECEIPT_HEADER_LINE5
,RECEIP
------------T_FOOTER_LINE1 ,RECEIPT_FOOTER_LINE2 ,WORKING_FUND_AMOUNT
,SALES_DAY
------------_START_TIME ,SALES_DAY_END_TIME ,CASH_PICKUP_WARNING_AMOUNT
,CASH_PI
------------CKUP_LIMIT_AMOUNT ,CASH_DECLARE_TOLERANCE_AMOUNT
,POS_DATABASE_ID F
------------ROM TERMINAL
PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:00:00 on 16-May-1997
----PACKET LENGTH: 417
PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:00:00 on 16-May-1997
----PACKET ID: 7, PACKET SEQUENCE: 0
--------SQLSRV_PREPARE
------------SQL STATEMENT
----------------SQLSRV_ASCII_STRING, len: 403
--------------------len: 403, value: SELECT DDAL$DBKEY ,TERMINAL_ID
,TERMINAL ,S
--------------------TATION_FIRST_DIG_NUM ,CITY ,RECEIPT_HEADER_LINE1
,RECEIPT_HE
--------------------ADER_LINE2 ,RECEIPT_HEADER_LINE3
,RECEIPT_HEADER_LINE4 ,RECE
--------------------IPT_HEADER_LINE5 ,RECEIPT_FOOTER_LINE1
,RECEIPT_FOOTER_LINE2
-------------------- ,WORKING_FUND_AMOUNT ,SALES_DAY_START_TIME
,SALES_DAY_END_T
--------------------IME ,CASH_PICKUP_WARNING_AMOUNT
,CASH_PICKUP_LIMIT_AMOUNT ,C
--------------------ASH_DECLARE_TOLERANCE_AMOUNT ,POS_DATABASE_ID FROM
TERMINAL
--------END OF MESSAGE
PROTOCOL LEVEL LOG CLIENT: read at 09:00:00 on 16-May-1997
----PACKET LENGTH: 679
PROTOCOL LEVEL LOG CLIENT: read at 09:00:00 on 16-May-1997
----PACKET ID: 7, PACKET SEQUENCE: 0
--------SQLSRV_PREPARE ACK
------------STATEMENT ID
----------------SQLSRV_GENERALIZED_NUMBER, len: 7
--------------------len: 7, value: 1000000
------------SQLERRD[1]
----------------SQLSRV_GENERALIZED_NUMBER, len: 1
--------------------len: 1, value: 1
------------SELECT LIST SQLDA
----------------len: 2, value: 19
------------SQLVAR
----------------len: 2, value: 0
------------SQLTYPE
----------------len: 2, value: 129
------------SQLLEN
----------------len: 2, value: 8
------------SQLNAME
----------------SQLSRV_ASCII_STRING, len: 10
--------------------len: 10, value: DDAL$DBKEY
------------SQLVAR
----------------len: 2, value: 1
------------SQLTYPE
----------------len: 2, value: 130
------------SQLLEN
----------------len: 2, value: 11
------------SQLNAME
----------------SQLSRV_ASCII_STRING, len: 11
--------------------len: 11, value: TERMINAL_ID
------------SQLVAR
----------------len: 2, value: 2
------------SQLTYPE
----------------len: 2, value: 132
------------SQLLEN
----------------len: 2, value: 50
------------SQLNAME
----------------SQLSRV_ASCII_STRING, len: 8
--------------------len: 8, value: TERMINAL
------------SQLVAR
----------------len: 2, value: 3
------------SQLTYPE
----------------len: 2, value: 129
------------SQLLEN
----------------len: 2, value: 12
------------SQLNAME
----------------SQLSRV_ASCII_STRING, len: 21
--------------------len: 21, value: STATION_FIRST_DIG_NUM
------------SQLVAR
----------------len: 2, value: 4
------------SQLTYPE
----------------len: 2, value: 132
------------SQLLEN
----------------len: 2, value: 50
------------SQLNAME
----------------SQLSRV_ASCII_STRING, len: 4
--------------------len: 4, value: CITY
------------SQLVAR
----------------len: 2, value: 5
------------SQLTYPE
----------------len: 2, value: 132
------------SQLLEN
----------------len: 2, value: 50
------------SQLNAME
----------------SQLSRV_ASCII_STRING, len: 20
--------------------len: 20, value: RECEIPT_HEADER_LINE1
------------SQLVAR
----------------len: 2, value: 6
------------SQLTYPE
----------------len: 2, value: 132
------------SQLLEN
----------------len: 2, value: 50
------------SQLNAME
----------------SQLSRV_ASCII_STRING, len: 20
--------------------len: 20, value: RECEIPT_HEADER_LINE2
------------SQLVAR
----------------len: 2, value: 7
------------SQLTYPE
----------------len: 2, value: 132
------------SQLLEN
----------------len: 2, value: 50
------------SQLNAME
----------------SQLSRV_ASCII_STRING, len: 20
--------------------len: 20, value: RECEIPT_HEADER_LINE3
------------SQLVAR
----------------len: 2, value: 8
------------SQLTYPE
----------------len: 2, value: 132
------------SQLLEN
----------------len: 2, value: 50
------------SQLNAME
----------------SQLSRV_ASCII_STRING, len: 20
--------------------len: 20, value: RECEIPT_HEADER_LINE4
------------SQLVAR
----------------len: 2, value: 9
------------SQLTYPE
----------------len: 2, value: 132
------------SQLLEN
----------------len: 2, value: 50
------------SQLNAME
----------------SQLSRV_ASCII_STRING, len: 20
--------------------len: 20, value: RECEIPT_HEADER_LINE5
------------SQLVAR
----------------len: 2, value: 10
------------SQLTYPE
----------------len: 2, value: 132
------------SQLLEN
----------------len: 2, value: 50
------------SQLNAME
----------------SQLSRV_ASCII_STRING, len: 20
--------------------len: 20, value: RECEIPT_FOOTER_LINE1
------------SQLVAR
----------------len: 2, value: 11
------------SQLTYPE
----------------len: 2, value: 132
------------SQLLEN
----------------len: 2, value: 50
------------SQLNAME
----------------SQLSRV_ASCII_STRING, len: 20
--------------------len: 20, value: RECEIPT_FOOTER_LINE2
------------SQLVAR
----------------len: 2, value: 12
------------SQLTYPE
----------------len: 2, value: 130
------------SQLLEN
----------------len: 2, value: 524
------------SQLNAME
----------------SQLSRV_ASCII_STRING, len: 19
--------------------len: 19, value: WORKING_FUND_AMOUNT
------------SQLVAR
----------------len: 2, value: 13
------------SQLTYPE
----------------len: 2, value: 131
------------SQLLEN
----------------len: 2, value: 529
------------SQLNAME
----------------SQLSRV_ASCII_STRING, len: 20
--------------------len: 20, value: SALES_DAY_START_TIME
------------SQLVAR
----------------len: 2, value: 14
------------SQLTYPE
----------------len: 2, value: 131
------------SQLLEN
----------------len: 2, value: 529
------------SQLNAME
----------------SQLSRV_ASCII_STRING, len: 18
--------------------len: 18, value: SALES_DAY_END_TIME
------------SQLVAR
----------------len: 2, value: 15
------------SQLTYPE
----------------len: 2, value: 130
------------SQLLEN
----------------len: 2, value: 524
------------SQLNAME
----------------SQLSRV_ASCII_STRING, len: 26
--------------------len: 26, value: CASH_PICKUP_WARNING_AMOUNT
------------SQLVAR
----------------len: 2, value: 16
------------SQLTYPE
----------------len: 2, value: 130
------------SQLLEN
----------------len: 2, value: 524
------------SQLNAME
----------------SQLSRV_ASCII_STRING, len: 24
--------------------len: 24, value: CASH_PICKUP_LIMIT_AMOUNT
------------SQLVAR
----------------len: 2, value: 17
------------SQLTYPE
----------------len: 2, value: 130
------------SQLLEN
----------------len: 2, value: 524
------------SQLNAME
----------------SQLSRV_ASCII_STRING, len: 29
--------------------len: 29, value: CASH_DECLARE_TOLERANCE_AMOUNT
------------SQLVAR
----------------len: 2, value: 18
------------SQLTYPE
----------------len: 2, value: 130
------------SQLLEN
----------------len: 2, value: 11
------------SQLNAME
----------------SQLSRV_ASCII_STRING, len: 15
--------------------len: 15, value: POS_DATABASE_ID
--------END OF MESSAGE
ROUTINE LEVEL LOG at 09:00:00 on 16-May-1997
----SELECT LIST SQLDA
--------SQLDA: SQLD 19
--------[0].SQLTYPE: SQLSRV_ASCII_STRING, SQLLEN: 8
------------SQLNAME: DDAL$DBKEY
--------[1].SQLTYPE: SQLSRV_GENERALIZED_NUMBER, SIZE 11, SCALE 0
------------SQLNAME: TERMINAL_ID
--------[2].SQLTYPE: SQLSRV_VARCHAR, SQLLEN: 50
------------SQLNAME: TERMINAL
--------[3].SQLTYPE: SQLSRV_ASCII_STRING, SQLLEN: 12
------------SQLNAME: STATION_FIRST_DIG_NUM
--------[4].SQLTYPE: SQLSRV_VARCHAR, SQLLEN: 50
------------SQLNAME: CITY
--------[5].SQLTYPE: SQLSRV_VARCHAR, SQLLEN: 50
------------SQLNAME: RECEIPT_HEADER_LINE1
--------[6].SQLTYPE: SQLSRV_VARCHAR, SQLLEN: 50
------------SQLNAME: RECEIPT_HEADER_LINE2
--------[7].SQLTYPE: SQLSRV_VARCHAR, SQLLEN: 50
------------SQLNAME: RECEIPT_HEADER_LINE3
--------[8].SQLTYPE: SQLSRV_VARCHAR, SQLLEN: 50
------------SQLNAME: RECEIPT_HEADER_LINE4
--------[9].SQLTYPE: SQLSRV_VARCHAR, SQLLEN: 50
------------SQLNAME: RECEIPT_HEADER_LINE5
--------[10].SQLTYPE: SQLSRV_VARCHAR, SQLLEN: 50
------------SQLNAME: RECEIPT_FOOTER_LINE1
--------[11].SQLTYPE: SQLSRV_VARCHAR, SQLLEN: 50
------------SQLNAME: RECEIPT_FOOTER_LINE2
--------[12].SQLTYPE: SQLSRV_GENERALIZED_NUMBER, SIZE 12, SCALE 2
------------SQLNAME: WORKING_FUND_AMOUNT
--------[13].SQLTYPE: SQLSRV_GENERALIZED_DATE, SIZE 17, TYPE 2
------------SQLNAME: SALES_DAY_START_TIME
--------[14].SQLTYPE: SQLSRV_GENERALIZED_DATE, SIZE 17, TYPE 2
------------SQLNAME: SALES_DAY_END_TIME
--------[15].SQLTYPE: SQLSRV_GENERALIZED_NUMBER, SIZE 12, SCALE 2
------------SQLNAME: CASH_PICKUP_WARNING_AMOUNT
--------[16].SQLTYPE: SQLSRV_GENERALIZED_NUMBER, SIZE 12, SCALE 2
------------SQLNAME: CASH_PICKUP_LIMIT_AMOUNT
--------[17].SQLTYPE: SQLSRV_GENERALIZED_NUMBER, SIZE 12, SCALE 2
------------SQLNAME: CASH_DECLARE_TOLERANCE_AMOUNT
--------[18].SQLTYPE: SQLSRV_GENERALIZED_NUMBER, SIZE 11, SCALE 0
------------SQLNAME: POS_DATABASE_ID
ROUTINE LEVEL LOG at 09:00:00 on 16-May-1997
----SQLSRV_ALLOCATE_SQLDA_DATA
ROUTINE LEVEL LOG at 09:00:00 on 16-May-1997
----SQLSRV_OPEN_CURSOR
--------CURSOR NAME
------------SQL_CUR3CCF0000
--------STATEMENT ID
------------1000000
PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:00:00 on 16-May-1997
----PACKET LENGTH: 44
PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:00:00 on 16-May-1997
----PACKET ID: 8, PACKET SEQUENCE: 0
--------SQLSRV_OPEN_CURSOR
------------CURSOR NAME
----------------SQLSRV_ASCII_STRING, len: 15
--------------------len: 15, value: SQL_CUR3CCF0000
------------STATEMENT ID
----------------SQLSRV_GENERALIZED_NUMBER, len: 7
--------------------len: 7, value: 1000000
------------CURSOR MODE
----------------len: 2, value: 2
--------END OF MESSAGE
PROTOCOL LEVEL LOG CLIENT: read at 09:00:00 on 16-May-1997
----PACKET LENGTH: 30
PROTOCOL LEVEL LOG CLIENT: read at 09:00:00 on 16-May-1997
----PACKET ID: 8, PACKET SEQUENCE: 0
--------SQLSRV_OPEN_CURSOR ACK
------------SQLERRD[1]
----------------SQLSRV_GENERALIZED_NUMBER, len: 1
--------------------len: 1, value: 0
------------SQLERRD[3]
----------------SQLSRV_GENERALIZED_NUMBER, len: 1
--------------------len: 1, value: 9
------------SQLERRD[4]
----------------SQLSRV_GENERALIZED_NUMBER, len: 1
--------------------len: 1, value: 0
------------SQLERRD[5]
----------------SQLSRV_GENERALIZED_NUMBER, len: 1
--------------------len: 1, value: 0
--------END OF MESSAGE
ROUTINE LEVEL LOG at 09:00:00 on 16-May-1997
----SQLSRV_FETCH_MANY
--------CURSOR NAME
------------SQL_CUR3CCF0000
--------REPEAT COUNT
------------111
ROUTINE LEVEL LOG at 09:00:00 on 16-May-1997
----SQLSRV_FETCH
--------CURSOR NAME
------------SQL_CUR3CCF0000
PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:00:00 on 16-May-1997
----PACKET LENGTH: 33
PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:00:00 on 16-May-1997
----PACKET ID: 9, PACKET SEQUENCE: 0
--------SQLSRV_FETCH
------------CURSOR NAME
----------------SQLSRV_ASCII_STRING, len: 15
--------------------len: 15, value: SQL_CUR3CCF0000
------------REPEAT COUNT
----------------len: 2, value: 111
--------END OF MESSAGE
PROTOCOL LEVEL LOG CLIENT: read at 09:00:00 on 16-May-1997
----PACKET LENGTH: 4996
PROTOCOL LEVEL LOG CLIENT: read at 09:00:00 on 16-May-1997
----PACKET ID: 9, PACKET SEQUENCE: 0
--------SQLSRV_FETCH ACK
------------FETCH ROW NUMBER
----------------SQLSRV_GENERALIZED_NUMBER, len: 1
--------------------len: 1, value: 1
------------SELECT LIST DATA
----------------len: 2, value: 19
------------SQLVAR
----------------len: 2, value: 0
------------SQLDATA
----------------SQLSRV_ASCII_STRING, len: 8
--------------------len: 8, value: Non-printable data
------------SQLIND
----------------len: 2, value: 0
------------SQLVAR
----------------len: 2, value: 1
------------SQLDATA
----------------SQLSRV_GENERALIZED_NUMBER, len: 2
--------------------len: 2, value: 10
------------SQLIND
----------------len: 2, value: 0
------------SQLVAR
----------------len: 2, value: 2
------------SQLDATA
----------------SQLSRV_VARCHAR, len: 49
--------------------len: 49, value: Pier 50
--------------------
------------SQLIND
----------------len: 2, value: 0
------------SQLVAR
----------------len: 2, value: 3
------------SQLDATA
----------------SQLSRV_ASCII_STRING, len: 12
--------------------len: 12, value: X
------------SQLIND
----------------len: 2, value: 0
------------SQLVAR
----------------len: 2, value: 4
------------SQLDATA
----------------SQLSRV_VARCHAR, len: 7
--------------------len: 7, value: Seattle
------------SQLIND
----------------len: 2, value: 0
------------SQLVAR
----------------len: 2, value: 5
------------SQLDATA
----------------SQLSRV_VARCHAR, len: 13
--------------------len: 13, value: W.S.F.
------------SQLIND
----------------len: 2, value: 0
------------SQLVAR
----------------len: 2, value: 6
------------SQLDATA
----------------SQLSRV_VARCHAR, len: 49
--------------------len: 49, value: Pier 50 - Seattle
--------------------
------------SQLIND
----------------len: 2, value: 0
------------SQLVAR
----------------len: 2, value: 7
------------SQLDATA
----------------SQLSRV_VARCHAR, len: 49
--------------------len: 49, value: PASSENGER
--------------------
------------SQLIND
----------------len: 2, value: 0
------------SQLVAR
----------------len: 2, value: 8
------------SQLDATA
----------------SQLSRV_VARCHAR, len: 49
--------------------len: 49, value: TOLLS COLLECTED HERE
--------------------
------------SQLIND
----------------len: 2, value: 0
------------SQLVAR
----------------len: 2, value: 9
------------SQLDATA
----------------SQLSRV_VARCHAR, len: 0
------------SQLIND
----------------len: 2, value: -1
------------SQLVAR
----------------len: 2, value: 10
------------SQLDATA
----------------SQLSRV_VARCHAR, len: 0
------------SQLIND
----------------len: 2, value: -1
------------SQLVAR
----------------len: 2, value: 11
------------SQLDATA
----------------SQLSRV_VARCHAR, len: 0
------------SQLIND
----------------len: 2, value: -1
------------SQLVAR
----------------len: 2, value: 12
------------SQLDATA
----------------SQLSRV_GENERALIZED_NUMBER, len: 8
--------------------len: 8, value: 10000.00
------------SQLIND
----------------len: 2, value: 0
------------SQLVAR
----------------len: 2, value: 13
------------SQLDATA
----------------SQLSRV_GENERALIZED_DATE, len: 16
--------------------len: 16, value: 0000000005000000
------------SQLIND
----------------len: 2, value: 0
------------SQLVAR
----------------len: 2, value: 14
------------SQLDATA
----------------SQLSRV_GENERALIZED_DATE, len: 16
--------------------len: 16, value: 0000000003000000
------------SQLIND
----------------len: 2, value: 0
------------SQLVAR
----------------len: 2, value: 15
------------SQLDATA
----------------SQLSRV_GENERALIZED_NUMBER, len: 6
--------------------len: 6, value: 800.00
------------SQLIND
----------------len: 2, value: 0
------------SQLVAR
----------------len: 2, value: 16
------------SQLDATA
----------------SQLSRV_GENERALIZED_NUMBER, len: 7
--------------------len: 7, value: 1000.00
------------SQLIND
----------------len: 2, value: 0
------------SQLVAR
----------------len: 2, value: 17
------------SQLDATA
----------------SQLSRV_GENERALIZED_NUMBER, len: 4
--------------------len: 4, value: 5.00
------------SQLIND
----------------len: 2, value: 0
------------SQLVAR
----------------len: 2, value: 18
------------SQLDATA
----------------SQLSRV_GENERALIZED_NUMBER, len: 0
------------SQLIND
----------------len: 2, value: -1
------------END OF DATA
ROUTINE LEVEL LOG at 09:00:00 on 16-May-1997
----SELECT LIST SQLDA
--------SQLDA: SQLD 19
------------[0].SQLTYPE: SQLSRV_ASCII_STRING, SQLIND: 0
----------------len: 8, value: Non-printable data
------------[1].SQLTYPE: SQLSRV_GENERALIZED_NUMBER, SQLIND: 0
----------------len: 2, value: 10
------------[2].SQLTYPE: SQLSRV_VARCHAR, SQLIND: 0
----------------len: 49, value: Pier 50
----------------
------------[3].SQLTYPE: SQLSRV_ASCII_STRING, SQLIND: 0
----------------len: 12, value: X
------------[4].SQLTYPE: SQLSRV_VARCHAR, SQLIND: 0
----------------len: 7, value: Seattle
------------[5].SQLTYPE: SQLSRV_VARCHAR, SQLIND: 0
----------------len: 13, value: W.S.F.
------------[6].SQLTYPE: SQLSRV_VARCHAR, SQLIND: 0
----------------len: 49, value: Pier 50 - Seattle
----------------
------------[7].SQLTYPE: SQLSRV_VARCHAR, SQLIND: 0
----------------len: 49, value: PASSENGER
----------------
------------[8].SQLTYPE: SQLSRV_VARCHAR, SQLIND: 0
----------------len: 49, value: TOLLS COLLECTED HERE
----------------
------------[9].SQLTYPE: SQLSRV_VARCHAR, SQLIND: -1
----------------len: 0, value:
------------[10].SQLTYPE: SQLSRV_VARCHAR, SQLIND: -1
----------------len: 0, value:
------------[11].SQLTYPE: SQLSRV_VARCHAR, SQLIND: -1
----------------len: 0, value:
------------[12].SQLTYPE: SQLSRV_GENERALIZED_NUMBER, SQLIND: 0
----------------len: 8, value: 10000.00
------------[13].SQLTYPE: SQLSRV_GENERALIZED_DATE, SQLIND: 0
----------------len: 16, value: 0000000005000000
------------[14].SQLTYPE: SQLSRV_GENERALIZED_DATE, SQLIND: 0
----------------len: 16, value: 0000000003000000
------------[15].SQLTYPE: SQLSRV_GENERALIZED_NUMBER, SQLIND: 0
----------------len: 6, value: 800.00
------------[16].SQLTYPE: SQLSRV_GENERALIZED_NUMBER, SQLIND: 0
----------------len: 7, value: 1000.00
------------[17].SQLTYPE: SQLSRV_GENERALIZED_NUMBER, SQLIND: 0
----------------len: 4, value: 5.00
------------[18].SQLTYPE: SQLSRV_GENERALIZED_NUMBER, SQLIND: -1
----------------len: 0, value:
ROUTINE LEVEL LOG at 09:00:00 on 16-May-1997
----SQLSRV_CLOSE_CURSOR
--------CURSOR NAME
------------SQL_CUR3CCF0000
PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:00:00 on 16-May-1997
----PACKET LENGTH: 29
PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:00:00 on 16-May-1997
----PACKET ID: 10, PACKET SEQUENCE: 0
--------SQLSRV_CLOSE_CURSOR
------------CURSOR NAME
----------------SQLSRV_ASCII_STRING, len: 15
--------------------len: 15, value: SQL_CUR3CCF0000
--------END OF MESSAGE
PROTOCOL LEVEL LOG CLIENT: read at 09:00:00 on 16-May-1997
----PACKET LENGTH: 4914
PROTOCOL LEVEL LOG CLIENT: read at 09:00:00 on 16-May-1997
----PACKET ID: 9, PACKET SEQUENCE: 1
PROTOCOL LEVEL LOG CLIENT: read at 09:00:00 on 16-May-1997
----PACKET LENGTH: 10
PROTOCOL LEVEL LOG CLIENT: read at 09:00:00 on 16-May-1997
----PACKET ID: 10, PACKET SEQUENCE: 0
--------SQLSRV_CLOSE_CURSOR ACK
--------END OF MESSAGE
ROUTINE LEVEL LOG at 09:00:00 on 16-May-1997
----SQLSRV_RELEASE_STATEMENT
--------STATEMENT ID
------------[0] 1000000
PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:00:00 on 16-May-1997
----PACKET LENGTH: 29
PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:00:00 on 16-May-1997
----PACKET ID: 11, PACKET SEQUENCE: 0
--------SQLSRV_RELEASE_STATEMENT
------------STATEMENT COUNT
----------------len: 2, value: 1
------------AUTO COMMIT
----------------len: 2, value: 1
------------STATEMENT ID
----------------SQLSRV_GENERALIZED_NUMBER, len: 7
--------------------len: 7, value: 1000000
--------END OF MESSAGE
PROTOCOL LEVEL LOG CLIENT: read at 09:00:00 on 16-May-1997
----PACKET LENGTH: 19
PROTOCOL LEVEL LOG CLIENT: read at 09:00:00 on 16-May-1997
----PACKET ID: 11, PACKET SEQUENCE: 0
--------SQLSRV_RELEASE_STATEMENT ACK
------------STATUS
----------------SQLSRV_GENERALIZED_NUMBER, len: 1
--------------------len: 1, value: 0
------------STATEMENT COUNT
----------------len: 2, value: 1
--------END OF MESSAGE
ROUTINE LEVEL LOG at 09:00:00 on 16-May-1997
----SQLSRV_FREE_SQLDA_DATA
ROUTINE LEVEL LOG at 09:00:00 on 16-May-1997
----SQLSRV_EXECUTE_IMMEDIATE
--------SQL STATEMENT
------------len: 54, value: DECLARE TRANSACTION READ ONLY WAIT
CONSISTENCY LEVEL
------------ 2
PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:00:00 on 16-May-1997
----PACKET LENGTH: 68
PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:00:00 on 16-May-1997
----PACKET ID: 12, PACKET SEQUENCE: 0
--------SQLSRV_EXECUTE_IMMEDIATE
------------SQL STATEMENT
----------------SQLSRV_ASCII_STRING, len: 54
--------------------len: 54, value: DECLARE TRANSACTION READ ONLY WAIT
CONSISTEN
--------------------CY LEVEL 2
--------END OF MESSAGE
PROTOCOL LEVEL LOG CLIENT: read at 09:00:00 on 16-May-1997
----PACKET LENGTH: 20
PROTOCOL LEVEL LOG CLIENT: read at 09:00:00 on 16-May-1997
----PACKET ID: 12, PACKET SEQUENCE: 0
--------SQLSRV_EXECUTE_IMMEDIATE ACK
------------STATUS
----------------SQLSRV_GENERALIZED_NUMBER, len: 1
--------------------len: 1, value: 0
------------EXECUTE PARAMETER
----------------SQLSRV_GENERALIZED_NUMBER, len: 1
--------------------len: 1, value: 0
--------END OF MESSAGE
ROUTINE LEVEL LOG at 09:00:00 on 16-May-1997
----SQLSRV_PREPARE
--------SQL STATEMENT
------------len: 403, value: SELECT DDAL$DBKEY ,TERMINAL_ID ,TERMINAL
,STATION_F
------------IRST_DIG_NUM ,CITY ,RECEIPT_HEADER_LINE1
,RECEIPT_HEADER_LINE2 ,RECE
------------IPT_HEADER_LINE3 ,RECEIPT_HEADER_LINE4 ,RECEIPT_HEADER_LINE5
,RECEIP
------------T_FOOTER_LINE1 ,RECEIPT_FOOTER_LINE2 ,WORKING_FUND_AMOUNT
,SALES_DAY
------------_START_TIME ,SALES_DAY_END_TIME ,CASH_PICKUP_WARNING_AMOUNT
,CASH_PI
------------CKUP_LIMIT_AMOUNT ,CASH_DECLARE_TOLERANCE_AMOUNT
,POS_DATABASE_ID F
------------ROM TERMINAL
PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:00:00 on 16-May-1997
----PACKET LENGTH: 417
PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:00:00 on 16-May-1997
----PACKET ID: 13, PACKET SEQUENCE: 0
--------SQLSRV_PREPARE
------------SQL STATEMENT
----------------SQLSRV_ASCII_STRING, len: 403
--------------------len: 403, value: SELECT DDAL$DBKEY ,TERMINAL_ID
,TERMINAL ,S
--------------------TATION_FIRST_DIG_NUM ,CITY ,RECEIPT_HEADER_LINE1
,RECEIPT_HE
--------------------ADER_LINE2 ,RECEIPT_HEADER_LINE3
,RECEIPT_HEADER_LINE4 ,RECE
--------------------IPT_HEADER_LINE5 ,RECEIPT_FOOTER_LINE1
,RECEIPT_FOOTER_LINE2
-------------------- ,WORKING_FUND_AMOUNT ,SALES_DAY_START_TIME
,SALES_DAY_END_T
--------------------IME ,CASH_PICKUP_WARNING_AMOUNT
,CASH_PICKUP_LIMIT_AMOUNT ,C
--------------------ASH_DECLARE_TOLERANCE_AMOUNT ,POS_DATABASE_ID FROM
TERMINAL
--------END OF MESSAGE
PROTOCOL LEVEL LOG CLIENT: read at 09:00:00 on 16-May-1997
----PACKET LENGTH: 679
PROTOCOL LEVEL LOG CLIENT: read at 09:00:00 on 16-May-1997
----PACKET ID: 13, PACKET SEQUENCE: 0
--------SQLSRV_PREPARE ACK
------------STATEMENT ID
----------------SQLSRV_GENERALIZED_NUMBER, len: 7
--------------------len: 7, value: 1000001
------------SQLERRD[1]
----------------SQLSRV_GENERALIZED_NUMBER, len: 1
--------------------len: 1, value: 1
------------SELECT LIST SQLDA
----------------len: 2, value: 19
------------SQLVAR
----------------len: 2, value: 0
------------SQLTYPE
----------------len: 2, value: 129
------------SQLLEN
----------------len: 2, value: 8
------------SQLNAME
----------------SQLSRV_ASCII_STRING, len: 10
--------------------len: 10, value: DDAL$DBKEY
------------SQLVAR
----------------len: 2, value: 1
------------SQLTYPE
----------------len: 2, value: 130
------------SQLLEN
----------------len: 2, value: 11
------------SQLNAME
----------------SQLSRV_ASCII_STRING, len: 11
--------------------len: 11, value: TERMINAL_ID
------------SQLVAR
----------------len: 2, value: 2
------------SQLTYPE
----------------len: 2, value: 132
------------SQLLEN
----------------len: 2, value: 50
------------SQLNAME
----------------SQLSRV_ASCII_STRING, len: 8
--------------------len: 8, value: TERMINAL
------------SQLVAR
----------------len: 2, value: 3
------------SQLTYPE
----------------len: 2, value: 129
------------SQLLEN
----------------len: 2, value: 12
------------SQLNAME
----------------SQLSRV_ASCII_STRING, len: 21
--------------------len: 21, value: STATION_FIRST_DIG_NUM
------------SQLVAR
----------------len: 2, value: 4
------------SQLTYPE
----------------len: 2, value: 132
------------SQLLEN
----------------len: 2, value: 50
------------SQLNAME
----------------SQLSRV_ASCII_STRING, len: 4
--------------------len: 4, value: CITY
------------SQLVAR
----------------len: 2, value: 5
------------SQLTYPE
----------------len: 2, value: 132
------------SQLLEN
----------------len: 2, value: 50
------------SQLNAME
----------------SQLSRV_ASCII_STRING, len: 20
--------------------len: 20, value: RECEIPT_HEADER_LINE1
------------SQLVAR
----------------len: 2, value: 6
------------SQLTYPE
----------------len: 2, value: 132
------------SQLLEN
----------------len: 2, value: 50
------------SQLNAME
----------------SQLSRV_ASCII_STRING, len: 20
--------------------len: 20, value: RECEIPT_HEADER_LINE2
------------SQLVAR
----------------len: 2, value: 7
------------SQLTYPE
----------------len: 2, value: 132
------------SQLLEN
----------------len: 2, value: 50
------------SQLNAME
----------------SQLSRV_ASCII_STRING, len: 20
--------------------len: 20, value: RECEIPT_HEADER_LINE3
------------SQLVAR
----------------len: 2, value: 8
------------SQLTYPE
----------------len: 2, value: 132
------------SQLLEN
----------------len: 2, value: 50
------------SQLNAME
----------------SQLSRV_ASCII_STRING, len: 20
--------------------len: 20, value: RECEIPT_HEADER_LINE4
------------SQLVAR
----------------len: 2, value: 9
------------SQLTYPE
----------------len: 2, value: 132
------------SQLLEN
----------------len: 2, value: 50
------------SQLNAME
----------------SQLSRV_ASCII_STRING, len: 20
--------------------len: 20, value: RECEIPT_HEADER_LINE5
------------SQLVAR
----------------len: 2, value: 10
------------SQLTYPE
----------------len: 2, value: 132
------------SQLLEN
----------------len: 2, value: 50
------------SQLNAME
----------------SQLSRV_ASCII_STRING, len: 20
--------------------len: 20, value: RECEIPT_FOOTER_LINE1
------------SQLVAR
----------------len: 2, value: 11
------------SQLTYPE
----------------len: 2, value: 132
------------SQLLEN
----------------len: 2, value: 50
------------SQLNAME
----------------SQLSRV_ASCII_STRING, len: 20
--------------------len: 20, value: RECEIPT_FOOTER_LINE2
------------SQLVAR
----------------len: 2, value: 12
------------SQLTYPE
----------------len: 2, value: 130
------------SQLLEN
----------------len: 2, value: 524
------------SQLNAME
----------------SQLSRV_ASCII_STRING, len: 19
--------------------len: 19, value: WORKING_FUND_AMOUNT
------------SQLVAR
----------------len: 2, value: 13
------------SQLTYPE
----------------len: 2, value: 131
------------SQLLEN
----------------len: 2, value: 529
------------SQLNAME
----------------SQLSRV_ASCII_STRING, len: 20
--------------------len: 20, value: SALES_DAY_START_TIME
------------SQLVAR
----------------len: 2, value: 14
------------SQLTYPE
----------------len: 2, value: 131
------------SQLLEN
----------------len: 2, value: 529
------------SQLNAME
----------------SQLSRV_ASCII_STRING, len: 18
--------------------len: 18, value: SALES_DAY_END_TIME
------------SQLVAR
----------------len: 2, value: 15
------------SQLTYPE
----------------len: 2, value: 130
------------SQLLEN
----------------len: 2, value: 524
------------SQLNAME
----------------SQLSRV_ASCII_STRING, len: 26
--------------------len: 26, value: CASH_PICKUP_WARNING_AMOUNT
------------SQLVAR
----------------len: 2, value: 16
------------SQLTYPE
----------------len: 2, value: 130
------------SQLLEN
----------------len: 2, value: 524
------------SQLNAME
----------------SQLSRV_ASCII_STRING, len: 24
--------------------len: 24, value: CASH_PICKUP_LIMIT_AMOUNT
------------SQLVAR
----------------len: 2, value: 17
------------SQLTYPE
----------------len: 2, value: 130
------------SQLLEN
----------------len: 2, value: 524
------------SQLNAME
----------------SQLSRV_ASCII_STRING, len: 29
--------------------len: 29, value: CASH_DECLARE_TOLERANCE_AMOUNT
------------SQLVAR
----------------len: 2, value: 18
------------SQLTYPE
----------------len: 2, value: 130
------------SQLLEN
----------------len: 2, value: 11
------------SQLNAME
----------------SQLSRV_ASCII_STRING, len: 15
--------------------len: 15, value: POS_DATABASE_ID
--------END OF MESSAGE
ROUTINE LEVEL LOG at 09:00:00 on 16-May-1997
----SELECT LIST SQLDA
--------SQLDA: SQLD 19
--------[0].SQLTYPE: SQLSRV_ASCII_STRING, SQLLEN: 8
------------SQLNAME: DDAL$DBKEY
--------[1].SQLTYPE: SQLSRV_GENERALIZED_NUMBER, SIZE 11, SCALE 0
------------SQLNAME: TERMINAL_ID
--------[2].SQLTYPE: SQLSRV_VARCHAR, SQLLEN: 50
------------SQLNAME: TERMINAL
--------[3].SQLTYPE: SQLSRV_ASCII_STRING, SQLLEN: 12
------------SQLNAME: STATION_FIRST_DIG_NUM
--------[4].SQLTYPE: SQLSRV_VARCHAR, SQLLEN: 50
------------SQLNAME: CITY
--------[5].SQLTYPE: SQLSRV_VARCHAR, SQLLEN: 50
------------SQLNAME: RECEIPT_HEADER_LINE1
--------[6].SQLTYPE: SQLSRV_VARCHAR, SQLLEN: 50
------------SQLNAME: RECEIPT_HEADER_LINE2
--------[7].SQLTYPE: SQLSRV_VARCHAR, SQLLEN: 50
------------SQLNAME: RECEIPT_HEADER_LINE3
--------[8].SQLTYPE: SQLSRV_VARCHAR, SQLLEN: 50
------------SQLNAME: RECEIPT_HEADER_LINE4
--------[9].SQLTYPE: SQLSRV_VARCHAR, SQLLEN: 50
------------SQLNAME: RECEIPT_HEADER_LINE5
--------[10].SQLTYPE: SQLSRV_VARCHAR, SQLLEN: 50
------------SQLNAME: RECEIPT_FOOTER_LINE1
--------[11].SQLTYPE: SQLSRV_VARCHAR, SQLLEN: 50
------------SQLNAME: RECEIPT_FOOTER_LINE2
--------[12].SQLTYPE: SQLSRV_GENERALIZED_NUMBER, SIZE 12, SCALE 2
------------SQLNAME: WORKING_FUND_AMOUNT
--------[13].SQLTYPE: SQLSRV_GENERALIZED_DATE, SIZE 17, TYPE 2
------------SQLNAME: SALES_DAY_START_TIME
--------[14].SQLTYPE: SQLSRV_GENERALIZED_DATE, SIZE 17, TYPE 2
------------SQLNAME: SALES_DAY_END_TIME
--------[15].SQLTYPE: SQLSRV_GENERALIZED_NUMBER, SIZE 12, SCALE 2
------------SQLNAME: CASH_PICKUP_WARNING_AMOUNT
--------[16].SQLTYPE: SQLSRV_GENERALIZED_NUMBER, SIZE 12, SCALE 2
------------SQLNAME: CASH_PICKUP_LIMIT_AMOUNT
--------[17].SQLTYPE: SQLSRV_GENERALIZED_NUMBER, SIZE 12, SCALE 2
------------SQLNAME: CASH_DECLARE_TOLERANCE_AMOUNT
--------[18].SQLTYPE: SQLSRV_GENERALIZED_NUMBER, SIZE 11, SCALE 0
------------SQLNAME: POS_DATABASE_ID
ROUTINE LEVEL LOG at 09:00:00 on 16-May-1997
----SQLSRV_ALLOCATE_SQLDA_DATA
ROUTINE LEVEL LOG at 09:00:00 on 16-May-1997
----SQLSRV_OPEN_CURSOR
--------CURSOR NAME
------------SQL_CUR376F0000
--------STATEMENT ID
------------1000001
PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:00:00 on 16-May-1997
----PACKET LENGTH: 44
PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:00:00 on 16-May-1997
----PACKET ID: 14, PACKET SEQUENCE: 0
--------SQLSRV_OPEN_CURSOR
------------CURSOR NAME
----------------SQLSRV_ASCII_STRING, len: 15
--------------------len: 15, value: SQL_CUR376F0000
------------STATEMENT ID
----------------SQLSRV_GENERALIZED_NUMBER, len: 7
--------------------len: 7, value: 1000001
------------CURSOR MODE
----------------len: 2, value: 2
--------END OF MESSAGE
PROTOCOL LEVEL LOG CLIENT: read at 09:00:00 on 16-May-1997
----PACKET LENGTH: 30
PROTOCOL LEVEL LOG CLIENT: read at 09:00:00 on 16-May-1997
----PACKET ID: 14, PACKET SEQUENCE: 0
--------SQLSRV_OPEN_CURSOR ACK
------------SQLERRD[1]
----------------SQLSRV_GENERALIZED_NUMBER, len: 1
--------------------len: 1, value: 0
------------SQLERRD[3]
----------------SQLSRV_GENERALIZED_NUMBER, len: 1
--------------------len: 1, value: 9
------------SQLERRD[4]
----------------SQLSRV_GENERALIZED_NUMBER, len: 1
--------------------len: 1, value: 0
------------SQLERRD[5]
----------------SQLSRV_GENERALIZED_NUMBER, len: 1
--------------------len: 1, value: 0
--------END OF MESSAGE
ROUTINE LEVEL LOG at 09:00:00 on 16-May-1997
----SQLSRV_FETCH_MANY
--------CURSOR NAME
------------SQL_CUR376F0000
--------REPEAT COUNT
------------111
ROUTINE LEVEL LOG at 09:00:00 on 16-May-1997
----SQLSRV_FETCH
--------CURSOR NAME
------------SQL_CUR376F0000
PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:00:00 on 16-May-1997
----PACKET LENGTH: 33
PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:00:00 on 16-May-1997
----PACKET ID: 15, PACKET SEQUENCE: 0
--------SQLSRV_FETCH
------------CURSOR NAME
----------------SQLSRV_ASCII_STRING, len: 15
--------------------len: 15, value: SQL_CUR376F0000
------------REPEAT COUNT
----------------len: 2, value: 111
--------END OF MESSAGE
PROTOCOL LEVEL LOG CLIENT: read at 09:00:00 on 16-May-1997
----PACKET LENGTH: 4996
PROTOCOL LEVEL LOG CLIENT: read at 09:00:00 on 16-May-1997
----PACKET ID: 15, PACKET SEQUENCE: 0
--------SQLSRV_FETCH ACK
------------FETCH ROW NUMBER
----------------SQLSRV_GENERALIZED_NUMBER, len: 1
--------------------len: 1, value: 1
------------SELECT LIST DATA
----------------len: 2, value: 19
------------SQLVAR
----------------len: 2, value: 0
------------SQLDATA
----------------SQLSRV_ASCII_STRING, len: 8
--------------------len: 8, value: Non-printable data
------------SQLIND
----------------len: 2, value: 0
------------SQLVAR
----------------len: 2, value: 1
------------SQLDATA
----------------SQLSRV_GENERALIZED_NUMBER, len: 2
--------------------len: 2, value: 10
------------SQLIND
----------------len: 2, value: 0
------------SQLVAR
----------------len: 2, value: 2
------------SQLDATA
----------------SQLSRV_VARCHAR, len: 49
--------------------len: 49, value: Pier 50
--------------------
------------SQLIND
----------------len: 2, value: 0
------------SQLVAR
----------------len: 2, value: 3
------------SQLDATA
----------------SQLSRV_ASCII_STRING, len: 12
--------------------len: 12, value: X
------------SQLIND
----------------len: 2, value: 0
------------SQLVAR
----------------len: 2, value: 4
------------SQLDATA
----------------SQLSRV_VARCHAR, len: 7
--------------------len: 7, value: Seattle
------------SQLIND
----------------len: 2, value: 0
------------SQLVAR
----------------len: 2, value: 5
------------SQLDATA
----------------SQLSRV_VARCHAR, len: 13
--------------------len: 13, value: W.S.F.
------------SQLIND
----------------len: 2, value: 0
------------SQLVAR
----------------len: 2, value: 6
------------SQLDATA
----------------SQLSRV_VARCHAR, len: 49
--------------------len: 49, value: Pier 50 - Seattle
--------------------
------------SQLIND
----------------len: 2, value: 0
------------SQLVAR
----------------len: 2, value: 7
------------SQLDATA
----------------SQLSRV_VARCHAR, len: 49
--------------------len: 49, value: PASSENGER
--------------------
------------SQLIND
----------------len: 2, value: 0
------------SQLVAR
----------------len: 2, value: 8
------------SQLDATA
----------------SQLSRV_VARCHAR, len: 49
--------------------len: 49, value: TOLLS COLLECTED HERE
--------------------
------------SQLIND
----------------len: 2, value: 0
------------SQLVAR
----------------len: 2, value: 9
------------SQLDATA
----------------SQLSRV_VARCHAR, len: 0
------------SQLIND
----------------len: 2, value: -1
------------SQLVAR
----------------len: 2, value: 10
------------SQLDATA
----------------SQLSRV_VARCHAR, len: 0
------------SQLIND
----------------len: 2, value: -1
------------SQLVAR
----------------len: 2, value: 11
------------SQLDATA
----------------SQLSRV_VARCHAR, len: 0
------------SQLIND
----------------len: 2, value: -1
------------SQLVAR
----------------len: 2, value: 12
------------SQLDATA
----------------SQLSRV_GENERALIZED_NUMBER, len: 8
--------------------len: 8, value: 10000.00
------------SQLIND
----------------len: 2, value: 0
------------SQLVAR
----------------len: 2, value: 13
------------SQLDATA
----------------SQLSRV_GENERALIZED_DATE, len: 16
--------------------len: 16, value: 0000000005000000
------------SQLIND
----------------len: 2, value: 0
------------SQLVAR
----------------len: 2, value: 14
------------SQLDATA
----------------SQLSRV_GENERALIZED_DATE, len: 16
--------------------len: 16, value: 0000000003000000
------------SQLIND
----------------len: 2, value: 0
------------SQLVAR
----------------len: 2, value: 15
------------SQLDATA
----------------SQLSRV_GENERALIZED_NUMBER, len: 6
--------------------len: 6, value: 800.00
------------SQLIND
----------------len: 2, value: 0
------------SQLVAR
----------------len: 2, value: 16
------------SQLDATA
----------------SQLSRV_GENERALIZED_NUMBER, len: 7
--------------------len: 7, value: 1000.00
------------SQLIND
----------------len: 2, value: 0
------------SQLVAR
----------------len: 2, value: 17
------------SQLDATA
----------------SQLSRV_GENERALIZED_NUMBER, len: 4
--------------------len: 4, value: 5.00
------------SQLIND
----------------len: 2, value: 0
------------SQLVAR
----------------len: 2, value: 18
------------SQLDATA
----------------SQLSRV_GENERALIZED_NUMBER, len: 0
------------SQLIND
----------------len: 2, value: -1
------------END OF DATA
ROUTINE LEVEL LOG at 09:00:00 on 16-May-1997
----SELECT LIST SQLDA
--------SQLDA: SQLD 19
------------[0].SQLTYPE: SQLSRV_ASCII_STRING, SQLIND: 0
----------------len: 8, value: Non-printable data
------------[1].SQLTYPE: SQLSRV_GENERALIZED_NUMBER, SQLIND: 0
----------------len: 2, value: 10
------------[2].SQLTYPE: SQLSRV_VARCHAR, SQLIND: 0
----------------len: 49, value: Pier 50
----------------
------------[3].SQLTYPE: SQLSRV_ASCII_STRING, SQLIND: 0
----------------len: 12, value: X
------------[4].SQLTYPE: SQLSRV_VARCHAR, SQLIND: 0
----------------len: 7, value: Seattle
------------[5].SQLTYPE: SQLSRV_VARCHAR, SQLIND: 0
----------------len: 13, value: W.S.F.
------------[6].SQLTYPE: SQLSRV_VARCHAR, SQLIND: 0
----------------len: 49, value: Pier 50 - Seattle
----------------
------------[7].SQLTYPE: SQLSRV_VARCHAR, SQLIND: 0
----------------len: 49, value: PASSENGER
----------------
------------[8].SQLTYPE: SQLSRV_VARCHAR, SQLIND: 0
----------------len: 49, value: TOLLS COLLECTED HERE
----------------
------------[9].SQLTYPE: SQLSRV_VARCHAR, SQLIND: -1
----------------len: 0, value:
------------[10].SQLTYPE: SQLSRV_VARCHAR, SQLIND: -1
----------------len: 0, value:
------------[11].SQLTYPE: SQLSRV_VARCHAR, SQLIND: -1
----------------len: 0, value:
------------[12].SQLTYPE: SQLSRV_GENERALIZED_NUMBER, SQLIND: 0
----------------len: 8, value: 10000.00
------------[13].SQLTYPE: SQLSRV_GENERALIZED_DATE, SQLIND: 0
----------------len: 16, value: 0000000005000000
------------[14].SQLTYPE: SQLSRV_GENERALIZED_DATE, SQLIND: 0
----------------len: 16, value: 0000000003000000
------------[15].SQLTYPE: SQLSRV_GENERALIZED_NUMBER, SQLIND: 0
----------------len: 6, value: 800.00
------------[16].SQLTYPE: SQLSRV_GENERALIZED_NUMBER, SQLIND: 0
----------------len: 7, value: 1000.00
------------[17].SQLTYPE: SQLSRV_GENERALIZED_NUMBER, SQLIND: 0
----------------len: 4, value: 5.00
------------[18].SQLTYPE: SQLSRV_GENERALIZED_NUMBER, SQLIND: -1
----------------len: 0, value:
ROUTINE LEVEL LOG at 09:00:00 on 16-May-1997
----FETCH ROW NUMBER
--------SQLSRV_GENERALIZED_NUMBER, len: 1
------------len: 1, value: 2
----SELECT LIST DATA
--------len: 2, value: 19
----SQLVAR
--------len: 2, value: 0
----SQLDATA
--------SQLSRV_ASCII_STRING, len: 8
------------len: 8, value: Non-printable data
----SQLIND
--------len: 2, value: 0
----SQLVAR
--------len: 2, value: 1
----SQLDATA
--------SQLSRV_GENERALIZED_NUMBER, len: 2
------------len: 2, value: 11
----SQLIND
--------len: 2, value: 0
----SQLVAR
--------len: 2, value: 2
----SQLDATA
--------SQLSRV_VARCHAR, len: 49
------------len: 49, value: Colman Dock
----SQLIND
--------len: 2, value: 0
----SQLVAR
--------len: 2, value: 3
----SQLDATA
--------SQLSRV_ASCII_STRING, len: 12
------------len: 12, value: S
----SQLIND
--------len: 2, value: 0
----SQLVAR
--------len: 2, value: 4
----SQLDATA
--------SQLSRV_VARCHAR, len: 7
------------len: 7, value: Seattle
----SQLIND
--------len: 2, value: 0
----SQLVAR
--------len: 2, value: 5
----SQLDATA
--------SQLSRV_VARCHAR, len: 13
------------len: 13, value: W.S.F.
----SQLIND
--------len: 2, value: 0
----SQLVAR
--------len: 2, value: 6
----SQLDATA
--------SQLSRV_VARCHAR, len: 49
------------len: 49, value: Seattle
----SQLIND
--------len: 2, value: 0
----SQLVAR
--------len: 2, value: 7
----SQLDATA
--------SQLSRV_VARCHAR, len: 49
------------len: 49, value: VEHICLE AND PASSENGER
----SQLIND
--------len: 2, value: 0
----SQLVAR
--------len: 2, value: 8
----SQLDATA
--------SQLSRV_VARCHAR, len: 49
------------len: 49, value: TOLLS COLLECTED HERE
----SQLIND
--------len: 2, value: 0
----SQLVAR
--------len: 2, value: 9
----SQLDATA
--------SQLSRV_VARCHAR, len: 0
----SQLIND
--------len: 2, value: -1
----SQLVAR
--------len: 2, value: 10
----SQLDATA
--------SQLSRV_VARCHAR, len: 0
----SQLIND
--------len: 2, value: -1
----SQLVAR
--------len: 2, value: 11
----SQLDATA
--------SQLSRV_VARCHAR, len: 0
----SQLIND
--------len: 2, value: -1
----SQLVAR
--------len: 2, value: 12
----SQLDATA
--------SQLSRV_GENERALIZED_NUMBER, len: 8
------------len: 8, value: 60000.00
----SQLIND
--------len: 2, value: 0
----SQLVAR
--------len: 2, value: 13
----SQLDATA
--------SQLSRV_GENERALIZED_DATE, len: 16
------------len: 16, value: 0000000004280000
----SQLIND
--------len: 2, value: 0
----SQLVAR
--------len: 2, value: 14
----SQLDATA
--------SQLSRV_GENERALIZED_DATE, len: 16
------------len: 16, value: 0000000002550000
----SQLIND
--------len: 2, value: 0
----SQLVAR
--------len: 2, value: 15
----SQLDATA
--------SQLSRV_GENERALIZED_NUMBER, len: 7
------------len: 7, value: 1200.00
----SQLIND
--------len: 2, value: 0
----SQLVAR
--------len: 2, value: 16
----SQLDATA
--------SQLSRV_GENERALIZED_NUMBER, len: 7
------------len: 7, value: 1500.00
----SQLIND
--------len: 2, value: 0
----SQLVAR
--------len: 2, value: 17
----SQLDATA
--------SQLSRV_GENERALIZED_NUMBER, len: 4
------------len: 4, value: 5.00
----SQLIND
--------len: 2, value: 0
----SQLVAR
--------len: 2, value: 18
----SQLDATA
--------SQLSRV_GENERALIZED_NUMBER, len: 1
------------len: 1, value: 6
----SQLIND
--------len: 2, value: 0
------------END OF DATA
ROUTINE LEVEL LOG at 09:00:00 on 16-May-1997
----SELECT LIST SQLDA
--------SQLDA: SQLD 19
------------[0].SQLTYPE: SQLSRV_ASCII_STRING, SQLIND: 0
----------------len: 8, value: Non-printable data
------------[1].SQLTYPE: SQLSRV_GENERALIZED_NUMBER, SQLIND: 0
----------------len: 2, value: 11
------------[2].SQLTYPE: SQLSRV_VARCHAR, SQLIND: 0
----------------len: 49, value: Colman Dock
----------------
------------[3].SQLTYPE: SQLSRV_ASCII_STRING, SQLIND: 0
----------------len: 12, value: S
------------[4].SQLTYPE: SQLSRV_VARCHAR, SQLIND: 0
----------------len: 7, value: Seattle
------------[5].SQLTYPE: SQLSRV_VARCHAR, SQLIND: 0
----------------len: 13, value: W.S.F.
------------[6].SQLTYPE: SQLSRV_VARCHAR, SQLIND: 0
----------------len: 49, value: Seattle
----------------
------------[7].SQLTYPE: SQLSRV_VARCHAR, SQLIND: 0
----------------len: 49, value: VEHICLE AND PASSENGER
----------------
------------[8].SQLTYPE: SQLSRV_VARCHAR, SQLIND: 0
----------------len: 49, value: TOLLS COLLECTED HERE
----------------
------------[9].SQLTYPE: SQLSRV_VARCHAR, SQLIND: -1
----------------len: 0, value:
------------[10].SQLTYPE: SQLSRV_VARCHAR, SQLIND: -1
----------------len: 0, value:
------------[11].SQLTYPE: SQLSRV_VARCHAR, SQLIND: -1
----------------len: 0, value:
------------[12].SQLTYPE: SQLSRV_GENERALIZED_NUMBER, SQLIND: 0
----------------len: 8, value: 60000.00
------------[13].SQLTYPE: SQLSRV_GENERALIZED_DATE, SQLIND: 0
----------------len: 16, value: 0000000004280000
------------[14].SQLTYPE: SQLSRV_GENERALIZED_DATE, SQLIND: 0
----------------len: 16, value: 0000000002550000
------------[15].SQLTYPE: SQLSRV_GENERALIZED_NUMBER, SQLIND: 0
----------------len: 7, value: 1200.00
------------[16].SQLTYPE: SQLSRV_GENERALIZED_NUMBER, SQLIND: 0
----------------len: 7, value: 1500.00
------------[17].SQLTYPE: SQLSRV_GENERALIZED_NUMBER, SQLIND: 0
----------------len: 4, value: 5.00
------------[18].SQLTYPE: SQLSRV_GENERALIZED_NUMBER, SQLIND: 0
----------------len: 1, value: 6
ROUTINE LEVEL LOG at 09:00:00 on 16-May-1997
----FETCH ROW NUMBER
--------SQLSRV_GENERALIZED_NUMBER, len: 1
------------len: 1, value: 3
----SELECT LIST DATA
--------len: 2, value: 19
----SQLVAR
--------len: 2, value: 0
----SQLDATA
--------SQLSRV_ASCII_STRING, len: 8
------------len: 8, value: Non-printable data
----SQLIND
--------len: 2, value: 0
----SQLVAR
--------len: 2, value: 1
----SQLDATA
--------SQLSRV_GENERALIZED_NUMBER, len: 2
------------len: 2, value: 12
----SQLIND
--------len: 2, value: 0
----SQLVAR
--------len: 2, value: 2
----SQLDATA
--------SQLSRV_VARCHAR, len: 9
------------len: 9, value: Bremerton
----SQLIND
--------len: 2, value: 0
----SQLVAR
--------len: 2, value: 3
----SQLDATA
--------SQLSRV_ASCII_STRING, len: 12
------------len: 12, value: B
----SQLIND
--------len: 2, value: 0
----SQLVAR
--------len: 2, value: 4
----SQLDATA
--------SQLSRV_VARCHAR, len: 9
------------len: 9, value: Bremerton
----SQLIND
--------len: 2, value: 0
----SQLVAR
--------len: 2, value: 5
----SQLDATA
--------SQLSRV_VARCHAR, len: 13
------------len: 13, value: W.S.F.
----SQLIND
--------len: 2, value: 0
----SQLVAR
--------len: 2, value: 6
----SQLDATA
--------SQLSRV_VARCHAR, len: 49
------------len: 49, value: Bremerton
----SQLIND
--------len: 2, value: 0
----SQLVAR
--------len: 2, value: 7
----SQLDATA
--------SQLSRV_VARCHAR, len: 49
------------len: 49, value: PASSENGER TOLLS NOT
----SQLIND
--------len: 2, value: 0
----SQLVAR
--------len: 2, value: 8
----SQLDATA
--------SQLSRV_VARCHAR, len: 49
------------len: 49, value: COLLECTED HERE
----SQLIND
--------len: 2, value: 0
----SQLVAR
--------len: 2, value: 9
----SQLDATA
--------SQLSRV_VARCHAR, len: 0
----SQLIND
--------len: 2, value: -1
----SQLVAR
--------len: 2, value: 10
----SQLDATA
--------SQLSRV_VARCHAR, len: 0
----SQLIND
--------len: 2, value: -1
----SQLVAR
--------len: 2, value: 11
----SQLDATA
--------SQLSRV_VARCHAR, len: 0
----SQLIND
--------len: 2, value: -1
----SQLVAR
--------len: 2, value: 12
----SQLDATA
--------SQLSRV_GENERALIZED_NUMBER, len: 8
------------len: 8, value: 23000.00
----SQLIND
--------len: 2, value: 0
----SQLVAR
--------len: 2, value: 13
----SQLDATA
--------SQLSRV_GENERALIZED_DATE, len: 16
------------len: 16, value: 0000000004150000
----SQLIND
--------len: 2, value: 0
----SQLVAR
--------len: 2, value: 14
----SQLDATA
--------SQLSRV_GENERALIZED_DATE, len: 16
------------len: 16, value: 0000000002000000
----SQLIND
--------len: 2, value: 0
----SQLVAR
--------len: 2, value: 15
----SQLDATA
--------SQLSRV_GENERALIZED_NUMBER, len: 7
------------len: 7, value: 1200.00
----SQLIND
--------len: 2, value: 0
----SQLVAR
--------len: 2, value: 16
----SQLDATA
--------SQLSRV_GENERALIZED_NUMBER, len: 7
------------len: 7, value: 1500.00
----SQLIND
--------len: 2, value: 0
----SQLVAR
--------len: 2, value: 17
----SQLDATA
--------SQLSRV_GENERALIZED_NUMBER, len: 4
------------len: 4, value: 5.00
----SQLIND
--------len: 2, value: 0
----SQLVAR
--------len: 2, value: 18
----SQLDATA
--------SQLSRV_GENERALIZED_NUMBER, len: 1
------------len: 1, value: 4
----SQLIND
--------len: 2, value: 0
------------END OF DATA
ROUTINE LEVEL LOG at 09:00:00 on 16-May-1997
----SELECT LIST SQLDA
--------SQLDA: SQLD 19
------------[0].SQLTYPE: SQLSRV_ASCII_STRING, SQLIND: 0
----------------len: 8, value: Non-printable data
------------[1].SQLTYPE: SQLSRV_GENERALIZED_NUMBER, SQLIND: 0
----------------len: 2, value: 12
------------[2].SQLTYPE: SQLSRV_VARCHAR, SQLIND: 0
----------------len: 9, value: Bremerton
------------[3].SQLTYPE: SQLSRV_ASCII_STRING, SQLIND: 0
----------------len: 12, value: B
------------[4].SQLTYPE: SQLSRV_VARCHAR, SQLIND: 0
----------------len: 9, value: Bremerton
------------[5].SQLTYPE: SQLSRV_VARCHAR, SQLIND: 0
----------------len: 13, value: W.S.F.
------------[6].SQLTYPE: SQLSRV_VARCHAR, SQLIND: 0
----------------len: 49, value: Bremerton
----------------
------------[7].SQLTYPE: SQLSRV_VARCHAR, SQLIND: 0
----------------len: 49, value: PASSENGER TOLLS NOT
----------------
------------[8].SQLTYPE: SQLSRV_VARCHAR, SQLIND: 0
----------------len: 49, value: COLLECTED HERE
----------------
------------[9].SQLTYPE: SQLSRV_VARCHAR, SQLIND: -1
----------------len: 0, value:
------------[10].SQLTYPE: SQLSRV_VARCHAR, SQLIND: -1
----------------len: 0, value:
------------[11].SQLTYPE: SQLSRV_VARCHAR, SQLIND: -1
----------------len: 0, value:
------------[12].SQLTYPE: SQLSRV_GENERALIZED_NUMBER, SQLIND: 0
----------------len: 8, value: 23000.00
------------[13].SQLTYPE: SQLSRV_GENERALIZED_DATE, SQLIND: 0
----------------len: 16, value: 0000000004150000
------------[14].SQLTYPE: SQLSRV_GENERALIZED_DATE, SQLIND: 0
----------------len: 16, value: 0000000002000000
------------[15].SQLTYPE: SQLSRV_GENERALIZED_NUMBER, SQLIND: 0
----------------len: 7, value: 1200.00
------------[16].SQLTYPE: SQLSRV_GENERALIZED_NUMBER, SQLIND: 0
----------------len: 7, value: 1500.00
------------[17].SQLTYPE: SQLSRV_GENERALIZED_NUMBER, SQLIND: 0
----------------len: 4, value: 5.00
------------[18].SQLTYPE: SQLSRV_GENERALIZED_NUMBER, SQLIND: 0
----------------len: 1, value: 4
ROUTINE LEVEL LOG at 09:00:00 on 16-May-1997
----FETCH ROW NUMBER
--------SQLSRV_GENERALIZED_NUMBER, len: 1
------------len: 1, value: 4
----SELECT LIST DATA
--------len: 2, value: 19
----SQLVAR
--------len: 2, value: 0
----SQLDATA
--------SQLSRV_ASCII_STRING, len: 8
------------len: 8, value: Non-printable data
----SQLIND
--------len: 2, value: 0
----SQLVAR
--------len: 2, value: 1
----SQLDATA
--------SQLSRV_GENERALIZED_NUMBER, len: 2
------------len: 2, value: 13
----SQLIND
--------len: 2, value: 0
----SQLVAR
--------len: 2, value: 2
----SQLDATA
--------SQLSRV_VARCHAR, len: 17
------------len: 17, value: Bainbridge Island
----SQLIND
--------len: 2, value: 0
----SQLVAR
--------len: 2, value: 3
----SQLDATA
--------SQLSRV_ASCII_STRING, len: 12
------------len: 12, value: W
----SQLIND
--------len: 2, value: 0
----SQLVAR
--------len: 2, value: 4
----SQLDATA
--------SQLSRV_VARCHAR, len: 17
------------len: 17, value: Bainbridge Island
----SQLIND
--------len: 2, value: 0
----SQLVAR
--------len: 2, value: 5
----SQLDATA
--------SQLSRV_VARCHAR, len: 13
------------len: 13, value: W.S.F.
----SQLIND
--------len: 2, value: 0
----SQLVAR
--------len: 2, value: 6
----SQLDATA
--------SQLSRV_VARCHAR, len: 49
------------len: 49, value: Bainbridge Island
----SQLIND
--------len: 2, value: 0
----SQLVAR
--------len: 2, value: 7
----SQLDATA
--------SQLSRV_VARCHAR, len: 49
------------len: 49, value: PASSENGER TOLLS NOT
----SQLIND
--------len: 2, value: 0
----SQLVAR
--------len: 2, value: 8
----SQLDATA
--------SQLSRV_VARCHAR, len: 49
------------len: 49, value: COLLECTED HERE
----SQLIND
--------len: 2, value: 0
----SQLVAR
--------len: 2, value: 9
----SQLDATA
--------SQLSRV_VARCHAR, len: 0
----SQLIND
--------len: 2, value: -1
----SQLVAR
--------len: 2, value: 10
----SQLDATA
--------SQLSRV_VARCHAR, len: 0
----SQLIND
--------len: 2, value: -1
----SQLVAR
--------len: 2, value: 11
----SQLDATA
--------SQLSRV_VARCHAR, len: 0
----SQLIND
--------len: 2, value: -1
----SQLVAR
--------len: 2, value: 12
----SQLDATA
--------SQLSRV_GENERALIZED_NUMBER, len: 8
------------len: 8, value: 36800.00
----SQLIND
--------len: 2, value: 0
----SQLVAR
--------len: 2, value: 13
----SQLDATA
--------SQLSRV_GENERALIZED_DATE, len: 16
------------len: 16, value: 0000000004300000
----SQLIND
--------len: 2, value: 0
----SQLVAR
--------len: 2, value: 14
----SQLDATA
--------SQLSRV_GENERALIZED_DATE, len: 16
------------len: 16, value: 0000000002000000
----SQLIND
--------len: 2, value: 0
----SQLVAR
--------len: 2, value: 15
----SQLDATA
--------SQLSRV_GENERALIZED_NUMBER, len: 7
------------len: 7, value: 1200.00
----SQLIND
--------len: 2, value: 0
----SQLVAR
--------len: 2, value: 16
----SQLDATA
--------SQLSRV_GENERALIZED_NUMBER, len: 7
------------len: 7, value: 1500.00
----SQLIND
--------len: 2, value: 0
----SQLVAR
--------len: 2, value: 17
----SQLDATA
--------SQLSRV_GENERALIZED_NUMBER, len: 4
------------len: 4, value: 5.00
----SQLIND
--------len: 2, value: 0
----SQLVAR
--------len: 2, value: 18
----SQLDATA
--------SQLSRV_GENERALIZED_NUMBER, len: 1
------------len: 1, value: 4
----SQLIND
--------len: 2, value: 0
------------END OF DATA
ROUTINE LEVEL LOG at 09:00:00 on 16-May-1997
----SELECT LIST SQLDA
--------SQLDA: SQLD 19
------------[0].SQLTYPE: SQLSRV_ASCII_STRING, SQLIND: 0
----------------len: 8, value: Non-printable data
------------[1].SQLTYPE: SQLSRV_GENERALIZED_NUMBER, SQLIND: 0
----------------len: 2, value: 13
------------[2].SQLTYPE: SQLSRV_VARCHAR, SQLIND: 0
----------------len: 17, value: Bainbridge Island
------------[3].SQLTYPE: SQLSRV_ASCII_STRING, SQLIND: 0
----------------len: 12, value: W
------------[4].SQLTYPE: SQLSRV_VARCHAR, SQLIND: 0
----------------len: 17, value: Bainbridge Island
------------[5].SQLTYPE: SQLSRV_VARCHAR, SQLIND: 0
----------------len: 13, value: W.S.F.
------------[6].SQLTYPE: SQLSRV_VARCHAR, SQLIND: 0
----------------len: 49, value: Bainbridge Island
----------------
------------[7].SQLTYPE: SQLSRV_VARCHAR, SQLIND: 0
----------------len: 49, value: PASSENGER TOLLS NOT
----------------
------------[8].SQLTYPE: SQLSRV_VARCHAR, SQLIND: 0
----------------len: 49, value: COLLECTED HERE
----------------
------------[9].SQLTYPE: SQLSRV_VARCHAR, SQLIND: -1
----------------len: 0, value:
------------[10].SQLTYPE: SQLSRV_VARCHAR, SQLIND: -1
----------------len: 0, value:
------------[11].SQLTYPE: SQLSRV_VARCHAR, SQLIND: -1
----------------len: 0, value:
------------[12].SQLTYPE: SQLSRV_GENERALIZED_NUMBER, SQLIND: 0
----------------len: 8, value: 36800.00
------------[13].SQLTYPE: SQLSRV_GENERALIZED_DATE, SQLIND: 0
----------------len: 16, value: 0000000004300000
------------[14].SQLTYPE: SQLSRV_GENERALIZED_DATE, SQLIND: 0
----------------len: 16, value: 0000000002000000
------------[15].SQLTYPE: SQLSRV_GENERALIZED_NUMBER, SQLIND: 0
----------------len: 7, value: 1200.00
------------[16].SQLTYPE: SQLSRV_GENERALIZED_NUMBER, SQLIND: 0
----------------len: 7, value: 1500.00
------------[17].SQLTYPE: SQLSRV_GENERALIZED_NUMBER, SQLIND: 0
----------------len: 4, value: 5.00
------------[18].SQLTYPE: SQLSRV_GENERALIZED_NUMBER, SQLIND: 0
----------------len: 1, value: 4
ROUTINE LEVEL LOG at 09:00:00 on 16-May-1997
----FETCH ROW NUMBER
--------SQLSRV_GENERALIZED_NUMBER, len: 1
------------len: 1, value: 5
----SELECT LIST DATA
--------len: 2, value: 19
----SQLVAR
--------len: 2, value: 0
----SQLDATA
--------SQLSRV_ASCII_STRING, len: 8
------------len: 8, value: Non-printable data
----SQLIND
--------len: 2, value: 0
----SQLVAR
--------len: 2, value: 1
----SQLDATA
--------SQLSRV_GENERALIZED_NUMBER, len: 2
------------len: 2, value: 31
----SQLIND
--------len: 2, value: 0
----SQLVAR
--------len: 2, value: 2
----SQLDATA
--------SQLSRV_VARCHAR, len: 10
------------len: 10, value: Fauntleroy
----SQLIND
--------len: 2, value: 0
----SQLVAR
--------len: 2, value: 3
----SQLDATA
--------SQLSRV_ASCII_STRING, len: 12
------------len: 12, value: F
----SQLIND
--------len: 2, value: 0
----SQLVAR
--------len: 2, value: 4
----SQLDATA
--------SQLSRV_VARCHAR, len: 10
------------len: 10, value: Fauntleroy
----SQLIND
--------len: 2, value: 0
----SQLVAR
--------len: 2, value: 5
----SQLDATA
--------SQLSRV_VARCHAR, len: 13
------------len: 13, value: W.S.F.
----SQLIND
--------len: 2, value: 0
----SQLVAR
--------len: 2, value: 6
----SQLDATA
--------SQLSRV_VARCHAR, len: 49
------------len: 49, value: FAUNTLEROY
----SQLIND
--------len: 2, value: 0
----SQLVAR
--------len: 2, value: 7
----SQLDATA
--------SQLSRV_VARCHAR, len: 49
------------len: 49, value: VEHICLE AND PASSENGER
----SQLIND
--------len: 2, value: 0
----SQLVAR
--------len: 2, value: 8
----SQLDATA
--------SQLSRV_VARCHAR, len: 49
------------len: 49, value: TOLLS COLLECTED HERE
----SQLIND
--------len: 2, value: 0
----SQLVAR
--------len: 2, value: 9
----SQLDATA
--------SQLSRV_VARCHAR, len: 0
----SQLIND
--------len: 2, value: -1
----SQLVAR
--------len: 2, value: 10
----SQLDATA
--------SQLSRV_VARCHAR, len: 0
----SQLIND
--------len: 2, value: -1
---- End of Message ----
|