IBM's AS/400 has:
"Libraries" instead of "Databases"
"Files" instead of "Tables"
"Logicals" instead of "Views"
and field names seem to be limited to 6 characters. So field names like
LNM@.CN (i.e. LastName) are not uncommon.
Am i being really closed minded about AS/400; or is what it's doing
perfectly valid and common?
i mean, wtf is a "Logical"? Who calls it that? Does Oracle? MySQL?
And how the heck is anyone supposed to know that the "file" CFPCLMM is
actually the table "Club Membership Information", and MSTSMM is a field name
for "Member Status"? And that the "logical" CFLDPCN1 is a view?
Is AS/400 stupid, or am i, or a little bit of both?<<
CFLDPCN1
I did an AS/400 to SQL DW a few years ago and drove myself nuts trying to
figure out thier non-verbose column names. Strangley enough the AS400 people
who started at it all day for years seemed to know... but I don't think
you're missing anything. An AS400 is certainly a powerful DB but it's not
quite as easy to use as SQL Server,
--
Brian
"Ian Boyd" <ian.msnews010@.avatopia.com> wrote in message
news:e%237oWhHVEHA.2840@.TK2MSFTNGP11.phx.gbl...[vbcol=seagreen]
> IBM's AS/400 has:
> "Libraries" instead of "Databases"
> "Files" instead of "Tables"
> "Logicals" instead of "Views"
> and field names seem to be limited to 6 characters. So field names like
> LNM@.CN (i.e. LastName) are not uncommon.
> Am i being really closed minded about AS/400; or is what it's doing
> perfectly valid and common?
> i mean, wtf is a "Logical"? Who calls it that? Does Oracle? MySQL?
> And how the heck is anyone supposed to know that the "file" CFPCLMM is
> actually the table "Club Membership Information", and MSTSMM is a field
name
> for "Member Status"? And that the "logical" CFLDPCN1 is a view?
>
> Is AS/400 stupid, or am i, or a little bit of both?
>
Sunday, February 19, 2012
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment