Best Way - SCO Unix to AS400

[jmd0252]

OK boys and girls,,, I have a question for you. I have to look at wasy to "dynamically link" the database from a Unix box into the As400,, to our JD Edwards (World) system. Cannot be uploads, or FTPs, that someone has the initiate. This needs to be a process, that happens "real time". We need PO and receinving info from the Unix server,, to be entered into the AS400. So what do you think boys and girls.. Thanks ahead of time..

 

[iSeriesCodePoet]

Hmm.. that is a tough one. Are you able to use java? That is about the only way I can think of.

iSeriesCodePoet
iSeries Programmer/Lawson Software Administrator

http://www.koldark.net

See my progress to converting to linux.

http://linux.koldark.net

 

[jmd0252]

define "able to use"... ha ha ha ha,,, do I know about it - yes,,, have I ever written anything - NO...

 

[jools1971]

Hi

I would consider using ODBC or OLE drivers to add the iSeries/as400 as a datasource.

You can then use SQL statements.

However when I last did something like this there were certain ODBC drivers that allowed only partial data access, such as read only.

I think IBM do their own ODBC drivers for unix which I think fully support whatever SQL you want to do.

You can also use DB2/Connect & DB2 UDB from IBM which is a similar thing to ODBC but it allows the automatic synchronisation of data between systems.

This is the IBM website

http://www-306.ibm.com/software/data/db2/udb/

If you only want small pieces of information and are happy with SQL code then you can do it yourself with an ODBC driver.

If you want a tool to do it then DB2 may be better, but that depends on what is already on your unix machines.

Regards

Julian

 

[jmd0252]

I wondered about going the DB2 Connect route. Do you know if you can use connect to syncro. to SQL Server, and then go from the SQL Server to Unix. I have the ODBC drives for the Unix system, and can make changes, pull data, etc into access for simple reports.

 

[jools1971]

Hi

The connect software is for an end-user machine, it can syncrhonise, but it would have to run on a client machine e.g a windows xp type install.

The DB2 UDB will run on a server and should do what you require, problem is its rather complicated for small jobs.

If you only have a few small pieces of info to synchronise from an AS400 database you are just as well using trigger programs and or unix processes to go and get data.

 

[jmd0252]

Well,,, I would be syncronizing purchase order info between the 2 systems.. Header and line detail info both. This would not be a small job,,, but something that needs to happen when the PO is entereed, or updated on the unix box,, it would then need to roll over to the AS400.

 

[MurrayInfoSys]

Two questions:
1) How dynamic is the "Dynamic Link".
2) Is it easier to PUSH or PULL the data.

I have written an application that checks for a file on the AS400 every minute. This file is created by a batch FTP process on 30 PCs. This was used for Shop Floor data gathering.

If you are comfortable with SQL, then ODBC is likely the best way to go.

Socket programming is another method.

Phil

 

[jmd0252]

Well,,,lets start out say every 30 minutes or so. And I have no idea about the differnt version of Unix, not sure if that makes a difference or not. Do you see any performance hits on the AS400 side. Ever since we went to V5R1, the interactive side has gone south. Which I understand was because of IBM changing the interactive Algo. Sorry I would spell it if I could. HA HA AH A