Re: sql valid end of statement token

On 26-May-2010 16:58, Jerry Draper wrote:

I am using STRQM to create a simple SQL script.

CREATE TABLE QTEMP/FILEMSG
(MSG CHAR (128 ) NOT NULL WITH DEFAULT)

INSERT INTO QTEMP/FILEMSG (MSG)
VALUES ('Job exceeded max run min of &MAXRUN')

I get :

Keyword INSERT not expected. Valid tokens: <END-OF-STATEMENT>

Is there some kind of end of stmt required for STRQM that is not
required in STRSQL where this script works fine?

I tried it with semi-colon and got same results

As others have noted, the *QMQRY can have only one statement. However I did not see where anyone suggested that the CREATE TABLE can combine them, effectively, using SELECT. For example...

Issue CRTQMQRY QTEMP/FILEMSG using the following as QMQRY source:

create table qtemp/filemsg as ( select
char('Job exceeded max run min of'
concat &MAXRUN ,128) as msg
from qsys2/qsqptabl ) with data

Then issue for example, the following request to run the query with the variable substitution:

strqmqry QTEMP/FILEMSG setvar((maxrun '2.5'))

Verification by RUNQRY *N QTEMP/FILEMSG shows:

Line ....+....1....+....2....+....3....+.
MSG
000001 Job exceeded max run min of 2.5
****** ******** End of report ********

Regards, Chuck