Re: To insert or read the record in particular membe r of the PF throu gh SQL Statement

Glad the ALIAS worked for your problem.

Bob

Kumar, Ashok (MIS) wrote:

Guys
I got the Solution in the PDF

This is for your information

Create alias first

Eg
Create alias Libnam/PFMBR for Libname/PFName(MbrName)
Now the MbrName of the PFName is created with the name PFMBR

Put Select * from Libnam/PFMBR
It will display the member andyou can do all the operation on that
particular Member

Using this you can update the Date field of your source member

Create alias for your source member in the source physical file And using update command you can update the date modified field as you want

Note: Please don't try this in the real time project. This is not quite good
for the professional people
But this is really a interesting one.

Regards


-----Original Message-----
From: cobol400-l-bounces@xxxxxxxxxxxx
[mailto:cobol400-l-bounces@xxxxxxxxxxxx] On Behalf Of Roman Miklos
Sent: Monday, March 27, 2006 2:11 PM
To: COBOL Programming on the iSeries/AS400
Subject: Re: [COBOL400-L] To insert or read the record in particular member
of the PF throu gh SQL Statement

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.