Search code examples
ibm-midrangerpgle

websphere, SQL1103: Position 24 Column definitions for table STVRECONWK in QTEMP not found

I have a table that is created and then deleted at the end of an SQLRPGLE program

     //Delete the temporary table
     shell('DLTF FILE(QTEMP/STVRECONWK)':IGNORE_ERROR);

     // create temporary table
     exec sql
       create table qtemp/stvreconwk (
         sysid integer,
         barcode varchar(100),
         description varchar(100),
         matchflag char(1)
       )
     ;

Whenever I try to compile from WebSphere I get

SQL1103: Position 24 Column definitions for table STVRECONWK in QTEMP not found.

The problem is that the table does not exist, if I create the table from a terminal session and then compile (from the terminal also) it works becuase the compiler is able to validate the table as they are running in the same job.

How can I do this in WebSphere?

Solution

  • By Default the WebSphere will run each command in a new job. You can change this in window->preferences->iseries->command execution and uncheck 'compile in batch'