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

1.what operation cannot be used in conjunction with file coded as divice type disk? 2.Difference between INCLUDE AND COPY?

1 Answers  

during input operation which indicator position is seton if there is a record lock?

1 Answers   IBM,

Define a Batch Job?

1 Answers  

WHAT IS FERERENTIAL INTRIGRITY ?

0 Answers  

What is a Member?

1 Answers  




can anybody give the interview questions list of RLU. plz mail me: dinesh_sati07@yahoo.com

0 Answers   HCL,

Why would you prefer OPNQRYF than logical file?

1 Answers  

What is left outer join?

2 Answers  

what is service program?

0 Answers   IBM,

how do you specify the number of records to roll in a subfile ?

2 Answers   IBM,

What is the symbol used for shifting fields in SDA?

1 Answers  

Define each of the following operation codes a, b, c, d, e

1 Answers  

For more IBM AS400 AllOther Interview Questions Click Here
Categories