Re: stored procedure error - sql0443n - sqlstate=38501

Lie. Tell DB2 it is RPG. It shouldn't matter to DB2 whether the external 
program is written in RPG or RPGLE. In either case it does a system call 
to the program and parameters are passed through a system call in the same 
manner whether it is RPG or RPGLE.

I haven't tested this. Just a theory.

Dan




Steve Richter <stephenrichter@xxxxxxxxx> 
Sent by: midrange-l-bounces@xxxxxxxxxxxx
04/08/2005 10:41 AM
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>


To
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
cc

Subject
Re: stored procedure error - sql0443n - sqlstate=38501






On Apr 8, 2005 10:51 AM, rob@xxxxxxxxx <rob@xxxxxxxxx> wrote:
> Question:  Is the CREATE PROCEDURE what is failing from your PC program?

no.  I can create and drop the procedure.  what fails is the execute. 
It only fails when LANGUAGE is RPGLE.  LANGUAGE RPG or CL works.  ( I
suspect DB2 UDB does not support RPGLE )
  cmd.CommandType = CommandType.Text;
  cmd.CommandText = "CREATE PROCEDURE FAXMAIL.TEST35B (" +
                       "IN VLU1 CHAR(1) ) " +
                        "LANGUAGE RPGLE " +
                        "DETERMINISTIC " +
                        "NO SQL " +
                        "SPECIFIC TEST35B " + 
                        "PARAMETER STYLE GENERAL " +
                        "EXTERNAL NAME 'FAXMAIL/TEST35B'";
   cmd.ExecuteNonQuery();
    Trace.Write("AutoCoder", "Stored procedure created");

> If so, have you tried putting the entire CREATE PROCEDURE in a source
> member and using RUNSQLSTM on it and see what happens?  Because writing 
a
> PC program to do this (which should be a one shot deal) seems like a lot
> of extra work.

I am an asp.net programmer now! :)  It is a good idea but it is better
for me to address the problem on the asp.net side of things.

I do have an IBM DB2 support call open, so I will see what they say.

Here is how to run and format the db2 trace:
1 - db2trc on -l 128M 
2 - recreate the error 
3 - db2trc dump <file_name.dmp> 
4 - db2trc off 
5 - db2trc fmt <file_name.dmp> <file_name.fmt> 
6 -     db2trc flw <file_name.dmp> <file_name.flw> 

-Steve
-- 
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing 
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.