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 / sachin
Try using this stmt :-
UPDATE TT SET TT = SUBSTR(TT,1,6) || 'Y' || substr(tt,8,6)
Cheers...
| Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
what are necessary keywords to code message subfile?
under given circumstances, my cgi should link to another site. How to implement this?
What is a query can be displayed without saving it?
when should I use method get, and when should I use method post in my cgis?
what is the sequence when using cursor?
What are the different opcodes used for file operation on a subfile in a rpg pgm?
which indicator is used for read?
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...
how may a cgi control duplicate inputs?
Difference between NOPASS & OMIT?
Difference Between Skip Before & Space Before?
how can you detect overflow for a print program that prints multiple lines per cycle?
define the purpose of the %sst function?
what is the difference between sflclr and sflinz?
which cl command can be used at program execution to redirect the file named in an rpg program?