|
Although I never done this in COBOL, but often in CL, I thing the only way is to override the member, e.g. OVRDBF FILE(FOO) TOFILE(MYLIB/MYFILE) MBR(MYMBR) then process the FOO file, e.g.: SELECT * from FOO and at end DLTOVR FILE(FOO) "Kumar, Ashok (MIS)" <Ashok.Kumar@xxxxxxxxxxxx> Sent by: cobol400-l-bounces@xxxxxxxxxxxx 27.03.2006 08:45 Please respond to COBOL Programming on the iSeries/AS400 <cobol400-l@xxxxxxxxxxxx> To COBOL Programming on the iSeries/AS400 <cobol400-l@xxxxxxxxxxxx> cc Subject [COBOL400-L] To insert or read the record in particular member of the PF throu gh SQL Statement Dear All Please let me know how to insert or read the record in particular member of the PF through SQL Statement (sql/400) For Eg I have one PF (Employee) with EMPNo and EMPName with three Member (E1,E2,E3) And I need to read all the records from member E2 Note: Should not override the member using OVRDBF I tried by using the alias name it is not working Select * from Employee E2 - Not worked Regards IMPORTANT NOTICE: The information in this email (and any attachments) is confidential. If you are not the intended recipient, you must not use or disseminate the information. If you have received this email in error, please immediately notify me by "Reply" command and permanently delete the original and any copies or printouts thereof. Although this email and any attachments are believed to be free of any virus or other defect that might affect any computer system into which it is received and opened, it is the responsibility of the recipient to ensure that it is virus free and no responsibility is accepted by American International Group, Inc. or its subsidiaries or affiliates either jointly or severally, for any loss or damage arising in any way from its use.
As an Amazon Associate we earn from qualifying purchases.
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.