AS400 Database tables?

[Former Member]

Post Author: Prava

CA Forum: General Feedback

Can anybody please explain me what AS400 Database table is??

Feedback is greatly appreciated.

Thank you.

Prava

[Former Member]

Post Author: DPowell

CA Forum: General Feedback

Hmmm. My AS/400 knowledge is a little rusty and your question is a little vague but I'll try...

The AS/400 had an unnamed built-in database for several years. Eventually IBM decided to call it DB2/400 just to give it a name and to compete with the Oracles and SQL Servers of the world. But AS400 tables are NOT tables in a database like you may think of tables in Oracle or SQL Server.

A '400 table is a physical file within the file system. Likewise, any logical views are also files within the file system. When you ask the system to open a table, "DB2/400" just opens the physical file.

Interestingly, indexes are NOT separate files and are stored within the physical data or logical view.

Hope that helps.