Moving to AS/400

[deebeetwo]

I have been asked to start positioning from DB2 on Windows to helping
maintain another DB2 database on the mainframe (AS/400). I am
comfortable in DB2 but have never used the green screens and all.

To get my footing during the transition phase, I have been trying to
explore different tables, run some simple SQL against them, and so on.
But it seems that the system catalogs that I use so frequently on LUW
are simply not available on the mainframe side. Is that the case or am
I looking at the wrong place? How would I get a list of tables/columns
in the database?

On a related note, I have already seen some syntactical differences in
SQL. Where can I find a document that introduces the differences (and
similarities) between these two platforms to someone who is familiar
with LUW side but not mainframes?

[Mark A]

<de*******@yahoo.com> wrote in message
news:11**********************@g49g2000cwa.googlegr oups.com...

I have been asked to start positioning from DB2 on Windows to helping
maintain another DB2 database on the mainframe (AS/400). I am
comfortable in DB2 but have never used the green screens and all.

To get my footing during the transition phase, I have been trying to
explore different tables, run some simple SQL against them, and so on.
But it seems that the system catalogs that I use so frequently on LUW
are simply not available on the mainframe side. Is that the case or am
I looking at the wrong place? How would I get a list of tables/columns
in the database?

On a related note, I have already seen some syntactical differences in
SQL. Where can I find a document that introduces the differences (and
similarities) between these two platforms to someone who is familiar
with LUW side but not mainframes?

Let's make one thing clear. The AS/400 is not a mainframe. If you continue
that description, you will held liable for slander (by z/OS users).

There is a manual called SQL Reference for Cross-Platform Development V2,
which you can download at:
http://www-306.ibm.com/software/data...manualsv8.html

If I were you, I would reconsider before it is too late. Any of the other
DB2 platforms is far better than DB2 for AS/400.

[deebeetwo]

Mark A wrote:

Let's make one thing clear. The AS/400 is not a mainframe. If you continue
that description, you will held liable for slander (by z/OS users).
Mark, Thanks for the clarification. I was not aware of the
sensitivities on this topic. My sincere apologies.

There is a manual called SQL Reference for Cross-Platform Development V2,
which you can download at:
http://www-306.ibm.com/software/data...manualsv8.html
I took a quick look at it. It does not seem to address the system
catalog. There is a single mention of it on page 14, and it refers to
some other documentation.

Do you happen to have a link to where I could find the information?
Specifically, I am interested in system catalog tables/views/etc. on
the AS/400 platform. Beyond that I think I can manage it on my own.
But if someone has sample SQL for it, that would be great.

If I were you, I would reconsider before it is too late. Any of the other
DB2 platforms is far better than DB2 for AS/400.

Well, I am not the decision maker on this unfortunately. I am not even
sure at this point who is ultimately responsible either, other than it
falls under some executive VP's domain.

[Bob Jones]

>

Well, I am not the decision maker on this unfortunately. I am not even
sure at this point who is ultimately responsible either, other than it
falls under some executive VP's domain.

Welcome to the IT world.

[Mark A]

<de*******@yahoo.com> wrote in message

I took a quick look at it. It does not seem to address the system
catalog. There is a single mention of it on page 14, and it refers to
some other documentation.

Do you happen to have a link to where I could find the information?
Specifically, I am interested in system catalog tables/views/etc. on
the AS/400 platform. Beyond that I think I can manage it on my own.
But if someone has sample SQL for it, that would be great.

You will have to find the DB2 for AS/400 documentation on the IBM website. I
assume you can download it, but I never looked myself.

On other DB2's the Catalog description is in the Appendix of the SQL
Reference.

[Anton Versteeg]

Mark A wrote:

<de*******@yahoo.com> wrote in message

I took a quick look at it. It does not seem to address the system
catalog. There is a single mention of it on page 14, and it refers to
some other documentation.

Do you happen to have a link to where I could find the information?
Specifically, I am interested in system catalog tables/views/etc. on
the AS/400 platform. Beyond that I think I can manage it on my own.
But if someone has sample SQL for it, that would be great.

You will have to find the DB2 for AS/400 documentation on the IBM website. I
assume you can download it, but I never looked myself.

On other DB2's the Catalog description is in the Appendix of the SQL
Reference.

For manuals on i-series (AS/400) have a look at:

http://publib.boulder.ibm.com/html/a...nfocenter.html
--
Anton Versteeg
IBM Netherlands

[4.spam]

Hello.

For V5R2 system catalog look at
http://publib.boulder.ibm.com/iserie...bafzmst183.htm

Sincerely,
Mark B.

[Karl Hanson]

de*******@yahoo.com wrote:

Mark A wrote:

There is a manual called SQL Reference for Cross-Platform Development V2,
which you can download at:
http://www-306.ibm.com/software/data...manualsv8.html

I took a quick look at it. It does not seem to address the system
catalog. There is a single mention of it on page 14, and it refers to
some other documentation.

Do you happen to have a link to where I could find the information?
Specifically, I am interested in system catalog tables/views/etc. on
the AS/400 platform. Beyond that I think I can manage it on my own.
But if someone has sample SQL for it, that would be great.

See Appendix F of the DB2 UDB for iSeries SQL Reference:
http://publib.boulder.ibm.com/infoce...rbafzmst02.htm

This link is for V5R3. Manuals for earlier releases are also available
online in the InfoCenter. (FYI: DB2 UDB for iSeries is part of OS/400 -
not a separate product that is purchased/installed - so its version is
the same as the installed OS/400 version)

--
Karl Hanson

[deebeetwo]

Karl Hanson wrote:

See Appendix F of the DB2 UDB for iSeries SQL Reference:
http://publib.boulder.ibm.com/infoce...rbafzmst02.htm

This link is for V5R3. Manuals for earlier releases are also available
online in the InfoCenter. (FYI: DB2 UDB for iSeries is part of OS/400 -
not a separate product that is purchased/installed - so its version is
the same as the installed OS/400 version)

Thanks a lot to all who have taken the time to reply. The documents
contain exactly what I was looking for. Now I will go poke around some
more.

--
Karl Hanson