Hello,

I'm wondering if a global environment variable defining the format of a date exists for DB2 (as DBDATE for Informix or NLS_DATE_FORMAT for Oracle).

I get this error when trying to insert a date in a field date passing throught a 4gl program :
SQL statement error number -6372 (-301).
[IBM][CLI Driver][DB2/SUN] SQL0301N The value of input host variable or parameter number "" cannot be used because of its data type. SQLSTATE=07006

Thx

What date format do you want to use, and exactly what value is the 4GL program using when you get the error?

I was inserting a DATE value in a VARCHAR DB2 field, and then retrieve this value with an INSERT INTO statement inserting the value in a variable of type DATE.

I've find out a solution, positionning DBDATE (to Y4MD/ in my case).