RE: sql with members

To access a specific member is a multi-member file is SQL,
First create an alias using the syntax below:

CREATE ALIAS library/aliasname FOR library/file(member)

Once you have created the alias, you may reference like any other
physical or logical file in SQL .
For example:

CREATE ALIAS qtemp/doggie FOR MFSPDTA/AETAGEDPHS (EA20071221)
SELECT PROVTIN, PROVNAME, CLAIMNO, PAIDAMT FROM qtemp/doggie


The alias actually creates a physical object, a DDMF file type, in the
library specified
Once you no longer need the alias, you may use the command below to
remove the alias

DROP ALIAS library/aliasname

You may also delete the alias using
DLTF library/aliasname



John Arnold
(301) 354-2939

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Vern Hamberg
Sent: Tuesday, February 03, 2009 9:02 AM
To: Midrange Systems Technical Discussion
Subject: Re: sql with members

Or use aliases = that is IBM's answer - create alias is the SQL
statement

elehti@xxxxxxxxxxxxxxxxxx wrote:

Jerome: How to specify members for SQL.

Step 1: OVRDBF FILE(JDESRC) TOFILE(CRPSRC/JDESRC) MBR(P30445)
Step 2: strsql
Step 3: update jdesrc set srcdta='EL01 '|| substr(srcdta,6,75)

where

srcdat between 070000 and 079999
Step 4. after exiting from STRSQL, do this: DLTOVR FILE(*ALL)