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
- 52292 Views
- Ocwen, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / bharathi
We can not update files from CL programs. We can read files
from CL.
| Is This Answer Correct ? | 31 Yes | 6 No |
Answer / sidd
We can update physical files from CL program by either
usinf RUNSQLSTM or STRQMQRY
| Is This Answer Correct ? | 21 Yes | 3 No |
Answer / sumit
Everyone is saying we cannot update pf using Cl...But please
try once using RUNSQLSTM before marking 'NO' to any answers.
As we can update a PF using CL.
RUNSQLSTM uses source file where source member is present.
And this source member contain UPDATE SQL, OR DELETE SQL, OR
INSERT SQL.
RUNSQLSTM SRCFILE(LIB/QSRCPF)SRCMBR(SQLPGM)COMMIT(*NONE)
Once this statement run in CL then PF will get updated,
deleted or inserted with the new record.
| Is This Answer Correct ? | 11 Yes | 0 No |
Answer / anupam
Use of RUNSQLSTM helps in updating the physical file within
a CL program.
Syntax:
RUNSQLSTM SRCFILE(LIB/QSRCPF)SRCMBR(SQLPGM)COMMIT(*NONE)
SQLPGM should contain
UPDATE PF set DATA='Value' where DATA'='Value1' and it will
update the PF
| Is This Answer Correct ? | 8 Yes | 2 No |
Answer / 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 |
Answer / gaurav agrawal
In CL program we can not update the database file ,
we can read only.
if any doubt contact at gauravag.innovative@gmail.com
| Is This Answer Correct ? | 7 Yes | 3 No |
Answer / jaishriram
Did anyone tried to test Rajeev's Answer 13, Saying about to
update file using "QSH" ? Not sure....anyone gave a try.
But folks, it works. You know. He really discover a new way
of updating files from CL program.
Thanks Rajeev. Thanks a lot for sharing this tech info.
| Is This Answer Correct ? | 2 Yes | 0 No |
define what a data area is along with a brief example of what it may be used for?
how to convert date format from one format to another i think in CL/400 its CVTDAT,Please tell in RPG/400 sir not in RPGILE
Define the purpose of Factor 1 the Operation Code and *IN15 in following code HI LO EQ C *YMD Test(D) yymmddDate 15
How to Define a Procedure in RPG?
In 'o' Specs What Is The Opcode For Write?
A join logical file has how many record formats?
A phisical file has two fields like 1) Account No(10,0) 2)Phone No(15,0)Unique on both fields?Please give me the answer for this?
an access path may be in which sequence?
Which of the following operations does NOT zero the field FLDA defined as 4,0? C MOVE *ZEROS FLDA C Z-ADD *ZEROS FLDA C Z-ADD 0 FLDA C MOVE *ALL'0' FLDA C SUB FLDA FLDA C MOVE '0000' FLDA C CLEAR FLDA C MOVE *BLANKS FLDA
What is the maximum number of elements in an array?
can a indexed file be accessed in arrival sequence in rpg program?
What is primary file? How many primary file can be declared in a RPG program?
RPG400 
