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


Please Help Members By Posting Answers For Below Questions

What is the Difference between command attention key and command function key ?

761


what is arrival sequence?

1090


define the rcvf command?

969


when would you use or not use this approach?

881


at what level s,o are defined and what they will do?

950






what are different record spacing keywords in rlu ?

1192


which indicator is used for read?

619


What Is Ddm ?

1018


what is the maximum number of record formats in dspf?

977


Hi,Please give me the the answer for these quesitons? 1.what is IFS and ICF and RAPE amd DISKET fils? explain with example please? 2.What is the difference between POST AND SPACE OPCODES? 3.Can anybody tell me default printerfile command and object type?

2070


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?

573


which type of object is used in db2/400?

638


What is the use of jdftval in as400?

898


What Is Default Data Type (if You Define Decimals '0') In Physical File?

1124


what are the basic features of seu?

603