DB2 (Oracle funtionality in)

Rireland

5 pts.

Tags:

File System

Flat files

IBM DB2

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 Last updated: February 3, 2010 9:54 PM

Answer Wiki

Last updated: February 2, 2010 2:36 AM GMT

philpl1jb54,090 pts.
History
Contributors
- Ordered by most recent
- philpl1jb54,090 pts.

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.

TomLiotta Feb 2, 2010 6:43 PM GMT

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 Feb 3, 2010 9:54 PM GMT

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