i am using non join multiple format my 3 database file is like that pf97
R REC
ENAME
ETENNO
ESTATUS
K ENAME
pf98
R REC1
ENAME
ESAL
K ENAME
PF99
R REC3
ENAME
CRDCARD
EID
K EID
& MY NON JOIN LOGICAL FILE IS ALSO SAME EXCEPT RECORD NAMES
BEFORE I TRIED WITH 2 FILES SO ITS SAYS ERROR I.E.(Key field attributes must be same as for previous formats. ) SO I CHANGED KEYFIELD ACCORDING TO PF SO ITS WORKING BUT AFTER ADDING 3 FILES ITS SAYING SAME ERROR . I DONT KNOW I NEW IN AS400 PLLZ HELP ME I HAVE ONE MORE QUE. CANT BE USE DIFFERENT KEYFIELD (NOT ACCORDING TO PF) IN NON JOIN LOGICAL FILE.
- 1 Answers
- 1596 Views
- I also Faced
- E-Mail Answers
Answer / Manju
In IBM AS400, when you are using non-join multiple formats for your database files, the key field attributes must be consistent across all files. If you encounter an error while adding more files, it could indicate inconsistencies in the key fields. Ensure that all key fields have the same length, data type, and alphanumeric value. It's also important to adhere to the Physical File (PF) specifications for your key fields. If needed, consult the AS400 documentation or seek assistance from an experienced AS400 developer.
| Is This Answer Correct ? | 0 Yes | 0 No |
how do you read changed records backward in subfile?
What is the maximum number of times Multiple Occurrences DS can occur in a program?
What is the symbol used for copying & moving new field in SDA?
what is default data type for the fields(sub fields) defined in data structures in rpg?
Is LDA can be access accross the Job?
What is the exact difference between Service Program and Binding Directory?
different type of cursor?
when is a tag statement used in rpg?
which single rpg opcode performs both setll and reade?
How many record formats can you have in a Physical file and in a Logical file ?
what is pointer error in rpg IV?
How to see all members of a file?
RPG400 
