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

Conference orarep::nomahs::rdb_60

Title:Oracle Rdb - Still a strategic database for DEC on Alpha AXP!
Notice:RDB_60 is archived, please use RDB_70..
Moderator:NOVA::SMITHISON
Created:Fri Mar 18 1994
Last Modified:Fri May 30 1997
Last Successful Update:Fri Jun 06 1997
Number of topics:5118
Total number of notes:28246

5068.0. "Probs with DATE ANSI, TIME, TIMESTAMP using ODBC" by ORAREP::AWECIM::HOWARD () Mon Feb 24 1997 20:35

    
I'm having trouble in MS-Access looking at any Rdb tables containing 
values of data types DATE ANSI, TIMESTAMP, or TIME.  When I create an
external link in MS-Access to the tables using the ODBC RDB driver, 
MS-Access issues a message "ODBC-call failed" and shows all values in 
these tables as "#Name?".

But tables containing DATE VMS values work just fine.

I am using:

   PC:
        Windows NT 3.51 (with Service Pack 4)
        Access for Windows 95 V7.0
        ODBC RDB V2.10.11 32-bit with TCP/IP

   OpenVMS:
        DEC SQL V6.1-0
        DEC Rdb V6.1-0
        Rdb/Dispatch V6.1-0 (OpenVMS AXP) 

Is there a way to access DATE ANSI, TIMESTAMP, and TIME data types using the 
ODBC RDB V2.10.11 32-bit with TCP/IP driver with MS-Access?

Thanks,
John Howard

The SQL statements that I used in my test are attached.

--------------------------------------------------------------------------------
create database filename 'MYTEST.RDB';
--------------------------------------------------------------------------------
--
-- Test DATE VMS  (can be seen via ODBC)
--------------------------------------------------------------------------------
create table myDateVms (
    myId1 	        INTEGER	PRIMARY KEY DEFERRABLE,
    myDateVms 		DATE VMS DEFAULT CURRENT_TIMESTAMP, 
    myId2 	        INTEGER);
commit;
--------------------------------------------------------------------------------
CREATE UNIQUE INDEX my_index_1
  ON myDateVms (
    myID1 ASC)
  TYPE IS SORTED
  NODE SIZE 1480
  USAGE QUERY
  ENABLE COMPRESSION;
commit;
-------------------------------------------------------------------------------
insert into myDateVms (
    myId1,
    myId2)
  VALUES (
	123,
	456);
commit;
--------------------------------------------------------------------------------






