[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference orarep::nomahs::odbc_rdb_driver

Title:DEC ODBC Driver
Notice:DEC ODBC Driver V2.0 Now Available
Moderator:SQLSRV::MAVRIS
Created:Tue Dec 29 1992
Last Modified:Fri Jun 06 1997
Last Successful Update:Fri Jun 06 1997
Number of topics:1357
Total number of notes:4864

1343.0. "Inconsistant results with 2.10.11 driver?" by BROKE::BASTINE () Fri May 16 1997 00:14

Customer upgraded from WinNT 3.51 to NT 4.0 and installed the new driver 
2.10.11.  Now some of his access applications, that worked in 3.51 and 
odbc 2.0.20 now return inconsistant results.  He re-installed the 2.0.20
driver on NT 4.0 and everything worked again... wanted to know if we
knew of any problems running 2.10.11 on NT 4.0.  This is an intel box, so
I didn't think there was a problem... 

I have asked him for client logs of the good system vs. the system that
produces the inconsistent results so we can compare... I am waiting for 
those, in the meantime... anyone know of any known problems in the 2.10.11
driver that would cause an inconsistant set of data to be returned for the
same query?

Thanks,

Renee
T.RTitleUserPersonal
Name
DateLines
1343.1IdeasNOMAHS::SECRISTRdb WWS; rsecrist@us.oracle.comSun May 18 1997 21:0714
    
    You didn't mention the transport.  Sue says NT 4.0 on Intel is
    cool and tested using TCP/IP, and I have worked with customers
    who can back that up -- but DECnet and IPX/SPX are unknowns as
    far as I know.
    
    He doesn't have the 16-bit ODBC installed too does he ?  I saw
    somebody who did this with the 32-bit installed and it made 
    everything inoperable (I think it was using the wrong
    administrator data files or something). 
    
    Regards,
    rcs
    
1343.2More informationBROKE::BASTINEMon May 19 1997 17:2724
Customer is running TCP/IP.

He is only running the 32-bit driver.

He said that the diff in the client logs between the system that worked and
the system that doesn't work showed that the network buffer sizes were 
different.  The system that worked had a network buffer size of 5000, but the
one that didn't work had a size of 1300.  

So he increased the network buffer size to 5000 on the system that doesn't
work and it still failed.  He is going to get a new client log from the 
2 systems and compare them again.

System that works:  NT 3.51 with ODBC 2.10.11
Broke system     :  NT 4.0 with ODBC 2.10.11

NT 4.0 with ODBC 2.0.20 also works!!

All clients are connecting to the SAME server so TCP/IP params on the server
are consistent.

Any other ideas?
    
Renee
1343.3More informationBROKE::BASTINEWed May 21 1997 00:252091
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



1343.416-bit good runBROKE::BASTINEWed May 21 1997 00:262085
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 ----


1343.5M5::JBALOGHWed May 21 1997 12:187
    What exactly do you mean by inconsistant results? Rows not being
    returned? Invalid data? Errors?    I took at quick look at the log
    files but didn't see anything exciting. There is 4000+ lines though so
    I may have missed something since I didn't really know what I was
    looking for... 
    
    John
1343.6wrong data returned...BROKE::BASTINEWed May 21 1997 12:368
Sorry John... rows are being returned in both cases.  In the 16 bit driver 
case the correct number of rows are being returned, with the expected data.
In the 32-bit log, an incorrect number of rows is being returned, data that
is not expected given the query.  There are no errors, he justs gets the 
wrong data back.  The 32-bit log should receive the same data/same number
of rows that the 16 bit log shows.  It is the same query to the same db.

Renee
1343.7M5::JHAYTERWed May 21 1997 15:4111
Renee

I'm no client log expert but

1.  neither log looks complete so i can't see proof of inconsistant data
2.  data in logs looks the same to me 
3.  difference is 16 says it is doing a fetch many, but the 32 is not or at
least doesn't appear to be doing so to me.

jerry
1343.8M5::JBALOGHWed May 21 1997 17:5911
    Jerry is right, neither log is complete but the data that is there
    looks consistant. It did look like one log had one more row than
    the other but it just looks like one got cut off earlier...
    
    We are going to need complete logs and we need to know exactly what row
    is inconsistant and specificly what is wrong with it. Since there is no
    where clause on the SQL statement, I would expect both drivers to
    return all rows in the table... 
    
    Is fetchahead enabled/disabled in both cases? Sounds like it may be on
    one but not the other...
1343.9BROKE::BASTINEWed May 21 1997 19:2711
>    Is fetchahead enabled/disabled in both cases? Sounds like it may be on
>    one but not the other...


According to the customer he set fetchahead to NO in both the WIN.INI
and RDBODBC.INI files.

I'll see if I can get the full log files.  He sent them via email, text
and might have gotten munged during transmission... I appreciate your help!!

Renee
1343.10M5::JHAYTERWed May 21 1997 21:056
>According to the customer he set fetchahead to NO in both the WIN.INI
>and RDBODBC.INI files.

well the 16 bit log file says he didn't.

1343.11But the 16 bit works!!! Hmmm...BROKE::BASTINEThu May 22 1997 00:346
> well the 16 bit log file says he didn't.

He doesn't like to reboot windows... so far all the changes we made we 
didn't have to, but I bet he didn't reboot afterwards... I'll double check.


1343.12Problem solved, still left with few questionsBROKE::BASTINEThu May 22 1997 21:5455
Well, the customer double checked fetch ahead settings on the 32 bit driver,
turned them off and now it is working correctly.

I received this from the customer:

I have generated the log files again. The proper setting for FetchAhead is
NO, and that is how it is now set for both 16- and 32-bit drivers. Because
we didn't know where these parameters were stored until I talked to you
last week, we hadn't set the parameters correctly. Now that they are set, I
get the correct results when I run the test.

Documentation is lacking. I just looked in the HELP file for information on
fetchahead. It says:

[Fetch Ahead] improves the speed in which the data is retrieved. For
applications that execute more than one SQL statement at a time over the
same connection, the "fetch ahead" feature will need to be disabled. The
driver will return the following error if the "fetch ahead" feature needs
to be disabled:

Multiple SQL statements cannot be active when FetchAhead=YES

As far as I know, ACCESS does not execute more than one SQL statement at a
time. In any case, we do not get the error message, only wrong results. I
do recall that the person that developed the application had problems until
some of the parameters were changed. I never knew what parameters or why
they were changed, though.

Another note: when I run the application with logging enabled with the

32-bit driver, it takes a lot longer - something like 25 minutes, as
opposed to about 3 or 4 minutes with the 16-bit driver. With logging
disabled, the 16-bit driver is slightly faster than the 32-bit driver
(about 30 seconds for the same test).

I think it is now working - it appears the problems were caused by
incorrect parameters. I'm not comfortable that wrong results were returned
without errors, though. It's possible that errors were returned with
improper error handling. I haven't looked at the code. You might want to
persue speed issues. I would expect the 32-bit drivers to be faster than
the 16-bit drivers, although I could understand that a 16-bit application
might have enough "thunking" going on to lose the speed gain. The debug
logging should not slow it down by a factor of 5 to 10, however.



---------------------------------------

Anyone heard of incorrect fetchahead setting causing inaccurate results 
instead of errors?

What about the 32 bit driver being slower than the 16 bit driver?

Thanks,
Renee