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


suppose if we want to update the data in cl what we will do?

Answers were Sorted based on User's Feedback



suppose if we want to update the data in cl what we will do?..

Answer / shanky

We can update records in CL program but its only possible
through SQL statement in CL

In STRQMQRY command we can write SQL statement at SETVAR(
Update &FILE set FILED=' ' where &FILED='Key Value'


........There are many PDFs on google from where u can get
ready programs....................

Is This Answer Correct ?    7 Yes 0 No

suppose if we want to update the data in cl what we will do?..

Answer / ali

we can updateby executing SQL update statements in CL

Is This Answer Correct ?    6 Yes 0 No

suppose if we want to update the data in cl what we will do?..

Answer / chandu

Use RUNSQLSTM to update data in CL.

Is This Answer Correct ?    7 Yes 1 No

suppose if we want to update the data in cl what we will do?..

Answer / afnas

Suppose want to update data in cl pgm perform SQL or call
RPG program , update the data using RPgG pgm then return
the value

Is This Answer Correct ?    4 Yes 0 No

suppose if we want to update the data in cl what we will do?..

Answer / chitta

we cannot update data through cl

Is This Answer Correct ?    4 Yes 2 No

suppose if we want to update the data in cl what we will do?..

Answer / shashank jain

We all know that in CL we can execute command line commands
so simply
write
''UPDDTA filename ""

in cl program and you can update your pf.

Is This Answer Correct ?    1 Yes 1 No

suppose if we want to update the data in cl what we will do?..

Answer / surya siram

Normally we cannot update the data in physical file by using CL program, But by using RUNSQLSTM or RUNSQL commands we can run the sequel to update the data in physical files.

But we can update the data in display file using SNDRCV command

Is This Answer Correct ?    0 Yes 0 No

suppose if we want to update the data in cl what we will do?..

Answer / suri

UPDATE IS NOT POSSIBLE IN CL.

Is This Answer Correct ?    3 Yes 4 No

suppose if we want to update the data in cl what we will do?..

Answer / jhansi sundar

We can update the records in cl by using upddata.........

Is This Answer Correct ?    5 Yes 8 No

Post New Answer



More RPG400 Interview Questions

Hi guys, anybody know How RPG/400 code can be converted to RPG IV code with a single command?

1 Answers  


What is the RPG cycle?

3 Answers   CSC,


what is the difference between do while and do until?

0 Answers   IBM,


Q:HI friends accually ihave one problem plesase let me know the alternate code of this code. Related field description of code: Add a field, CALvsPRD, "Calendar Day Starts Before/After Production Day" to the parameter set WRKORDER which accepts values 'A' or 'B' o B = Calendar Day Starts Before Production Day o A = Calendar Day Starts After Production Day o Any other value indicates the production and calendar dates are always the same. code: Automatic Execution Of *INZSR Subroutine /Z01 * retrieves WRKORDER field values. /Z01 * Calculate default Production Date and return it to caller. /Z01 * Production date defaults to system date /Z01 C Eval P@Pdate = %DATE() /Z01 * unless Calendar date starts Before PDN(production) date and /Z01 * system time is before PDN Start Time then /Z01 * PDN date is yesterday. /Z01 C If W@CALvsPRD = 'B' and /Z01 C %TIME() < %TIME (W@Strtime) /Z01 C Eval P@Pdate -= %Day(1) /Z01 * unless Calendar date starts After PDN date and /Z01 * system time is *GE PDN(production) Start Time then /Z01 * PDN date is tomorrow. /Z01 C ElseIf W@CALvsPRD = 'A' and W@Strtime > *Zero and /Z01 C %TIME() >= %TIME (W@STrtime) /Z01 C Eval P@Pdate += %Day(1) /Z01 C EndIf /Z01 C Eval *InLr = *On

0 Answers   IBM,


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

4 Answers   IBM,






are there any useful c runtime apis that I can call from rpg iv?

0 Answers   IBM,


What is the difference between inner join @ outer join

4 Answers  


difference betwen keywords and opcodes

3 Answers  


we are sending data of physical file to screen design and it is showing no record why?

1 Answers   NTT Data,


1.CA(command Atention key)& CF(command Function key) difference with example?Please can any body tell me in real time exp? 2.Can any body tell me some mandatery function keys using while creating any screen with use of SDA-FUNCTION kEYS?

5 Answers   HCL,


1. If my rpg program has a date field, What extra care I have to take while compiling that RPG program? 2. If the file is keyed and I have declared the file as well as Key list properly in my program. Still am getting an error message like "Chain/reade operation is not allowed" What may be the case?

6 Answers   Virtusa,


in rpg could u please tell me errors types and meanings like 3030 that ....

1 Answers   EXL, UHG,






Categories