RE: Data Transfer Tool -- MIDRANGE-L

Hi Tena,
if u're looking for something more generic (and sophisticated) for data 
accessed by java drivers, take also a look to the following:
www.sunopsis.com

Fabio




Tena Hewes <THewes@xxxxxxxxxxx> 
Sent by: midrange-l-bounces@xxxxxxxxxxxx
10/12/2004 03:16 PM
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>


To
'Midrange Systems Technical Discussion' <midrange-l@xxxxxxxxxxxx>
cc

Subject
RE: Data Transfer Tool






Cary,
I would like any info you can provide.
Thank you,
Tena 

Email: thewes@xxxxxxxxxxx


-----Original Message-----
From: Cary Phillips [mailto:lists@xxxxxxxxxxxxxxxx] 
Sent: Tuesday, October 12, 2004 11:51 AM
To: 'Midrange Systems Technical Discussion'
Subject: RE: Data Transfer Tool

Tena,

You could also use Java to write/read directly from your SQL Server
database.  Microsoft has a free JDBC driver that works from the AS400 to
allow Java to access SQL Server databases.  I used this for a recent
project.

Let me know if you need any information on this or would like some sample
code.

Good luck,
Cary Phillips 

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Tena Hewes
Sent: Tuesday, October 12, 2004 4:43 AM
To: 'Midrange Systems Technical Discussion'
Subject: RE: Data Transfer Tool

Phew! Ok, let me see if I can clarify...
We have an application that runs on SQL server (An SQL database w/ an 
Access
user interface). 
Currently, we have a program running in Access (VBA) on our SQL server 
that
"looks" at the AS400 DQ (out) every minute to determine if there is any 
data
needing to be transferred. When there is, it is imported in to a "holding"
table, where a stored procedure processes it. We also need to do the same
thing backwards. There is another holding table in our SQL application 
that
stores the data waiting to be transmitted back to the AS400 and sends it 
to
another AS400 DQ (in) where the AS400 takes over. 
This whole process is in place to make sure data (Inventory, PO's, Orders,
etc.) is synced up on an ongoing basis. Timed data feeds going from the
AS400 to our SQL app. are reasonable, but coming from the app. to the 
AS400
need to be "real-time".
Ok, the problem is this interface program between the AS400 and the SQL
server does not make me feel "warm and fuzzy". It has to always be 
running,
and if you happen to log on to the server as another user, you may not see
it running on your session. I really want something "hands-off". I want to
be able to set up 'jobs' on my SQL server (or AS400, if I know what I am
doing) that run automatically, so these data queues are populated behind 
the
scenes.

In answer to the following:
"Do you have iSeries Access?"
I am assuming you mean can I get my hands on it? Yes.

"One possibility is to export the data from Access into a different file
format."
Like Excel?

"Judging by what I perceive your background to be, you might find it 
easier
to create this intermediate file in DB2 using iSeries Access Navigator
Database tool."
Where would I find this? My background (other than an AS400 user) is
completely PC based. I like pictures!!! I try to navigate in the AS400 by
clicking...:( )

"There's other little tricks, like CCSID but that's one general path to
walk."



I hope this explains some things?
Thanks so much for the responses!
Tena

"-----Original Message-----
From: michael@xxxxxxxxxxxxxxxxxx [mailto:michael@xxxxxxxxxxxxxxxxxx]
Sent: Monday, October 11, 2004 3:49 PM
To: Midrange Systems Technical Discussion
Subject: RE: Data Transfer Tool

Hi Tena...we were all newbies once...welcome! Make sure you drop by the
Midrange-L table at CUDS Sunday night at COMMON and you'll be able to meet
some of the folks that frequent this place."


--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing 
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, 
unsubscribe,
or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at http://archive.midrange.com/midrange-l.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing 
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing 
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.