Answer / gagan44

Multiple occuerence data structure is a data structure in which multiple oocurence of the data are defined .
It is similiar to a 2-D array.
For Eg: a 2-D array is defined as:
ara1 ds dim( 99 ) qualified
d ara2 10a dim( 99 )
d ara3 10i 0 dim( 99 )

If Multioccurence data structure is defined in same way then it would look like this:
DS1 ds Occurs( 99 )
d FLD2 10a dim( 99 )
d FLD3 10i 0 dim( 99 )

Why there is invention of RPG if we can do insert update delete in CL through SQL.Why the rise of RPG?

1 Answers   Infogain,

---

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

0 Answers  

---

1) How to declare a file? 2) How to define a display file? 3) How to monitor error messages in RPG? 4) How to find the attributes for subfiles? and what is the DDS for subfiles?

2 Answers   TCS,

---

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

1 Answers  

---

Thanks gagan for your answer,i'm new to as400,i don't know embedded sql in rpg.can you send me the coding for the below mentioned question in embedded sql rpg. how to retrieve particular field records from a physical file,say i have a physical file called 'employee' in it i have to retrieve the records of a field 'admin' present in pf 'employee' using rpg,but i should not use logical file or openquery file.

2 Answers   iGate,

---

wat is scan and check ? give me real time scenarios where we used these keywords in ur projects?

2 Answers   Four soft,

---

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

5 Answers   CTS,

---

How do you find whether a record is locked or not?

2 Answers  

---

can we use cl programming to update or delete physical files

12 Answers  

---

How can we read a particular record from the database file which is not having DDS (Flat File). For example, there are 100 records in the flat file. How can we retrive 15th record in RPG/400 program (Without using CL)

6 Answers   CTS, IBM,

---

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.

2 Answers  

---

1. If my rpg program has a date field, What extra care I have to take while compiling that RPG program? 2. If the file is keyed and I have declared the file as well as Key list properly in my program. Still am getting an error message like "Chain/reade operation is not allowed" What may be the case?

6 Answers   Virtusa,

---