Re: SQL Data Structure is Procedures and not in Main section - compilation unsuccessful

Hi,

I recently wrote a program that uses SQL to process all tables/files. The
program has a very short main section, 4 statements, followed by all the
Procedures. When compiling the program I am getting an horrendous number
of errors, all associated with SQL. If I change the program to use
Sub-routines instead of the Procedures, the compilation completes
successfully.

Initially I thought that possibly the SQL Communication Area (SQLCA data
structure) may not have been created in the correct section, but that is
not the case. It appears that FETCH, SELECT, OPEN data structures are in
the certain Procedures and can't be accessed from other procedures.

I can supply both compilation reports if required to assist.

Has anyone had a similar issue and could make some suggestions to remedy
the situation.

Regards,

Alan McKenzie
XA Consultant
CBI electric Telecom Cables (Pty) Ltd.
Registration Number: 1967/005978/07
Office: +27 12 381 1405 | Switchboard: +27 12 381 1400
Mobile: +27 (0) 82 453 7990
E-mail: AMcKenzie@xxxxxxxxxxx<mailto:AMcKenzie@xxxxxxxxxxx>
NOTE:- This e-mail message and all attachments hereto contain confidential
information intended for specific addressee and purpose. If you are not
the addressee:
(a) You may not disclose, copy, distribute or take any action based
on the contents hereof.
(b) Kindly inform the sender immediately and destroy all copies
thereof.
(c) Any discloser, copying, distribution or any action taken or
omitted in reliance on it, is prohibited and may be unlawful.
The views and opinions expressed in this e-mail message may not
necessarily be those of the management of the company.

--
This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L)
mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: http://amzn.to/2dEadiD