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....?
Answer Posted / brave
Update <Table> set <field> = Substr(<field>,1,5)
||'Y'||Substr(<field>,7,6) where <Condition>
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
what are the different methods to access seu?
what does defn do?
what do we can do with the embedded sql statements?
What Is The Purpose Of The "n" In The Following Calculation Specification?
Why we are not able to perform insert delete and update operation in Join logical file?
What is %CHECK?
How we will get issues on AS/400 technology ? I mean which issue/Defect Tracking tool is using in all companies when any issue comes? Can anybody explain about the work flow of AS/400 project ? plzzz
what is *iso date format?
what is the use of jdftval in join logical file?
What is diff between EVAL & MOVE?
In 'o' Specs What Is The Opcode For Write?
how can you detect overflow for a print program that prints multiple lines per cycle?
what is sflpag and sflsiz ?
What is the difference between iter and do? We know both are used to execute set of statements repeatedly, but what is the main difference?
what is full form for dds?