suppose if we want to update the data in cl what we will do?
Answers were Sorted based on User's Feedback
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
|Is This Answer Correct ?||7 Yes||0 No|
Answer / ali
we can updateby executing SQL update statements in CL
|Is This Answer Correct ?||6 Yes||0 No|
Answer / chandu
Use RUNSQLSTM to update data in CL.
|Is This Answer Correct ?||7 Yes||1 No|
Answer / afnas
Suppose want to update data in cl pgm perform SQL or call
RPG program , update the data using RPgG pgm then return
|Is This Answer Correct ?||4 Yes||0 No|
Answer / chitta
we cannot update data through cl
|Is This Answer Correct ?||4 Yes||2 No|
Answer / shashank jain
We all know that in CL we can execute command line commands
''UPDDTA filename ""
in cl program and you can update your pf.
|Is This Answer Correct ?||1 Yes||1 No|
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|
Answer / suri
UPDATE IS NOT POSSIBLE IN CL.
|Is This Answer Correct ?||3 Yes||4 No|
Answer / jhansi sundar
We can update the records in cl by using upddata.........
|Is This Answer Correct ?||5 Yes||8 No|
Hi guys, anybody know How RPG/400 code can be converted to RPG IV code with a single command?
What is the RPG cycle?
what is the difference between do while and do until?
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
Q1.How to read the Array? Q2.How to copy the content of one Array to another Array?
are there any useful c runtime apis that I can call from rpg iv?
What is the difference between inner join @ outer join
difference betwen keywords and opcodes
we are sending data of physical file to screen design and it is showing no record why?
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?
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?
in rpg could u please tell me errors types and meanings like 3030 that ....