Hello all,
I have a weird situation here. We are on an ISeries AS400. We have created an SQL table and can access it just fine when the COBOL program is called directly. The problem exists when the process is invoked with a stored procedure. The stored procedure calls a CL and then the COBOL program, but the SQL statement fails during this process.
Am I missing something, why does it work when the COBOL progam is invoked...
jk9427
Last Activity: Sep 26 '07, 07:57 PM
Joined: Aug 31 '07
Location: Dallas, TX
-
SQL select not working when starting program is a stored procedure.
-
Create Table sql0204 error
I'm creating an SQL table and it compiles fine, but in the spool file I have a level 30 error. Is this an actual problem, or can I procede?
SQL0204 30 36 Position 3 ETBRAN in JKENDZIERS type *FILE not found.
Create Table RENOFRCTL
(BRANCH for column ROCTBRAN char(02) not null,
CARRIER for column ROCTCARR char(02) not null,...
No activity results to display