RE: Query/400 outfile as input into RPG

["Andrew Borts" <Andrewb@xxxxxxxxxxxxxxxxxxx>]

Actually - SQL/400 is a neat way around this - no DDS - no specs - just
create the Datastructure you want, and perform the selection using the
SQL embedded in the RPG, then put the results into your fields... quite
elegant!

Andrew Borts / Webmaster
Seta Corporation
6400 East Rogers Circle
Boca Raton, FL 33499

E-mail: Andrewb@setacorporation.com
Corporate web site http://www.setacorporation.com
E-Commerce web site http://www.palmbeachjewelry.com
                              http://www.myfreeitems.com
Voice: 561-994-2660 Ext. 2211 / Fax: 561-997-0774

-----Original Message-----
From: jt [mailto:jt@ee.net]
Sent: Wednesday, December 26, 2001 2:35 PM
To: rpg400-l@midrange.com
Subject: RE: Query/400 outfile as input into RPG

Wayne,

You need to rename the record format on the F-spec.

RENAME(filename:yourrcdfmt)

jt

| -----Original Message-----
| From: rpg400-l-admin@midrange.com
[mailto:rpg400-l-admin@midrange.com]On
| Behalf Of frensw@bayareahospital.org
| Sent: Wednesday, December 26, 2001 2:16 PM
| To: RPG400-L@midrange.com
| Subject: Query/400 outfile as input into RPG
|
|
| I'm trying to use a Query/400 outfile as input into an RPGIV program.
I
| have the file as input and externally defined.
| The error message is RNF2121 saying the record format is already
defined.
| How do I get around this without copying the query outfile to a DDS
file
| and using this newly created file?
| Thanks,

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