Querying the AS400, how???

[ChrisRutherford]

Hello,

I know next to nothing about AS400 so I need a starting point. Microsoft SQL Server has a program called Query Analyser, IBM DB2 ver 7 has a program called Command Center. They both do much the same thing, i.e. you can query the database using DDL, DML etc.

Does AS400 have this as well? I can use the AS/400 Operations Navigator but I need something a little more taylored for running queries. Does anyone know what program does this? Pref something that is part of the AS400 and if so how to run it.

Really appreciate any assistance given.

Chris

 

[flapeyre]

Try the command STRSQL. That's the command-line SQL interface.

IBM's site seems to be tempararily down, but I have the link to the SQL Reference for V5R1 as:

http://publib.boulder.ibm.com/pubs/html/as400/v5r1/ic2924/info/db2/rbafzmst02.htm

The i-Series Infocenter for V5R1 is:

http://publib.boulder.ibm.com/iseries/v5r1/ic2924/index.htm

That will link to all of the manuals for the AS/400 (aka iSeries).



"When once you have tasted flight, you will forever walk the Earth with your eyes turned skyward, for here you have been, and there you will always long to return."

--Leonardo da Vinci

 

[ChrisRutherford]

Hi there,

Thanks for those links, much appreciated.

Cheers,

Chris