View Single Post

   
  #1 (permalink)  
Old 05-16-2008, 02:39 PM
Eniacson
 
Posts: n/a
Default AS400 STRSQL vs RUNSQLSTM

I've worked with DB2 for a long time, but I'm new to the AS400
environment.
I'm having a problem with an SQL statement that runs perfectly when I
use STRSQL, but when I batch it and call RUNSQLSTM, the exact same
statement (with a semicolon added at the very end) fails with the
following error:

Buffer length longer than record for member SBXARDTL.
Member SBXARDTL not journaled to journal *N.
SBXARDTL in QGPL not valid for operation.
RUNSQLSTM command failed.
SQL9010 received by procedure SBXORCEXT.

Now, SBXARDTL is a new table I created, and the SQL statement is an
insert based on a select on another table. Table was empty when I
attempted the batch insert.
SBXORCEXT is the CL program that calls RUNSQLSTM.

I could add more details, but for a seasoned AS400 expert among you
probably this is enough info to pinpoint the problem.

I will appreciate any hints.
Thanks in advance.
Reply With Quote