Re: SQL question

[steema@xxxxxxxxxxxxx]

Not 36 files.
> 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
> --
> Group Dekko Services, LLC
> Dept 01.073
> PO Box 2000
> Dock 108
> 6928N 400E
> Kendallville, IN 46755
> http://www.dekko.com
>
>
>
>
>
> steema@xxxxxxxxxxxxx
> Sent by: midrange-l-bounces@xxxxxxxxxxxx
> 02/06/2006 08:35 AM
> Please respond to
> Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
>
>
> To
> "Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
> cc
>
> Fax to
>
> Subject
> SQL question
>
>
>
>
>
>
> HI I have to remidiate a bunch of files. Some programs are not
> initializing properly so that some records, have a character at the end,
> that should not be there ( belongs to a prev.)
>
> I need to write a small prg that will look for a blank, then look for
> something other than a blank, and replace w/ a blank. Can this be done
> easily in SQL ?
>
> Thanks,
> Steve
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>
>