Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


can we use cl programming to update or delete physical files

Answers were Sorted based on User's Feedback



can we use cl programming to update or delete physical files..

Answer / anish

Although there are no keywords to update or insert or
delete records in a CL program, we can do the same with the
help of a 'RUNSQLSTM' statement. With this command we can
runa query directly from the CL program and do an
insert/update/delete without calling an RPG program.

Plzz let me know if my understanding is corerct.

Is This Answer Correct ?    32 Yes 4 No

can we use cl programming to update or delete physical files..

Answer / saravan

We can clear file using CLRPFM command.
If we want delete PF we can use DLTF command.
But before delete any PF first of all we need to
delete all the LFs related in that PF.(DSPDBR=Display Data
Base Relations,we can get all LFs relating to that PF)You
must give the correct Library name for all the commands
above.
For UPDATE, DELETE & INSERT, use RUNSQL command.
Ex: RUNSQL (UPDATE LIBR/FILE SET FLD = 'XXX'
WHERE CONDITION)
Note: RMVM is to delete/remove a member from a file. But
not to delet a file completely.

Is This Answer Correct ?    18 Yes 2 No

can we use cl programming to update or delete physical files..

Answer / narender

No, you can access the records using the CL program but
can't perform any operation other then reading the records.

Is This Answer Correct ?    19 Yes 10 No

can we use cl programming to update or delete physical files..

Answer / chirag

Hi,

First you need to create a TXT source in which you need to
provie the update command.
Next in CL program you should use the command RUNSQLSTM on
this source(TXT).
So whenever you have to change another record you need to
simply change and save the TXT source.

Examply:

Data on file, PF1:
FLD1 FLD2 FLD3
000001 001 AAA BBB
000002 002 BBB CCC
000003 003 CCC DDD
000004 004 XXX ZZZ


Member1, Name: PGM1 , Type: TXT
UPDATE PF1 SET FLD3 = 'CHG' WHERE FLD1 = '004';


Member2, Name: PGM2 , Type: TXT
PGM
RUNSQLSTM SRCFILE(LIB1/SRCFILE) SRCMBR(PGM1) +
COMMIT(*NONE)
ENDPGM

Compile the PGM2 and call it.

Now Result for data on PF1
FLD1 FLD2 FLD3
000001 001 AAA BBB
000002 002 BBB CCC
000003 003 CCC DDD
000004 004 XXX CHG

Is This Answer Correct ?    9 Yes 3 No

can we use cl programming to update or delete physical files..

Answer / nirosh

We can clear all records from the physical file using
CLRPFM command. If we want delete PF we can use DLTF
command.But before delete any PF first of all we need to
delete all the LFs related in that PF.(DSPDBR=Display Data
Base Relations,we can get all LFs relating to that PF)You
must give the correct Library name for all the commands
above. I don't know how to update PF from the CL
programming.

Is This Answer Correct ?    7 Yes 2 No

can we use cl programming to update or delete physical files..

Answer / sree

ok friends what is use of "RUNSQLSTM"

Is This Answer Correct ?    6 Yes 1 No

can we use cl programming to update or delete physical files..

Answer / lama

We can not perform update operation by using CL

Is This Answer Correct ?    12 Yes 9 No

can we use cl programming to update or delete physical files..

Answer / kamal

YES BY USING RUNSQLSTM

Is This Answer Correct ?    5 Yes 2 No

can we use cl programming to update or delete physical files..

Answer / ismail

Yes, With the help of 'RUNSQLSTM' command, we can able to
update/insert/delete record in PF.

Is This Answer Correct ?    2 Yes 1 No

can we use cl programming to update or delete physical files..

Answer / dinesh

we can not update pf
using cl because there is no such
keward

Is This Answer Correct ?    3 Yes 4 No

Post New Answer



More RPG400 Interview Questions

What is SFLNXTCHG keyword why it has used and where? Briefly explain with Example.

2 Answers   IBM,


How can we receive values from a called procedure in CL?

1 Answers   IBM, NTT Data,


how many variables can we declare in cl pgm?

13 Answers  


Suppose we have 10 records with same name and we are reading using READE,after 4 record i have to use CHAIN what is the output

3 Answers  


How many program bind in one module....

0 Answers  






Job is in MSGW while reading the input file and writing a new record / updating a reacod due to Duplicate data error. What action would you take ( C D I R )...?

4 Answers  


Q1.How to read the Array? Q2.How to copy the content of one Array to another Array?

4 Answers   IBM,


steps for debugging two rpg programs????

4 Answers  


i want code and what are used key words are ...like wrkmbrpdm screen (q) i have a file with 3 fields empno,empname,empaddr... here you give the empno it displays from that number to remaining empno's how? sub file screen: employee details pos to:empno then enter empno empname empaddr so file have 100 records from 1 to 100 so the above pos you give the 55 empno...it displays the from 55 to remaining... ...... please share this answel

2 Answers   IBM,


How to get only unique records from a file which contains duplicate data using CPYF command ? Example : FILEA has duplicate records and FILEB is a UNIQUE defined.... and I want to get the data from FILEA to FILEB by eliminating all the duplicate records...

1 Answers  


what is the use of sflnxtchg?

0 Answers   IBM,


suppose we have 10 members in physical file and i have to use 4 out of 10 so how can we read this in RPG

3 Answers   TCS,






Categories