I have 1 rd in my flat file.
say reord from 1 to 10 position : 'AS400NDB2400'
I need to change the value from N to Y
using SQL stmt ...How can I update this....?
Answer Posted / murali
Update <FileName> set substr(<Field Name>,6,1) = 'Y' where
substr(<Field Name>,6,1) = 'N'
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
what is sflinz and sflrna?
define the purpose of the *bcat function?
The content of Physical file is as below: hfcftp wruquief SENDPASV 0 CDUP ASCII GET 01100901.CSV ramndk/ECP505.EC0110090 (REPLACE QUIT Thw above commands will get executed when we call STRTCPFTP from CL program.... Now if I want to use SFTP what can be the solution? plz reply in detail....Thank you for ny help... I m using RPG/ILERPG to download...
name few ibm supplied libraries?
define a shared access path?
what is the purpose of ovrdta and ovrata keywords ?
which cl command can be used at program execution to redirect the file named in an rpg program?
how to define global parameter in ile ?
define the purpose of the iter operation?
what is overlay?
the maximum number of subfiles that can defined in a rpg program for one display file is ___ .
What Does 'sr' In Columns 7-8 Of C Specs Mean?
what does vldcmdkey means?
what the purpose of ovrdta, ovrata keywords?
what is procedure prototype and procedure interface.