RE: S/36-mode alt indexes

This is a multipart message in MIME format.
--
[ Picked text/plain from multipart/alternative ]
Like this?

SELECT SUBSTR(ROB1.F00001,1,6), SUBSTR(ROB1.F00001,7,1),
       SUBSTR(ROB1.F00001,8,50)
FROM ROB1 JOIN XOB1
          ON SUBSTR(ROB1.F00001,1,6)=SUBSTR(XOB1.F00001,1,6)

Works on my system.

Rob Berendt
--
"They that can give up essential liberty to obtain a little temporary
safety deserve neither liberty nor safety."
Benjamin Franklin




"Dan Bale" <dbale@samsa.com>
Sent by: rpg400-l-admin@midrange.com
04/30/2002 02:47 PM
Please respond to rpg400-l


        To:     <rpg400-l@midrange.com>
        cc:
        Fax to:
        Subject:        RE: S/36-mode alt indexes


Jim Franz wrote:
>btw - you can do sql selects on these 36 files by doing the same kind
>of substring, although I never got packed fields to work in a SELECT.

Can I do a join thru SQL on s/36 flatfiles?  Anybody have an example?

- Dan Bale
(I am *NOT* "Dale"
http://archive.midrange.com/midrange-l/200105/msg00281.html )
SAMSA, Inc.
989-790-0507
DBale@SAMSA.com <mailto:DBale@SAMSA.com>
  Quiquid latine dictum sit altum viditur.
  (Whatever is said in Latin seems profound.)

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