We are at System 21 version 3.5.2B SP3 and are prepping to move to V6R1
of the O/S. We've had to recompile over 2,000 System 21 programs that
will not run at V6R1 without recompilation and it's been really ugly but
we are nearly there.



While trying to recompile the Sales Analysis "Update sales History"
SQLRPG program, OSLSAP3/SA025, at 3.5.2B so it will work at V6R1. I get
the following SQL errors.



SQL1001 30 176 External file definition for AIPS8L02 not found.


SQL1001 30 643 External file definition for AIPS7 not found.


SQL1103 10 728 Position 14 Column definitions for table AIPS8 in
*LIBL

not found.


SQL1103 10 728 Position 21 Column definitions for table AIPS7 in
*LIBL

not found.


SQL0312 30 1573 Position 43 Variable VATRS8 not defined or not
usable.

SQL0312 30 1576 Position 16 Variable RESNS7 not defined or not
usable.



When I do a DSPREF on SA025 it shows files AIPS8L02 or AIPS7 in the
object that I received from JBA or Geac but I do not have them anywhere
on my system.



Does someone have the file layouts for these files so that I can compile
them and get my program recompiled? I'd probably need the layouts for
AIPS8 (if that is the physical over AIP8L02), AIPS7, and AIP8L02. I
obviously don't use these files but need them for the compile. I think
any version 3 files will work since the dates of the code in the program
that is not compiling is from 1997.



Thanks in advance for your help.



Steve Prill



Steve Prill | I.T. Manager | Rexair LLC |50 W. Big Beaver Rd. Suite 350
| Troy, MI 48084 | 248-816-8627 | fax 248-524-2191 |
sprill@xxxxxxxxxxxxx <mailto:sprill@xxxxxxxxxxxxx>






This email and any attachments are confidential and may be legally
privileged. If you are not the intended recipients, please notify
the author by replying to this email message, and then delete all
copies of the email on the system. If you are not the intended
recipient, you must not disclose, distribute, copy, print or use
this email in any manner.

Email messages and attachments may contain viruses. Although we
take precautions to check for viruses, we make no assurances about
the absence of viruses. We accept no liability and suggest that
you carry out your own virus checks.

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.