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....?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / brave
Update <Table> set <field> = Substr(<field>,1,5)
||'Y'||Substr(<field>,7,6) where <Condition>
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / surya siram
UPDATE FF SET SUBSTR(RCD, 6, 1) = 'Y' WHERE SUBSTR(RCD, 6, 1) = 'N'
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / mahalakshmi
update file1 set file1 = 'AS400YDB2400' where file1 = 'AS400NDB2400'
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / 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 |
what is a program described file in rpg?
Difference Between Ca & Cf?
what are two types of record are used in subfile?
how do you specify page overflow indicator for printer files in rpg?
why we use binding directory and service pgm
what is clile code get last digit in numarice value
How do I release jobs in queue and change a job destination to a different printer. I know wrkjobq but I have not worked with As/400 for a while,so_can someone help me?
how to write code for singlepage in sqlrpgle with update ?
What are the types of data areas?
what are the two record formats a subfile contain ?
How many libraries can be there in library list ?
What is difference between fully procedural file and primary file?