Try using this stmt :- UPDATE TT SET TT = SUBSTR(TT,1,6) || 'Y'

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....?

Question Posted / sachin

5 Answers
9431 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

Please Help Members By Posting Answers For Below Questions

What is file access opcodes?

1279

WHICH REPLY CODE IS USED BT sftp ? ... (e.g.226 is used by FTP IF FILE IS TRANSFERED)

2110

why is as/400 called object oriented machine?

1610

what is the disadvantage of using global variable?

1142

what is elastic and non elastic subrile?

964

when should I use method get, and when should I use method post in my cgis?

1072

what are the important factors in error message subfile ?

960

Explain The Keywords Edtcde & Edtwrd?

1331

can anybody give the interview questions list of RLU. plz mail me: dinesh_sati07@yahoo.com

2649

define a shared access path?

1641

maximum number of subfiles that can defined in a rpg program for one display file is?

1903

what is the use of sflend keyword?

1772

how do you pass parameters in cl?

1723

Difference Between Call & Sbmjob?

1229

what is the length of a variable in rpg?

1605