Re: SQL0901 error when run in a CLLE but not when run from command line

Darryl,

Sometimes these kind of errors are related to ERRLVL parameter or SQL statement length...

When I need to run a really long SQL statement (what about 500 lines?) I use DB2 CLI and a stream file with SQL extension and all my statements.

It's like using the SQL client from Navigator.

Regards

Diego


El 24/04/18 a las 18:12, a4g atl escribió:

I have a SQL script which I have been using for the past month and have
been running it from the command line using RUNSQLSTM. I am also able to
run it from the interactive SQL environment in iNavigator.

Today I started to run the script as part of a process in a CL program.

It executes a number of the statements in the script and then stops dead
with a SQL0901 and no meaningful error that I can see or interpret. There
is a SQL trace dump but I cannot interpret it.

Googling SQL0901 I see a bunch of references to ODBC and SQL packages. I do
not see how to delete and recreate the package.

Does RUNSQLSTM use an internal ODBC?

TIA

Darryl Freinkel