Re: SQL SYNTAX

["oludare" <oludare@xxxxxxxxxxxxx>]

Thanks HTH,

This will not work where you are trying to change a character from a 132
bytes flat file and your character in position 61.
You have characters before and after position 61.

Dare

----- Original Message -----
From: "Rolf Mittag" <rm@r-m-e-d-v.de>
To: <RPG400-L@midrange.com>
Sent: Tuesday, March 06, 2001 3:53 PM
Subject: Re: SQL SYNTAX


> substr IMHO cannot be the target of an update
> operation. change to something like :
>
>         update qtemp/test
>                 set f1 = substr(f1, 1, 5) || '*' || substr(f1, 7)
>
> that will work (tested and cut & paste)
>
> HTH rolf
>
> ---------------------------
> Dipl.Inf.(FH) Rolf P Mittag
> Leipziger Str. 50
> D-69214 Eppelheim
> Fon: +49 (6221) 76 78 60
> Fax: +49 (6221) 76 80 26
> eMl: rm@r-m-e-d-v.de
>
> +---
> | This is the RPG/400 Mailing List!
> | To submit a new message, send your mail to RPG400-L@midrange.com.
> | To subscribe to this list send email to RPG400-L-SUB@midrange.com.
> | To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator:
david@midrange.com
> +---

+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---