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 |
how can i retrieve the field name from display file at run time? Devendra Singh Tomar
What is significance of a file designated as a Primary file in Rpg400 program....also what's use of secoundry file
1.The questions have given an array declaration and move operation then this statement is correct or not?
WHAT IS MEANT BY SIGNATURE VAILOTION ERROR
Interviewer asked me write down DDS for load all subfile .can anybody write dds
which program rpg or cl is efficent to update a transaction onto a database file and why ?
What are the necessary keywords required to code a message subfile?
What is the compilation option that has to he specified while compiling an RPC program which uses a file having date data type field?
can I touch the array during treatments?
two attributes which govern the excecution of a job>>>>??
How Chain operation copies the record's data to the input buffer for the program?
how many variables can we declare in cl pgm?