×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
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
midrange.com
