Monty,
Here is my trace file (only has DM logging... see previous post).
This was generated from the use of unixODBC-DataManager. I basically
drilled down to Tables and then Columns and then Special Columns. I
ended up with two Special columns called 2.
I have not looked further inot it yet.
Peter Harvey
BTW: The table was something like this...
create table tbTest ( vcFirstName varchar(100), vcLastName varchar(100)
)
...no indexs etc
[ODBC][14059][SQLConnect.c][1092]
Exit:[SQL_SUCCESS]
[ODBC][14059][SQLAllocHandle.c][232]
Entry:
Handle Type = 3
Input Handle = 0x80888b8
[ODBC][14059][SQLAllocHandle.c][556]
Exit:[SQL_SUCCESS]
Output Handle = 0x8096138
[ODBC][14059][SQLTables.c][78]
Entry:
Statement = 0x8096138
Catalog Name = [NULL]
Schema Name = [NULL]
Table Name = [NULL]
Table Type = [NULL]
[ODBC][14059][SQLTables.c][224]
Exit:[SQL_SUCCESS]
[ODBC][14059][SQLBindCol.c][76]
Entry:
Statement = 0x8096138
Column Number = 3
Target Type = 1 SQL_CHAR
Target Value = 0xbffff5e0
Buffer Length = 101
StrLen Or Ind = 0xbffff5c8
[ODBC][14059][SQLBindCol.c][157]
Exit:[SQL_SUCCESS]
[ODBC][14059][SQLFetch.c][67]
Entry:
Statement = 0x8096138
[ODBC][14059][SQLFetch.c][200]
Exit:[SQL_SUCCESS]
[ODBC][14059][SQLFetch.c][67]
Entry:
Statement = 0x8096138
[ODBC][14059][SQLFetch.c][200]
Exit:[SQL_NO_DATA]
[ODBC][14059][SQLFreeStmt.c][62]
Entry:
Statement = 0x8096138
Option = 1
[ODBC][14059][SQLFreeHandle.c][197]
Entry:
Handle Type = 3
Input Handle = 0x8096138
[ODBC][14059][SQLFreeHandle.c][280]
Exit:[SQL_SUCCESS]
[ODBC][14059][SQLAllocHandle.c][232]
Entry:
Handle Type = 3
Input Handle = 0x80888b8
[ODBC][14059][SQLAllocHandle.c][556]
Exit:[SQL_SUCCESS]
Output Handle = 0x8096138
[ODBC][14059][SQLColumns.c][78]
Entry:
Statement = 0x8096138
Catalog Name = [NULL]
Schema Name = [NULL]
Table Name = [tbTest][length = 6 (SQL_NTS)]
Column Type = [NULL]
[ODBC][14059][SQLColumns.c][202]
Exit:[SQL_SUCCESS]
[ODBC][14059][SQLFetch.c][67]
Entry:
Statement = 0x8096138
[ODBC][14059][SQLFetch.c][200]
Exit:[SQL_SUCCESS]
[ODBC][14059][SQLGetData.c][77]
Entry:
Statement = 0x8096138
Column Number = 4
Target Type = 1 SQL_CHAR
Buffer Length = 101
StrLen Or Ind = (nil)
[ODBC][14059][SQLGetData.c][237]
Exit:[SQL_SUCCESS]
Buffer = [vcFirstName]
Strlen Or Ind = NULLPTR
[ODBC][14059][SQLFetch.c][67]
Entry:
Statement = 0x8096138
[ODBC][14059][SQLFetch.c][200]
Exit:[SQL_SUCCESS]
[ODBC][14059][SQLGetData.c][77]
Entry:
Statement = 0x8096138
Column Number = 4
Target Type = 1 SQL_CHAR
Buffer Length = 101
StrLen Or Ind = (nil)
[ODBC][14059][SQLGetData.c][237]
Exit:[SQL_SUCCESS]
Buffer = [vcLastName]
Strlen Or Ind = NULLPTR
[ODBC][14059][SQLFetch.c][67]
Entry:
Statement = 0x8096138
[ODBC][14059][SQLFetch.c][200]
Exit:[SQL_NO_DATA]
[ODBC][14059][SQLFreeStmt.c][62]
Entry:
Statement = 0x8096138
Option = 1
[ODBC][14059][SQLFreeHandle.c][197]
Entry:
Handle Type = 3
Input Handle = 0x8096138
[ODBC][14059][SQLFreeHandle.c][280]
Exit:[SQL_SUCCESS]
[ODBC][14059][SQLAllocHandle.c][232]
Entry:
Handle Type = 3
Input Handle = 0x80888b8
[ODBC][14059][SQLAllocHandle.c][556]
Exit:[SQL_SUCCESS]
Output Handle = 0x8096138
[ODBC][14059][SQLSpecialColumns.c][79]
Entry:
Statement = 0x8096138
Catalog Name = [NULL]
Schema Name = [NULL]
Table Name = [tbTest][length = 6 (SQL_NTS)]
Scope = 2
Nullable = 1
[ODBC][14059][SQLSpecialColumns.c][263]
Exit:[SQL_SUCCESS]
[ODBC][14059][SQLFetch.c][67]
Entry:
Statement = 0x8096138
[ODBC][14059][SQLFetch.c][200]
Exit:[SQL_SUCCESS]
[ODBC][14059][SQLGetData.c][77]
Entry:
Statement = 0x8096138
Column Number = 1
Target Type = 1 SQL_CHAR
Buffer Length = 101
StrLen Or Ind = (nil)
[ODBC][14059][SQLGetData.c][237]
Exit:[SQL_SUCCESS]
Buffer = [2]
Strlen Or Ind = NULLPTR
[ODBC][14059][SQLFetch.c][67]
Entry:
Statement = 0x8096138
[ODBC][14059][SQLFetch.c][200]
Exit:[SQL_SUCCESS]
[ODBC][14059][SQLGetData.c][77]
Entry:
Statement = 0x8096138
Column Number = 1
Target Type = 1 SQL_CHAR
Buffer Length = 101
StrLen Or Ind = (nil)
[ODBC][14059][SQLGetData.c][237]
Exit:[SQL_SUCCESS]
Buffer = [2]
Strlen Or Ind = NULLPTR
[ODBC][14059][SQLFetch.c][67]
Entry:
Statement = 0x8096138
[ODBC][14059][SQLFetch.c][200]
Exit:[SQL_NO_DATA]
[ODBC][14059][SQLFreeStmt.c][62]
Entry:
Statement = 0x8096138
Option = 1
[ODBC][14059][SQLFreeHandle.c][197]
Entry:
Handle Type = 3
Input Handle = 0x8096138
[ODBC][14059][SQLFreeHandle.c][280]
Exit:[SQL_SUCCESS]
