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
52981 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 is the purpose of the "N" in the following calculation specification? C KEY CHAIN FILE N 99

1 Answers

what are the basic features of seu?

0 Answers IBM,

under given circumstances, my cgi should link to another site. How to implement this?

0 Answers IBM,

What is the purpose of 'CPYTOIMPF' command?

6 Answers Aditya Birla, Redington,

Can an indexed file be accessed in arrival seQuence in RPG program ?

1 Answers

what does dfu program you to do on a record?

0 Answers IBM,

What is the use of Data Queues?

1 Answers

Hi, can you plz tell me ...syntax for GET command in FTP & SFTP is same or different???

3 Answers

what would be the effect on the field where reverse image, underline and highlight display attributes are active ?

1 Answers IBM,

PGM QSH CMD('/QOpenSys/bin/sftp -b/home/test/myfile.txt serverUserID@server') ENDPGM In above example,what is content of myfile.txt ...Thanx

2 Answers

if dspatr(pc) and csrloc were specified for a format, which keyword would have priority?

1 Answers IBM,

what is the purpose of data structure?

1 Answers IBM,

For more IBM AS400 AllOther Interview Questions Click Here