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

Может, кто что знает/видел ? Спасбо

I have Prepare.
Actually, it is an example only, what I want is to use date() and timestamp() in WHERE statement in CLI programm.

Like -
ELECT start_date from table where date(?) > start_date
jr something like this.
So - I did a SELECT and got a timestamp into a variable, let call it connect_time.
SO I whant to bind connect_time to the SELECT

Trying VALUES INTO , thanks.
Actually I can in russian, but when I see translit I start to use english automaticaly :)

VALUES INTO - This statement can be embedded only in an application program. It is an executable statement that cannot be dynamically prepared.

Вспомнил! Лечиться использованием cast()
values (or select, whatever) date(cast(? as timestamp)) - works