Interested to Buy Any Domain ? << Click Here >> for more details...
suppose if we want to update the data in cl what we will do?
- 9 Answers
- 16101 Views
- I also Faced
- E-Mail Answers
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
ready programs....................
| 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 / 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 |
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 / 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 | 2 No |
Answer / jhansi sundar
We can update the records in cl by using upddata.........
| Is This Answer Correct ? | 5 Yes | 8 No |
How to create a login screen using a command instead of display file.... intention is to get a password field on a command..... how do you achieve this...
what is kids-rpg?
1. I have2 records in a PF. READ PF DO DSPLY EMPNO RETRN DSPLY EMPNO ENDDO What was the output 2. SETON LR vs RETURN 3. Primary File 4. How to delete a deleted spaces 5. How to read a PF in reverse order in CL 6. I have a object in Lib A, B and C. But it shows in D Lib..Why? 7.
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
How to read alternative records in a pf by using rpg?
i hav 2 logical files(L1,L2) both r derived from one physical file(P1). how can i use both the logical files in one RPG program? if yes what i have to d.
What is the OPEN and CLOSE accesspath?
Anybody know the difference of primary file and full procedural file
How do you find whether a record is locked or not?
How can you determine the number of characters in a variable?
suppose i i am changing / updating record of subfile and i want to change the record in reverse order . means i want to change the bottom record first and so on through readc . how i do it please any one explain .
what is decimal data error? when it will come and how to achieve(rectify) this error please give me solution as well as code
RPG400 
