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

Categories >> Software >> MainFrame >> IBM AS400 >> IBM AS400 AllOther
Suggest New Category

Question Posted / cyjil

19 Answers
52424 Views
Ocwen, I also Faced
E-Mail Answers

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

How can we change the uppercase to Lowercase in RPG?

0 Answers

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

0 Answers IBM,

what is the maximum number of parameters allowed in rpg?

1 Answers IBM,

Can we use OVRDBF command without using of OPNQRYF ? Or can we use OPNQRYF command without using of OVRDBF command ?

4 Answers HCL, iGate,

What is the exact difference between Service Program and Binding Directory?

1 Answers

what are dds required for subfile?

0 Answers IBM,

is it possible to do commitment control with out journaling?

1 Answers

In 'o' Specs What Is The Opcode For Write?

0 Answers IBM,

What is field reference file?

1 Answers

How to read 2 positions at a time in a data area? I have created a data area of length and i have to read the values of the data area like 91-92,93-94 at a time up till 100

3 Answers

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

0 Answers HCL,

I have SQLRPGLE program in which there are some update statements which executed correctly. there were no errors run time. Once the program gets over, the file was not updated with the new values. What might be the reason?

2 Answers

For more IBM AS400 AllOther Interview Questions Click Here