Sign Up Login


  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

what is a program described file in rpg?

1 Answers   IBM,

How I can read and display three fields in the record format DSPFM1 of the display file,while one field(using in one file) is NAME which is Key field in field reference file and another two fields are AGE and ROLL NO are using another file. Please send me coding part.

2 Answers   IBM,

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 a query can be displayed without saving it?

0 Answers   IBM,

What is the necessary keyword used in a physical file to refer field definitions from the field reference file?

1 Answers  

how to define to define a hidden filed in dspf ?

0 Answers   IBM,

what is the function of cpyf command?

1 Answers   IBM,

how can see logical file based on which physical file and vice versa

1 Answers   IBM,

What is the purpose of OVRDTA keyword ?

1 Answers  

What the purpose of the keywords FIFO, LIFO, FCFO?

1 Answers  

How to position the cursor on a display file at a desired location.

5 Answers   Four soft,

how many triggers can be associated with a file?

1 Answers   IBM,

For more IBM AS400 AllOther Interview Questions Click Here
Categories