fixed by adding cast() Thank you all for wasting your time On 4:09pm, Gregory G. V. wrote:
> 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 ? > 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
