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 is xfoot opcode ?
how do you specify the number of records to roll in a subfile ?
WHAT IS AS/400 SYNORIO?
What is binder language ?
Apart from opening of a file do we have any other use of USROPN?
during input operation which indicator position is seton if there is a record lock?
How can we arrange duplicate records in a file?
how can a cgi check whether an ifs object is available?
how you will find an error which is not in the first page of the subfile without using rolldown key?
what would be the effect on the field where reverse image, underline and highlight display attributes were active?
what is the difference between packed decimal and zoned decimal?
is their a difference in cobol400 for the release 5.2 and 6.1 at the as400.
what is the purpose of the indara keyword?
what is the maximum number of fields under a record format of physical file?
is it possible to create a physical file without dds?