AS400-DML

1,215 pts.
Tags:
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?
ASKED: September 1, 2008  8:38 AM
UPDATED: September 3, 2008  2:33 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Cwc
    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.
    4,290 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following