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
52428 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 see all members of a file?

1 Answers

I need to insert a record in a file using STRSQL containing the some field values same as an already existing record in that file.I know to smple insert mentioning those values one by one.But is there any another query can be prepared for the same .Please share the query if known to you. Thanks in advance.

0 Answers CSC,

1.what are the builtin funtions in cl pgg?Explain with example 2.what is meant by left outer join?where we can use this?

2 Answers

Difference Between Skip Before & Space Before?

0 Answers IBM,

I want to run ls *.csv (sftp command) from CL Program... Can u plz tell me when SFTP command will start running? i.e.which command should I use in CL Program to run ls command?

2 Answers

What is access path in as400?

0 Answers

which are the member types which seu supports?

0 Answers IBM,

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

what are the two record formats a subfile contain ?

1 Answers IBM,

distinguish between terminating a program through seton lr and return?

0 Answers IBM,

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

1 Answers

how to get the particular field's records in CL without using OVRDBF,OPNQRY? tell me the concept?

2 Answers

For more IBM AS400 AllOther Interview Questions Click Here