By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,287 Members | 1,309 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,287 IT Pros & Developers. It's quick & easy.

Moving to AS/400

P: n/a
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?

Nov 12 '05 #1
Share this Question
Share on Google+
8 Replies


P: n/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.
Nov 12 '05 #2

P: n/a
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.

Nov 12 '05 #3

P: n/a
>
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.
Nov 12 '05 #4

P: n/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.
Nov 12 '05 #5

P: n/a
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
Nov 12 '05 #6

P: n/a
Hello.

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

Sincerely,
Mark B.

Nov 12 '05 #7

P: n/a
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
Nov 12 '05 #8

P: n/a
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


Nov 12 '05 #9

This discussion thread is closed

Replies have been disabled for this discussion.