1. Categories >> Software >> MainFrame >> IBM AS400 >> IBM AS400 AllOther
  2. Suggest New Category

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 / samul

Answers were Sorted based on User's Feedback



I have 1 rd in my flat file. say reord from 1 to 10 position : 'AS400NDB2400' I need to ..

Answer / 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

I have 1 rd in my flat file. say reord from 1 to 10 position : 'AS400NDB2400' I need to ..

Answer / brave

Update <Table> set <field> = Substr(<field>,1,5)
||'Y'||Substr(<field>,7,6) where <Condition>

Is This Answer Correct ?    3 Yes 0 No

I have 1 rd in my flat file. say reord from 1 to 10 position : 'AS400NDB2400' I need to ..

Answer / surya siram

UPDATE FF SET SUBSTR(RCD, 6, 1) = 'Y' WHERE SUBSTR(RCD, 6, 1) = 'N'

Is This Answer Correct ?    0 Yes 0 No

I have 1 rd in my flat file. say reord from 1 to 10 position : 'AS400NDB2400' I need to ..

Answer / mahalakshmi

update file1 set file1 = 'AS400YDB2400' where file1 = 'AS400NDB2400'

Is This Answer Correct ?    0 Yes 0 No

I have 1 rd in my flat file. say reord from 1 to 10 position : 'AS400NDB2400' I need to ..

Answer / murali

Update <FileName> set substr(<Field Name>,6,1) = 'Y' where
substr(<Field Name>,6,1) = 'N'

Is This Answer Correct ?    0 Yes 2 No

Post New Answer

More IBM AS400 AllOther Interview Questions

What is the purpose of SFLFOLD and SFLDROP keywords?

1 Answers  

what is code for reading member in rpgle when wehave like extmbr(*all) so we have 3 members in *all then i want to read first record in 2member

2 Answers   HCL,

what are activation group and what are its types.?

2 Answers   IBM,

Why do you use Keep and Assume Keywords.

2 Answers   Four soft,

What is SAA?

1 Answers  




Hi i have one question In my srvpgm one module ADDM is there now i want to add new module i.e SUBM , please answer me IN STEPS how to write bndlanguage and how it was attach to SRVPGM

2 Answers   IBM, Satyam,

Which command is used to replace CDUP command in FTP IF i WANT TO USE SFTP?

0 Answers   ITTI Pvt Ltd,

Can you summarize the steps I have to go through in writing my first cgi?

0 Answers   IBM,

How many primary files allowed in a program?

1 Answers  

how do you specify page overflow indicator for printer files in rpg?

1 Answers   IBM,

what is the use of sflend keyword?

1 Answers   IBM,

hi guys i am new for sqlrpgle, please suggest me good websites and theory and coding. plz plz its very urgent.

0 Answers  

For more IBM AS400 AllOther Interview Questions Click Here
Categories