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

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 / surya siram

5 Answers
9868 Views
I also Faced
E-Mail Answers

Answer Posted / surya siram

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

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

what are the different opcodes available in rpg for database access ?

1772

how can I control from my cgis the cache of a remote browser?

1222

What is the Difference between command attention key and command function key ?

1431

what is the maximum number of fields under a record format of physical file?

1957

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

2496

how can you detect and handle a record lock situation?

2065

what is sflrolval?

1129

what is the necessary keyword for non-join logical file?

1886

what is a spool file?

1189

how can I start a page in a new window?

1275

Difference between NOPASS & OMIT?

1940

How to add 99 menu (page down) option in menu creation..

2415

How can we arrange duplicate records in a file?

1134

how will you display a particular page in subfile ?

1760

WHAT is STORED PROCEDURE CONCEPT IN AS400 WITH EXAMPLE?

2578