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
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 |
explain sflclr, sflend, sfldlt, and sflcsrrrn?
what is an online rpg?
in a cl pgm records are copied to a file in qtemp a pgm is called to delete records from the file in qtemp no of records in file in library qtemp is checked wat shud be the count of records let say it was 10 initially endpgm
how does the rpg element work?
Delete FileName at first statement in RPG.
How to select highest score of each subject or how to select highest income of every month?
What is the OPEN and CLOSE accesspath?
how to display all the members records in a physical file without using ovrdbf?
Given the following code, what is the value of RESULT? DName+++++++++++ETDsFrom+++To/L+++IDc.Keywords+++++++++++++ D RESULT S 5 0 C EVAL RESULT = (2 + 3 * 2) ** 2 / 2
write an RPG program to calculate the marks of 5 students (A,B, C, D, E)in 3 different subjects (eng, math, sci) an display on the screen
what are the parameters of jobd?give in detail.&what are the parameters of subsystem...????
what is the equivalent keyword for CHAIN opcode ??