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

we should not use OVRDBF
I already mentioned in the mail

see my notes in the previous mail


-----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.