Interested to Buy Any Domain ? << Click Here >> for more details...
Which command we can use to update a physical file using c.l pgm?
- 19 Answers
- 52305 Views
- Ocwen, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
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 |
Answer / john
i am sure cant update database file through clp.........
| Is This Answer Correct ? | 0 Yes | 3 No |
what is xfoot opcode ?
How to retrieve data from data area?
what is the command to rtrieve system date? options:1.rtvsysval 2.rtvjoba 3.rtvjobd 4.both a and b
What Is The Purpose Of The "n" In The Following Calculation Specification?
List the steps/commands necessary to accomplish the following: a. Copy data from the file ORDHDR into file ORDHIST b. The file ORDHIST may or may not exist c. If the file ORDHDR does exist, it may or may not contain data d. The file ORDHIST may or may not contain data, if the file does contain data the old data should be erased
the output from my cgi is correctly interpreted by ms internet explorer, whereas netscape navigator would display it as a plain text. What should I do to have also netscape interpreting the html output from my cgi?
is it possible to create a physical file without dds?
What is logical file in as400? What are the types of logical file?
how many specifications are there in rpg/400? What are they?
in conjunction with which statements can orxx and andxx conditions be used ?
Hi, can you plz tell me ...syntax for GET command in FTP & SFTP is same or different???
How to declare the length of emp no in the physilcal file and the mandatory length is 6 i.e. Emp No should be numeric, mandatory and fill all the 6 places
RPG400 
