as/400 and db2

dinhchung82:

You indicate that you are new to the AS/400 hardware and operating system, that you are new to the DB2 database, and that you are new to the fundamental programming language in use at your location. You want to know where to begin.

But you haven't told us what you do know. What programming languages do you have experience with? What databases have you used? What hardware and OS? What kinds of environments -- multi-user? multi-national? manufacturing? financial? communications? security?

Where to begin -- It's hard to begin with RPG without knowing about source statements. It's hard to know much about source statements without knowing about source editors or about source files. It's hard to know about source files without knowing about source members. It's hard to know about source members without a basic grasp of how DB2 is implemented on AS/400 -- which leads to how file systems are implemented, and the Integrated File System (the IFS), and the object-based nature of the operating system, and...

Tell us something about YOU in order for us to relate concepts to your experience.

Tom

thanks for all !

I worked in bank and have experience with Oracle and Java.
But now , my new work need to know db2 and rpg ( on as/400).
I can use test/dev enviroment for learning .

Now , i have one use from application and use it through tn5250 .
when i want to use one program from vendor , i must call library .
how to i know the way to call library if i don't know the name and the way db2 is working with as/400.

I try to use DB GUI as Toad and use this use to connect to view database structure  but not successful . how to show database in as/400 that use and port that is db2 used?
Would any tool that is different with 5250 terminal have support for GUI more ?

dinhchung82:

Not sure I understand your question on the "call library"  Can you give more details

On you question on TOAD for DB2 I think you problems come from the fact DB2 UDB on the iSeries(AS/400) is not the same at DB2 UDB on other platforms.  I found a posting (http://www.ibm.com/developerworks/forums/thread.jspa?threadID=117032) suggesting DB2 Connect could possible be used to connect TOAD to an iSeries database.  From my experience the best way to get a GUI view of the iSeries Database is to use iSeries Navigator part of iSeries Access.

thanks , i shall use iSeries Navigator.

i am new to as/400 as you know but when i learn from my colleague: this is the steps i do :
+ use iSeries Navigator to connec to as/400
+ user and pass
+ setebu1 ( set ebs library list)
+ call library .... ( that's i mean )


i have one question , i use this user and pass for ftp . i list , i see some file . is it a library ???

Thanks.

dinhchung82:
Yes it sounds this those are libraries or in DB2/SQL would be schemas, and beneath that level you would have files or in DB2/SQL Tables.  If you use iSeries Navigator the terminology used is actually the DB2/SQL terminology and not the iSeries terminology.

Once in iSeries Navigator expand "Databases", expand your Database, and select a Schema(Library) and your should see all the Tables, Procedures..... within that schema.

If the schema you would like to see is not listed just right clickon Schemas and click on "Select Schemas to display" and enter the Schema or library you wish to see then click Add and OK