Hello
CLI program -
char connect_time[] = "2003-08-05-01.24.00.00";
static SQLCHAR *stmt_val = (SQLCHAR *)
"values date(timestamp(?))";
(also tried as tatic SQLCHAR *stmt_val = (SQLCHAR *)
"values date(?)"; with the same result)
// Bind parameter
sqlret = SQLBindParameter(hstmt_val, 1,
SQL_PARAM_INPUT, SQL_C_CHAR, SQL_CHAR, 22, 0, connect_time,
strlen(connect_time), NULL);
// Execute
sqlret = SQLExecute(hstmt_val);
It's always return -
Error: SQLSTATE = 42610
Error: Native Error Code = -418
[IBM][CLI Driver][DB2/LINUX] SQL0418N A statement contains a use of a
parameter marker that is not valid. SQLSTATE=42610
And I could not get it working....
Any idea? May be, someone see what I did wrong ?
Thank you!
Gregory G. V.
---------------
Any opinions in this posting are my own and not those of my present
or previous employers.
According Isham Research's Devil's IT Dictionary mainframe is:
"an obsolete device still used by thousands of obsolete companies
serving billions of obsolete customers and making huge obsolete profits
for their obsolete shareholders.
And this year's run twice as fast as last year's."
-
::: When replying to the list, please use 'Reply-All' and make sure
::: a copy goes to the list ([EMAIL PROTECTED]).
*** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
*** For more information, check http://www.db2eug.uni.cc
