Skip to content

Instantly share code, notes, and snippets.

@serega

serega/success_unixodbc.log

Created February 14, 2018 18:51
Show Gist options
  • Save serega/6299177839618b7abe4ae6e8aac05061 to your computer and use it in GitHub Desktop.
Save serega/6299177839618b7abe4ae6e8aac05061 to your computer and use it in GitHub Desktop.
Download ZIP
Example of successful execution of SQL from turbodbc to SAP IQ
Raw
success_unixodbc.log
[ODBC][3235][1518634039.203705][__handles.c][460]
Exit:[SQL_SUCCESS]
Environment = 0x7fc6bc902e00
[ODBC][3235][1518634039.203863][SQLSetEnvAttr.c][189]
Entry:
Environment = 0x7fc6bc902e00
Attribute = SQL_ATTR_ODBC_VERSION
Value = 0x3
StrLen = 0
[ODBC][3235][1518634039.203943][SQLSetEnvAttr.c][381]
Exit:[SQL_SUCCESS]
[ODBC][3235][1518634039.204034][SQLAllocHandle.c][377]
Entry:
Handle Type = 2
Input Handle = 0x7fc6bc902e00
[ODBC][3235][1518634039.204103][SQLAllocHandle.c][493]
Exit:[SQL_SUCCESS]
Output Handle = 0x7fc6bc900c00
[ODBC][3235][1518634039.204187][SQLDriverConnect.c][748]
Entry:
Connection = 0x7fc6bc900c00
Window Hdl = 0x0
Str In = [dsn=SQLATestDSN][length = 15]
Str Out = 0x7fc6bc8c9800
Str Out Max = 1024
Str Out Ptr = 0x7ffee94168c8
Completion = 0
UNICODE Using encoding ASCII 'UTF-8' and UNICODE 'UCS-2-INTERNAL'
[ODBC][3235][1518634039.430953][SQLDriverConnect.c][1727]
Exit:[SQL_SUCCESS]
Connection Out [[DSN=SQLATestDSN][length = 15 (SQL_NTS)]]
[ODBC][3235][1518634039.431214][SQLGetFunctions.c][151]
Entry:
Connection = 0x7fc6bc900c00
Id = SQLDescribeParam
Supported = 0x7ffee94169ae
[ODBC][3235][1518634039.433226][SQLGetFunctions.c][209]
Exit:[SQL_SUCCESS]
Supported = 0x7ffee94169ae -> 1
[ODBC][3235][1518634039.433398][SQLSetConnectAttr.c][396]
Entry:
Connection = 0x7fc6bc900c00
Attribute = SQL_ATTR_AUTOCOMMIT
Value = 0x0
StrLen = 0
[ODBC][3235][1518634039.433544][SQLSetConnectAttr.c][859]
Exit:[SQL_SUCCESS]
[ODBC][3235][1518634051.124968][SQLAllocHandle.c][540]
Entry:
Handle Type = 3
Input Handle = 0x7fc6bc900c00
[ODBC][3235][1518634051.125173][SQLAllocHandle.c][1085]
Exit:[SQL_SUCCESS]
Output Handle = 0x7fc6bd4b6400
[ODBC][3235][1518634051.127047][SQLPrepare.c][196]
Entry:
Statement = 0x7fc6bd4b6400
SQL = [select * from autorouter.conversion_rate_alert_run_log][length = 54]
[ODBC][3235][1518634051.169844][SQLPrepare.c][377]
Exit:[SQL_SUCCESS]
[ODBC][3235][1518634051.170160][SQLNumParams.c][144]
Entry:
Statement = 0x7fc6bd4b6400
Param Count = 0x7ffee94168ee
[ODBC][3235][1518634051.172017][SQLNumParams.c][231]
Exit:[SQL_SUCCESS]
Count = 0x7ffee94168ee -> 0
[ODBC][3235][1518634051.172222][SQLSetStmtAttr.c][265]
Entry:
Statement = 0x7fc6bd4b6400
Attribute = SQL_ATTR_PARAMS_PROCESSED_PTR
Value = 0x7fc6bc653330
StrLen = -4
[ODBC][3235][1518634051.172365][SQLSetStmtAttr.c][928]
Exit:[SQL_SUCCESS]
[ODBC][3235][1518634051.172718][SQLExecute.c][187]
Entry:
Statement = 0x7fc6bd4b6400
[ODBC][3235][1518634051.212619][SQLExecute.c][357]
Exit:[SQL_SUCCESS]
[ODBC][3235][1518634051.212877][SQLNumResultCols.c][156]
Entry:
Statement = 0x7fc6bd4b6400
Column Count = 0x7ffee94168fe
[ODBC][3235][1518634051.213024][SQLNumResultCols.c][251]
Exit:[SQL_SUCCESS]
Count = 0x7ffee94168fe -> 6
[ODBC][3235][1518634051.213175][SQLNumResultCols.c][156]
Entry:
Statement = 0x7fc6bd4b6400
Column Count = 0x7ffee941679e
[ODBC][3235][1518634051.213311][SQLNumResultCols.c][251]
Exit:[SQL_SUCCESS]
Count = 0x7ffee941679e -> 6
[ODBC][3235][1518634051.213442][SQLNumResultCols.c][156]
Entry:
Statement = 0x7fc6bd4b6400
Column Count = 0x7ffee941679e
[ODBC][3235][1518634051.213573][SQLNumResultCols.c][251]
Exit:[SQL_SUCCESS]
Count = 0x7ffee941679e -> 6
[ODBC][3235][1518634051.213717][SQLDescribeCol.c][247]
Entry:
Statement = 0x7fc6bd4b6400
Column Number = 1
Column Name = 0x7fc6bc48cae0
Buffer Length = 256
Name Length = 0x7ffee9416720
Data Type = 0x7ffee9416706
Column Size = 0x7ffee94166f8
Decimal Digits = 0x7ffee94166f6
Nullable = 0x7ffee94166f4
[ODBC][3235][1518634051.213861][SQLDescribeCol.c][504]
Exit:[SQL_SUCCESS]
Column Name = [run_log_id]
Data Type = 0x7ffee9416706 -> 4
Column Size = 0x7ffee94166f8 -> 10
Decimal Digits = 0x7ffee94166f6 -> 0
Nullable = 0x7ffee94166f4 -> 0
[ODBC][3235][1518634051.214010][SQLDescribeCol.c][247]
Entry:
Statement = 0x7fc6bd4b6400
Column Number = 2
Column Name = 0x7fc6bc48cae0
Buffer Length = 256
Name Length = 0x7ffee9416720
Data Type = 0x7ffee9416706
Column Size = 0x7ffee94166f8
Decimal Digits = 0x7ffee94166f6
Nullable = 0x7ffee94166f4
[ODBC][3235][1518634051.214321][SQLDescribeCol.c][504]
Exit:[SQL_SUCCESS]
Column Name = [log_type]
Data Type = 0x7ffee9416706 -> 12
Column Size = 0x7ffee94166f8 -> 16
Decimal Digits = 0x7ffee94166f6 -> 0
Nullable = 0x7ffee94166f4 -> 0
[ODBC][3235][1518634051.214502][SQLDescribeCol.c][247]
Entry:
Statement = 0x7fc6bd4b6400
Column Number = 3
Column Name = 0x7fc6beb6b070
Buffer Length = 256
Name Length = 0x7ffee9416720
Data Type = 0x7ffee9416706
Column Size = 0x7ffee94166f8
Decimal Digits = 0x7ffee94166f6
Nullable = 0x7ffee94166f4
[ODBC][3235][1518634051.214660][SQLDescribeCol.c][504]
Exit:[SQL_SUCCESS]
Column Name = [run_log_start_id]
Data Type = 0x7ffee9416706 -> 4
Column Size = 0x7ffee94166f8 -> 10
Decimal Digits = 0x7ffee94166f6 -> 0
Nullable = 0x7ffee94166f4 -> 1
[ODBC][3235][1518634051.214815][SQLDescribeCol.c][247]
Entry:
Statement = 0x7fc6bd4b6400
Column Number = 4
Column Name = 0x7fc6beb6b070
Buffer Length = 256
Name Length = 0x7ffee9416720
Data Type = 0x7ffee9416706
Column Size = 0x7ffee94166f8
Decimal Digits = 0x7ffee94166f6
Nullable = 0x7ffee94166f4
[ODBC][3235][1518634051.214966][SQLDescribeCol.c][504]
Exit:[SQL_SUCCESS]
Column Name = [status]
Data Type = 0x7ffee9416706 -> -6
Column Size = 0x7ffee94166f8 -> 3
Decimal Digits = 0x7ffee94166f6 -> 0
Nullable = 0x7ffee94166f4 -> 1
[ODBC][3235][1518634051.215116][SQLDescribeCol.c][247]
Entry:
Statement = 0x7fc6bd4b6400
Column Number = 5
Column Name = 0x7fc6beb6b070
Buffer Length = 256
Name Length = 0x7ffee9416720
Data Type = 0x7ffee9416706
Column Size = 0x7ffee94166f8
Decimal Digits = 0x7ffee94166f6
Nullable = 0x7ffee94166f4
[ODBC][3235][1518634051.215264][SQLDescribeCol.c][504]
Exit:[SQL_SUCCESS]
Column Name = [error_detail]
Data Type = 0x7ffee9416706 -> 12
Column Size = 0x7ffee94166f8 -> 1024
Decimal Digits = 0x7ffee94166f6 -> 0
Nullable = 0x7ffee94166f4 -> 1
[ODBC][3235][1518634051.215412][SQLDescribeCol.c][247]
Entry:
Statement = 0x7fc6bd4b6400
Column Number = 6
Column Name = 0x7fc6beb6b070
Buffer Length = 256
Name Length = 0x7ffee9416720
Data Type = 0x7ffee9416706
Column Size = 0x7ffee94166f8
Decimal Digits = 0x7ffee94166f6
Nullable = 0x7ffee94166f4
[ODBC][3235][1518634051.215559][SQLDescribeCol.c][504]
Exit:[SQL_SUCCESS]
Column Name = [insert_date]
Data Type = 0x7ffee9416706 -> 93
Column Size = 0x7ffee94166f8 -> 6
Decimal Digits = 0x7ffee94166f6 -> 6
Nullable = 0x7ffee94166f4 -> 0
[ODBC][3235][1518634051.215708][SQLDescribeCol.c][247]
Entry:
Statement = 0x7fc6bd4b6400
Column Number = 1
Column Name = 0x7fc6beb6b070
Buffer Length = 256
Name Length = 0x7ffee9416720
Data Type = 0x7ffee9416706
Column Size = 0x7ffee94166f8
Decimal Digits = 0x7ffee94166f6
Nullable = 0x7ffee94166f4
[ODBC][3235][1518634051.215853][SQLDescribeCol.c][504]
Exit:[SQL_SUCCESS]
Column Name = [run_log_id]
Data Type = 0x7ffee9416706 -> 4
Column Size = 0x7ffee94166f8 -> 10
Decimal Digits = 0x7ffee94166f6 -> 0
Nullable = 0x7ffee94166f4 -> 0
[ODBC][3235][1518634051.216608][SQLDescribeCol.c][247]
Entry:
Statement = 0x7fc6bd4b6400
Column Number = 2
Column Name = 0x7fc6beb6b070
Buffer Length = 256
Name Length = 0x7ffee9416720
Data Type = 0x7ffee9416706
Column Size = 0x7ffee94166f8
Decimal Digits = 0x7ffee94166f6
Nullable = 0x7ffee94166f4
[ODBC][3235][1518634051.216884][SQLDescribeCol.c][504]
Exit:[SQL_SUCCESS]
Column Name = [log_type]
Data Type = 0x7ffee9416706 -> 12
Column Size = 0x7ffee94166f8 -> 16
Decimal Digits = 0x7ffee94166f6 -> 0
Nullable = 0x7ffee94166f4 -> 0
[ODBC][3235][1518634051.217915][SQLDescribeCol.c][247]
Entry:
Statement = 0x7fc6bd4b6400
Column Number = 3
Column Name = 0x7fc6beb6b070
Buffer Length = 256
Name Length = 0x7ffee9416720
Data Type = 0x7ffee9416706
Column Size = 0x7ffee94166f8
Decimal Digits = 0x7ffee94166f6
Nullable = 0x7ffee94166f4
[ODBC][3235][1518634051.218009][SQLDescribeCol.c][504]
Exit:[SQL_SUCCESS]
Column Name = [run_log_start_id]
Data Type = 0x7ffee9416706 -> 4
Column Size = 0x7ffee94166f8 -> 10
Decimal Digits = 0x7ffee94166f6 -> 0
Nullable = 0x7ffee94166f4 -> 1
[ODBC][3235][1518634051.218678][SQLDescribeCol.c][247]
Entry:
Statement = 0x7fc6bd4b6400
Column Number = 4
Column Name = 0x7fc6beb6b070
Buffer Length = 256
Name Length = 0x7ffee9416720
Data Type = 0x7ffee9416706
Column Size = 0x7ffee94166f8
Decimal Digits = 0x7ffee94166f6
Nullable = 0x7ffee94166f4
[ODBC][3235][1518634051.218773][SQLDescribeCol.c][504]
Exit:[SQL_SUCCESS]
Column Name = [status]
Data Type = 0x7ffee9416706 -> -6
Column Size = 0x7ffee94166f8 -> 3
Decimal Digits = 0x7ffee94166f6 -> 0
Nullable = 0x7ffee94166f4 -> 1
[ODBC][3235][1518634051.219477][SQLDescribeCol.c][247]
Entry:
Statement = 0x7fc6bd4b6400
Column Number = 5
Column Name = 0x7fc6beb6b070
Buffer Length = 256
Name Length = 0x7ffee9416720
Data Type = 0x7ffee9416706
Column Size = 0x7ffee94166f8
Decimal Digits = 0x7ffee94166f6
Nullable = 0x7ffee94166f4
[ODBC][3235][1518634051.219575][SQLDescribeCol.c][504]
Exit:[SQL_SUCCESS]
Column Name = [error_detail]
Data Type = 0x7ffee9416706 -> 12
Column Size = 0x7ffee94166f8 -> 1024
Decimal Digits = 0x7ffee94166f6 -> 0
Nullable = 0x7ffee94166f4 -> 1
[ODBC][3235][1518634051.264690][SQLDescribeCol.c][247]
Entry:
Statement = 0x7fc6bd4b6400
Column Number = 6
Column Name = 0x7fc6bc48cae0
Buffer Length = 256
Name Length = 0x7ffee9416720
Data Type = 0x7ffee9416706
Column Size = 0x7ffee94166f8
Decimal Digits = 0x7ffee94166f6
Nullable = 0x7ffee94166f4
[ODBC][3235][1518634051.264857][SQLDescribeCol.c][504]
Exit:[SQL_SUCCESS]
Column Name = [insert_date]
Data Type = 0x7ffee9416706 -> 93
Column Size = 0x7ffee94166f8 -> 6
Decimal Digits = 0x7ffee94166f6 -> 6
Nullable = 0x7ffee94166f4 -> 0
[ODBC][3235][1518634051.268819][SQLSetStmtAttr.c][265]
Entry:
Statement = 0x7fc6bd4b6400
Attribute = SQL_ATTR_ROW_ARRAY_SIZE
Value = 0x4bb6
StrLen = -6
[ODBC][3235][1518634051.269012][SQLSetStmtAttr.c][928]
Exit:[SQL_SUCCESS]
[ODBC][3235][1518634051.269116][SQLBindCol.c][236]
Entry:
Statement = 0x7fc6bd4b6400
Column Number = 1
Target Type = -25 SQL_C_SBIGINT
Target Value = 0x108fff000
Buffer Length = 8
StrLen Or Ind = 0x108fcd000
[ODBC][3235][1518634051.269211][SQLBindCol.c][344]
Exit:[SQL_SUCCESS]
[ODBC][3235][1518634051.269316][SQLBindCol.c][236]
Entry:
Statement = 0x7fc6bd4b6400
Column Number = 2
Target Type = 1 SQL_CHAR
Target Value = 0x107984000
Buffer Length = 17
StrLen Or Ind = 0x1091f1000
[ODBC][3235][1518634051.269406][SQLBindCol.c][344]
Exit:[SQL_SUCCESS]
[ODBC][3235][1518634051.269494][SQLBindCol.c][236]
Entry:
Statement = 0x7fc6bd4b6400
Column Number = 3
Target Type = -25 SQL_C_SBIGINT
Target Value = 0x10a23e000
Buffer Length = 8
StrLen Or Ind = 0x10a264000
[ODBC][3235][1518634051.269768][SQLBindCol.c][344]
Exit:[SQL_SUCCESS]
[ODBC][3235][1518634051.269854][SQLBindCol.c][236]
Entry:
Statement = 0x7fc6bd4b6400
Column Number = 4
Target Type = -25 SQL_C_SBIGINT
Target Value = 0x10a28a000
Buffer Length = 8
StrLen Or Ind = 0x10a2b0000
[ODBC][3235][1518634051.269938][SQLBindCol.c][344]
Exit:[SQL_SUCCESS]
[ODBC][3235][1518634051.270023][SQLBindCol.c][236]
Entry:
Statement = 0x7fc6bd4b6400
Column Number = 5
Target Type = 1 SQL_CHAR
Target Value = 0x10a2d6000
Buffer Length = 1025
StrLen Or Ind = 0x10b5c9000
[ODBC][3235][1518634051.270107][SQLBindCol.c][344]
Exit:[SQL_SUCCESS]
[ODBC][3235][1518634051.270190][SQLBindCol.c][236]
Entry:
Statement = 0x7fc6bd4b6400
Column Number = 6
Target Type = 93 SQL_TYPE_TIMESTAMP
Target Value = 0x10b5ef000
Buffer Length = 16
StrLen Or Ind = 0x10b63b000
[ODBC][3235][1518634051.270287][SQLBindCol.c][344]
Exit:[SQL_SUCCESS]
[ODBC][3235][1518634051.270425][SQLSetStmtAttr.c][265]
Entry:
Statement = 0x7fc6bd4b6400
Attribute = SQL_ATTR_ROWS_FETCHED_PTR
Value = 0x7fc6bc423288
StrLen = -4
[ODBC][3235][1518634051.270509][SQLSetStmtAttr.c][928]
Exit:[SQL_SUCCESS]
[ODBC][3235][1518634051.270623][SQLNumResultCols.c][156]
Entry:
Statement = 0x7fc6bd4b6400
Column Count = 0x7ffee941696e
[ODBC][3235][1518634051.270710][SQLNumResultCols.c][251]
Exit:[SQL_SUCCESS]
Count = 0x7ffee941696e -> 6
[ODBC][3235][1518634051.270802][SQLRowCount.c][173]
Entry:
Statement = 0x7fc6bd4b6400
Row Count = 0x7ffee9416988
[ODBC][3235][1518634051.270892][SQLRowCount.c][247]
Exit:[SQL_SUCCESS]
Row Count = 0x7ffee9416988 -> -100
[ODBC][3235][1518634063.648416][SQLFreeHandle.c][387]
Entry:
Handle Type = 3
Input Handle = 0x7fc6bd4b6400
[ODBC][3235][1518634063.686884][SQLFreeHandle.c][490]
Exit:[SQL_SUCCESS]
[ODBC][3235][1518634063.687195][SQLEndTran.c][417]
Entry:
Connection = 0x7fc6bc900c00
Completion Type = 1
[ODBC][3235][1518634063.730930][SQLGetInfo.c][236]
Entry:
Connection = 0x7fc6bc900c00
Info Type = SQL_CURSOR_COMMIT_BEHAVIOR (23)
Info Value = 0x7fc6bc902088
Buffer Length = 2
StrLen = 0x7ffee9417090
[ODBC][3235][1518634063.731172][SQLGetInfo.c][236]
Entry:
Connection = 0x7fc6bc900c00
Info Type = SQL_CURSOR_ROLLBACK_BEHAVIOR (24)
Info Value = 0x7fc6bc90208a
Buffer Length = 2
StrLen = 0x7ffee9417090
[ODBC][3235][1518634063.733142][SQLEndTran.c][566]
Exit:[SQL_SUCCESS]
[ODBC][3235][1518634063.733320][SQLDisconnect.c][208]
Entry:
Connection = 0x7fc6bc900c00
[ODBC][3235][1518634063.889399][SQLDisconnect.c][379]
Exit:[SQL_SUCCESS]
[ODBC][3235][1518634063.889628][SQLFreeHandle.c][290]
Entry:
Handle Type = 2
Input Handle = 0x7fc6bc900c00
[ODBC][3235][1518634063.891588][SQLFreeHandle.c][339]
Exit:[SQL_SUCCESS]
[ODBC][3235][1518634063.891764][SQLFreeHandle.c][220]
Entry:
Handle Type = 1
Input Handle = 0x7fc6bc902e00
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment