Hello
I am running db2 cobol program and its giving me a sql code of 0927 while executing query

exec sql
set ws-date - current_date
end

anybody have idea on how to resolve this?

Thanks...

It depends on what you are trying to do.

An SQLCODE -927 indicates that you run your program directly instead of using the DB2 RUN command (actually: DSN subcommand).
Programs containing EXEC SQL should be run under supervision of DB2, not independently.
Have a look at the DB2 Command Reference Guide (SC18-9844) for the syntax of the DSN RUN subcommand. (It's on page 377.)

Shouldn't that minus sign be an equal sign?

Andy

Not just that: there is a colon ( : ) missing in front of the variable name:

Hello, the issue got resolved by having a loadlib QSTART.LOADLIB (?) in STEPLIB of the DB2 cobol program.

Thanks for all your responses... Appreciate it.

Thanks....