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
- 9429 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 an ICF file?
What is difference between fully procedural file and primary file?
what does the opcode free do?
What is the draw back of Procedures? why we are going to Modules?
what are the different commands used in rlu ?
how do you know that records are locked?
why is the declare cursor statement is used for?
4 persons a, b , c , d have to go to concert which will held in 17 minutes. there is a bridge which only 2 persons at a time can cross. its night and they have only one flashlight with them. Flashlight cannot be thrown. one person should return with the flashlight all 4 person have different speed. a = crosses bridge in 1 min. b = crosses bridge in 2 min. c = crosses bridge in 5 min. d = crosses bridge in 10 min how can they all reach in time.?? Ex- suppose a and d crosses bridge which will take 10 mins and then d returns back with a flashlight which will make 20 mins and mission is failed.
where can you specify an indicator in lokup operation?
What is primary file? How many primary file can be declared in a RPG program?
what are the uses of factor1, factor2 and result field for the rpg operation code parm?
difference between view and index ?
RPG400 
