RE: RUNSQLSTM Source File Record Length

["Holden Tommy" <Tommy.Holden@xxxxxxxxxxxxxxxxx>]

Just do the same as interactive SQL just continue the statement on the
next line nothing else needed.  If you have more than one statement to
run just end each SQL statement with a semi-colon... 


Thanks,
Tommy Holden


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of eftimios
pantzopoulos
Sent: Monday, June 25, 2007 6:19 AM
To: midrange-l@xxxxxxxxxxxx
Subject: RUNSQLSTM Source File Record Length

I'm generating SQL statements to a source file in order to run that
source 
file member through RUNSQLSTM. The SQL statements are about 150
characters 
long so I created a source physical file with a record length of 200 
thinking that this would solve my problem. My SQL statements were now 
complete but when I ran the source member through RUNSQLSTM it seemed to

ignore everything past character 79! What documentation I could find
said 
the same thing about QM QRY.

I'm using SQL to insert into the source physical file. Is there an easy
way 
to generate each SQL statement so that it runs over two lines without 
resorting to another pass over the resulting member with another
program?



Thanks,
Mike Pantzopoulos