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

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.