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 the difference between seton lr and retrn?
which of the cl command can be used to determine which logical files are dependent on a specific file?
Hello, I have created a CMD type object. In one of the fields in Display file , I would like to see All the Source files present by pass the name of Library. Tried using CHoice(Keyword) and Choicepgm on PARM , but doesn't seems to be working. Any help please..
Write a CL program which will run a batch job at 1 am every night
what is the length of a variable in rpg?
what is logical file?
what is the maximum number of subroutines allowed in rpg?
define what a data area is along with a brief example of what it may be used for?
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...
Can you summarize the steps I have to go through in writing my first cgi?
what is the command to know key fields of file?
different type of cursor?
what is the sequence when using cursor?
Difference Between Call & Sbmjob?
how to run other job when one job is active?