Re: SQL question

[rob@xxxxxxxxx]

Are these S/36 type internally defined files?  Basically one record = one 
field (unless keyed)?

CREATE TABLE QTEMP/STEEMA (MYCHAR CHAR (30 ) NOT NULL WITH DEFAULT)
INSERT INTO QTEMP/STEEMA VALUES('                             3')
INSERT INTO QTEMP/STEEMA VALUES('                              ')
INSERT INTO QTEMP/STEEMA VALUES('                            XX')
UPDATE STEEMA 
SET MYCHAR=SUBSTR(MYCHAR,1,29) CONCAT ' '
WHERE SUBSTR(MYCHAR,29,1)=' ' 
  AND SUBSTR(MYCHAR,30,1)<>' ' 
1 rows updated in STEEMA in QTEMP. 
SELECT * FROM STEEMA 
....+....1....+....2....+....3 
MYCHAR 
 
 
                            XX 
********  End of data  ********


Rob Berendt