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

[Diego Kesselman <diegokesselman@xxxxxxxxx>]

Maybe it's using JDBC or some kind of QZDASOINIT-based connection ... 
I've found similar errors when using DB2 CLI from QSHELL.


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