Hi All,

In some of our programs DB2 reserved words are being used.

DAY and PARAMETER are two columns in a table.

in one program we inserted DAY - with out any delimeters like insert into table(day) values(day) - it is not giving any error.

in other program we are insering parameter in the same way inser into table(parameter) values(parameter) - it is giving compilation error saying "parameter" is a reserved word..

if I modify the statement as insert into table("parameter") values (parameter) -- delimeted the column name - it is working fine.

Could you please advice why it is happening some times?

is there any special way to bind if we are using reserved words?

Please give exact and complete error message(s).
And, where did day and parameter in values(day) and values(parameter) came from?

Also note that this may depend on your specific platform and version of DB2.
Personally I've never had any "reserved word" conflicts with DB2 for z/OS.
But the precompiler sometimes thinks he's clever and flags some "valid" constructs (e.g. because they contain reserved words).