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
- 9675 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 to develop some simple graphs (bar charts) using just html?
what are various techniques to pass parameters from one program to another?
what is the purpose of data structure?
list some of the commonly used commands for debugging?
can a single screen format occupy a screen area above and below a subfile format ?
define the purpose of the %sst function?
what are the three line types in rlu ?
Difference Between Interactive & Batch Job?
what do we can do with the embedded sql statements?
how many levels are there in a physical file?
can you specify a display file to be used in the following modes input,output, or combined modes ?
what are members?
what does dfu program you to do on a record?
what is the function of cpysplf command?
how can you check for a records existence without causing and i/o (chain/read)?
