RE: RUNSQLSTM Source File Record Length

["Jonathan Mason" <jonathan.mason@xxxxxxxxxxxxxxxx>]

Hi Mike

How are you generating the SQL statements?

Jonathan

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of eftimios pantzopoulos
Sent: 25 June 2007 12:19
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