DB400 Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

DB400 Interview Questions

Questions Answers Views Company eMail

what is open data base command

Active Brains, Cognizant, CSC, CTS,

1 3774

what is exception and how many types of exception

Active Brains,

1 4561

what is error handling concepts in cl

Active Brains,

3 7052

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

HCL,

1 4179

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 4184

How many libraries can be there in a library list?

2 3168

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

1 2606

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

1067

How to update physical file using logical file with example?

1058

Why journalling is compulsory before commitment control?

1 2001

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

1045

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?

1106

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

1 1732

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

998

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

1118

Post New DB400 Questions

Un-Answered Questions { DB400 }

How to index LF by relative record no (RRN)

3294

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.

1181

What is the batch job?

987

Last statement of any rpg program is lr?

1082

What is open data path?

1001

What is the use of member in pf?

992

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

1043

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

1045

How many maximum record format a logical file have?

991

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?

1124

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

998

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

1106

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

975

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?

1054

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

1067

For More Un-Answered { DB400 } Questions Click Here