RE: Query/400 outfile as input into RPG

["Andrew Borts" <Andrewb@xxxxxxxxxxxxxxxxxxx>]

Sure no prob.  However after playing with SQL for a little bit... I will
use them when I can - esp. since the code in my Net.Data macros is
EXACTLY the same in my RPG now - and LOTSA RPG code can be replaced with
SQL built in functions... I rather like the embedded SQL - & it avoids
things like level checks when the files change... things like soundex
lookups can be a dream in SQL 'cause it's built in.

Honestly - it's just another tool in the toolbox that's all - the best
way to complete a project (as long as it adheres to standards!) is the
quickest.

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: Thursday, December 27, 2001 10:04 AM
To: rpg400-l@midrange.com
Subject: RE: Query/400 outfile as input into RPG

Sorry, Andrew...

I don't have time to get in a long "SQL vs. DDS Wars" thread..  but I
beg to
differ...

ESPECIALLY in this particular case, where all that's needed to solve the
problem is a half-line of code.  (In a language that most everybody
knows
already.)

jt

| -----Original Message-----
| From: rpg400-l-admin@midrange.com
[mailto:rpg400-l-admin@midrange.com]On
| Behalf Of Andrew Borts
| Sent: Thursday, December 27, 2001 9:47 AM
| To: rpg400-l@midrange.com
| Subject: RE: Query/400 outfile as input into RPG
|
|
| 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!
|
| | -----Original Message-----
| | Behalf Of frensw@bayareahospital.org
| | Sent: Wednesday, December 26, 2001 2:16 PM
| |
| | 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?

_______________________________________________
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.