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
52451 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 to inner join more than 2 PFs in a CL program using OPNQRYF command?

1 Answers

What is the benefit of using Externally Described files over Internally Described?

19 Answers IBM, Patni,

what are the different types of arrays?

1 Answers IBM,

Q. 1.What would be structure of CL PGM. 2. What are the levels of CL PGM. 3.How many files can be defined in new CLLE program?

3 Answers IBM,

Pgm A is invoked through HTTP. It is in Activtion group QILE. Pgm A calls Pgm B and Pgm C. Pgm B is in activation group TEMPACTGRP. Pgm A ends in error. Pgm A is called again. But it gives an error that TEMPACTGRP still exists and files are present in QTEMP. What is the cause and how will u fix?

1 Answers

what are different record spacing keywords in rlu ?

1 Answers IBM,

What is compiler directive in as400? Give example of compiler directive.?

0 Answers

how can we run a batch job?

0 Answers IBM,

What is RETURN CURSER LOCATION in subfile?

0 Answers

what is OUTFILE?what is the uses and disadvantage? where we can use this?

2 Answers

how do u compile rpgle program?