Moving to AS/400

[deebeetwo@yahoo.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?

[Mark A]

Re: Moving to AS/400

<deebeetwo@yaho o.com> wrote in message
news:1123542441 .772644.222820@ g49g2000cwa.goo glegroups.com.. .[color=blue]
>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?
>[/color]

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/db2/udb/support/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@yahoo.com]

Re: Moving to AS/400

Mark A wrote:[color=blue]
> 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).[/color]

Mark, Thanks for the clarification. I was not aware of the
sensitivities on this topic. My sincere apologies.

[color=blue]
> 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[/color]

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.

[color=blue]
> 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.[/color]

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]

Re: Moving to AS/400

>[color=blue]
> 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.
>[/color]

Welcome to the IT world.

[Mark A]

Re: Moving to AS/400

<deebeetwo@yaho o.com> wrote in message[color=blue]
> 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.
>[/color]

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]

Re: Moving to AS/400

Mark A wrote:
[color=blue]
> <deebeetwo@yaho o.com> wrote in message
>[color=green]
>>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?
>>Specificall y, 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.
>>[/color]
>
>
> 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.
>
>[/color]
For manuals on i-series (AS/400) have a look at:

http://publib.boulder.ibm.com/html/as400/infocenter.html

--
Anton Versteeg
IBM Netherlands

[4.spam@mail.ru]

Re: Moving to AS/400

Hello.

For V5R2 system catalog look at

http://publib.boulder.ibm.com/iseries/v5r2/ic2924/index.htm?info/db2/rbafzmst183.htm

Sincerely,
Mark B.

[Karl Hanson]

Re: Moving to AS/400

deebeetwo@yahoo .com wrote:[color=blue]
> Mark A wrote:
>[color=green]
>>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[/color]
>
>
> 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.
>[/color]

See Appendix F of the DB2 UDB for iSeries SQL Reference:

http://publib.boulder.ibm.com/infocenter/iseries/v5r3/ic2924/index.htm?info/db2/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@yahoo.com]

Re: Moving to AS/400

Karl Hanson wrote:[color=blue]
> 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)
>[/color]

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.

[color=blue]
> --
> Karl Hanson[/color]