1. Categories >> Software >> MainFrame >> IBM AS400 >> DB400
  2. Suggest New Category

Is Constent can be define as a key field?

Question Posted / pankaj

Answers were Sorted based on User's Feedback



Is Constent can be define as a key field?..

Answer / praneetha

Firstly a Constant cannot be a part of a File field list.
There is no meaning in having a Constant in the Key field.

Is This Answer Correct ?    5 Yes 0 No

Is Constent can be define as a key field?..

Answer / ravi

No, Constant can not be define as a key field.
Constant can not be the part of file field.

Is This Answer Correct ?    1 Yes 0 No

Is Constent can be define as a key field?..

Answer / syam

No, But you can give a constent Value in physical file
field and you can specify that field as a key field.

In PF

A XXXXX 20 Value("MYNAME")
yyyyy 6 0
Kxxxxx

Is This Answer Correct ?    3 Yes 3 No

Post New Answer

More DB400 Interview Questions

Hi, Please give the answer to this question? I have Phisical 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?Please give me answer?

4 Answers   IBM,

what is dynslt and why we use that command when do we use command

2 Answers   Active Brains, UHG,

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.

0 Answers   Nous,

Define interactive jobs and batch jobs

6 Answers  

A pf containing 100 records... my query is how to display from 11th record in the pf?

3 Answers  




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.

0 Answers  

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 Answers  

how can i know logical file belongs to which physical file without source?

3 Answers   Cap Gemini,

What is the interactive job?

0 Answers  

one physical file can have how many max of logical files? what is the primary file?

3 Answers   Four soft,

Can anybody tell why Journalling is compulsary before Commitment Control?

2 Answers  

how can we write LF using flatfile.

9 Answers  

For more DB400 Interview Questions Click Here
Categories