Which command we can use to update a physical file using c.l pgm?

Answer Posted / madhusudhan

As mentioned above by Rajeev and Sumit, both the commands
will work. There is one more which i tried and it worked.

You can use the below way

RUNSQL STMT('Update LIB/File Set Field = "1" where Field
="2" ')
I have tried all the three ways and after working i am
posting it here.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what does the opcode free do?

1131


what are the limitations of cl (compare to rpg) ?

1552


Pose, there are 100 records in the file.i need to retrieve all the records matching/equal to the particular name field. How can we do the above using search criteria other than using the if cond?

600


what are dds required for subfile?

587


when is a tag statement used in rpg?

1367






can a indexed file be accessed in arrival sequence in rpg program?

951


what are the various types of device files?

999


What is array in as400? What are the types of array?

626


which are the string manipulation opcodes?

633


Write a logic program for knowing the repeated number of a vowels in a given program?

3313


What is compiler directive in as400? Give example of compiler directive.?

576


what is full form for dds?

745


how to read database records without locking them?

1143


how can a cgi check whether an ifs object is available?

643


Can level check error occur if we do chgpf?

778