Re: SQL vs. a member

not directly, but you can create aliases for the members and access them and
you can do it the same way as you would do it in RPG.... OVRDBF MBR(....)
and then open.


===========================================================
R. Bruce Hoffman, Jr.
 -- IBM Certified Specialist - iSeries Administrator
 -- IBM Certified Specialist - RPG IV Developer

"I want to be different, just like everybody else!"
  - Ceili Rain

----- Original Message -----
From: <MacWheel99@aol.com>
To: "AS400 & iSeries & family discussion group" <MIDRANGE-L@midrange.com>
Sent: Tuesday, December 04, 2001 2:50 PM
Subject: SQL vs. a member


> Can I access member RETURN of file ESN via SQL embedded in RPG/400?
>
> Scenario: File ESN has different kinds of notes for different kinds of
BPCS
> files & I am finding some notes apparently exist in member ESN of file ESN
> for customer orders etc. that do not exist any more, and I am working on
> doing something about that.
>
> RMA;s (Return Material Authorization) stored in member RETURN of various
> files whose *FIRST member is for standard new customer orders.  I was
> wondering if the kind of analysis I doing in each *FIRST to find old
garbage
> records we not need any more could also be done against member RETURN of
> these files.
>
> I know I can do it with RPG/400.
> I was wondering if SQL embedded in RPG/400 can access by member or if this
is
> outside of SQL reality.
>
> I am trying to clean up garbage from our data base, in which initial step
is
> get a handle on where it is, then next step is best software tools to get
the
> job done, possibly different techniques for different scenarios.
>
> MacWheel99@aol.com (Alister Wm Macintyre) (Al Mac)
> BPCS 405 CD Manager / Programmer @ Global Wire Technologies Incorporated
> http://www.globalwiretechnologies.com = new name same quality wire
> engineering company: fax # 812-424-6838
> _______________________________________________
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
> To post a message email: MIDRANGE-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
> or email: MIDRANGE-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>