Re: SQL question

Actually, it has been decided that it would be more prudent to just print
such a listing first and let the users review. As there are some cases
where a blank is OK.

> Ok.  But did the logic work anyway?
>
> 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 09:24 AM
> Please respond to
> Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
>
>
> To
> "Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
> cc
>
> Fax to
>
> Subject
> Re: SQL question
>
>
>
>
>
>
> 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.
>>
>>
>
> --
> 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.
>
>