Re: creating a view - looking for a specific member using SQL

Hold on a sec. What is meant by "In SQL"?

SQL does work with OVRDVF if you specify the Physical File (it has to be DDS defined to have more than one member, right) on the SQL statement.


----- Original Message ----- From: <jvoris@xxxxxxxxxxx>
To: "rpg400-l" <rpg400-l@xxxxxxxxxxxx>
Sent: Friday, June 29, 2007 12:23 PM
Subject: RE: creating a view - looking for a specific member using SQL

In SQL, you cannot use OVRDBF. In SQL, you have to create an ALIAS to
point to the specific member of a multi-member file. And then open the
ALIAS name.

Later, you might want to delete the ALIAS with the command DROP ALIAS.
In a highly controlled environment like where I work, I cannot create
and drop aliases without them showing up on our security report, so I
create the alias in QTEMP for the life of the job, and then DROP ALIAS
QTEMP/aliasname.

- John Voris -
- mailto:jvoris@xxxxxxxxxxx -
- family ties to the Jacquays of Ft Wayne -

--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.