RE: Query/400 outfile as input into RPG -- RPG400-L

<blushing> OK ... I didn't take it the wrong way...
        After playing with SQL/RPG combo - I honestly couldn't think of
the other way to get a "small amount of records" defined as *LT 100,000
without creating an SQL block - for big relational stuff, I whip out the
setll/read routines... but MAN if I can join a few files together with a
selection process and include a total within that, MAN it becomes a way
of life.

        OK - SQL Notes;
        For EVERY language you use from NOW ON - there will be some form
of SQL manipulating files.  Sorry - fact-o-life.  So - learn to do ASP's
- BAM - ODBC connected to ACCESS - using ... SQL as the interface.  Java
- BAM - use SQL to access the data.  Net.Data - BAM - SQL ... It'zall
the same...


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 2:18 PM
To: rpg400-l@midrange.com
Subject: RE: Query/400 outfile as input into RPG

Andrew,

I came across wrong...

Bought Paul Conte's (and Mike Cravitz' maybe?)
pretty-much-everything-you-need-to-know-about SQL book...  I've been
MEANING
to read it... (excuses, excuses, yada, yada...)

Sometimes I react, rather than act...  IOW, I react AGAINST this idea
that
SQL is the ONLY way to go (being as OS/400 developers are putting
functions
ONLY in SQL, just to force me to use it).  I'm not against SQL, so much
as
I'm against the idea it's the only way to go.


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 1:04 PM
| To: rpg400-l@midrange.com
| Subject: RE: Query/400 outfile as input into RPG
|
|
| 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.
| _______________________________________________
| 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.
|

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