Reading an unknown file in RPG

15 pts.
Tags:
DBU
RPG
RPG ILE
SQL
Hi All, I am working on a DBU like utility which will provide a maintainance screen for each file. I need to read the file in an rpg program but i dont know the program name till runtime. I can't declare the file in F specs as i dont know the file name. SQL is very bothering and is very heavy for the interactive application. Plese suggest some other way to do this. Thanks in advance
ASKED: March 19, 2009  12:27 PM
UPDATED: March 19, 2009  2:38 PM

Answer Wiki

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

Hi,

You could declare the file as internally defined with user open, then you can do an OVRDBF to the correct file at run time and open the file.

Regards,

Martin Gilbert.

///////////////////////////
Why? You’re taking on quite a chore, that has good comercial solutions.
You could declare your file as Internally described .. but then you have no field definitions.
You can capture the field definitions in a number of ways (DSPFFD or in SQL).
You’ve got a lot of work ahead of you.
Phil
/////////////////////////

Hi,

You could also retrieve the field descriptions and details on the file description from the cross reference tables.

Regards,

Martin Gilbert.
///////////////////////////////////////////////////////////////////////
You’re right – as always, Martin. And it’s still quite a chore.
Are there some freebee or cheepe that does this? — Oh there’s always DFU.

Phil

Discuss This Question:  

 
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

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