DB400 Interview Questions
Questions Answers Views Company eMail

How to read a pf in reverse(from last record to first) using cl?

780

What is the interactive job? What is the batch job?

755

What is the difference between access path and open data path?

791

I have a pf, it contains 5 members, how to access particular member data from logical file?

709

There is one string as A B C and wanted to display string as Shri A Shri B Shri C, how we can do this in sql? If we have around 100 values in string like this, each value should be displayed with initials as Shri.

913

What is FORMAT keyword and its use?

362


Post New DB400 Questions

Un-Answered Questions { DB400 }

How to know the particular record in pf with out reading?

760


How to read a pf in reverse(from last record to first) using cl?

780


Last statement of any rpg program is lr?

800


In a CL Program after executing a SQL SP how to receive a Output value from the SP. Just to make it clear I am sending 2 input and 1 output parameter to the SQL Stored Procedure. Now while receiving it output parm it is failing.

2309


I have a pf, it contains 5 members, how to access particular member data from logical file?

709






What is the batch job?

745


How to retrieve a physical file after deleting that?

741


What is the interactive job? What is the batch job? How to change the batch job to interactive job?

784


What is the interactive job? What is the batch job?

755


Suppose I have a pf, it contains 5 members, how to access particular member data from logical file? What is the use of member in pf?

785


What is the interactive job?

751


What is the purpose of the chain and setll and setgt?

777


How many maximum record format a logical file have?

743


Suppose I have a pf,it contains 5 members,how to access particular member data from logical file ?and what is the use of member in pf?

805


What is the use of member in pf?

733