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
52144 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

what are the necessary keywords for the join logical file?

2 Answers IBM,

some special characters I key in my html source members show different on my web pages. Why? How can I solve this?

0 Answers IBM,

what is flatfile?what is the use of this file?where we can use usualy?what is the advantage of this?

2 Answers Cognizant,

what are the parameters required for calling ls & get command(SFTP COMMANDS) from cl progtram.... I want to transfer files(using GET COMMAND) that are retrieved by LS command ...FROM 1 SYSTEM TO ANOTHER... STEP 1:LS-list all files...from remote system STEP 2:GET-actually transfer the files(listed in step 1) from remote system to local system & get stored in some Physical file....Plz reply in detail...Thanx

1 Answers EDS,

How we can delete all the Logical File of a Physical file in one instance ?

9 Answers IBM,

What is the purpose of the following C/COPY QRPGSRC, ORDERR

1 Answers

can we define multi-dimensional arrays in rpg ?

1 Answers IBM,

what is data structure?how many types of data structers?

4 Answers

What is the maximum number of key fields allowed defining in a physical file?

1 Answers

what is the function of cpysplf command?