Interested to Buy Any Domain ? << Click Here >> for more details...
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....?
- 5 Answers
- 9528 Views
- I also Faced
- E-Mail Answers
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 would be the effect on the field where reverse image, underline and highlight display attributes are active ?
WHAT IS DECIMAL DATA ERROR IN RPG IV...WHEN WILL IT HAPPENS?
What is the Function of PDM?
What is the purpose of the following FORDHDR1 CF E WORKSTN $2SFN SFILE FMT2
What is the function of RJE Conversion Utility?
what is the use of dspatr(mdt) keyword?
How do you grant authority?
how to develop some simple graphs (bar charts) using just html?
What is the symbol used for copying & moving new field in SDA?
how you will find an error which is not in the first page of the subfile without using rolldown key?
What is the Difference between command attention key and command function key ?
is it possible to create a join logical file using two join logical files ? give exact reason for your answer
RPG400 
