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
I need to insert a record in a file using STRSQL containing the some field values same as an already existing record in that file.I know to smple insert mentioning those values one by one.But is there any another query can be prepared for the same .Please share the query if known to you. Thanks in advance.
what is the use of dspatr(mdt) keyword?
Hi,Please give me the the answer for these quesitons? 1.what is IFS and ICF and RAPE amd DISKET fils? explain with example please? 2.What is the difference between POST AND SPACE OPCODES? 3.Can anybody tell me default printerfile command and object type?
http default port 80 is used by some other production http service. How can I create an http instance on another port to run cgidev2 and my future cgi developments?
describe the difference between the dowxx and douxx operations?
What is program status data structure(psds) in as400?
what is procedure prototype and procedure interface.
the maximum number of subfiles that can be active for a single file is ____ .
which are the string manipulation opcodes?
what is sflpag and sflsiz ?
what is the difference between udate and the system date?
what are the different types of data areas?
what does opcode post do ?
what is message file?
define what a data area is along with a brief example of what it may be used for?