Are SQL statement lines limited to 80 characters ?

Maybe some of you already know this, but I just spent a couple hours debugging an SQL statement that worked great in ACS Run SQL but would not pass the SQLRPGLE pre-compiler test.

As it turns out I believe each line of an SQL statement can only be up to position 80 before you need to continue on the next line.

I read something that alluded specifying **free would allow longer lines, but that didn't seem to help.

Can someone tell me what the reality is for this ?

Am I limited to 80 line SQL statements in SQLRPGLE ?

Thanks

Regards,
Richard Schoen
Web: http://www.richardschoen.net
Email: richard-DiTrGpQEJGItADg8e/3/[email protected]<mailto:richard-DiTrGpQEJGItADg8e/3/[email protected]>

-- 
This is the RPG programming on IBM i (RPG400-L) mailing list
To post a message email: [email protected]
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request-+hD5IHI5Xscn3HwCXmMcX9BPR1lH4CV8@public.gmane.org
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-l.

Please contact support-FMtJrHiV//lnDLsaKlm4mFaTQe2KTcn/@public.gmane.org for any subscription related questions.