Re: source file

[Vern Hamberg <vhamberg@xxxxxxxxxxx>]

hi Donna

Personally, I prefer to set up Turnover to use the suggested lengths for 
the various source types - all except RPGLE (SQLRPGLE) and C/C++ at 92, 
as they always were. RPGLE at 112. C/C+ maybe at 240 or whatever value 
gives you the longest SRCDTA field length in a source physical file.

Now QM queries need a record length of 91 - who know why? And QM forms 
need a length of 162. Also, who knows now why?

So I would just bite the bullet and set RUNSQLSTM source to 92 and be 
done with it.

HTH
Vern

donna lester wrote:
> Hi All, 
> To  promote the SQL based objects such as Tables, Stored Procedures, etc., TurnOver uses the RUNSQLSTM which has the limitation that it only reads the first 80 columns of the  source file even when the file length is greater than that and we took  112 as source file record length. So, if I create or change  the code using a file with record length greater than 80 and the code extends beyond the 80 columns then the code in column 81 and above gets ignored. This is resulting in   a syntax error thus preventing the objects from being promoted or if this doesn't result in a systax error then the objects will be promoted with no errors and could cause runtime error .
> Is it only resolution that I have to reduce source file length (QSQLSRC) from 112 to 92?
> Are there any commands that support only 80 length or less than that or more that? any insights are highly appreciated.
>
>
>       
>