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
- 9615 Views
- I also Faced
- E-Mail Answers
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
How can we arrange duplicate records in a file?
difference between sflrcdnbr and sflnxtchg?
What is the difference between physical file and logical file?
A join logical file has how many record formats?
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?
How can we change the uppercase to Lowercase in RPG?
how can you specify no duplicate key?
why is the declare cursor statement is used for?
How can we update a specific field in RPG?
the output from my cgi is correctly interpreted by ms internet explorer, whereas netscape navigator would display it as a plain text. What should I do to have also netscape interpreting the html output from my cgi?
What Is Default Data Type (if You Define Decimals '0') In Physical File?
how can I predict the performance of my cgis?
what does check opcode is used?
what does check opcode do ?
what is rpg ?
