Hi Serge Rielau,

Sorry for the late response.

Now i breaked the procedure into small 10 procedures and calling all
those procedures from a single procedure. All are compiled/created
successfully.
Actually oracle procedure was having VARRAY as parameters and there
were around 18 VARRAY parameters, While converting to DB2, i made them
as VARCHAR and inside the procedure i'm parsing the string using
ORA8.INSTR functions with WHILE..DO loop. But, it gives me "SQL1042C
-- Unexpected system error". After getting System Error, if i try to
execute ora8.instr, it gives the same error. But,all other statements
will work like select, insert, update and delete etc.
except CREATE PROCEDURE statment. Is there any problem with the
memory?
I am using Win2k IBM UDB v8.

Calling 10 procedure from one procedure is this a problem?

Please help me

Thanks in Advance
Praveen


Serge Rielau <srielau@ca.eye-be-em.com> wrote in message news:<c4c338$es1$1@hanover.torolab.ibm.com>...
> Praveen,
>
> You should get a -101 SQLCODE (statement too long or too complex) if
> procedure size were the problem.
>
> Can you post the context of the line including the previous and
> following statement?
>
> Cheers
> Serge

Praveen,

Calling 10 procedures from one is no problem.
Possibly the problem lies in ORA8.INSTR()?
Consider sending a note to
mtk@us.ibm.com
The migration folks may know about an issue.
What does ORA8.INSTR() do?
Very likely you could just as well use a native DB2 function (POSSTR?)
(which will be faster anyway).

Cheers
Serge

--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab

Hi,

ORA8.INSTR function is same as POSSTR db2 function, which search for a
particualt in another string gives the index. I have changed my
procedures with POSSTR and they are working fine without any system
error. Thank You very much for the help. Is there any limitations in
string length in POSSTR? because i have params as VARCHAR(10000) and
as of now, the data is not coming that much to these parameters.

Thanks,
Praveen

Serge Rielau <srielau@ca.eye-be-em.com> wrote in message news:<c4v350$p8i$1@hanover.torolab.ibm.com>...
> Praveen,
>
> Calling 10 procedures from one is no problem.
> Possibly the problem lies in ORA8.INSTR()?
> Consider sending a note to
> mtk@us.ibm.com
> The migration folks may know about an issue.
> What does ORA8.INSTR() do?
> Very likely you could just as well use a native DB2 function (POSSTR?)
> (which will be faster anyway).
>
> Cheers
> Serge

Should be fine:
http://publib.boulder.ibm.com/infoce...n/r0000835.htm

--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab

Hi,

Thank You very much for the Help!!!

I have created all my procedures in another db2 server and almost all
of them works fine. But, sometimes when i try execute procedure, it
says...

SQL4301N Java interpreter startup or communication failed, reason
code "0".
SQLSTATE=58004..

When i searched in the NET, i got some answers to increase the
JAVA_HEAP_SIZE, it worked for sometime, but again getting same error.
Is this a problem with the procedure? because, when i try to execute
the same procedure, in my database, it works fine. what might be the
reason?

Thanks,
Praveen

Serge Rielau <srielau@ca.eye-be-em.com> wrote in message news:<c58vr9$k31$1@hanover.torolab.ibm.com>...
> Should be fine:
> http://publib.boulder.ibm.com/infoce...n/r0000835.htm

Sorry, I'm no Java person. Maybe Knut has some insight here.

Cheers
Serge
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab

Serge Rielau wrote:

> Sorry, I'm no Java person. Maybe Knut has some insight here.

Sorry, I don't know exactly what might have happened. Please post the
content of the db2diag.log file as this should contain some more
information for SQL4301.

Maybe something went wrong when the classpaths for the JVM was to be
constructed. Did you set anything special in the db2 configuration?

--
Knut Stolze
Information Integration
IBM Germany / University of Jena