RE: How to view Sql Stored Procedure Precompiled Log ?

Lugman;
I will risk suggesting an alternative approach to the creation of the
stored procedures.  If your stored procedure is to reside on the
iSeries, then don't use Navigator to create it.  Put the SQL statement
that creates the stored procedure into a source member of a source
physical file on the iseries.  Then use the RUNSQLSTM command on the
iSeries to run the SQL which creates the stored procedure.  You may
still get the error, but you can look at the output from the SQL in your
spool files.  And that should help you resolve the issue.
 
Andy Leisk
920-751-4434
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Luqman
Sent: Tuesday, March 14, 2006 1:45 PM
To: midrange-l@xxxxxxxxxxxx
Subject: How to view Sql Stored Procedure Precompiled Log ?

While creating sql stored procedure in Navigator, if any error occurs,
while 
compiling, how can I view such Log, which line of code has error ?

Best Regards,

Luqman