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
- 9604 Views
- I also Faced
- E-Mail Answers
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
Can level check error occur if we do chgpf?
during input operation which indicator position is seton if there is a record lock?
how can a message from a message file appear as a constant on the screen?
what is the purpose of putovr (put with explicit override) keyword?
what is the function of cpyf command?
what would be the effect on the field where reverse image, underline and highlight display attributes were active?
what does check opcode do ?
how will you display a particular page in subfile ?
What is binder language ?
How to add 99 menu (page down) option in menu creation..
Difference Between Call & Sbmjob?
when would you prefer logical file than opnqryf?
what is scan and xlate?
i am using non join multiple format my 3 database file is like that pf97 R REC ENAME ETENNO ESTATUS K ENAME pf98 R REC1 ENAME ESAL K ENAME PF99 R REC3 ENAME CRDCARD EID K EID & MY NON JOIN LOGICAL FILE IS ALSO SAME EXCEPT RECORD NAMES BEFORE I TRIED WITH 2 FILES SO ITS SAYS ERROR I.E.(Key field attributes must be same as for previous formats. ) SO I CHANGED KEYFIELD ACCORDING TO PF SO ITS WORKING BUT AFTER ADDING 3 FILES ITS SAYING SAME ERROR . I DONT KNOW I NEW IN AS400 PLLZ HELP ME I HAVE ONE MORE QUE. CANT BE USE DIFFERENT KEYFIELD (NOT ACCORDING TO PF) IN NON JOIN LOGICAL FILE.
Difference Between Ca & Cf?
