Answer / swadesh.yadav

Suppose i have a file 'ABC' and i want to know that how
many fields,how many records,when it was created,when was
last used,its access path ,trigger,journal,total member
these file have- with DSPFD command we can findout easily.

Suppose anyone want to know about there field in detail(i.e
name of the field also)we use DSPFFD b'cos DSPFD is not
diplay it field name.

In brief,DSPFFD is not able to findout-Trigger
name,Journal, Access path,Key field but DSPFD can find it.

How can we find out whether the job is interactive or Batch through RPG program? 2) How can we find out through CL program?

6 Answers   CSC,

---

what is the difference between the cpyf command crtdupobj command?

9 Answers   IBM,

---

what r drawbacks of OPM? Why do we go for ILE RPG?

1 Answers  

---

1.What is referential Integrity? 2.What is Foreign Key? 3.What is Transfer Control? 4.What is Free format?

3 Answers  

---

Suppose in CL we reach at end of file and again we have to reach from 1 record

3 Answers   TCS,

---

i hav 2 logical files(L1,L2) both r derived from one physical file(P1). how can i use both the logical files in one RPG program? if yes what i have to d.

5 Answers   TCS,

---

1)how to do date validation in rpg? 2)how to delete dUPLICATE RECORDS?

12 Answers   IBM, Opus,

---

Can any one plz explain the concept of INFSR, *PSSR, INFDS AND PSDS, I' confusing about PSDS and *PSSR, Wat is the difference btw them, wat PSDS will do????

1 Answers  

---

i 'm new to as/400.in an interview i was asked this question.give a practical example for passing information or data through local data area. I know only that data area is an object used to store tiny bits of data or it can store one value at a time and it is used to store frequently changing values or datas.thats all i know about data area can any one tell me how local data area and user defined data area are used to pass data between jobs with a example or coding.thanks in advance.

2 Answers   CTS,

---

There is a excel sheet having details of Old account number and new account number. I need to update these details in my AS400 files. i.e. all the records having old account number should be replaced with new account number. There can be 100 or 200 or 300 PFs...no fix files known. how can we do this?Solution should be performance oriented

3 Answers   Cap Gemini, IBM,

---

Suppose i am having 3 programs PgmA,pgmB,pgmC and using source debugger. At debugging time i found that pgmC having some code error..then in debug mode directly how can i debug pgmC

2 Answers  

---

Can you copy the records created by the OPNQRYF to other files and how?

2 Answers  

---