How to declare the length of emp no in the physilcal file
and the mandatory length is 6 i.e. Emp No should be
numeric, mandatory and fill all the 6 places

Answers were Sorted based on User's Feedback



How to declare the length of emp no in the physilcal file and the mandatory length is 6 i.e. Emp N..

Answer / syam

Use CHECK(MF) keyword in PF

Is This Answer Correct ?    5 Yes 1 No

How to declare the length of emp no in the physilcal file and the mandatory length is 6 i.e. Emp N..

Answer / pallavi

Syam is partly correct, but it will allow eventhough we
didn't specify any value for that field.

So we have to use mandatory entry along with mandatory field

Use CHECK(MF ME)

Hope this works fine.

Is This Answer Correct ?    1 Yes 1 No

Post New Answer

More IBM AS400 AllOther Interview Questions

what are two types of record are used in subfile?

1 Answers   IBM,


Define a Batch Job?

1 Answers  


I need to insert a record in a file using STRSQL containing the some field values same as an already existing record in that file.I know to smple insert mentioning those values one by one.But is there any another query can be prepared for the same .Please share the query if known to you. Thanks in advance.

0 Answers   CSC,


what are the different types of variables available in cl?

1 Answers   IBM,


What is the difference between physical file and logical file?

0 Answers  






what is the syntax for plist?

0 Answers   IBM,


Hi, can you plz tell me ...syntax for GET command in FTP & SFTP is same or different???

3 Answers  


How to avoid using indicators in ile ?

0 Answers   IBM,


how can we view the entire objects and its types in a pgm?

7 Answers   Mind Tree,


What the purpose of the keywords FIFO, LIFO, FCFO?

1 Answers  


What command must be executed before executing OPNQRYF command?

1 Answers  


What is GDA?

1 Answers  


Categories