Record format in DB2/400

60 pts.
Tags:
AS/400
DB2/400
How to check file name using record format in DB2/400?


Software/Hardware used:
AS/400
1

Answer Wiki

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

There is no correlation between file name and record format name. You can have say 12 files monthly01,  monthly02, monthly03…. for recording monthly sales.

They can all have the same record format name SALES… This makes running programs easier because you can just OVRDBF the file and the program will run for all 12 months.

Discuss This Question: 4  Replies

 
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.
  • deepu9321
    Can you add some more details to your question? 
    4,980 pointsBadges:
    report
  • TheRealRaven
    You can't determine a file name from a record format name.

    The same record format may be used by many different files.
    36,025 pointsBadges:
    report
  • TheRealRaven
    It's not clear why you'd know record format names without first knowing the file names. But I suppose you could build a table of record format names by running DSPFD TYPE(*RCDFMT) into an *OUTFILE for every database file that you have. Once you do that, you could query that file for any record format name you're interested in. You should regenerate that *OUTFILE regularly if there is any reason to use it again.
    36,025 pointsBadges:
    report
  • Yorkshireman
    Could you be intending to check member names - such as source members, to find their parent file?

    as other said - there is no way to find the file, given only the format.  Only A file - one among many possibles. 

    same with members too - many copies of a source member - or a data file member, even if they sahre the same format 


    6,085 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.

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

Following

Share this item with your network: