 |
BorlandTalk.com
Borland discussion newsgroups
|
| View previous topic :: View next topic |
| Author |
Message |
server
Guest
|
 Posted: Fri Jan 30, 2004 10:40 am Post subject: How to get the data of Department and Employee from AS400 to |
 |
|
message unavailable |
|
| Back to top |
|
 |
pnichols
Guest
|
| Posted: Fri Jan 30, 2004 10:40 am Post subject: Re: How to get the data of Department and Employee from AS40 |
|
|
MLHuang wrote:
| Quote: | Dear all,
Please help me to think about this.
How to get the data of Department and Employee from AS400 to MS SQL
server?
Thank you very much.
Windlan
|
You could surely follow David's advise, or write some middleware that would
do the translation for you in Java. I am not sure however, if the MS-SQL
Server Drivers would work on an AS400. I seriously doubt it, but who knows
<G>.
You could probably use a middleware Unix, Linux, or Windows Server to write
the java code. If you are invoking the method through a 5250 emulator, you
would need to set the middleware server up to recieve the 5250 emulator
terminal, invoke the middleware server piece, and then make a call to the
AS400 through the middleware server data repository. If you want a batch
operation to do this, would be pretty straight forward, I would assume.
If you want to invoke this operation directly through a Java application,
applet, Web Start Application, or Java terminal program, should be straight
forward enough. If the Java application, etc. is to be invoked on each
workstation, you would simply need to create two Connections, one to the
MS-SQL Server and another to the DB/2 repository. You could use Meta Data
to pull the tables and field names, then do normal SQL operations from here
(IE. Insert Into DB/2(Field1,Field2)
Values(SQLServerResultset.getDataType(1), SQLServerResultSet.getDataType
(2));
Since I do not know which you are planning to do, I cannot be more specific.
Java would certainly work for you with AS400 and DB/2, but I am not sure
what the limitations are with SQL-Server Type 4 drivers are as per
platforms supported. |
|
| Back to top |
|
|
pnichols
Guest
|
| Posted: Thu Feb 05, 2004 8:05 am Post subject: Re: Java Form |
|
|
pvdb (AT) gmx (DOT) de wrote:
| Quote: | Hello,
how can I load an java Applet into an HTML File?
Ciao
|
You mean like?
<applet
codebase = "."
code = "myappletpackage.MyApplet.class"
name = "MyApplet"
width = "400"
height = "300"
hspace = "0"
vspace = "0"
align = "middle"
|
|
| Back to top |
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
