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.