Database Strucure

kjc13

Member
I am new to the One World community but have an AS/400 background.
   Are the database definitions for OW running on NT SQL  identical to the DDS on the 400?

Thanks,
KJC13
 
Hi EJ
Welcome.
On an AS400 data is stored in physical files and the the indexes/indices are
attached to the files in form of logical files. Instead of databases you get
libraries which a used to group AS400 files, programs, whatever together.
So there will be an address book file called F0101. If you use the AS400
commands DSPFFD F0101 you'll get a list of all the fields with that file.
They'll be logical files, e.g. F0101_1 which present a sorted or selected
set of records from F0101.
OneWorld used SQL to create files and not the classical CRTPF and DDS.
There is a important if obscure different between the two which is that with
an AS400 file there is something called a record format. When you create a
file using SQL the record format name and the file name is the same and
using DDS it must be different. Nothing to worry about if you're just
dealing with OneWorld.
Any problems, just send down an email.
Regards
Robert

XE 17.0, AS400 V4R4
 
Re: RE: Database Strucure

Does this mean all of the data elements are identical also? By this I mean the database definitions are not taking advantage of some of the formats available in SQL that are not available on the AS/400.

Thanks,
KJC
 
Back
Top