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
- 9874 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 is the purpose of the "N" in the following calculation specification? C KEY CHAIN FILE N 99
Can anybody please tell me what is difference between SQL (STRSQL ) and WRKQRY .....?
how do you know that records are locked?
how can we run a batch job?
What does SDA stands for ?
Which is better LF or OPNQRYF ? When should we use LF and when should we use OPNQRYF ?
how do we know batch job aborted after we submitting it
what is the use of data structures?
what are all the contents of subfile?
WHAT IS FERERENTIAL INTRIGRITY ?
where exactly we can use OPNQRYF ?
how do you specify the number of records to roll in a subfile ?
RPG400 
