[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 () Thu May 15 1997 20: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.R	Title	User	Personal Name	Date	Lines
1343.1	Ideas	NOMAHS::SECRIST	Rdb WWS; [email protected]	`Sun May 18 1997 17:07`	14
	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.2	More information	BROKE::BASTINE		`Mon May 19 1997 13:27`	24
	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.3	More information	BROKE::BASTINE		`Tue May 20 1997 20:25`	2091
	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.4	16-bit good run	BROKE::BASTINE		`Tue May 20 1997 20:26`	2085
	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.5		M5::JBALOGH		`Wed May 21 1997 08:18`	7
	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.6	wrong data returned...	BROKE::BASTINE		`Wed May 21 1997 08:36`	8
	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.7		M5::JHAYTER		`Wed May 21 1997 11:41`	11
	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.8		M5::JBALOGH		`Wed May 21 1997 13:59`	11
	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.9		BROKE::BASTINE		`Wed May 21 1997 15:27`	11
	> 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.10		M5::JHAYTER		`Wed May 21 1997 17:05`	6
	>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.11	But the 16 bit works!!! Hmmm...	BROKE::BASTINE		`Wed May 21 1997 20:34`	6
	> 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.12	Problem solved, still left with few questions	BROKE::BASTINE		`Thu May 22 1997 17:54`	55
	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