DB2 (Oracle funtionality in)

5 pts.
Tags:
DB2
DB2 file system
File systems
Flat files
Hi, all I have no familiarity with DB2, but plenty in Oracle and SQL Server and other RDMS. In Oracle, I can access a flat file on disk by defining it as an External File. Similar functionality in SQL Server. My question then: Does DB@ on the mainframe have the same type of feature? Thanks in advance!
ASKED: February 1, 2010  6:04 PM
UPDATED: February 3, 2010  9:54 PM

Answer Wiki

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

DB/2 runs on three IBM “mainframes” but the instructions would be very different on each. What is your system i-series (AS/400), AIX, or a true mainframe?
Phil

Discuss This Question: 2  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.

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
  • TomLiotta
    Phil's comment comes from regular questions about DB2 and "mainframes" where the question turns out to be about iSeries or AIX. It's just something we deal with often. Also, the term "flat file" can have two different meanings -- a streamfile in a directory or a single-field file in a database. Sometimes a question is about one or the other but doesn't clarify. The two types have radically different approaches. Can you clarify a little? Tom
    125,585 pointsBadges:
    report
  • Meandyou
    reference TomLiotta's response ... I have a third definition for "flat file" On a mainframe (running z/OS) the term flat file means a sequential dataset. Physically sequential as opposed to any other type of dataset; VSAM (any of the 4 flavors) or a PDS (library). Then, we confuse the issue even more when start speaking of RDBMSes. We think of the data as stored in tables, but the underlying dataset is VSAM LINDEAR. Very confusing. Still, when I hear "flat file", I think a sequential dataset on disk.
    5,220 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