Hello there,

I am writing my query in development environment and then release it to 
production using Thenon (for performance and security reasons I am not 
allowed to run in production). Even though I input *LIBL for the Library of 
the input file the system changes it to the top library where the file is 
found from my library list. The fact that the query definition is not 
retaining *LIBL is crushing the query when it is run in production 
environment for the development environment is different to the production. 


 <<ole0.bmp>> 

I entered here *LIBL

 <<ole1.bmp>>        

System puts the library name from Development Library List.                   
                                                    

 <<ole2.bmp>> 

Can you please help me if you know of a way of making WRKQRY retain *LIBL. 

I know of creating a CL program to run the query....

      PGM 
              RUNQRY qryname QRYFILE((*LIBL/file1) (*LIBL/file2)) 
      ENDPGM 
or 

Running the query as follows..
      
      RUNQRY qryname QRYFILE((*LIBL/file1) (*LIBL/file2)) 


Regards,
Hassen Osman
Release Analyst
OTSS - Esanda Group Technology
Australia and New Zealand Banking Group Limited
ABN 11 005 357 522
1/85 Spring Street, Melbourne VIC 3000

Tel. 61 3 9666 9693
mailto:osmanh@xxxxxxx

This e-mail and any attachments to it (the "Communication") is confidential 
and is for the use only of the intended recipient. The Communication may 
contain copyright material of Australia and New Zealand Banking Group Limited 
ABN 11 005 357 522 ("ANZ"), of any of its related entities or of third 
parties. If you are not the intended recipient of the Communication, please 
notify the sender immediately by return e-mail, delete the Communication, and 
do not read, copy, print, retransmit, store or act in reliance on the 
Communication. Any views expressed in the Communication are those of the 
individual sender only, unless expressly stated to be those of ANZ. ANZ does 
not guarantee the integrity of the Communication, or that it is free from 
errors, viruses or interference.



As an Amazon Associate we earn from qualifying purchases.

This thread ...


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

This mailing list archive is Copyright 1997-2024 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.