× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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.

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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.