iSeries any beyond

0 pts.
Tags:
AS/400
Data analysis
Database
DB2
Development
Oracle
I'll start by introducing myself and my background and then hopefully explain what information i'm looking for. I'm a COBOL developer for an insurance company based here in Ireland. I'd like to think of myself as been proficient at programming and at navigating my way around the AS/400. I have experience in other non-AS/400 languages, VB, C++ and the like but not in a working environment. Now...my question. From reading posts from other people on here, there are alot of questions on how to link the AS/400 yo other machines and way to extract information from the AS/400. An example of this would be using ODBC and MS Query to perform queries or extract information from the AS/400. This area is a particular area i would like to gain more knowledge on...i.e. connecting the AS/400 to others systems and information exchange between them. I'm coming into this as a beginner as we do not use or do anything like this where i work, but i see it as an area with great benefits. I was hoping someone out there could give me a few pointers as to where i might start to get to terms with all this, be it a book or a website or where ever. Thanking you in advance.
ASKED: December 2, 2005  6:31 AM
UPDATED: December 3, 2005  12:27 AM

Answer Wiki

Thanks. We'll let you know when a new response is added.

Hi.
You didn’t say much about the database but let’s assume it’s AS/400 DB2. You have many options, even if you are using Oracle, MySQL etc..

If DB2 you can use DB2 Connect, it requires a separate license if not already owned.

You can use SQL Server DTS on a PC as a go between.

JDBC or ODBC using home-grown Queries.

You can crate a DB2 Staging DB on the “other platform (also not mentioned) using Federated Database.

You can use High-Speed Unload/Load.

You can EXPORT AS Delimited and Import.

The correct solution depends on the needs, whether Batch or Realtime is preferred.

Another convenience is MQ Series and/or WebShere or BEAs WebLogic.

StartGoogling, write down the requirements and row sizes and number of tables and we can better determine a viable solution, of which there are many.

- Corey from Falls Church

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following