-- Test DATE ANSI  (can't be seen via ODBC)
--------------------------------------------------------------------------------
create table myDateAnsi (
    myId1 	        INTEGER	PRIMARY KEY DEFERRABLE,
    myDateAnsi 		DATE ANSI DEFAULT CURRENT_DATE,
    myId2 	        INTEGER);
commit;
--------------------------------------------------------------------------------
CREATE UNIQUE INDEX my_index_2
  ON myDateAnsi (
    myID1 ASC)
  TYPE IS SORTED
  NODE SIZE 1480
  USAGE QUERY
  ENABLE COMPRESSION;
commit;
-------------------------------------------------------------------------------
insert into myDateAnsi (
    myId1,
    myId2)
  VALUES (
	123,
	456);
commit;
--------------------------------------------------------------------------------





-- Test TIMESTAMP (can't be seen via ODBC)
--------------------------------------------------------------------------------
create table myTimestamp (
    myId1 	        INTEGER	PRIMARY KEY DEFERRABLE,
    myTimestamp 	TIMESTAMP DEFAULT CURRENT_TIMESTAMP(2),
    myId2 	        INTEGER);
commit;
--------------------------------------------------------------------------------
CREATE UNIQUE INDEX my_index_3
  ON myTimestamp (
    myID1 ASC)
  TYPE IS SORTED
  NODE SIZE 1480
  USAGE QUERY
  ENABLE COMPRESSION;
commit;
-------------------------------------------------------------------------------
insert into myTimestamp (
    myId1,
    myId2)
  VALUES (
	123,
	456);
commit;
--------------------------------------------------------------------------------





-- Test TIME (can't be seen via ODBC)
--------------------------------------------------------------------------------
create table myTime (
    myId1 	        INTEGER	PRIMARY KEY DEFERRABLE,
    myTime	 	TIME DEFAULT CURRENT_TIME,
    myId2 	        INTEGER);
commit;
--------------------------------------------------------------------------------
CREATE UNIQUE INDEX my_index_4
  ON myTime (
    myID1 ASC)
  TYPE IS SORTED
  NODE SIZE 1480
  USAGE QUERY
  ENABLE COMPRESSION;
commit;
-------------------------------------------------------------------------------
insert into myTime (
    myId1,
    myId2)
  VALUES (
	123,
	456);
commit;
--------------------------------------------------------------------------------
--
--
--
exit


=========================================================================
Here are the SQL Table Contents from Interactive SQL.

	SQL> attach 'filename mytest.rdb';

	SQL> select * from myDateVms;
	       MYID1   MYDATEVMS                       MYID2
	         123   24-FEB-1997 15:51:15.06           456
	1 row selected

	SQL> select * from myDateAnsi;
	       MYID1   MYDATEANSI         MYID2
	         123   1997-02-24           456
	1 row selected

	SQL> select * from myTimestamp;
	       MYID1   MYTIMESTAMP                    MYID2
	         123   1997-02-24:15:51:19.65           456
	1 row selected

	SQL> select * from myTime;
	       MYID1   MYTIME           MYID2
	         123   15:51:21           456
	1 row selected
T.RTitleUserPersonal
Name		DateLines
5068.1M5::JBALOGHMon Feb 24 1997 21:4621
    I have been using SQLSRV 6.1-02 and Rdb 6.1-01 for quite a while with
    date ansi without a problem. What version of SQLServices are you
    running? To find out, anal/image/int sys$system:sqlsrv$.exe and look
    for image identification information. This image won't exist for SQLSRV
    7.0 so if you can't find the image... Look for SQLSRV_MON*. This is NOT
    necessarily the same version as SQL...
    
    MS Access displays #Name for a number of reasons including lack of
    resources, using reserved words or an error returned from the server at
    a bad time. 
    
    So see if Rdb returned an error, turn on driver and client logging and
    review the logs for errors. To get these logs, edit RDBODBC.INI and set
    the clientlogging and driverlogging values to 7 on both. The logs will
    be called ODBCRDB.LOG and CLIENTxx.LOG (xx increments) and will be
    created in your default directory (possibly the MS Access dir). 
    
    John
5068.2Getting error: "%SQL-F-NOREPSQLDA, Cannot represent using SQLDA"ORAREP::AWECIM::HOWARDTue Feb 25 1997 13:022371
    
    John,
    
    It appears that I may be running V6.0-1 of SQLServices from Feb-95:
    
            Image Identification Information
    
                    image name: "SQLSRV$"
                    image file identification: "V6.0-1"
                    link date/time:  9-FEB-1995 22:22:27.12
                    linker identification: "05-05"
    
    I couldn't find SQLSRV_MON*.
    
    As suggested, I turned on logging.  The log files (attached) revealed
    an error stating "%SQL-F-NOREPSQLDA, Cannot represent using SQLDA."
    
    Can you suggest how I should move forward?
    
    Thanks,
    John Howard
    
    The files CLIENT00.LOG and ODBCRDB.LOG follow...

    Log file generated by C:\WINNT\System32\sqsapi32.dll
    Oracle Sql/Services Version 7.00

ASSOCIATE LEVEL LOG
----SQLSRV_ASSOCIATE
--------SQLSRV_ASSOCIATE ID: 7cf15c8
--------NODE: cimmom, USERNAME: howard, SQLCODE: 0, SQLERRD[0] 0
--------NETWORK TRANSPORT: TCP/IP

PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:23:41 on 25-Feb-1997
----PACKET ID: 1, PACKET SEQUENCE: 0
--------SQLSRV_ASSOCIATE
------------CLIENT PROTOCOL VERSION
----------------len: 2, value: 14
------------USERNAME
----------------SQLSRV_ASCII_STRING, len: 6
--------------------len: 6, value: howard
------------PASSWORD
----------------SQLSRV_VARCHAR, len: 8
--------------------len: 10, value: <password>
------------READ BUFFER SIZE
----------------len: 2, value: 5000
------------WRITE BUFFER SIZE
----------------len: 2, value: 5000
------------SERVICE NAME
----------------SQLSRV_ASCII_STRING, len: 7
--------------------len: 7, value: generic
------------ATTACH STATEMENT
----------------SQLSRV_ASCII_STRING, len: 47
--------------------len: 47, value: attach 'filename user3$:[howard.rdb]mytest.r
--------------------db'
------------DECLARE TRANSACTION STATEMENT
----------------SQLSRV_ASCII_STRING, len: 58
--------------------len: 58, value: DECLARE TRANSACTION READ WRITE WAIT 30 CONSI
--------------------STENCY LEVEL 2
------------APPLICATION NAME
----------------SQLSRV_ASCII_STRING, len: 8
--------------------len: 8, value: MSACCESS
--------END OF MESSAGE

PROTOCOL LEVEL LOG CLIENT: read at 09:23:43 on 25-Feb-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: 7
------------SQLSRV SERVER VERSION
----------------SQLSRV_ASCII_STRING, len: 6
--------------------len: 6, value: V6.0-1
------------EXCECUTOR PID
----------------SQLSRV_GENERALIZED_NUMBER, len: 9
--------------------len: 9, value: 538976626
------------SERVICE ATTRIBUTES
----------------len: 2, value: 0
--------END OF MESSAGE

ROUTINE LEVEL LOG at 09:23:43 on 25-Feb-1997
----SQLSRV_EXECUTE_IMMEDIATE
--------SQL STATEMENT
------------len: 47, value: attach 'filename user3$:[howard.rdb]mytest.rdb'

PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:23:43 on 25-Feb-1997
----PACKET LENGTH: 61

PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:23:43 on 25-Feb-1997
----PACKET ID: 2, PACKET SEQUENCE: 0
--------SQLSRV_EXECUTE_IMMEDIATE
------------SQL STATEMENT
----------------SQLSRV_ASCII_STRING, len: 47
--------------------len: 47, value: attach 'filename user3$:[howard.rdb]mytest.r
--------------------db'
--------END OF MESSAGE

PROTOCOL LEVEL LOG CLIENT: read at 09:23:45 on 25-Feb-1997
----PACKET LENGTH: 20

PROTOCOL LEVEL LOG CLIENT: read at 09:23:45 on 25-Feb-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:23:45 on 25-Feb-1997
----SQLSRV_EXECUTE_IMMEDIATE
--------SQL STATEMENT
------------len: 58, value: DECLARE TRANSACTION READ WRITE WAIT 30 CONSISTENCY L
------------EVEL 2

PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:23:45 on 25-Feb-1997
----PACKET LENGTH: 72

PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:23:45 on 25-Feb-1997
----PACKET ID: 3, PACKET SEQUENCE: 0
--------SQLSRV_EXECUTE_IMMEDIATE
------------SQL STATEMENT
----------------SQLSRV_ASCII_STRING, len: 58
--------------------len: 58, value: DECLARE TRANSACTION READ WRITE WAIT 30 CONSI
--------------------STENCY LEVEL 2
--------END OF MESSAGE

PROTOCOL LEVEL LOG CLIENT: read at 09:23:45 on 25-Feb-1997
----PACKET LENGTH: 20

PROTOCOL LEVEL LOG CLIENT: read at 09:23:45 on 25-Feb-1997
----PACKET ID: 3, 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:23:45 on 25-Feb-1997
----SQLSRV_GET_ASSOCIATE_INFO

ROUTINE LEVEL LOG at 09:23:45 on 25-Feb-1997
----SQLSRV_GET_ASSOCIATE_INFO

ROUTINE LEVEL LOG at 09:23:45 on 25-Feb-1997
----SQLSRV_GET_ASSOCIATE_INFO

ROUTINE LEVEL LOG at 09:23:45 on 25-Feb-1997
----SQLSRV_EXECUTE_IMMEDIATE
--------SQL STATEMENT
------------len: 57, value: DECLARE TRANSACTION READ ONLY WAIT 30 CONSISTENCY LE
------------VEL 2

PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:23:45 on 25-Feb-1997
----PACKET LENGTH: 71

PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:23:45 on 25-Feb-1997
----PACKET ID: 4, PACKET SEQUENCE: 0
--------SQLSRV_EXECUTE_IMMEDIATE
------------SQL STATEMENT
----------------SQLSRV_ASCII_STRING, len: 57
--------------------len: 57, value: DECLARE TRANSACTION READ ONLY WAIT 30 CONSIS
--------------------TENCY LEVEL 2
--------END OF MESSAGE

PROTOCOL LEVEL LOG CLIENT: read at 09:23:45 on 25-Feb-1997
----PACKET LENGTH: 20

PROTOCOL LEVEL LOG CLIENT: read at 09:23:45 on 25-Feb-1997
----PACKET ID: 4, 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:23:46 on 25-Feb-1997
----SQLSRV_PREPARE
--------SQL STATEMENT
------------len: 35, value: SELECT Config, nValue FROM MSysConf

PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:23:46 on 25-Feb-1997
----PACKET LENGTH: 49

PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:23:46 on 25-Feb-1997
----PACKET ID: 5, 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:23:46 on 25-Feb-1997
----PACKET LENGTH: 97

PROTOCOL LEVEL LOG CLIENT: read at 09:23:46 on 25-Feb-1997
----PACKET ID: 5, 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:23:47 on 25-Feb-1997
----SQLSRV_PREPARE
--------SQL STATEMENT
------------len: 37, value: SELECT MYDATEVMS.MYID1 FROM MYDATEVMS

PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:23:47 on 25-Feb-1997
----PACKET LENGTH: 51

PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:23:47 on 25-Feb-1997
----PACKET ID: 6, PACKET SEQUENCE: 0
--------SQLSRV_PREPARE
------------SQL STATEMENT
----------------SQLSRV_ASCII_STRING, len: 37
--------------------len: 37, value: SELECT MYDATEVMS.MYID1 FROM MYDATEVMS
--------END OF MESSAGE

PROTOCOL LEVEL LOG CLIENT: read at 09:23:47 on 25-Feb-1997
----PACKET LENGTH: 51

PROTOCOL LEVEL LOG CLIENT: read at 09:23:47 on 25-Feb-1997
----PACKET ID: 6, PACKET SEQUENCE: 0
--------SQLSRV_PREPARE ACK
------------STATEMENT ID
----------------SQLSRV_GENERALIZED_NUMBER, len: 7
--------------------len: 7, value: 3827432
------------SQLERRD[1]
----------------SQLSRV_GENERALIZED_NUMBER, len: 1
--------------------len: 1, value: 1
------------SELECT LIST SQLDA
----------------len: 2, value: 1
------------SQLVAR
----------------len: 2, value: 0
------------SQLTYPE
----------------len: 2, value: 130
------------SQLLEN
----------------len: 2, value: 11
------------SQLNAME
----------------SQLSRV_ASCII_STRING, len: 5
--------------------len: 5, value: MYID1
--------END OF MESSAGE

ROUTINE LEVEL LOG at 09:23:47 on 25-Feb-1997
----SELECT LIST SQLDA
--------SQLDA: SQLD 1
--------[0].SQLTYPE: SQLSRV_GENERALIZED_NUMBER, SIZE 11, SCALE 0
------------SQLNAME: MYID1

ROUTINE LEVEL LOG at 09:23:47 on 25-Feb-1997
----SQLSRV_ALLOCATE_SQLDA_DATA

ROUTINE LEVEL LOG at 09:23:47 on 25-Feb-1997
----SQLSRV_OPEN_CURSOR
--------CURSOR NAME
------------SQL_CUR181588
--------STATEMENT ID
------------3827432

PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:23:47 on 25-Feb-1997
----PACKET LENGTH: 42

PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:23:47 on 25-Feb-1997
----PACKET ID: 7, PACKET SEQUENCE: 0
--------SQLSRV_OPEN_CURSOR
------------CURSOR NAME
----------------SQLSRV_ASCII_STRING, len: 13
--------------------len: 13, value: SQL_CUR181588
------------STATEMENT ID
----------------SQLSRV_GENERALIZED_NUMBER, len: 7
--------------------len: 7, value: 3827432
------------CURSOR MODE
----------------len: 2, value: 2
--------END OF MESSAGE

PROTOCOL LEVEL LOG CLIENT: read at 09:23:47 on 25-Feb-1997
----PACKET LENGTH: 30

PROTOCOL LEVEL LOG CLIENT: read at 09:23:47 on 25-Feb-1997
----PACKET ID: 7, 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: 1
------------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:23:47 on 25-Feb-1997
----SQLSRV_FETCH_MANY
--------CURSOR NAME
------------SQL_CUR181588
--------REPEAT COUNT
------------5818

ROUTINE LEVEL LOG at 09:23:47 on 25-Feb-1997
----SQLSRV_FETCH
--------CURSOR NAME
------------SQL_CUR181588

PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:23:47 on 25-Feb-1997
----PACKET LENGTH: 31

PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:23:47 on 25-Feb-1997
----PACKET ID: 8, PACKET SEQUENCE: 0
--------SQLSRV_FETCH
------------CURSOR NAME
----------------SQLSRV_ASCII_STRING, len: 13
--------------------len: 13, value: SQL_CUR181588
------------REPEAT COUNT
----------------len: 2, value: 5818
--------END OF MESSAGE

PROTOCOL LEVEL LOG CLIENT: read at 09:23:47 on 25-Feb-1997
----PACKET LENGTH: 52

PROTOCOL LEVEL LOG CLIENT: read at 09:23:47 on 25-Feb-1997
----PACKET ID: 8, PACKET SEQUENCE: 0
--------SQLSRV_FETCH ACK
------------FETCH ROW NUMBER
----------------SQLSRV_GENERALIZED_NUMBER, len: 1
--------------------len: 1, value: 1
------------SELECT LIST DATA
----------------len: 2, value: 1
------------SQLVAR
----------------len: 2, value: 0
------------SQLDATA
----------------SQLSRV_GENERALIZED_NUMBER, len: 3
--------------------len: 3, value: 123
------------SQLIND
----------------len: 2, value: 0
------------END OF DATA

ROUTINE LEVEL LOG at 09:23:47 on 25-Feb-1997
----SELECT LIST SQLDA
--------SQLDA: SQLD 1
------------[0].SQLTYPE: SQLSRV_GENERALIZED_NUMBER, SQLIND: 0
----------------len: 3, value: 123

ROUTINE LEVEL LOG at 09:23:48 on 25-Feb-1997
----FETCH ROW NUMBER
--------SQLSRV_GENERALIZED_NUMBER, len: 1
------------len: 1, value: 0
----STATUS
--------SQLSRV_GENERALIZED_NUMBER, len: 3
------------len: 3, value: 100
----SQLERRD[5]
--------SQLSRV_GENERALIZED_NUMBER, len: 1
------------len: 1, value: 0
--------END OF MESSAGE

ROUTINE LEVEL LOG at 09:23:48 on 25-Feb-1997
----SELECT LIST SQLDA
--------SQLDA: SQLD 1
------------[0].SQLTYPE: SQLSRV_GENERALIZED_NUMBER, SQLIND: 0
----------------len: 3, value: 123

ROUTINE LEVEL LOG at 09:23:48 on 25-Feb-1997
----SQLSRV_CLOSE_CURSOR
--------CURSOR NAME
------------SQL_CUR181588

PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:23:48 on 25-Feb-1997
----PACKET LENGTH: 27

PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:23:48 on 25-Feb-1997
----PACKET ID: 9, PACKET SEQUENCE: 0
--------SQLSRV_CLOSE_CURSOR
------------CURSOR NAME
----------------SQLSRV_ASCII_STRING, len: 13
--------------------len: 13, value: SQL_CUR181588
--------END OF MESSAGE

PROTOCOL LEVEL LOG CLIENT: read at 09:23:48 on 25-Feb-1997
----PACKET LENGTH: 10

PROTOCOL LEVEL LOG CLIENT: read at 09:23:48 on 25-Feb-1997
----PACKET ID: 9, PACKET SEQUENCE: 0
--------SQLSRV_CLOSE_CURSOR ACK
--------END OF MESSAGE

ROUTINE LEVEL LOG at 09:23:48 on 25-Feb-1997
----SQLSRV_EXECUTE_IMMEDIATE
--------SQL STATEMENT
------------len: 6, value: COMMIT

PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:23:48 on 25-Feb-1997
----PACKET LENGTH: 20

PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:23:48 on 25-Feb-1997
----PACKET ID: 10, PACKET SEQUENCE: 0
--------SQLSRV_EXECUTE_IMMEDIATE
------------SQL STATEMENT
----------------SQLSRV_ASCII_STRING, len: 6
--------------------len: 6, value: COMMIT
--------END OF MESSAGE

PROTOCOL LEVEL LOG CLIENT: read at 09:23:48 on 25-Feb-1997
----PACKET LENGTH: 20

PROTOCOL LEVEL LOG CLIENT: read at 09:23:48 on 25-Feb-1997
----PACKET ID: 10, 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:23:48 on 25-Feb-1997
----SQLSRV_RELEASE_STATEMENT
--------STATEMENT ID
------------[0] 3827432

PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:23:48 on 25-Feb-1997
----PACKET LENGTH: 25

PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:23:48 on 25-Feb-1997
----PACKET ID: 11, PACKET SEQUENCE: 0
--------SQLSRV_RELEASE_STATEMENT
------------STATEMENT COUNT
----------------len: 2, value: 1
------------STATEMENT ID
----------------SQLSRV_GENERALIZED_NUMBER, len: 7
--------------------len: 7, value: 3827432
--------END OF MESSAGE

PROTOCOL LEVEL LOG CLIENT: read at 09:23:48 on 25-Feb-1997
----PACKET LENGTH: 19

PROTOCOL LEVEL LOG CLIENT: read at 09:23:48 on 25-Feb-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:23:48 on 25-Feb-1997
----SQLSRV_FREE_SQLDA_DATA

ROUTINE LEVEL LOG at 09:23:49 on 25-Feb-1997
----SQLSRV_EXECUTE_IMMEDIATE
--------SQL STATEMENT
------------len: 58, value: DECLARE TRANSACTION READ WRITE WAIT 30 CONSISTENCY L
------------EVEL 2

PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:23:49 on 25-Feb-1997
----PACKET LENGTH: 72

PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:23:49 on 25-Feb-1997
----PACKET ID: 12, PACKET SEQUENCE: 0
--------SQLSRV_EXECUTE_IMMEDIATE
------------SQL STATEMENT
----------------SQLSRV_ASCII_STRING, len: 58
--------------------len: 58, value: DECLARE TRANSACTION READ WRITE WAIT 30 CONSI
--------------------STENCY LEVEL 2
--------END OF MESSAGE

PROTOCOL LEVEL LOG CLIENT: read at 09:23:49 on 25-Feb-1997
----PACKET LENGTH: 20

PROTOCOL LEVEL LOG CLIENT: read at 09:23:49 on 25-Feb-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:23:49 on 25-Feb-1997
----SQLSRV_PREPARE
--------SQL STATEMENT
------------len: 44, value: SELECT MYID1,MYDATEVMS,MYID2  FROM MYDATEVMS

PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:23:49 on 25-Feb-1997
----PACKET LENGTH: 58

PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:23:49 on 25-Feb-1997
----PACKET ID: 13, PACKET SEQUENCE: 0
--------SQLSRV_PREPARE
------------SQL STATEMENT
----------------SQLSRV_ASCII_STRING, len: 44
--------------------len: 44, value: SELECT MYID1,MYDATEVMS,MYID2  FROM MYDATEVMS
--------END OF MESSAGE

PROTOCOL LEVEL LOG CLIENT: read at 09:23:49 on 25-Feb-1997
----PACKET LENGTH: 97

PROTOCOL LEVEL LOG CLIENT: read at 09:23:49 on 25-Feb-1997
----PACKET ID: 13, PACKET SEQUENCE: 0
--------SQLSRV_PREPARE ACK
------------STATEMENT ID
----------------SQLSRV_GENERALIZED_NUMBER, len: 7
--------------------len: 7, value: 3827432
------------SQLERRD[1]
----------------SQLSRV_GENERALIZED_NUMBER, len: 1
--------------------len: 1, value: 1
------------SELECT LIST SQLDA
----------------len: 2, value: 3
------------SQLVAR
----------------len: 2, value: 0
------------SQLTYPE
----------------len: 2, value: 130
------------SQLLEN
----------------len: 2, value: 11
------------SQLNAME
----------------SQLSRV_ASCII_STRING, len: 5
--------------------len: 5, value: MYID1
------------SQLVAR
----------------len: 2, value: 1
------------SQLTYPE
----------------len: 2, value: 131
------------SQLLEN
----------------len: 2, value: 17
------------SQLNAME
----------------SQLSRV_ASCII_STRING, len: 9
--------------------len: 9, value: MYDATEVMS
------------SQLVAR
----------------len: 2, value: 2
------------SQLTYPE
----------------len: 2, value: 130
------------SQLLEN
----------------len: 2, value: 11
------------SQLNAME
----------------SQLSRV_ASCII_STRING, len: 5
--------------------len: 5, value: MYID2
--------END OF MESSAGE

ROUTINE LEVEL LOG at 09:23:49 on 25-Feb-1997
----SELECT LIST SQLDA
--------SQLDA: SQLD 3
--------[0].SQLTYPE: SQLSRV_GENERALIZED_NUMBER, SIZE 11, SCALE 0
------------SQLNAME: MYID1
--------[1].SQLTYPE: SQLSRV_GENERALIZED_DATE, SIZE 17, TYPE 0
------------SQLNAME: MYDATEVMS
--------[2].SQLTYPE: SQLSRV_GENERALIZED_NUMBER, SIZE 11, SCALE 0
------------SQLNAME: MYID2

ROUTINE LEVEL LOG at 09:23:49 on 25-Feb-1997
----SQLSRV_ALLOCATE_SQLDA_DATA

ROUTINE LEVEL LOG at 09:23:49 on 25-Feb-1997
----SQLSRV_OPEN_CURSOR
--------CURSOR NAME
------------SQL_CUR181588
--------STATEMENT ID
------------3827432

PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:23:49 on 25-Feb-1997
----PACKET LENGTH: 38

PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:23:49 on 25-Feb-1997
----PACKET ID: 14, PACKET SEQUENCE: 0
--------SQLSRV_OPEN_CURSOR
------------CURSOR NAME
----------------SQLSRV_ASCII_STRING, len: 13
--------------------len: 13, value: SQL_CUR181588
------------STATEMENT ID
----------------SQLSRV_GENERALIZED_NUMBER, len: 7
--------------------len: 7, value: 3827432
--------END OF MESSAGE

PROTOCOL LEVEL LOG CLIENT: read at 09:23:50 on 25-Feb-1997
----PACKET LENGTH: 30

PROTOCOL LEVEL LOG CLIENT: read at 09:23:50 on 25-Feb-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: 2
------------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:23:50 on 25-Feb-1997
----SQLSRV_FETCH_MANY
--------CURSOR NAME
------------SQL_CUR181588
--------REPEAT COUNT
------------10

ROUTINE LEVEL LOG at 09:23:50 on 25-Feb-1997
----SQLSRV_FETCH
--------CURSOR NAME
------------SQL_CUR181588

PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:23:50 on 25-Feb-1997
----PACKET LENGTH: 31

PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:23:50 on 25-Feb-1997
----PACKET ID: 15, PACKET SEQUENCE: 0
--------SQLSRV_FETCH
------------CURSOR NAME
----------------SQLSRV_ASCII_STRING, len: 13
--------------------len: 13, value: SQL_CUR181588
------------REPEAT COUNT
----------------len: 2, value: 10
--------END OF MESSAGE

PROTOCOL LEVEL LOG CLIENT: read at 09:23:50 on 25-Feb-1997
----PACKET LENGTH: 95

PROTOCOL LEVEL LOG CLIENT: read at 09:23:50 on 25-Feb-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: 3
------------SQLVAR
----------------len: 2, value: 0
------------SQLDATA
----------------SQLSRV_GENERALIZED_NUMBER, len: 3
--------------------len: 3, value: 123
------------SQLIND
----------------len: 2, value: 0
------------SQLVAR
----------------len: 2, value: 1
------------SQLDATA
----------------SQLSRV_GENERALIZED_DATE, len: 16
--------------------len: 16, value: 1997022416504328
------------SQLIND
----------------len: 2, value: 0
------------SQLVAR
----------------len: 2, value: 2
------------SQLDATA
----------------SQLSRV_GENERALIZED_NUMBER, len: 3
--------------------len: 3, value: 456
------------SQLIND
----------------len: 2, value: 0
------------END OF DATA

ROUTINE LEVEL LOG at 09:23:50 on 25-Feb-1997
----SELECT LIST SQLDA
--------SQLDA: SQLD 3
------------[0].SQLTYPE: SQLSRV_GENERALIZED_NUMBER, SQLIND: 0
----------------len: 3, value: 123
------------[1].SQLTYPE: SQLSRV_GENERALIZED_DATE, SQLIND: 0
----------------len: 16, value: 1997022416504328
------------[2].SQLTYPE: SQLSRV_GENERALIZED_NUMBER, SQLIND: 0
----------------len: 3, value: 456

ROUTINE LEVEL LOG at 09:23:50 on 25-Feb-1997
----FETCH ROW NUMBER
--------SQLSRV_GENERALIZED_NUMBER, len: 1
------------len: 1, value: 0
----STATUS
--------SQLSRV_GENERALIZED_NUMBER, len: 3
------------len: 3, value: 100
----SQLERRD[5]
--------SQLSRV_GENERALIZED_NUMBER, len: 1
------------len: 1, value: 0
--------END OF MESSAGE

ROUTINE LEVEL LOG at 09:23:50 on 25-Feb-1997
----SELECT LIST SQLDA
--------SQLDA: SQLD 3
------------[0].SQLTYPE: SQLSRV_GENERALIZED_NUMBER, SQLIND: 0
----------------len: 3, value: 123
------------[1].SQLTYPE: SQLSRV_GENERALIZED_DATE, SQLIND: 0
----------------len: 16, value: 1997022416504328
------------[2].SQLTYPE: SQLSRV_GENERALIZED_NUMBER, SQLIND: 0
----------------len: 3, value: 456

ROUTINE LEVEL LOG at 09:23:51 on 25-Feb-1997
----SQLSRV_CLOSE_CURSOR
--------CURSOR NAME
------------SQL_CUR181588

PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:23:51 on 25-Feb-1997
----PACKET LENGTH: 27

PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:23:51 on 25-Feb-1997
----PACKET ID: 16, PACKET SEQUENCE: 0
--------SQLSRV_CLOSE_CURSOR
------------CURSOR NAME
----------------SQLSRV_ASCII_STRING, len: 13
--------------------len: 13, value: SQL_CUR181588
--------END OF MESSAGE

PROTOCOL LEVEL LOG CLIENT: read at 09:23:51 on 25-Feb-1997
----PACKET LENGTH: 10

PROTOCOL LEVEL LOG CLIENT: read at 09:23:51 on 25-Feb-1997
----PACKET ID: 16, PACKET SEQUENCE: 0
--------SQLSRV_CLOSE_CURSOR ACK
--------END OF MESSAGE

ROUTINE LEVEL LOG at 09:23:51 on 25-Feb-1997
----SQLSRV_EXECUTE_IMMEDIATE
--------SQL STATEMENT
------------len: 6, value: COMMIT

PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:23:51 on 25-Feb-1997
----PACKET LENGTH: 20

PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:23:51 on 25-Feb-1997
----PACKET ID: 17, PACKET SEQUENCE: 0
--------SQLSRV_EXECUTE_IMMEDIATE
------------SQL STATEMENT
----------------SQLSRV_ASCII_STRING, len: 6
--------------------len: 6, value: COMMIT
--------END OF MESSAGE

PROTOCOL LEVEL LOG CLIENT: read at 09:23:51 on 25-Feb-1997
----PACKET LENGTH: 20

PROTOCOL LEVEL LOG CLIENT: read at 09:23:51 on 25-Feb-1997
----PACKET ID: 17, 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:23:51 on 25-Feb-1997
----SQLSRV_RELEASE_STATEMENT
--------STATEMENT ID
------------[0] 3827432

PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:23:51 on 25-Feb-1997
----PACKET LENGTH: 25

PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:23:51 on 25-Feb-1997
----PACKET ID: 18, PACKET SEQUENCE: 0
--------SQLSRV_RELEASE_STATEMENT
------------STATEMENT COUNT
----------------len: 2, value: 1
------------STATEMENT ID
----------------SQLSRV_GENERALIZED_NUMBER, len: 7
--------------------len: 7, value: 3827432
--------END OF MESSAGE

PROTOCOL LEVEL LOG CLIENT: read at 09:23:51 on 25-Feb-1997
----PACKET LENGTH: 19

PROTOCOL LEVEL LOG CLIENT: read at 09:23:51 on 25-Feb-1997
----PACKET ID: 18, 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:23:51 on 25-Feb-1997
----SQLSRV_FREE_SQLDA_DATA

ROUTINE LEVEL LOG at 09:23:56 on 25-Feb-1997
----SQLSRV_EXECUTE_IMMEDIATE
--------SQL STATEMENT
------------len: 57, value: DECLARE TRANSACTION READ ONLY WAIT 30 CONSISTENCY LE
------------VEL 2

PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:23:56 on 25-Feb-1997
----PACKET LENGTH: 71

PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:23:56 on 25-Feb-1997
----PACKET ID: 19, PACKET SEQUENCE: 0
--------SQLSRV_EXECUTE_IMMEDIATE
------------SQL STATEMENT
----------------SQLSRV_ASCII_STRING, len: 57
--------------------len: 57, value: DECLARE TRANSACTION READ ONLY WAIT 30 CONSIS
--------------------TENCY LEVEL 2
--------END OF MESSAGE

PROTOCOL LEVEL LOG CLIENT: read at 09:23:56 on 25-Feb-1997
----PACKET LENGTH: 20

PROTOCOL LEVEL LOG CLIENT: read at 09:23:56 on 25-Feb-1997
----PACKET ID: 19, 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:23:56 on 25-Feb-1997
----SQLSRV_PREPARE
--------SQL STATEMENT
------------len: 39, value: SELECT MYDATEANSI.MYID1 FROM MYDATEANSI

PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:23:56 on 25-Feb-1997
----PACKET LENGTH: 53

PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:23:56 on 25-Feb-1997
----PACKET ID: 20, PACKET SEQUENCE: 0
--------SQLSRV_PREPARE
------------SQL STATEMENT
----------------SQLSRV_ASCII_STRING, len: 39
--------------------len: 39, value: SELECT MYDATEANSI.MYID1 FROM MYDATEANSI
--------END OF MESSAGE

PROTOCOL LEVEL LOG CLIENT: read at 09:23:56 on 25-Feb-1997
----PACKET LENGTH: 51

PROTOCOL LEVEL LOG CLIENT: read at 09:23:56 on 25-Feb-1997
----PACKET ID: 20, PACKET SEQUENCE: 0
--------SQLSRV_PREPARE ACK
------------STATEMENT ID
----------------SQLSRV_GENERALIZED_NUMBER, len: 7
--------------------len: 7, value: 3827432
------------SQLERRD[1]
----------------SQLSRV_GENERALIZED_NUMBER, len: 1
--------------------len: 1, value: 1
------------SELECT LIST SQLDA
----------------len: 2, value: 1
------------SQLVAR
----------------len: 2, value: 0
------------SQLTYPE
----------------len: 2, value: 130
------------SQLLEN
----------------len: 2, value: 11
------------SQLNAME
----------------SQLSRV_ASCII_STRING, len: 5
--------------------len: 5, value: MYID1
--------END OF MESSAGE

ROUTINE LEVEL LOG at 09:23:56 on 25-Feb-1997
----SELECT LIST SQLDA
--------SQLDA: SQLD 1
--------[0].SQLTYPE: SQLSRV_GENERALIZED_NUMBER, SIZE 11, SCALE 0
------------SQLNAME: MYID1

ROUTINE LEVEL LOG at 09:23:56 on 25-Feb-1997
----SQLSRV_ALLOCATE_SQLDA_DATA

ROUTINE LEVEL LOG at 09:23:56 on 25-Feb-1997
----SQLSRV_OPEN_CURSOR
--------CURSOR NAME
------------SQL_CUR18D9F8
--------STATEMENT ID
------------3827432

PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:23:56 on 25-Feb-1997
----PACKET LENGTH: 42

PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:23:56 on 25-Feb-1997
----PACKET ID: 21, PACKET SEQUENCE: 0
--------SQLSRV_OPEN_CURSOR
------------CURSOR NAME
----------------SQLSRV_ASCII_STRING, len: 13
--------------------len: 13, value: SQL_CUR18D9F8
------------STATEMENT ID
----------------SQLSRV_GENERALIZED_NUMBER, len: 7
--------------------len: 7, value: 3827432
------------CURSOR MODE
----------------len: 2, value: 2
--------END OF MESSAGE

PROTOCOL LEVEL LOG CLIENT: read at 09:23:56 on 25-Feb-1997
----PACKET LENGTH: 30

PROTOCOL LEVEL LOG CLIENT: read at 09:23:56 on 25-Feb-1997
----PACKET ID: 21, 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: 1
------------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:23:56 on 25-Feb-1997
----SQLSRV_FETCH_MANY
--------CURSOR NAME
------------SQL_CUR18D9F8
--------REPEAT COUNT
------------5818

ROUTINE LEVEL LOG at 09:23:56 on 25-Feb-1997
----SQLSRV_FETCH
--------CURSOR NAME
------------SQL_CUR18D9F8

PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:23:56 on 25-Feb-1997
----PACKET LENGTH: 31

PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:23:56 on 25-Feb-1997
----PACKET ID: 22, PACKET SEQUENCE: 0
--------SQLSRV_FETCH
------------CURSOR NAME
----------------SQLSRV_ASCII_STRING, len: 13
--------------------len: 13, value: SQL_CUR18D9F8
------------REPEAT COUNT
----------------len: 2, value: 5818
--------END OF MESSAGE

PROTOCOL LEVEL LOG CLIENT: read at 09:23:56 on 25-Feb-1997
----PACKET LENGTH: 52

PROTOCOL LEVEL LOG CLIENT: read at 09:23:56 on 25-Feb-1997
----PACKET ID: 22, PACKET SEQUENCE: 0
--------SQLSRV_FETCH ACK
------------FETCH ROW NUMBER
----------------SQLSRV_GENERALIZED_NUMBER, len: 1
--------------------len: 1, value: 1
------------SELECT LIST DATA
----------------len: 2, value: 1
------------SQLVAR
----------------len: 2, value: 0
------------SQLDATA
----------------SQLSRV_GENERALIZED_NUMBER, len: 3
--------------------len: 3, value: 123
------------SQLIND
----------------len: 2, value: 0
------------END OF DATA

ROUTINE LEVEL LOG at 09:23:56 on 25-Feb-1997
----SELECT LIST SQLDA
--------SQLDA: SQLD 1
------------[0].SQLTYPE: SQLSRV_GENERALIZED_NUMBER, SQLIND: 0
----------------len: 3, value: 123

ROUTINE LEVEL LOG at 09:23:57 on 25-Feb-1997
----FETCH ROW NUMBER
--------SQLSRV_GENERALIZED_NUMBER, len: 1
------------len: 1, value: 0
----STATUS
--------SQLSRV_GENERALIZED_NUMBER, len: 3
------------len: 3, value: 100
----SQLERRD[5]
--------SQLSRV_GENERALIZED_NUMBER, len: 1
------------len: 1, value: 0
--------END OF MESSAGE

ROUTINE LEVEL LOG at 09:23:57 on 25-Feb-1997
----SELECT LIST SQLDA
--------SQLDA: SQLD 1
------------[0].SQLTYPE: SQLSRV_GENERALIZED_NUMBER, SQLIND: 0
----------------len: 3, value: 123

ROUTINE LEVEL LOG at 09:23:57 on 25-Feb-1997
----SQLSRV_CLOSE_CURSOR
--------CURSOR NAME
------------SQL_CUR18D9F8

PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:23:57 on 25-Feb-1997
----PACKET LENGTH: 27

PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:23:57 on 25-Feb-1997
----PACKET ID: 23, PACKET SEQUENCE: 0
--------SQLSRV_CLOSE_CURSOR
------------CURSOR NAME
----------------SQLSRV_ASCII_STRING, len: 13
--------------------len: 13, value: SQL_CUR18D9F8
--------END OF MESSAGE

PROTOCOL LEVEL LOG CLIENT: read at 09:23:57 on 25-Feb-1997
----PACKET LENGTH: 10

PROTOCOL LEVEL LOG CLIENT: read at 09:23:57 on 25-Feb-1997
----PACKET ID: 23, PACKET SEQUENCE: 0
--------SQLSRV_CLOSE_CURSOR ACK
--------END OF MESSAGE

ROUTINE LEVEL LOG at 09:23:57 on 25-Feb-1997
----SQLSRV_EXECUTE_IMMEDIATE
--------SQL STATEMENT
------------len: 6, value: COMMIT

PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:23:57 on 25-Feb-1997
----PACKET LENGTH: 20

PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:23:57 on 25-Feb-1997
----PACKET ID: 24, PACKET SEQUENCE: 0
--------SQLSRV_EXECUTE_IMMEDIATE
------------SQL STATEMENT
----------------SQLSRV_ASCII_STRING, len: 6
--------------------len: 6, value: COMMIT
--------END OF MESSAGE

PROTOCOL LEVEL LOG CLIENT: read at 09:23:57 on 25-Feb-1997
----PACKET LENGTH: 20

PROTOCOL LEVEL LOG CLIENT: read at 09:23:57 on 25-Feb-1997
----PACKET ID: 24, 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:23:57 on 25-Feb-1997
----SQLSRV_RELEASE_STATEMENT
--------STATEMENT ID
------------[0] 3827432

PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:23:57 on 25-Feb-1997
----PACKET LENGTH: 25

PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:23:57 on 25-Feb-1997
----PACKET ID: 25, PACKET SEQUENCE: 0
--------SQLSRV_RELEASE_STATEMENT
------------STATEMENT COUNT
----------------len: 2, value: 1
------------STATEMENT ID
----------------SQLSRV_GENERALIZED_NUMBER, len: 7
--------------------len: 7, value: 3827432
--------END OF MESSAGE

PROTOCOL LEVEL LOG CLIENT: read at 09:23:57 on 25-Feb-1997
----PACKET LENGTH: 19

PROTOCOL LEVEL LOG CLIENT: read at 09:23:57 on 25-Feb-1997
----PACKET ID: 25, 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:23:57 on 25-Feb-1997
----SQLSRV_FREE_SQLDA_DATA

ROUTINE LEVEL LOG at 09:23:57 on 25-Feb-1997
----SQLSRV_EXECUTE_IMMEDIATE
--------SQL STATEMENT
------------len: 58, value: DECLARE TRANSACTION READ WRITE WAIT 30 CONSISTENCY L
------------EVEL 2

PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:23:57 on 25-Feb-1997
----PACKET LENGTH: 72

PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:23:57 on 25-Feb-1997
----PACKET ID: 26, PACKET SEQUENCE: 0
--------SQLSRV_EXECUTE_IMMEDIATE
------------SQL STATEMENT
----------------SQLSRV_ASCII_STRING, len: 58
--------------------len: 58, value: DECLARE TRANSACTION READ WRITE WAIT 30 CONSI
--------------------STENCY LEVEL 2
--------END OF MESSAGE

PROTOCOL LEVEL LOG CLIENT: read at 09:23:57 on 25-Feb-1997
----PACKET LENGTH: 20

PROTOCOL LEVEL LOG CLIENT: read at 09:23:57 on 25-Feb-1997
----PACKET ID: 26, 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:23:58 on 25-Feb-1997
----SQLSRV_PREPARE
--------SQL STATEMENT
------------len: 46, value: SELECT MYID1,MYDATEANSI,MYID2  FROM MYDATEANSI

PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:23:58 on 25-Feb-1997
----PACKET LENGTH: 60

PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:23:58 on 25-Feb-1997
----PACKET ID: 27, PACKET SEQUENCE: 0
--------SQLSRV_PREPARE
------------SQL STATEMENT
----------------SQLSRV_ASCII_STRING, len: 46
--------------------len: 46, value: SELECT MYID1,MYDATEANSI,MYID2  FROM MYDATEAN
--------------------SI
--------END OF MESSAGE

PROTOCOL LEVEL LOG CLIENT: read at 09:23:58 on 25-Feb-1997
----PACKET LENGTH: 73

PROTOCOL LEVEL LOG CLIENT: read at 09:23:58 on 25-Feb-1997
----PACKET ID: 27, 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: 48
--------------------len: 48, value: %SQL-F-NOREPSQLDA, Cannot represent using SQ
--------------------LDA.
--------END OF MESSAGE

ROUTINE LEVEL LOG at 09:23:58 on 25-Feb-1997
----SQLSRV_PREPARE
--------SQL STATEMENT
------------len: 180, value: SELECT MYID1,MYDATEANSI,MYID2  FROM MYDATEANSI  WHE
------------RE MYID1 = ? OR MYID1 = ? OR MYID1 = ? OR MYID1 = ? OR MYID1 = ? OR 
------------MYID1 = ? OR MYID1 = ? OR MYID1 = ? OR MYID1 = ? OR MYID1 = ?

PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:23:58 on 25-Feb-1997
----PACKET LENGTH: 194

PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:23:58 on 25-Feb-1997
----PACKET ID: 28, PACKET SEQUENCE: 0
--------SQLSRV_PREPARE
------------SQL STATEMENT
----------------SQLSRV_ASCII_STRING, len: 180
--------------------len: 180, value: SELECT MYID1,MYDATEANSI,MYID2  FROM MYDATEA
--------------------NSI  WHERE MYID1 = ? OR MYID1 = ? OR MYID1 = ? OR MYID1 = ? 
--------------------OR MYID1 = ? OR MYID1 = ? OR MYID1 = ? OR MYID1 = ? OR MYID1
-------------------- = ? OR MYID1 = ?
--------END OF MESSAGE

PROTOCOL LEVEL LOG CLIENT: read at 09:23:59 on 25-Feb-1997
----PACKET LENGTH: 73

PROTOCOL LEVEL LOG CLIENT: read at 09:23:59 on 25-Feb-1997
----PACKET ID: 28, 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: 48
--------------------len: 48, value: %SQL-F-NOREPSQLDA, Cannot represent using SQ
--------------------LDA.
--------END OF MESSAGE

ROUTINE LEVEL LOG at 09:24:07 on 25-Feb-1997
----SQLSRV_EXECUTE_IMMEDIATE
--------SQL STATEMENT
------------len: 57, value: DECLARE TRANSACTION READ ONLY WAIT 30 CONSISTENCY LE
------------VEL 2

PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:24:07 on 25-Feb-1997
----PACKET LENGTH: 71

PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:24:07 on 25-Feb-1997
----PACKET ID: 29, PACKET SEQUENCE: 0
--------SQLSRV_EXECUTE_IMMEDIATE
------------SQL STATEMENT
----------------SQLSRV_ASCII_STRING, len: 57
--------------------len: 57, value: DECLARE TRANSACTION READ ONLY WAIT 30 CONSIS
--------------------TENCY LEVEL 2
--------END OF MESSAGE

PROTOCOL LEVEL LOG CLIENT: read at 09:24:07 on 25-Feb-1997
----PACKET LENGTH: 20

PROTOCOL LEVEL LOG CLIENT: read at 09:24:07 on 25-Feb-1997
----PACKET ID: 29, 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:24:07 on 25-Feb-1997
----SQLSRV_PREPARE
--------SQL STATEMENT
------------len: 31, value: SELECT MYTIME.MYID1 FROM MYTIME

PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:24:07 on 25-Feb-1997
----PACKET LENGTH: 45

PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:24:07 on 25-Feb-1997
----PACKET ID: 30, PACKET SEQUENCE: 0
--------SQLSRV_PREPARE
------------SQL STATEMENT
----------------SQLSRV_ASCII_STRING, len: 31
--------------------len: 31, value: SELECT MYTIME.MYID1 FROM MYTIME
--------END OF MESSAGE

PROTOCOL LEVEL LOG CLIENT: read at 09:24:07 on 25-Feb-1997
----PACKET LENGTH: 51

PROTOCOL LEVEL LOG CLIENT: read at 09:24:07 on 25-Feb-1997
----PACKET ID: 30, PACKET SEQUENCE: 0
--------SQLSRV_PREPARE ACK
------------STATEMENT ID
----------------SQLSRV_GENERALIZED_NUMBER, len: 7
--------------------len: 7, value: 3827432
------------SQLERRD[1]
----------------SQLSRV_GENERALIZED_NUMBER, len: 1
--------------------len: 1, value: 1
------------SELECT LIST SQLDA
----------------len: 2, value: 1
------------SQLVAR
----------------len: 2, value: 0
------------SQLTYPE
----------------len: 2, value: 130
------------SQLLEN
----------------len: 2, value: 11
------------SQLNAME
----------------SQLSRV_ASCII_STRING, len: 5
--------------------len: 5, value: MYID1
--------END OF MESSAGE

ROUTINE LEVEL LOG at 09:24:07 on 25-Feb-1997
----SELECT LIST SQLDA
--------SQLDA: SQLD 1
--------[0].SQLTYPE: SQLSRV_GENERALIZED_NUMBER, SIZE 11, SCALE 0
------------SQLNAME: MYID1

ROUTINE LEVEL LOG at 09:24:07 on 25-Feb-1997
----SQLSRV_ALLOCATE_SQLDA_DATA

ROUTINE LEVEL LOG at 09:24:07 on 25-Feb-1997
----SQLSRV_OPEN_CURSOR
--------CURSOR NAME
------------SQL_CUR18E120
--------STATEMENT ID
------------3827432

PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:24:07 on 25-Feb-1997
----PACKET LENGTH: 42

PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:24:07 on 25-Feb-1997
----PACKET ID: 31, PACKET SEQUENCE: 0
--------SQLSRV_OPEN_CURSOR
------------CURSOR NAME
----------------SQLSRV_ASCII_STRING, len: 13
--------------------len: 13, value: SQL_CUR18E120
------------STATEMENT ID
----------------SQLSRV_GENERALIZED_NUMBER, len: 7
--------------------len: 7, value: 3827432
------------CURSOR MODE
----------------len: 2, value: 2
--------END OF MESSAGE

PROTOCOL LEVEL LOG CLIENT: read at 09:24:07 on 25-Feb-1997
----PACKET LENGTH: 30

PROTOCOL LEVEL LOG CLIENT: read at 09:24:07 on 25-Feb-1997
----PACKET ID: 31, 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: 1
------------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:24:07 on 25-Feb-1997
----SQLSRV_FETCH_MANY
--------CURSOR NAME
------------SQL_CUR18E120
--------REPEAT COUNT
------------5818

ROUTINE LEVEL LOG at 09:24:07 on 25-Feb-1997
----SQLSRV_FETCH
--------CURSOR NAME
------------SQL_CUR18E120

PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:24:07 on 25-Feb-1997
----PACKET LENGTH: 31

PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:24:07 on 25-Feb-1997
----PACKET ID: 32, PACKET SEQUENCE: 0
--------SQLSRV_FETCH
------------CURSOR NAME
----------------SQLSRV_ASCII_STRING, len: 13
--------------------len: 13, value: SQL_CUR18E120
------------REPEAT COUNT
----------------len: 2, value: 5818
--------END OF MESSAGE

PROTOCOL LEVEL LOG CLIENT: read at 09:24:07 on 25-Feb-1997
----PACKET LENGTH: 52

PROTOCOL LEVEL LOG CLIENT: read at 09:24:07 on 25-Feb-1997
----PACKET ID: 32, PACKET SEQUENCE: 0
--------SQLSRV_FETCH ACK
------------FETCH ROW NUMBER
----------------SQLSRV_GENERALIZED_NUMBER, len: 1
--------------------len: 1, value: 1
------------SELECT LIST DATA
----------------len: 2, value: 1
------------SQLVAR
----------------len: 2, value: 0
------------SQLDATA
----------------SQLSRV_GENERALIZED_NUMBER, len: 3
--------------------len: 3, value: 123
------------SQLIND
----------------len: 2, value: 0
------------END OF DATA

ROUTINE LEVEL LOG at 09:24:07 on 25-Feb-1997
----SELECT LIST SQLDA
--------SQLDA: SQLD 1
------------[0].SQLTYPE: SQLSRV_GENERALIZED_NUMBER, SQLIND: 0
----------------len: 3, value: 123

ROUTINE LEVEL LOG at 09:24:07 on 25-Feb-1997
----FETCH ROW NUMBER
--------SQLSRV_GENERALIZED_NUMBER, len: 1
------------len: 1, value: 0
----STATUS
--------SQLSRV_GENERALIZED_NUMBER, len: 3
------------len: 3, value: 100
----SQLERRD[5]
--------SQLSRV_GENERALIZED_NUMBER, len: 1
------------len: 1, value: 0
--------END OF MESSAGE

ROUTINE LEVEL LOG at 09:24:07 on 25-Feb-1997
----SELECT LIST SQLDA
--------SQLDA: SQLD 1
------------[0].SQLTYPE: SQLSRV_GENERALIZED_NUMBER, SQLIND: 0
----------------len: 3, value: 123

ROUTINE LEVEL LOG at 09:24:08 on 25-Feb-1997
----SQLSRV_CLOSE_CURSOR
--------CURSOR NAME
------------SQL_CUR18E120

PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:24:08 on 25-Feb-1997
----PACKET LENGTH: 27

PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:24:08 on 25-Feb-1997
----PACKET ID: 33, PACKET SEQUENCE: 0
--------SQLSRV_CLOSE_CURSOR
------------CURSOR NAME
----------------SQLSRV_ASCII_STRING, len: 13
--------------------len: 13, value: SQL_CUR18E120
--------END OF MESSAGE

PROTOCOL LEVEL LOG CLIENT: read at 09:24:08 on 25-Feb-1997
----PACKET LENGTH: 10

PROTOCOL LEVEL LOG CLIENT: read at 09:24:08 on 25-Feb-1997
----PACKET ID: 33, PACKET SEQUENCE: 0
--------SQLSRV_CLOSE_CURSOR ACK
--------END OF MESSAGE

ROUTINE LEVEL LOG at 09:24:08 on 25-Feb-1997
----SQLSRV_EXECUTE_IMMEDIATE
--------SQL STATEMENT
------------len: 6, value: COMMIT

PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:24:08 on 25-Feb-1997
----PACKET LENGTH: 20

PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:24:08 on 25-Feb-1997
----PACKET ID: 34, PACKET SEQUENCE: 0
--------SQLSRV_EXECUTE_IMMEDIATE
------------SQL STATEMENT
----------------SQLSRV_ASCII_STRING, len: 6
--------------------len: 6, value: COMMIT
--------END OF MESSAGE

PROTOCOL LEVEL LOG CLIENT: read at 09:24:08 on 25-Feb-1997
----PACKET LENGTH: 20

PROTOCOL LEVEL LOG CLIENT: read at 09:24:08 on 25-Feb-1997
----PACKET ID: 34, 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:24:08 on 25-Feb-1997
----SQLSRV_RELEASE_STATEMENT
--------STATEMENT ID
------------[0] 3827432

PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:24:08 on 25-Feb-1997
----PACKET LENGTH: 25

PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:24:08 on 25-Feb-1997
----PACKET ID: 35, PACKET SEQUENCE: 0
--------SQLSRV_RELEASE_STATEMENT
------------STATEMENT COUNT
----------------len: 2, value: 1
------------STATEMENT ID
----------------SQLSRV_GENERALIZED_NUMBER, len: 7
--------------------len: 7, value: 3827432
--------END OF MESSAGE

PROTOCOL LEVEL LOG CLIENT: read at 09:24:08 on 25-Feb-1997
----PACKET LENGTH: 19

PROTOCOL LEVEL LOG CLIENT: read at 09:24:08 on 25-Feb-1997
----PACKET ID: 35, 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:24:08 on 25-Feb-1997
----SQLSRV_FREE_SQLDA_DATA

ROUTINE LEVEL LOG at 09:24:08 on 25-Feb-1997
----SQLSRV_EXECUTE_IMMEDIATE
--------SQL STATEMENT
------------len: 58, value: DECLARE TRANSACTION READ WRITE WAIT 30 CONSISTENCY L
------------EVEL 2

PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:24:08 on 25-Feb-1997
----PACKET LENGTH: 72

PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:24:08 on 25-Feb-1997
----PACKET ID: 36, PACKET SEQUENCE: 0
--------SQLSRV_EXECUTE_IMMEDIATE
------------SQL STATEMENT
----------------SQLSRV_ASCII_STRING, len: 58
--------------------len: 58, value: DECLARE TRANSACTION READ WRITE WAIT 30 CONSI
--------------------STENCY LEVEL 2
--------END OF MESSAGE

PROTOCOL LEVEL LOG CLIENT: read at 09:24:08 on 25-Feb-1997
----PACKET LENGTH: 20

PROTOCOL LEVEL LOG CLIENT: read at 09:24:08 on 25-Feb-1997
----PACKET ID: 36, 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:24:08 on 25-Feb-1997
----SQLSRV_PREPARE
--------SQL STATEMENT
------------len: 38, value: SELECT MYID1,MYTIME,MYID2  FROM MYTIME

PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:24:08 on 25-Feb-1997
----PACKET LENGTH: 52

PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:24:08 on 25-Feb-1997
----PACKET ID: 37, PACKET SEQUENCE: 0
--------SQLSRV_PREPARE
------------SQL STATEMENT
----------------SQLSRV_ASCII_STRING, len: 38
--------------------len: 38, value: SELECT MYID1,MYTIME,MYID2  FROM MYTIME
--------END OF MESSAGE

PROTOCOL LEVEL LOG CLIENT: read at 09:24:08 on 25-Feb-1997
----PACKET LENGTH: 73

PROTOCOL LEVEL LOG CLIENT: read at 09:24:08 on 25-Feb-1997
----PACKET ID: 37, 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: 48
--------------------len: 48, value: %SQL-F-NOREPSQLDA, Cannot represent using SQ
--------------------LDA.
--------END OF MESSAGE

ROUTINE LEVEL LOG at 09:24:09 on 25-Feb-1997
----SQLSRV_PREPARE
--------SQL STATEMENT
------------len: 172, value: SELECT MYID1,MYTIME,MYID2  FROM MYTIME  WHERE MYID1
------------ = ? OR MYID1 = ? OR MYID1 = ? OR MYID1 = ? OR MYID1 = ? OR MYID1 = 
------------? OR MYID1 = ? OR MYID1 = ? OR MYID1 = ? OR MYID1 = ?

PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:24:09 on 25-Feb-1997
----PACKET LENGTH: 186

PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:24:09 on 25-Feb-1997
----PACKET ID: 38, PACKET SEQUENCE: 0
--------SQLSRV_PREPARE
------------SQL STATEMENT
----------------SQLSRV_ASCII_STRING, len: 172
--------------------len: 172, value: SELECT MYID1,MYTIME,MYID2  FROM MYTIME  WHE
--------------------RE MYID1 = ? OR MYID1 = ? OR MYID1 = ? OR MYID1 = ? OR MYID1
-------------------- = ? OR MYID1 = ? OR MYID1 = ? OR MYID1 = ? OR MYID1 = ? OR 
--------------------MYID1 = ?
--------END OF MESSAGE

PROTOCOL LEVEL LOG CLIENT: read at 09:24:09 on 25-Feb-1997
----PACKET LENGTH: 73

PROTOCOL LEVEL LOG CLIENT: read at 09:24:09 on 25-Feb-1997
----PACKET ID: 38, 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: 48
--------------------len: 48, value: %SQL-F-NOREPSQLDA, Cannot represent using SQ
--------------------LDA.
--------END OF MESSAGE

ROUTINE LEVEL LOG at 09:24:16 on 25-Feb-1997
----SQLSRV_EXECUTE_IMMEDIATE
--------SQL STATEMENT
------------len: 57, value: DECLARE TRANSACTION READ ONLY WAIT 30 CONSISTENCY LE
------------VEL 2

PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:24:16 on 25-Feb-1997
----PACKET LENGTH: 71

PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:24:16 on 25-Feb-1997
----PACKET ID: 39, PACKET SEQUENCE: 0
--------SQLSRV_EXECUTE_IMMEDIATE
------------SQL STATEMENT
----------------SQLSRV_ASCII_STRING, len: 57
--------------------len: 57, value: DECLARE TRANSACTION READ ONLY WAIT 30 CONSIS
--------------------TENCY LEVEL 2
--------END OF MESSAGE

PROTOCOL LEVEL LOG CLIENT: read at 09:24:16 on 25-Feb-1997
----PACKET LENGTH: 20

PROTOCOL LEVEL LOG CLIENT: read at 09:24:16 on 25-Feb-1997
----PACKET ID: 39, 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:24:16 on 25-Feb-1997
----SQLSRV_PREPARE
--------SQL STATEMENT
------------len: 41, value: SELECT MYTIMESTAMP.MYID1 FROM MYTIMESTAMP

PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:24:16 on 25-Feb-1997
----PACKET LENGTH: 55

PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:24:16 on 25-Feb-1997
----PACKET ID: 40, PACKET SEQUENCE: 0
--------SQLSRV_PREPARE
------------SQL STATEMENT
----------------SQLSRV_ASCII_STRING, len: 41
--------------------len: 41, value: SELECT MYTIMESTAMP.MYID1 FROM MYTIMESTAMP
--------END OF MESSAGE

PROTOCOL LEVEL LOG CLIENT: read at 09:24:16 on 25-Feb-1997
----PACKET LENGTH: 51

PROTOCOL LEVEL LOG CLIENT: read at 09:24:16 on 25-Feb-1997
----PACKET ID: 40, PACKET SEQUENCE: 0
--------SQLSRV_PREPARE ACK
------------STATEMENT ID
----------------SQLSRV_GENERALIZED_NUMBER, len: 7
--------------------len: 7, value: 3827432
------------SQLERRD[1]
----------------SQLSRV_GENERALIZED_NUMBER, len: 1
--------------------len: 1, value: 1
------------SELECT LIST SQLDA
----------------len: 2, value: 1
------------SQLVAR
----------------len: 2, value: 0
------------SQLTYPE
----------------len: 2, value: 130
------------SQLLEN
----------------len: 2, value: 11
------------SQLNAME
----------------SQLSRV_ASCII_STRING, len: 5
--------------------len: 5, value: MYID1
--------END OF MESSAGE

ROUTINE LEVEL LOG at 09:24:16 on 25-Feb-1997
----SELECT LIST SQLDA
--------SQLDA: SQLD 1
--------[0].SQLTYPE: SQLSRV_GENERALIZED_NUMBER, SIZE 11, SCALE 0
------------SQLNAME: MYID1

ROUTINE LEVEL LOG at 09:24:16 on 25-Feb-1997
----SQLSRV_ALLOCATE_SQLDA_DATA

ROUTINE LEVEL LOG at 09:24:16 on 25-Feb-1997
----SQLSRV_OPEN_CURSOR
--------CURSOR NAME
------------SQL_CUR18E7D0
--------STATEMENT ID
------------3827432

PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:24:16 on 25-Feb-1997
----PACKET LENGTH: 42

PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:24:16 on 25-Feb-1997
----PACKET ID: 41, PACKET SEQUENCE: 0
--------SQLSRV_OPEN_CURSOR
------------CURSOR NAME
----------------SQLSRV_ASCII_STRING, len: 13
--------------------len: 13, value: SQL_CUR18E7D0
------------STATEMENT ID
----------------SQLSRV_GENERALIZED_NUMBER, len: 7
--------------------len: 7, value: 3827432
------------CURSOR MODE
----------------len: 2, value: 2
--------END OF MESSAGE

PROTOCOL LEVEL LOG CLIENT: read at 09:24:16 on 25-Feb-1997
----PACKET LENGTH: 30

PROTOCOL LEVEL LOG CLIENT: read at 09:24:16 on 25-Feb-1997
----PACKET ID: 41, 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: 1
------------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:24:16 on 25-Feb-1997
----SQLSRV_FETCH_MANY
--------CURSOR NAME
------------SQL_CUR18E7D0
--------REPEAT COUNT
------------5818

ROUTINE LEVEL LOG at 09:24:16 on 25-Feb-1997
----SQLSRV_FETCH
--------CURSOR NAME
------------SQL_CUR18E7D0

PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:24:16 on 25-Feb-1997
----PACKET LENGTH: 31

PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:24:16 on 25-Feb-1997
----PACKET ID: 42, PACKET SEQUENCE: 0
--------SQLSRV_FETCH
------------CURSOR NAME
----------------SQLSRV_ASCII_STRING, len: 13
--------------------len: 13, value: SQL_CUR18E7D0
------------REPEAT COUNT
----------------len: 2, value: 5818
--------END OF MESSAGE

PROTOCOL LEVEL LOG CLIENT: read at 09:24:16 on 25-Feb-1997
----PACKET LENGTH: 52

PROTOCOL LEVEL LOG CLIENT: read at 09:24:16 on 25-Feb-1997
----PACKET ID: 42, PACKET SEQUENCE: 0
--------SQLSRV_FETCH ACK
------------FETCH ROW NUMBER
----------------SQLSRV_GENERALIZED_NUMBER, len: 1
--------------------len: 1, value: 1
------------SELECT LIST DATA
----------------len: 2, value: 1
------------SQLVAR
----------------len: 2, value: 0
------------SQLDATA
----------------SQLSRV_GENERALIZED_NUMBER, len: 3
--------------------len: 3, value: 123
------------SQLIND
----------------len: 2, value: 0
------------END OF DATA

ROUTINE LEVEL LOG at 09:24:16 on 25-Feb-1997
----SELECT LIST SQLDA
--------SQLDA: SQLD 1
------------[0].SQLTYPE: SQLSRV_GENERALIZED_NUMBER, SQLIND: 0
----------------len: 3, value: 123

ROUTINE LEVEL LOG at 09:24:16 on 25-Feb-1997
----FETCH ROW NUMBER
--------SQLSRV_GENERALIZED_NUMBER, len: 1
------------len: 1, value: 0
----STATUS
--------SQLSRV_GENERALIZED_NUMBER, len: 3
------------len: 3, value: 100
----SQLERRD[5]
--------SQLSRV_GENERALIZED_NUMBER, len: 1
------------len: 1, value: 0
--------END OF MESSAGE

ROUTINE LEVEL LOG at 09:24:16 on 25-Feb-1997
----SELECT LIST SQLDA
--------SQLDA: SQLD 1
------------[0].SQLTYPE: SQLSRV_GENERALIZED_NUMBER, SQLIND: 0
----------------len: 3, value: 123

ROUTINE LEVEL LOG at 09:24:16 on 25-Feb-1997
----SQLSRV_CLOSE_CURSOR
--------CURSOR NAME
------------SQL_CUR18E7D0

PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:24:16 on 25-Feb-1997
----PACKET LENGTH: 27

PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:24:16 on 25-Feb-1997
----PACKET ID: 43, PACKET SEQUENCE: 0
--------SQLSRV_CLOSE_CURSOR
------------CURSOR NAME
----------------SQLSRV_ASCII_STRING, len: 13
--------------------len: 13, value: SQL_CUR18E7D0
--------END OF MESSAGE

PROTOCOL LEVEL LOG CLIENT: read at 09:24:16 on 25-Feb-1997
----PACKET LENGTH: 10

PROTOCOL LEVEL LOG CLIENT: read at 09:24:16 on 25-Feb-1997
----PACKET ID: 43, PACKET SEQUENCE: 0
--------SQLSRV_CLOSE_CURSOR ACK
--------END OF MESSAGE

ROUTINE LEVEL LOG at 09:24:17 on 25-Feb-1997
----SQLSRV_EXECUTE_IMMEDIATE
--------SQL STATEMENT
------------len: 6, value: COMMIT

PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:24:17 on 25-Feb-1997
----PACKET LENGTH: 20

PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:24:17 on 25-Feb-1997
----PACKET ID: 44, PACKET SEQUENCE: 0
--------SQLSRV_EXECUTE_IMMEDIATE
------------SQL STATEMENT
----------------SQLSRV_ASCII_STRING, len: 6
--------------------len: 6, value: COMMIT
--------END OF MESSAGE

PROTOCOL LEVEL LOG CLIENT: read at 09:24:17 on 25-Feb-1997
----PACKET LENGTH: 20

PROTOCOL LEVEL LOG CLIENT: read at 09:24:17 on 25-Feb-1997
----PACKET ID: 44, 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:24:17 on 25-Feb-1997
----SQLSRV_RELEASE_STATEMENT
--------STATEMENT ID
------------[0] 3827432

PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:24:17 on 25-Feb-1997
----PACKET LENGTH: 25

PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:24:17 on 25-Feb-1997
----PACKET ID: 45, PACKET SEQUENCE: 0
--------SQLSRV_RELEASE_STATEMENT
------------STATEMENT COUNT
----------------len: 2, value: 1
------------STATEMENT ID
----------------SQLSRV_GENERALIZED_NUMBER, len: 7
--------------------len: 7, value: 3827432
--------END OF MESSAGE

PROTOCOL LEVEL LOG CLIENT: read at 09:24:17 on 25-Feb-1997
----PACKET LENGTH: 19

PROTOCOL LEVEL LOG CLIENT: read at 09:24:17 on 25-Feb-1997
----PACKET ID: 45, 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:24:17 on 25-Feb-1997
----SQLSRV_FREE_SQLDA_DATA

ROUTINE LEVEL LOG at 09:24:17 on 25-Feb-1997
----SQLSRV_EXECUTE_IMMEDIATE
--------SQL STATEMENT
------------len: 58, value: DECLARE TRANSACTION READ WRITE WAIT 30 CONSISTENCY L
------------EVEL 2

PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:24:17 on 25-Feb-1997
----PACKET LENGTH: 72

PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:24:17 on 25-Feb-1997
----PACKET ID: 46, PACKET SEQUENCE: 0
--------SQLSRV_EXECUTE_IMMEDIATE
------------SQL STATEMENT
----------------SQLSRV_ASCII_STRING, len: 58
--------------------len: 58, value: DECLARE TRANSACTION READ WRITE WAIT 30 CONSI
--------------------STENCY LEVEL 2
--------END OF MESSAGE

PROTOCOL LEVEL LOG CLIENT: read at 09:24:17 on 25-Feb-1997
----PACKET LENGTH: 20

PROTOCOL LEVEL LOG CLIENT: read at 09:24:17 on 25-Feb-1997
----PACKET ID: 46, 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:24:17 on 25-Feb-1997
----SQLSRV_PREPARE
--------SQL STATEMENT
------------len: 48, value: SELECT MYID1,MYTIMESTAMP,MYID2  FROM MYTIMESTAMP

PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:24:17 on 25-Feb-1997
----PACKET LENGTH: 62

PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:24:17 on 25-Feb-1997
----PACKET ID: 47, PACKET SEQUENCE: 0
--------SQLSRV_PREPARE
------------SQL STATEMENT
----------------SQLSRV_ASCII_STRING, len: 48
--------------------len: 48, value: SELECT MYID1,MYTIMESTAMP,MYID2  FROM MYTIMES
--------------------TAMP
--------END OF MESSAGE

PROTOCOL LEVEL LOG CLIENT: read at 09:24:17 on 25-Feb-1997
----PACKET LENGTH: 73

PROTOCOL LEVEL LOG CLIENT: read at 09:24:17 on 25-Feb-1997
----PACKET ID: 47, 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: 48
--------------------len: 48, value: %SQL-F-NOREPSQLDA, Cannot represent using SQ
--------------------LDA.
--------END OF MESSAGE

ROUTINE LEVEL LOG at 09:24:18 on 25-Feb-1997
----SQLSRV_PREPARE
--------SQL STATEMENT
------------len: 182, value: SELECT MYID1,MYTIMESTAMP,MYID2  FROM MYTIMESTAMP  W
------------HERE MYID1 = ? OR MYID1 = ? OR MYID1 = ? OR MYID1 = ? OR MYID1 = ? O
------------R MYID1 = ? OR MYID1 = ? OR MYID1 = ? OR MYID1 = ? OR MYID1 = ?

PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:24:18 on 25-Feb-1997
----PACKET LENGTH: 196

PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:24:18 on 25-Feb-1997
----PACKET ID: 48, PACKET SEQUENCE: 0
--------SQLSRV_PREPARE
------------SQL STATEMENT
----------------SQLSRV_ASCII_STRING, len: 182
--------------------len: 182, value: SELECT MYID1,MYTIMESTAMP,MYID2  FROM MYTIME
--------------------STAMP  WHERE MYID1 = ? OR MYID1 = ? OR MYID1 = ? OR MYID1 = 
--------------------? OR MYID1 = ? OR MYID1 = ? OR MYID1 = ? OR MYID1 = ? OR MYI
--------------------D1 = ? OR MYID1 = ?
--------END OF MESSAGE

PROTOCOL LEVEL LOG CLIENT: read at 09:24:18 on 25-Feb-1997
----PACKET LENGTH: 73

PROTOCOL LEVEL LOG CLIENT: read at 09:24:18 on 25-Feb-1997
----PACKET ID: 48, 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: 48
--------------------len: 48, value: %SQL-F-NOREPSQLDA, Cannot represent using SQ
--------------------LDA.
--------END OF MESSAGE

PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:24:27 on 25-Feb-1997
----PACKET LENGTH: 14

PROTOCOL LEVEL LOG CLIENT: write (logonly) at 09:24:27 on 25-Feb-1997
----PACKET ID: 49, PACKET SEQUENCE: 0
--------SQLSRV_RELEASE
------------ASSOCIATE_ID
----------------len: 2, value: 0
--------END OF MESSAGE

PROTOCOL LEVEL LOG CLIENT: read at 09:24:27 on 25-Feb-1997
----PACKET LENGTH: 14

PROTOCOL LEVEL LOG CLIENT: read at 09:24:27 on 25-Feb-1997
----PACKET ID: 49, PACKET SEQUENCE: 0
--------SQLSRV_RELEASE ACK
------------ASSOCIATE_ID
----------------len: 2, value: 0
--------END OF MESSAGE

ASSOCIATE LEVEL LOG
----SQLSRV_RELEASE
--------SQLSRV_ASSOCIATE ID: 7cf15c8
    
    
    
Oracle ODBC 32 Bit Driver for Rdb Version         2.10.11.0.0
Oracle ODBC 32 Bit Driver for Rdb File Version    2.10.11.0.0

SQLAllocEnv                     0X0017EF00
SQLAllocConnect                 0X0017F700
SQLGetInfo                      0X0017F8A8
...._rcSQLGetInfo                   0X0000004D
SQLSetConnectOption             0X0017F8A8
....Option                          0X00000067
SQLDriverConnect                0X0017F8A8
...._rcSQLDriverConnect             0X0017F8A8
....DSN=mytest on CIMMOM;SVR=cimmom;CLS=generic;DATABASE=attach 'filename 
....user3$:[howard.rdb]mytest.rdb';XPT=2;CSO=1;DBA=W;DSO=0
...._rcSQLConnect                   0X0017F8A8
....0X0017F8A8: MSACCESS            0X00000000
....attach 'filename user3$:[howard.rdb]mytest.rdb'
...._sRdbAssociate                  0X00000000
....DSN=mytest on CIMMOM;UID=howard;PWD=********;SVR=cimmom;CLS=generic;DA
....TABASE=attach 'filename user3$:[howard.rdb]mytest.rdb';XPT=2;CSO=1;DBA
....=W;DSO=0;
SQLError                        0X00000000
SQLGetInfo                      0X0017F8A8
...._rcSQLGetInfo                   0X00000017
SQLGetInfo                      0X0017F8A8
...._rcSQLGetInfo                   0X00000018
SQLGetInfo                      0X0017F8A8
...._rcSQLGetInfo                   0X00000009
SQLGetInfo                      0X0017F8A8
...._rcSQLGetInfo                   0X00000006
SQLGetInfo                      0X0017F8A8
...._rcSQLGetInfo                   0X0000002E
SQLGetInfo                      0X0017F8A8
...._rcSQLGetInfo                   0X00000017
SQLGetInfo                      0X0017F8A8
...._rcSQLGetInfo                   0X00000018
SQLGetInfo                      0X0017F8A8
...._rcSQLGetInfo                   0X00000001
SQLSetConnectOption             0X0017F8A8
....Option                          0X00000065
...._rcResetTransaction             0X0017F8A8
SQLAllocStmt                    0X0017F8A8
SQLGetStmtOption                0X00181588
....Option                          0X00000000
SQLSetStmtOption                0X00181588
...._rcSQLSetStmtOption             0X00000000
SQLExecDirect                   0X00181588
...._rcSQLPrepare                   0X00181588
....0X00181588: SELECT Config, nValue FROM MSysConf
......SQL Error Code =              0X00001029
......Native Error Code=            0XFFFFFBEF
....%SQL-F-RELNOTDEF, Table MSYSCONF is not defined in database or schema
SQLError                        0X00000000
[Oracle][ODBC][Rdb]%SQL-F-RELNOTDEF, Table MSYSCONF is not defined in 
database or schema
SQLError                        0X00000000
SQLFreeStmt                     0X00181588
...._rcSQLFreeStmt                  0X00181588
...._StmtDestroy                    0X00181588
SQLAllocStmt                    0X0017F8A8
SQLGetStmtOption                0X00181588
....Option                          0X00000000
SQLSetStmtOption                0X00181588
...._rcSQLSetStmtOption             0X00000000
SQLExecDirect                   0X00181588
...._rcSQLPrepare                   0X00181588
....0X00181588: SELECT MYDATEVMS.MYID1 FROM MYDATEVMS 
...._rcSQLExecDirect                0X00181588
...._rcSQLExecute                   0X00181588
...._sOpenCursor                    0X00181588
SQLFetch                        0X00181588
...._rcSQLFetch                     0X00000000
SQLGetData                      0X00181588
...._rcSQLGetData                   0X00181588
....dbgetdata                       0X00000001
....uCnvConvert                     0X07CF1FA8
SQLFetch                        0X00181588
...._rcSQLFetch                     0X00000001
....0X00181588: Rows Fetched =      0X00000001
SQLFreeStmt                     0X00181588
...._rcSQLFreeStmt                  0X00181588
...._rcStmtClose                    0X00181588
Auto Commit                     0X00181588
SQLTransact                     0X0017F8A8
...._rcSQLTransact                  0X0017F8A8
....COMMIT                          0X07CF15C8
SQLFreeStmt                     0X00181588
...._rcSQLFreeStmt                  0X00181588
...._StmtDestroy                    0X00181588
SQLSetConnectOption             0X0017F8A8
....Option                          0X00000065
...._rcResetTransaction             0X0017F8A8
SQLAllocStmt                    0X0017F8A8
SQLGetStmtOption                0X00181588
....Option                          0X00000000
SQLSetStmtOption                0X00181588
...._rcSQLSetStmtOption             0X00000000
SQLGetStmtOption                0X00181588
....Option                          0X00000001
SQLSetStmtOption                0X00181588
...._rcSQLSetStmtOption             0X00000001
SQLExecDirect                   0X00181588
...._rcSQLPrepare                   0X00181588
....0X00181588: SELECT MYID1,MYDATEVMS,MYID2  FROM MYDATEVMS 
...._rcSQLExecDirect                0X00181588
...._rcSQLExecute                   0X00181588
...._sOpenCursor                    0X00181588
SQLFetch                        0X00181588
...._rcSQLFetch                     0X00000000
SQLGetData                      0X00181588
...._rcSQLGetData                   0X00181588
....dbgetdata                       0X00000001
....uCnvConvert                     0X07CF1F48
SQLGetData                      0X00181588
...._rcSQLGetData                   0X00181588
....dbgetdata                       0X00000002
....uCnvConvert                     0X07CF1F68
SQLGetData                      0X00181588
...._rcSQLGetData                   0X00181588
....dbgetdata                       0X00000003
....uCnvConvert                     0X07CF2058
SQLFetch                        0X00181588
...._rcSQLFetch                     0X00000001
....0X00181588: Rows Fetched =      0X00000001
SQLFreeStmt                     0X00181588
...._rcSQLFreeStmt                  0X00181588
...._rcStmtClose                    0X00181588
Auto Commit                     0X00181588
SQLTransact                     0X0017F8A8
...._rcSQLTransact                  0X0017F8A8
....COMMIT                          0X07CF15C8
SQLCancel                       0X00181588
SQLFreeStmt                     0X00181588
...._rcSQLFreeStmt                  0X00181588
...._rcStmtClose                    0X00181588
SQLFreeStmt                     0X00181588
...._rcSQLFreeStmt                  0X00181588
...._StmtDestroy                    0X00181588
SQLSetConnectOption             0X0017F8A8
....Option                          0X00000065
...._rcResetTransaction             0X0017F8A8
SQLAllocStmt                    0X0017F8A8
SQLGetStmtOption                0X0018D9F8
....Option                          0X00000000
SQLSetStmtOption                0X0018D9F8
...._rcSQLSetStmtOption             0X00000000
SQLExecDirect                   0X0018D9F8
...._rcSQLPrepare                   0X0018D9F8
....0X0018D9F8: SELECT MYDATEANSI.MYID1 FROM MYDATEANSI 
...._rcSQLExecDirect                0X0018D9F8
...._rcSQLExecute                   0X0018D9F8
...._sOpenCursor                    0X0018D9F8
SQLFetch                        0X0018D9F8
...._rcSQLFetch                     0X00000000
SQLGetData                      0X0018D9F8
...._rcSQLGetData                   0X0018D9F8
....dbgetdata                       0X00000001
....uCnvConvert                     0X07CF1FA8
SQLFetch                        0X0018D9F8
...._rcSQLFetch                     0X00000001
....0X0018D9F8: Rows Fetched =      0X00000001
SQLFreeStmt                     0X0018D9F8
...._rcSQLFreeStmt                  0X0018D9F8
...._rcStmtClose                    0X0018D9F8
Auto Commit                     0X0018D9F8
SQLTransact                     0X0017F8A8
...._rcSQLTransact                  0X0017F8A8
....COMMIT                          0X07CF15C8
SQLFreeStmt                     0X0018D9F8
...._rcSQLFreeStmt                  0X0018D9F8
...._StmtDestroy                    0X0018D9F8
SQLSetConnectOption             0X0017F8A8
....Option                          0X00000065
...._rcResetTransaction             0X0017F8A8
SQLAllocStmt                    0X0017F8A8
SQLGetStmtOption                0X0018D9F8
....Option                          0X00000000
SQLSetStmtOption                0X0018D9F8
...._rcSQLSetStmtOption             0X00000000
SQLGetStmtOption                0X0018D9F8
....Option                          0X00000001
SQLSetStmtOption                0X0018D9F8
...._rcSQLSetStmtOption             0X00000001
SQLExecDirect                   0X0018D9F8
...._rcSQLPrepare                   0X0018D9F8
....0X0018D9F8: SELECT MYID1,MYDATEANSI,MYID2  FROM MYDATEANSI 
......SQL Error Code =              0X00001000
......Native Error Code=            0XFFFFFFFF
....%SQL-F-NOREPSQLDA, Cannot represent using SQLDA.
SQLError                        0X00000000
[Oracle][ODBC][Rdb]%SQL-F-NOREPSQLDA, Cannot represent using SQLDA.
SQLError                        0X00000000
SQLCancel                       0X0018D9F8
SQLFreeStmt                     0X0018D9F8
...._rcSQLFreeStmt                  0X0018D9F8
...._rcStmtClose                    0X0018D9F8
SQLFreeStmt                     0X0018D9F8
...._rcSQLFreeStmt                  0X0018D9F8
...._StmtDestroy                    0X0018D9F8
SQLAllocStmt                    0X0017F8A8
SQLGetStmtOption                0X0018D9F8
....Option                          0X00000000
SQLSetStmtOption                0X0018D9F8
...._rcSQLSetStmtOption             0X00000000
SQLPrepare                      0X0018D9F8
...._rcSQLPrepare                   0X0018D9F8
....0X0018D9F8: SELECT MYID1,MYDATEANSI,MYID2  FROM MYDATEANSI  WHERE MYID
....1 = ? OR MYID1 = ? OR MYID1 = ? OR MYID1 = ? OR MYID1 = ? OR MYID1 = ?
.... OR MYID1 = ? OR MYID1 = ? OR MYID1 = ? OR MYID1 = ?
......SQL Error Code =              0X00001000
......Native Error Code=            0XFFFFFFFF
....%SQL-F-NOREPSQLDA, Cannot represent using SQLDA.
SQLError                        0X00000000
[Oracle][ODBC][Rdb]%SQL-F-NOREPSQLDA, Cannot represent using SQLDA.
SQLError                        0X00000000
SQLFreeStmt                     0X0018D9F8
...._rcSQLFreeStmt                  0X0018D9F8
...._StmtDestroy                    0X0018D9F8
SQLSetConnectOption             0X0017F8A8
....Option                          0X00000065
...._rcResetTransaction             0X0017F8A8
SQLAllocStmt                    0X0017F8A8
SQLGetStmtOption                0X0018E120
....Option                          0X00000000
SQLSetStmtOption                0X0018E120
...._rcSQLSetStmtOption             0X00000000
SQLExecDirect                   0X0018E120
...._rcSQLPrepare                   0X0018E120
....0X0018E120: SELECT MYTIME.MYID1 FROM MYTIME 
...._rcSQLExecDirect                0X0018E120
...._rcSQLExecute                   0X0018E120
...._sOpenCursor                    0X0018E120
SQLFetch                        0X0018E120
...._rcSQLFetch                     0X00000000
SQLGetData                      0X0018E120
...._rcSQLGetData                   0X0018E120
....dbgetdata                       0X00000001
....uCnvConvert                     0X07CF1FA8
SQLFetch                        0X0018E120
...._rcSQLFetch                     0X00000001
....0X0018E120: Rows Fetched =      0X00000001
SQLFreeStmt                     0X0018E120
...._rcSQLFreeStmt                  0X0018E120
...._rcStmtClose                    0X0018E120
Auto Commit                     0X0018E120
SQLTransact                     0X0017F8A8
...._rcSQLTransact                  0X0017F8A8
....COMMIT                          0X07CF15C8
SQLFreeStmt                     0X0018E120
...._rcSQLFreeStmt                  0X0018E120
...._StmtDestroy                    0X0018E120
SQLSetConnectOption             0X0017F8A8
....Option                          0X00000065
...._rcResetTransaction             0X0017F8A8
SQLAllocStmt                    0X0017F8A8
SQLGetStmtOption                0X0018E120
....Option                          0X00000000
SQLSetStmtOption                0X0018E120
...._rcSQLSetStmtOption             0X00000000
SQLGetStmtOption                0X0018E120
....Option                          0X00000001
SQLSetStmtOption                0X0018E120
...._rcSQLSetStmtOption             0X00000001
SQLExecDirect                   0X0018E120
...._rcSQLPrepare                   0X0018E120
....0X0018E120: SELECT MYID1,MYTIME,MYID2  FROM MYTIME 
......SQL Error Code =              0X00001000
......Native Error Code=            0XFFFFFFFF
....%SQL-F-NOREPSQLDA, Cannot represent using SQLDA.
SQLError                        0X00000000
[Oracle][ODBC][Rdb]%SQL-F-NOREPSQLDA, Cannot represent using SQLDA.
SQLError                        0X00000000
SQLCancel                       0X0018E120
SQLFreeStmt                     0X0018E120
...._rcSQLFreeStmt                  0X0018E120
...._rcStmtClose                    0X0018E120
SQLFreeStmt                     0X0018E120
...._rcSQLFreeStmt                  0X0018E120
...._StmtDestroy                    0X0018E120
SQLAllocStmt                    0X0017F8A8
SQLGetStmtOption                0X0018E120
....Option                          0X00000000
SQLSetStmtOption                0X0018E120
...._rcSQLSetStmtOption             0X00000000
SQLPrepare                      0X0018E120
...._rcSQLPrepare                   0X0018E120
....0X0018E120: SELECT MYID1,MYTIME,MYID2  FROM MYTIME  WHERE MYID1 = ? OR
.... MYID1 = ? OR MYID1 = ? OR MYID1 = ? OR MYID1 = ? OR MYID1 = ? OR MYID
....1 = ? OR MYID1 = ? OR MYID1 = ? OR MYID1 = ?
......SQL Error Code =              0X00001000
......Native Error Code=            0XFFFFFFFF
....%SQL-F-NOREPSQLDA, Cannot represent using SQLDA.
SQLError                        0X00000000
[Oracle][ODBC][Rdb]%SQL-F-NOREPSQLDA, Cannot represent using SQLDA.
SQLError                        0X00000000
SQLFreeStmt                     0X0018E120
...._rcSQLFreeStmt                  0X0018E120
...._StmtDestroy                    0X0018E120
SQLSetConnectOption             0X0017F8A8
....Option                          0X00000065
...._rcResetTransaction             0X0017F8A8
SQLAllocStmt                    0X0017F8A8
SQLGetStmtOption                0X0018E7D0
....Option                          0X00000000
SQLSetStmtOption                0X0018E7D0
...._rcSQLSetStmtOption             0X00000000
SQLExecDirect                   0X0018E7D0
...._rcSQLPrepare                   0X0018E7D0
....0X0018E7D0: SELECT MYTIMESTAMP.MYID1 FROM MYTIMESTAMP 
...._rcSQLExecDirect                0X0018E7D0
...._rcSQLExecute                   0X0018E7D0
...._sOpenCursor                    0X0018E7D0
SQLFetch                        0X0018E7D0
...._rcSQLFetch                     0X00000000
SQLGetData                      0X0018E7D0
...._rcSQLGetData                   0X0018E7D0
....dbgetdata                       0X00000001
....uCnvConvert                     0X07CF1FA8
SQLFetch                        0X0018E7D0
...._rcSQLFetch                     0X00000001
....0X0018E7D0: Rows Fetched =      0X00000001
SQLFreeStmt                     0X0018E7D0
...._rcSQLFreeStmt                  0X0018E7D0
...._rcStmtClose                    0X0018E7D0
Auto Commit                     0X0018E7D0
SQLTransact                     0X0017F8A8
...._rcSQLTransact                  0X0017F8A8
....COMMIT                          0X07CF15C8
SQLFreeStmt                     0X0018E7D0
...._rcSQLFreeStmt                  0X0018E7D0
...._StmtDestroy                    0X0018E7D0
SQLSetConnectOption             0X0017F8A8
....Option                          0X00000065
...._rcResetTransaction             0X0017F8A8
SQLAllocStmt                    0X0017F8A8
SQLGetStmtOption                0X0018E7D0
....Option                          0X00000000
SQLSetStmtOption                0X0018E7D0
...._rcSQLSetStmtOption             0X00000000
SQLGetStmtOption                0X0018E7D0
....Option                          0X00000001
SQLSetStmtOption                0X0018E7D0
...._rcSQLSetStmtOption             0X00000001
SQLExecDirect                   0X0018E7D0
...._rcSQLPrepare                   0X0018E7D0
....0X0018E7D0: SELECT MYID1,MYTIMESTAMP,MYID2  FROM MYTIMESTAMP 
......SQL Error Code =              0X00001000
......Native Error Code=            0XFFFFFFFF
....%SQL-F-NOREPSQLDA, Cannot represent using SQLDA.
SQLError                        0X00000000
[Oracle][ODBC][Rdb]%SQL-F-NOREPSQLDA, Cannot represent using SQLDA.
SQLError                        0X00000000
SQLCancel                       0X0018E7D0
SQLFreeStmt                     0X0018E7D0
...._rcSQLFreeStmt                  0X0018E7D0
...._rcStmtClose                    0X0018E7D0
SQLFreeStmt                     0X0018E7D0
...._rcSQLFreeStmt                  0X0018E7D0
...._StmtDestroy                    0X0018E7D0
SQLAllocStmt                    0X0017F8A8
SQLGetStmtOption                0X0018E7D0
....Option                          0X00000000
SQLSetStmtOption                0X0018E7D0
...._rcSQLSetStmtOption             0X00000000
SQLPrepare                      0X0018E7D0
...._rcSQLPrepare                   0X0018E7D0
....0X0018E7D0: SELECT MYID1,MYTIMESTAMP,MYID2  FROM MYTIMESTAMP  WHERE MY
....ID1 = ? OR MYID1 = ? OR MYID1 = ? OR MYID1 = ? OR MYID1 = ? OR MYID1 =
.... ? OR MYID1 = ? OR MYID1 = ? OR MYID1 = ? OR MYID1 = ?
......SQL Error Code =              0X00001000
......Native Error Code=            0XFFFFFFFF
....%SQL-F-NOREPSQLDA, Cannot represent using SQLDA.
SQLError                        0X00000000
[Oracle][ODBC][Rdb]%SQL-F-NOREPSQLDA, Cannot represent using SQLDA.
SQLError                        0X00000000
SQLFreeStmt                     0X0018E7D0
...._rcSQLFreeStmt                  0X0018E7D0
...._StmtDestroy                    0X0018E7D0
SQLDisconnect                   0X0017F8A8
...._rcSQLDisconnect                0X0017F8A8
SQLFreeConnect                  0X0017F8A8
SQLFreeEnv                      0X0017F700
5068.3upgrade sqlsrv...M5::JBALOGHTue Feb 25 1997 13:477
    >image file identification: "V6.0-1"
    
    This is your problem. To use SQLSRV/ODBC with Date Ansi, you need at
    least 6.1 SQLSRV and 2.0 or higher ODBC. You need to upgrade SQLSRV
    server to at least 6.1. I would suggest 6.1-02...
    
    John
5068.4TIMESTAMP got shiftedORAREP::AWECIM::HOWARDTue Feb 25 1997 16:5916
    
    I tried this on a system running SQLSRV V6.1-0 and had success with
    DATE ANSI and TIME.  
    
    But the table with TIMESTAMP shifted the characters in an odd manner:
    
    TIMESTAMP showed in interactive SQL as "1997-02-25 13:43:23.04" but
    MS-Access showed this as "2/25/97 1:34:32 AM"
    
    It's as if "13:43:23.04" got shifted to:
               " 1:34:32"
    
    Was this corrected in 6.1-02 or is this some other behaviour?
    
    Thanks again,
    John Howard
5068.5works for meM5::JBALOGHTue Feb 25 1997 17:198
    Using the date you specified, 
    
    >TIMESTAMP showed in interactive SQL as "1997-02-25 13:43:23.04" but
    
    Shows up in MS Access as 2/25/97 1:43.23 PM which is correct. Please
    upgrade SQLServices to 6.1-02 and apply the 6.1-A update to Rdb. 
    
    John
5068.6double check...thanksORAREP::AWECIM::HOWARDTue Feb 25 1997 18:3314
    John,
    
    I really aprreciate your help and speedy responses!
    
    Before I request the upgrade to production, I just need to double check 
    one thing:
    
    You said that in your environment, the original TIMESTAMP value of:
    	"1997-02-25 13:43:23.04" showed up in MS-Access as
    	"1:43:23 PM".   Are you certain it didn't show up as 
    	"1:34:32 AM" like it did in mine?
    
    Thanks again,
    John Howard
5068.7M5::JBALOGHTue Feb 25 1997 19:284
    Yup. At first glance I thought it was broke... until I noticed the
    PM... 
    
    john