RE: S/36-mode alt indexes

["Dan Bale" <dbale@xxxxxxxxx>]

Yes, I think so.  Is ROB1 the file name?

What is the result of running this?  Will the view (?) be a record with
three fields and a length of 57 bytes?  Would I be able to chain or
SETLL/READE on one or more of the substrings?

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

-----Original Message-----
From: rpg400-l-admin@midrange.com [mailto:rpg400-l-admin@midrange.com]On
Behalf Of rob@dekko.com
Sent: Tuesday, April 30, 2002 4:20 PM
To: rpg400-l@midrange.com
Subject: 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