|
Hi I am trying to write a routine that needs to identify the Field Reference File information for a given database file. I know that the DSPFFD command shows this information and that the output can be directed to an *OUTFILE for processing, however, as the program will process a large number of files I want to avoid having to make repeated calls to the command and then reading the output. I feel sure that the information must be accessible from somewhere and have been through the eight or so QADB* database cross reference files in QSYS that the logical files SYSTABLES, SYSCOLUMNS, etc are built over and none of these contain the field reference file details. I have also looked at the QUSLFLD API and, again, that does not contain the required details. Does anybody know if there is another API or database file that I can reference to find this information? Thanks and best regards Jonathan Mason ___________________________________________ Consultant Astradyne (UK) Ltd. 4 Knoll Road, Fleet, Hampshire, England. GU51 4PR Tel: +44 (0)1252 400955 Fax: +44 (0)1252 400956 jonathan.mason@xxxxxxxxxxxxxxxx CONFIDENTIALITY NOTICE This communication is from Astradyne (UK) Ltd. The information contained in this communication is confidential and may be privileged. It is for the exclusive use of the intended recipient. If you are not the intended recipient, please do not distribute, copy or otherwise use this communication or the information in it. If you have received this communication in error, please notify us by e-mail at enquiries@xxxxxxxxxxxxxxxx and then delete the e-mail and any copies of it. VIRUSES The contents of an attachment to this e-mail may contain software viruses which could damage your own computer system. While Astradyne (UK) Ltd. has taken every reasonable precaution to minimise this risk, we cannot accept liability for any damage which you sustain as a result of software viruses. You should carry out your own virus checks before opening any attachment.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 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.