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

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

Question Posted / cyjil

Answers were Sorted based on User's Feedback



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

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

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

Answer / swathi

can't possible to update/delete/change through CL PGM.Only we can read through CL PGM.

Is This Answer Correct ?    1 Yes 0 No

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

Answer / ramana

hi,

we can update data in cl, but we can use runsqlstm commance,

here if use select statement u canot select data, ucan
update dlelete

Is This Answer Correct ?    5 Yes 5 No

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

Answer / jeetu

we can not update batabase file through CL.it is possible through RPG by using UPDAT opcode.

Is This Answer Correct ?    0 Yes 1 No

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

Answer / swapan

we cant update from CL PGM.....rather we can do type RUNSQLSTM IN command prompt & from there we can go to the sql prompt for any changes required.

Is This Answer Correct ?    0 Yes 1 No

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

Answer / john

i am sure cant update database file through clp.........

Is This Answer Correct ?    0 Yes 3 No

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

Answer / cyjil

ranjini.. please tell the exact method

Is This Answer Correct ?    2 Yes 10 No

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

Answer / nagaraju

PGM
UPDDTA FILE(*LIBL/FILENAME)
ENDPGM

By Using above command we update pf in cl pgm.

Is This Answer Correct ?    6 Yes 28 No

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

Answer / ranjini

UPDATE

Is This Answer Correct ?    2 Yes 63 No

Post New Answer

More IBM AS400 AllOther Interview Questions

PGM QSH CMD('/QOpenSys/bin/sftp -b/home/test/myfile.txt serverUserID@server') ENDPGM Can u plz tell me what the above code do exactly?

2 Answers  

Can anyone answer me when we will go for LF without key fields

4 Answers   HCL,

what do we can do with the embedded sql statements?

0 Answers   IBM,

what is xfoot opcode ?

1 Answers   IBM,

WHAT is STORED PROCEDURE CONCEPT IN AS400 WITH EXAMPLE?

0 Answers  




What are Control level indicators?

1 Answers  

Can anybody know difference between SNDUSRMSG AND SNDPGMMSG IN CL PROGRAMMING? IF DON'T KNOW MAIL ME @ gkarthik.as400@gmail.com

3 Answers  

What Is The Object Type Of Pf, Lf, Printer File & Display File?

0 Answers   IBM,

How can we find from which source the program has been compiled for a given RPGLE program object?

5 Answers  

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

1 Answers   IBM,

Can be OVRDBF command mentioned after OPNQRYF command in CL?

1 Answers  

How can we read file using curser? how to define a curser?

0 Answers  

For more IBM AS400 AllOther Interview Questions Click Here
Categories