Home > IT Answers > Database > AS400-DML
rajeshece
1,025 pts.
 AS400-DML
DML, RNF2109 Error, RPGLE
I have created one table using CREATE TABLE Command and have added some datas in that table.i have defined that table RPGLE's File specification. FEmployee IF A E Disk . While compiling i am getting RNF2109 Error. Please help me to rectify this error?

Software/Hardware used:
ASKED: September 1, 2008  8:38 AM
UPDATED: September 3, 2008  2:33 PM
RELATED QUESTIONS
Answer Wiki:
The SQL creates a file with the record format named the same as the file. The RPG F spec should include RENAME(Employee : EmpRec) Then when you are adding a record you Write EmpRec.
Last Wiki Answer Submitted:  September 2, 2008  6:20 pm  by  philpl1jb   44,180 pts.
All Answer Wiki Contributors:  philpl1jb   44,180 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Since the concept of a record format is not supported by SQL, another way around this is to create the SQL table using the record format name. Then, you can rename the table to what you want it to be – the record format name will remain what it was originally, and your RPG program won’t need to rename the format to something that’s unique from the file name because it will be that way already.

Also, I recall reading something about RPG record formats for 6.1 of the operating system, which I think would better facilitate this.

Cwc
 4,275 pts.