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

Any change in service program we write binder language to allow signature change,What is the maximum number of signature change allowed in RPGLE?

3 Answers   Syntel, Tech Mahindra,

Hello, I have created a CMD type object. In one of the fields in Display file , I would like to see All the Source files present by pass the name of Library. Tried using CHoice(Keyword) and Choicepgm on PARM , but doesn't seems to be working. Any help please..

0 Answers   BlackRock,

What Is The Purpose Of The "n" In The Following Calculation Specification?

0 Answers   IBM,

what is multijoin logical file? what are the keywords available in joinlogical file? what are the mandatary keywords for joinlogical file? explai the keywords?

2 Answers   HCL,

Difference Between Interactive & Batch Job?

0 Answers   IBM,




what is rpg ?

1 Answers   IBM,

how many printer files maximum can be used in single rpg program?

0 Answers   IBM,

What is the purpose of OVRATA keyword ?

1 Answers  

define the purpose of the iter operation?

1 Answers   IBM,

When does the DFT keyword in PF be used?

1 Answers  

what is the difference between normal upddta to pf and updating using dfu program?

0 Answers   IBM,

What is Group Job?

1 Answers  

For more IBM AS400 AllOther Interview Questions Click Here
Categories