Which command we can use to update a physical file using c.l pgm?
Answer Posted / rajeev
We can not update a database file throught CL in a normal
way but if we use QSH then we can update or insert. Here I
am showing a exaple of insert.
QSH CMD('db2 "insert into $SCHEMA.$TABLE + VALUES(12,
5,''rajeev'', ''2009-11-24'',.2" ')
Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
during input operation which indicator position is seton if there is a record lock?
which of the following operations does not zero the field flda defined as 4,0?
How to add 99 menu (page down) option in menu creation..
what is the necessary keyword for non-join logical file?
Hi,Can any body give the code for the below mentioned quetion.?Im trying to get coding in with easily inderstanding.Plese give me the coding for this? 1.How would you achieve this requirement with out using RPG/RPGLE pgm,but by using only CL?Read a database file and display file contents on the screen when enter key pressed the next record should be displayed on screen.When the last record is reached or when F3 key is pressed the program should exit if the file is empty,a message should be displayed indicate that there are no records to display. Database file Name=EMPDBF Fields in EMPDBF to be displayed on screen Employee Number- EMPNUM(5,0) Employee Name- EMPNAM(30,A) Employee Address-EMP ADDR(50 A)
what is externally described file ?
what is meant by object lock requests,held locks and locks waiting to be applied(wrkobjlck) why should we apply for locks.Please explain sir.
what is *iso date format?
which are control break logic indicators?
what is the maximum number of parameters allowed in rpg?
http default port 80 is used by some other production http service. How can I create an http instance on another port to run cgidev2 and my future cgi developments?
how many printer files maximum can be used in single rpg program?
when are the referential constraints executed?
which are the query selection criteria, which can be given in a query?
when do you explicitly open files and close files in an rpg program?