Answer / gss

Cursor we can define as pointer to the records of database
where we can fetch the records depending on varios
conditions or even sequential.

Answer / abhijeet m

Simple cursor (Only one fetch operation per record )and
Scrollable cursor (Can be moved up or down of cursor result
set)

Answer / kamal

declare cursor
open cursor
fetch cursor
close cursor

Answer / gagan

A cursor is a temporary area of storage that is used to hold the information that is retreived from the SQL select statements.A cursor is mainly used to point to the table retrieved as a result of select query.
Types of cursor :
Serial cursor: In this the rows retreived from the resulting table are in sequential order .Also once EOF is reached the cursor can not be repositioned
Scrollable cursor:In this the rows retreived are based on the position mentioned on the FETCH statement

What is file identifier where we can use?

0 Answers  

---

how can an indexed file be used as arrival sequence in RPG?

3 Answers   IBM,

---

I have learnt through Net that Debugging a Batch job involves 1. Submit the job with the HOLD (*YES) parameter: SBMJOB HOLD(*YES) or Hold the job queue that before submitting the job by using the HLDJOBQ command. 2. Determine the job name, user, and number of the submitted job by using the WRKSBMJOB command. 3. Type the Start Service Job command on your screen: STRSRVJOB JOB(job name/user/number) 4. Type the Start Debug command on your screen: STRDBG 5. Release the job in the jobq. Type WRKSBMJOB and then put a 6 beside the job to be released and press enter, or, if the job queue was put on hold, release the job queue with the RLSJOBQ command. 6. A display appears when the job is ready to start, saying that you can now begin debugging the job. Press F10 to show the Command Entry display. 7. Now you can start debugging by entering an Add Break Point command: ADDBKP 8.ENDDBG 9.ENDSRVJOB I tried this for RPG/400 Program and up to six steps of the above it's ok,but for me no source is displayed and i typed DSPMODSRC in Command line but still i can't see the sourceif i press F.10 and enter command ADDBKP i don't know how to add break points through it,usually i add break points using F.6 for Interactive job debugs,but since this is batch i don't know sir,Please help me out. I was asked this question in a interview,i know only RPG/400 and i’m asking for debugging of RPG/400 program only sir. or is it only possible to debug BATCH RPG ILE JOB and it is not possible to debug BATCH RPG/400 JOB kindly help me out sir

4 Answers   HSBC,

---

Can we have a Physical file without any member ? Please let me know

12 Answers  

---

Are all these RPG/400 Interviewed Questions being asked recently? are current?

1 Answers  

---

what is the difference between the procedure and module in ILERPG?

4 Answers  

---

Suppose we have one database file and it is used by 5 programs and in 3 program we have to add some records in datbase file s what is the impact on other program?

0 Answers  

---

how do u track msg in cl pgm???

1 Answers   CTS,

---

I know whole thing ab't Arrays related to declaration..can anyone tell me what exactly use of array or anyone faced a situation where he found use of array must....

1 Answers  

---

i have a file with the values 10, 20, 30, 40, if am setll with the value 25 then readp, so what it will return?

6 Answers   Mind Tree,

---

What does Implicit Open means with respect to a file ? What about the Explicit Open?..what are the major differences between these two?

1 Answers   IBM,

---

thanks mr.Harshad R Suryawaunshi,i'm new to as400 i think you are telling in rpgile i know only rpg400 if possible can you tell in rpg400

0 Answers   iGate,

---