DB400 Interview Questions
Questions Answers Views Company eMail

what is open data base command

Active Brains, Cognizant, CSC, CTS,

1 3113

what is exception and how many types of exception

Active Brains,

1 4136

what is error handling concepts in cl

Active Brains,

3 6197

I have a PF with out any data but the dependent LF is having data?

HCL,

1 3727

When we use any keyword like FIFO,LIFO, at file level but whenever we check by runqry we couldn't find answer in FIFO,LIFO,FCFO etc so how we check the answer.

2 3623

How many libraries can be there in a library list?

2 2633

how to add a new field to a file without compiling it?

1 2049

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

797

How to update physical file using logical file with example?

812

Why journalling is compulsory before commitment control?

1 1628

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

813

I have physical file with 100 records,there is no any duplicate records in this pf.based on this pf one logical file I have used.but this lf is viewing only 80 records only of that pf?what is the reason for this?

895

I had created one physical file tell me command to enter data in to?

1 1358

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

806

How to find the list of source physical files in a library?

845


Post New DB400 Questions

Un-Answered Questions { DB400 }

When we create a pf and did not fill up maint parameter, then by default which access path will the system take & why?

797


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

806


I have physical file with 100 records,there is no any duplicate records in this pf.based on this pf one logical file I have used.but this lf is viewing only 80 records only of that pf?what is the reason for this?

895


What is the interactive job?

787


What is the batch job?

769


How to find the list of source physical files in a library?

845


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

794


What is the use of member in pf?

771


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.

2348


How to update physical file using logical file with example?

812


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?

835


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

813


What is FORMAT keyword and its use?

394


Last statement of any rpg program is lr?

837


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

820