suppose if we want to update the data in cl what we will do?

Categories >> Software >> MainFrame >> IBM AS400 >> RPG400
Suggest New Category

Question Posted / sony

9 Answers
16268 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

suppose if we want to update the data in cl what we will do?..

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

suppose if we want to update the data in cl what we will do?..

Answer / chandu

Use RUNSQLSTM to update data in CL.

Is This Answer Correct ?

8 Yes

1 No

suppose if we want to update the data in cl what we will do?..

Answer / ali

we can updateby executing SQL update statements in CL

Is This Answer Correct ?

6 Yes

0 No

suppose if we want to update the data in cl what we will do?..

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

suppose if we want to update the data in cl what we will do?..

Answer / chitta

we cannot update data through cl

Is This Answer Correct ?

4 Yes

2 No

suppose if we want to update the data in cl what we will do?..

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

suppose if we want to update the data in cl what we will do?..

Answer / suri

UPDATE IS NOT POSSIBLE IN CL.

Is This Answer Correct ?

3 Yes

4 No

suppose if we want to update the data in cl what we will do?..

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

suppose if we want to update the data in cl what we will do?..

Answer / jhansi sundar

We can update the records in cl by using upddata.........

Is This Answer Correct ?

5 Yes

8 No

Post New Answer

More RPG400 Interview Questions

The PGMA calls PGMB.PGMB generates a report.The report should contain the called program name(PGMA).How do i get the called program name in PGMB to print it on the spool file?(calling program name should NOT be hard coded or passed as parameter to called program?

6 Answers

i want to retrieve record b/w 2 dates in as400

2 Answers L&T,

Can a indexed file be accessed in arrival sequence in RPG?

1 Answers

Anyone help me for the below question:- If problem/error occur in *PSSR subroutine,how should I handel it in RPG program.

1 Answers

Hi, Can anybody give me real sinario for SFLRCDNBR?with example?

2 Answers

if i have three programs progA,progB and progC .now i call progB from progA. but the progB does not exist . now i want to call progC instead of starting dump. how can we achieve this.

10 Answers Four soft,

can anybody explain significance of *loval setll with example code????

3 Answers HSBC,

HI, 1: WHAT IS THE FUNCTION OF %KDS?WITH PROGRAMMING CODES EXAMPLE 2: WHAT IS THE FUNCTION OF Z-ADD AND Z-SUB ? WITH PROGRAMMING CODES EXAMPLE

1 Answers IBM,

how to run only 10 modules of existing N modules in service program in RPGILE ?

3 Answers Wipro,

Interviewer asked me write down DDS for load all subfile .can anybody write dds

0 Answers

Hi all friend, Could Any body send me the code (with coding) of this senario because I have tried but I am stucking somewhere so Please reply ASAp with coding. senario:Q: I have to write the flat file(FLAT1) into the three different PFS (PF1,PF2 and PF3) with the respect of H line data, D line data and Z line data of flat file. where I have different data in flat file(FLAT1) which is mentioned below with data. H0929200909282009092820095529420003000073 D2222220006765555webservi001633.9909222009092820090924200951 8564380134049ROSNER TOYOTA OF FREDE FREDERICKSBURVA 224080000USA840840001633.99001633.99851856492689800208001915 511001633.990408490000000.0000000003446048 1,3 110793145 09070700351 372367 Rosner Motors D3333320006774444webservi000271.2409222009092820090924200951 8564380134049ROSNER TOYOTA OF FREDE FREDERICKSBURVA 224080000USA840840000271.24000271.24851856492689800208001835 511000271.240930680000000.0000000003450293 1 110793254 09072100079 373933 Rosner Motors Z0929200900000020001905.25 FLAT1 has the three pf data H line-represents the header pf data,D-Represent Details pf data,Z-Represents the trailer pf data Now I have to write H line data of flat file into Header pf (PF1),D line data of flat into datails pf(PF2) and Z line data of flat file into pf(PF3) with the spefic position(H,D and Z data of flat file into PF1, PF2 and PF3) of flat file.

4 Answers IBM,

how do u find whether a record is locked or not??/

5 Answers CTS,

For more RPG400 Interview Questions Click Here