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
- 16509 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 |
1.Load an runtime array of length 99 from the pf and you want to handle all the possible errors?
I want to declare the number of elements of an array dynamically in RPGLE ? Is it possible? If yes, then how do I do it ?
Hello, I want to extend a length of field in my Display file(Subfile). Please suggest the possible steps. Thanks
Difference between creating a report using Printer file and WRKQRY(Query Report) ?
How to declare the pull button in AS/400..
Are all these RPG/400 Interviewed Questions being asked recently? are current?
what is plat file?
Please tell me how to read the records from a file with load an array of size with error conditions(The logic answer for this question is ARR is array of 99 elements Z-ADD 0 IDX *LOVAL SETLL FILE READ FILE 99 *IN99 DOWEQ *OFF IDX ANDLT 99 ADD 1 IDX MOVE FIELD ARR,IDX READ FILE 99 ENDDO).So,Please give me the complete of this code.
i want to retrieve record b/w 2 dates in as400
what happens when sflsiz = sflpag? What are the advantages and disadvantages?
difference between 1:%found and %equal built function in detail with example .
Im traying to get out put of this below mention simple logic code.But im geting out of different.(im trying with my laptop trhough my company server. DCL &FIELD1 *CHAR 10 VALUE('TCS AS/400') DCL &FIELD2 *CHAR 10 CHGVAR(%SST(&FIELD2 1 10))(%SST(&FIELD1 10 1) Can you tell me the value of field2 after excuted of CHGVAR command.
RPG400 
