AS400 to AS400 connection issuesHi All,
We have two AS400's at different locations, and were able to
passthrough and send files between both no problems.
Last week one of our AS400's was moved to another location, with an IP
change.
We have updated the IP addresses on the other AS400 and can passthrough
fine....however we can no longer send files from the new location.
When I look at the distribution queue I see the following status:
RTY-FAIL
Any idea's as to what may be causing this?
Thanks,
Mike
mot98@yahoo.com wrote:
> Hi All,
>
> We have two AS400's at different locations, and were able to
> passthrough and send files between both no problems.
>
> Last week one of our AS400's was moved to another location, with an IP
> change.
>
> We have updated the IP addresses on the other AS400 and can passthrough
> fine....however we can no longer send files from the new location.
>
> When I look at the distribution queue I see the following status:
> RTY-FAIL
>
> Any idea's as to what may be causing this?
run the CFGDSTSRV command and then look at all the menu options.
Another command to look at is CFGTCP.
-Steve
Steve Richter wrote:
> mot98@yahoo.com wrote:
> > Hi All,
> >
> > We have two AS400's at different locations, and were able to
> > passthrough and send files between both no problems.
> >
> > Last week one of our AS400's was moved to another location, with an IP
> > chan...
Printing on AS400 via IBM AS400 Java ToolkitHello all,
I'm working on a program that needs to send a print job to a printer
connected to an AS/400. I've tried using the SpooledFileOutputStream
and I've also tried using one of the SCS Writer classes. Neither
solution is working. With the SpooledFileOutputStream I am at least
able to create my print file, but when my program ends, the file is
still not being printed.
This program does not run on the AS400, it runs on a PC and connects to
the AS400 via the toolkit classes. I know this part works as I am able
to use the toolkit to access Data Queues, Files and Data Areas without
a problem.
Is there anyplace anyone can point me to see some examples of how to
print a file using the AS400 Java Toolkit?
Thanks in advance,
Chuck
Chuck,
What printer data stream is used? or how was the printer data generated?
I am wondering if the data stream being generated matches the data
stream of the printer connected to the iSeries? What printer is attached
to the iSeries and how is it configured?
The iSeries info center has some Toolbox examples:
Programming>Java>IBM Toolbox for Java>IBM Toolbox for Java Classes>
Access Classes>Print>Creating...
Dave
Chuck wrote:
> Hello all,
>
> I'm working on a program that needs to send a print job to a printer
> connected to an AS/400. I've tried using the SpooledFileOutputStream
> and I've also tried using one of the SCS Writer classes. Neither
> solution is working. With the Sp...
AS400 to AS400 data transferHi
I need to place a trigger on a set of tables on an AS400 to fire off
whenever new records are added to these tables. This trigger program
will then transfer the data to another AS400 across a WAN. This will
allow us to transfer orders from one system to another.
Can anyone tell me how I would achieve this. Normally if it had been a
PC I would have used an ODBC type application but I am not sure
what is available to me for AS400 to AS400 data transfer.
I know that we can transfer a SAVF by FTP but this is not a route I
would like to go down. I would prefer to populate tables directly if
possible.
Thanks for any help offered
Iain
Iain wrote:
> Hi
>
> I need to place a trigger on a set of tables on an AS400 to fire off
> whenever new records are added to these tables. This trigger program
> will then transfer the data to another AS400 across a WAN. This will
> allow us to transfer orders from one system to another.
Even if there may be multiple way, I think the best would be using a
remote journal, on the target system a journal entry exit program will
be evoked at event time, so it can apply new records to the target
tables, then it can fire a new event if necessary.
--
Dr.Ugo Gagliardelli,Modena,ItalyCertifiedUindoscrasherA�ejoAlcoolInside
Spaccamaroni andate a cagare/Spammers not welcome/Spammers v�o � merda
Spamers iros a la mierda/Spamers allez vous faire foutre/Spammers loop
schijten/Spammers macht Euch vom Acker/Spamerzy wypierdalac'
...
AS400 to AS400 data transfer #2Hi
I need to place a trigger on a set of tables on an AS400 to fire off
whenever new records are added to these tables. This trigger program
will then transfer the data to another AS400 across a WAN. This will
allow us to transfer orders from one system to another.
Can anyone tell me how I would achieve this. Normally if it had been a
PC I would have used an ODBC type application but I am not sure
what is available to me for AS400 to AS400 data transfer.
I know that we can transfer a SAVF by FTP but this is not a route I
would like to go down. I would prefer to populate tables directly if
possible.
We are using 2 model 820's with OS400 V5 R2
Thanks for any help offered
Iain
...
AS400 connection again...Can someonne please tell me an ADO connection string to use to link an AS400
table to Access WITHOUT using a DSN? I want to use:
currentdb.tabledefs(td).connect = sConnectionString
currentdb.tabledefs(td).RefreshLink
I CAN ALREADY CREATE AN ADO CONNECTION. THE WEB SITES PEOPLE ARE SUGGESTING
ONLY GIVE CONNECTION STRINGS NOT A STRING I CAN USE FOR A TABLEDEF.
Is there a way?
Thanks.
Matthew Wells
MWells@FirstByte.net
On Fri, 08 Apr 2005 21:38:21 GMT, "Matthew Wells"
<MWells@FirstByte.net> wrote:
I like this site for connection strings:
http://www.carlprothman.net/Default.aspx?tabid=81
(formerly able-consulting.com)
-Tom.
>Can someonne please tell me an ADO connection string to use to link an AS400
>table to Access WITHOUT using a DSN? I want to use:
>
>currentdb.tabledefs(td).connect = sConnectionString
>currentdb.tabledefs(td).RefreshLink
>
>I CAN ALREADY CREATE AN ADO CONNECTION. THE WEB SITES PEOPLE ARE SUGGESTING
>ONLY GIVE CONNECTION STRINGS NOT A STRING I CAN USE FOR A TABLEDEF.
>
>
>Is there a way?
>
>Thanks.
>
>Matthew Wells
>MWells@FirstByte.net
>
>
>
...
From a AS400 with a CCSID to another AS400 with different CCSIDHi all,
I've the following issue:
- I have to move data from a AS400 with CCSID 65535 (no conversion) to
another AS400 with CCSID 37
I'm using DDM files on the second AS400 linked to the first AS400, but
reading DDM files I have the problem that data are different in the
special characters...
So I changed my job session CCSID to 65535 with CHGJOB; with that I
can see correctly DDM files data, but not the local files...
What do you suggest to do?
Many thanks in advance.
Fabrizio
On 09-Jun-2011 05:47 , Fabrizio wrote:
>
> I've the following issue:
>
> - I have to move data from a AS400 with CCSID 65535 (no conversion)
> to another AS400 with CCSID 37
>
> I'm using DDM files on the second AS400 linked to the first AS400,
> but reading DDM files I have the problem that data are different in
> the special characters...
>
> So I changed my job session CCSID to 65535 with CHGJOB; with that I
> can see correctly DDM files data, but not the local files...
>
> What do you suggest to do?
>
The system CCSID QCCSID is effectively moot in that scenario as far
as I can recall. What do matter are the CCSID of the job opening the
file and then reading the data, and the CCSID of the columns of the file
being opened. When the job is set to a proper CCSID, then whenever the
data is also "tagged" properly with a CCSID [e.g. column of a table with
a non-hex (non-65535) CCSID], the database will convert the dat...
IBM AS400Does anyone have some notes, documentation or helful
pointers about navigating, command language and DB2 on
an AS400 for a guy who has done HP3000, Windows
2k/2k3, MS SQL, HP9000, IBM ES9000/UNIX, SCO UNIX?
Ideally a commands cross reference qaulivalent would
be terrific - I.E. HP3000 to AS400.
Thanks much.
P.S. I'm taking a role in a shop that runs its ERP
system on this platform.
Jim.
____________________________________________________________________________________
Get easy, one-click access to your favorites.
Make Yahoo! your homepage.
http://www.y...
AS400 connection AGAIN....FIRST OF ALL, I APPRECIATE PEOPLE SENDIUNG ME LINKS TO WEB SITES FOR
CONNECTION STRINGS BUT AS I'VE SAID BEFORE THAT IS NOT WHAT I NEED. I CAN
EASILY OPEN AN ADO CONNECTION OBJECT TO AS400. I NEED TO REFRESH A DAO
(Access) TABLEDEF OBJECT'S CONNECTION STRING WHICH MUST INCLUDE A CLAUSE FOR
THE TABLE NAME. THIS IS WHAT I NEED. PLEASE READ AGAIN.
Can someonne please tell me an ADO connection string to use to link an AS400
table to Access WITHOUT using a DSN? I want to use:
currentdb.tabledefs(td).connect = sConnectionString
currentdb.tabledefs(td).RefreshLink
or if I must:
docmd.transfer database....
I CAN ALREADY CREATE AN ADO CONNECTION. THE WEB SITES PEOPLE ARE SUGGESTING
ONLY GIVE CONNECTION STRINGS NOT A STRING I CAN USE FOR A TABLEDEF.
Thank you.
Matthew Wells
MWells@FirstByte.net
The first link below should do the trick for you...
http://members.rogers.com/douglas.j.steele/DSNLessLinks.html
ODBC DSN-Less Connection Tutorial Part I
http://www.amazecreations.com/datafast/GetFile.aspx?file=ODBCTutor01.htm&Article=true
HOWTO: Use "DSN-Less" ODBC Connections with RDO and DAO
http://support.microsoft.com/?id=147875
ODBC DSN Less
http://www.able-consulting.com/MDAC/ADO/Connection/ODBC_DSNLess.htm
--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKallal@msn.com
http://www.members.shaw.ca/AlbertKallal
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Using ADO usually means connection w/ the OLE DB connection. ...
Connecting to AS400 running on IBM with MS AccessHello All,
I've been struggling on and off for 3 months trying to connect to an
DB2 database running on an IBM iSeries machine.
I FINALLY figured out how to connect with Coldfusion (see instructions
below).
So, now I am trying to connect to the same database with MS Access. I
want to link the tables within Access so I can quickly query and answer
questions.
The problem is that I HAVE NO IDEA how to do this. I'm familiar with
linking tables to other databases (MySQL, MS SQL Server, Oracle), but
I've never done it for IBM DB2 (I'm not even familiar with the IB...
A Basic question on Connecting non-IBM FC Disk Subsystem to AS400Hi,
I'm exploring connecting a non-IBM AS400 disk subsystem to AS400, for
example connecting an IBM FAStT Storage Subsystem to the AS400.
Can this be done? If so what do I need to get this working? Is the
config certified by IBM?
Thank you.
...
How to connect WHow to connect WINCE to AS400 DB2 ?I'm looking for a solution to connect from a WinCE device to an AS400
Database (or MySQL or whatever else other than MS SQL).
ADOCE for example is only supporting a connection to an local Access
Database or the local file system.
I tried ViaDB from Odessey Software (a trial version for one
connection) but no succsess.
I have looked for several solutions in C++, VB and Java but nothing
seems capable to get an easy connection to a database connected wireless.
Maybe someone can help me. Thanks.
--
"Warum haben wir eigentlich nie Zeit, eine Sache richtig zu machen,
aber immer Zeit, sie noch mal zu machen?"
'Systemdenken und Softwarequalit�t', Gerald Weinberg
I tried to do this 2 years ago --- the only information I was able to
ascertain was that you could write your own data provider or have one
written for you. There were also several kludges we were entertaining in
order to do this -- one involved Citrix server I believe. Ultimately, the
project was killed. It seems like the same issues still exist today.
If you find a data provider that works with CE I'd be interested in learning
about it.
Good Luck
Jim K
"Frank Barfs" <wegmachen.barfs@vsb-soft.de> wrote in message
news:f7qjsc.hic.ln@ID-226326.user.uni-berlin.de...
> I'm looking for a solution to connect from a WinCE device to an AS400
> Database (or MySQL or whatever else other than MS SQL).
> ADOCE for example is only supporting a connection t...
AS400 modem connectionHelp please,
I have an AS400 running OS V4R1 and have the *LIN/*CTL/*DEV
configured, with a modem connected to COMN2.
I am trying to dial in to this from my laptop using a standard dial up
connection (Windows XP) the laptop has client access loaded.
The AS400 modem receives the call, but then I get the following
messages.
AS400 The exchange identifier (XID) is *NOID
PC error the is 619
It would seem that I need a different form of dial up!
First - upgrade to a supported release of OS/400 (i.e. at least v5r1).
Second - is this leading to a Lotus Notes/Domino question? If n...
Connecting with AS400 systemname??Hello.
All my clients(PCs) are with CA connected to AS400.
In CA configuration are for systemname the IP address of the AS400.
If i put the Systemname SXXXXXX i have a error "Cannot find the
system........"
I have many AS400, so i dont wont to search always, if i install CA in
a PC what are the IP address.
I wont do use AS400 Names LIKE PROCUTION, FACTORING,SERVICE etc.
..
Its this possible?? And how??
thanks.
marsias racontait dans comp.sys.ibm.as400.misc:
> Hello.
Hello
>
> All my clients(PCs) are with CA connected to AS400.
>
> In CA configuration are for systemname the IP address of the
> AS400.
>
> If i put the Systemname SXXXXXX i have a error "Cannot find the
> system........"
>
It means that the IP stack of the PC cannot resolve the IP address of
the SXXXXXX name.
> I have many AS400, so i dont wont to search always, if i install
> CA in a PC what are the IP address.
>
> I wont do use AS400 Names LIKE PROCUTION, FACTORING,SERVICE etc.
>
> .
>
> Its this possible?? And how??
>
You have to update the hosts file of your PC or use a DNS for name
resolution.
> thanks.
>
>
--
Cordialement/Best regards
Marc Rauzier
marsias wrote:
> Hello.
>
> All my clients(PCs) are with CA connected to AS400.
>
> In CA configuration are for systemname the IP address of the AS400.
>
> If i put the Systemname SXXXXXX i have a error "Cann...
AS400 Network ConnectionWhen I rebooted a switch today, an AS400 running 4R5, I believe, (I don't
administer the box in question) connected to it lost its Ethernet network
connection (twinax console was still connected). A reboot brought the
connection backup.
Is there a way to prevent this from happening? If the Ethernet cable is
unplugged then plugged back in the connection dies.
"Coder" <none@nowhere.com> wrote in message
news:UeAWb.1437$_66.226@twister.rdc-kc.rr.com...
> When I rebooted a switch today, an AS400 running 4R5, I believe, (I don't
> administer the box in question) connected to it lost its Ethernet network
> connection (twinax console was still connected). A reboot brought the
> connection backup.
>
> Is there a way to prevent this from happening? If the Ethernet cable is
> unplugged then plugged back in the connection dies.
Is there a configuration setting that makes this stop? No. iSeries NICs are
very, very anal about being connected to something.
What I do is set up a reply-list entry to deal with it (WRKRPYLE). Just
have it answer 'R' whenever the message shows up. But even with this, it
will eventually quit retrying and vary-off the device.
Also, you said reboot, I hope you didn't mean IPL the entire system, just
varying off/on the line description (or if it is stuck in RCYPND status,
just '7 resume recovery' will do) and restarting TCP/IP will get it going
again.
George Kinney wrote:
>
> ...
Connect to as400 through vpnHi all,
This is sort of a strange thing, when I connect to our office
through the vpn (road warrior) I cannot access our as400.
I am using mocha, that doesn't work. I tried telneting directly
to the as400 from a command prompt, that doesn't work. I can
telnet from a command prompt to other computers in the office,
that's fine. Just not the as400s.
Anyone else have something like this?
Is there some issue with telnet or mocha through a vpn?
Thanks,
Julien
Hi,
Julien Mills schrieb:
> Hi all,
>
> This is sort of a strange thing, when I connect to our office
> through the vpn (road warrior) I cannot access our as400.
> I am using mocha, that doesn't work. I tried telneting directly
> to the as400 from a command prompt, that doesn't work. I can
> telnet from a command prompt to other computers in the office,
> that's fine. Just not the as400s.
>
> Anyone else have something like this?
>
> Is there some issue with telnet or mocha through a vpn?
>
> Thanks,
> Julien
that sounds to me as if the default gateway on as400 is'nt setup
correctly. We are using Mochasoft over vpn without any problems.
Kind regards
Michael
On Sep 23, 11:24=A0am, Michael Paris <michael.pa...@pv-koeln.de> wrote:
> Hi,
>
> Julien Mills schrieb:
>
> > Hi all,
>
> > This is sort of a strange thing, when I connect to our office
> > through the vpn (road warrior) I cannot access our as4...
MQ connection on AS400 and OS390Message could be send to 390 from AS400 through a channel. However, message
could not be send from 390 to AS400 through an other channel. Any idea??
...
PowerPC extensions for IBM AS400Looking for an explanation or documentation on the as400 specific
extensions to the PowerPC instruction set.
Pointers on the as400 are stored as 16 byte values. The LQ ( load
quad word ) and STQ ( store quad word ) instructions are used to load
and store those pointers.
Here is PPC assembler code that loads a pointer from an EA into a
register:
LQ 24, 0x1e50(30), 6
SELRI 26, 25, 0, 41
LQ loads the 16 bytes stored at EA reg30 + 0x1e50 into reg24 and
reg25. The next SELRI stmt does something to reg25 and places the
result in reg26. Does anyone know what the 3rd opera...
JDBC connect to as400 databaseI' m trying to connect to as400 db2 database using JDBC driver
(com.ibm.as400.access.AS400JDBCDriver).
I'm executing query:
select vrijednost from sekvence where ime='seq_transid'
and i get this message:
[SQL0204] SEKVENCE in EXTLOG001 type *FILE not found.
Table sekvence looks like this:
CREATE TABLE VASPRDDB00/SEKVENCE (
IME VARCHAR(64) CCSID 870 NOT NULL ,
VRIJEDNOST INTEGER NOT NULL DEFAULT 1 ,
CONSTRAINT VASPRDDB00/PK_SEKVENCE PRIMARY KEY( IME )
);
What is the problem?
Thanx,
Alan
try:
select vrijednost from VASPRDDB00.sekvence where ime='seq_transid'
HTH
is it necessary to use shema (VASPRDDB00) before table name in as400
database?
Alan
The qualified name (schema.table) is mandatory if your connection use
*SQL naming criteria.
Check your connection setting.
The error that you've reported IMHO may be caused from
- naming criteria (if setted as SQL)
or (if naming is setted to SYS)
- table not found in your library list.
HTH
Most likely case is that EXTLOG001 is your default library and you are
using SQL naming scheme on your connection. You have several options:
* change to system naming and make sure VASPRDDB00 is in your library
list
* SET SCHEMA EXTLOG001 /* makes this lib your default lib */
* fully qualify SEKVENCE with the library name (i.e.
VASPRDDB00.SEKVENCE)
Elvis
That was it.
Thanx. Alan
...
connect to AS400 using ADO...Can someonne please tell me an ADO connection string to use to link an AS400
table to Access WITHOUT using a DSN?
Thanks.
Matthew Wells
MWells@FirstByte.net
Matthew Wells wrote:
> Can someonne please tell me an ADO connection string to use to link
an AS400
> table to Access WITHOUT using a DSN?
>
> Thanks.
>
> Matthew Wells
> MWells@FirstByte.net
Have a look at Carl Prothman's website. He has examples of ADO/.NET
connections on his website
http://www.carlprothman.net/Default.aspx?tabid=87#OLEDBProviderForAS400FromIBM
Matthew Wells wrote:
> Can someonne please tell me an ADO connection string to use to link
> an AS400 table to Access WITHOUT using a DSN?
>
> Thanks.
>
> Matthew Wells
> MWells@FirstByte.net
I don't know about ADO specifically, but I have never been able to do any
sort of connection to our AS400 (ISeries) without using a DSN. The problem I
run into is that I can find no entry in the connect string for the "System"
argument that works, and yet it also doesn't work if I leave that argument
out.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
I've been able to open an ADO connection without a DSN, but not refresh a
table link.
"Rick Brandt" <rickbrandt2@hotmail.com> wrote in message
news:Zkz5e.8887$c76.8335@newssvr11.news.prodigy.com...
> Matthew Wells wrote:
> > Can s...
link table IBM AS400Hi.
Sorry for my english but I have MS Access in italian.
My problem is by link a table from IBM As400 (with > 100.000 rows).
The output of the table is many #ELIMINATO (in english "delete" / "erase"..
I dont't know the exact message).
I have tried with "requery" or recreating the link without results.
If I *import* the table from AS400 it works perfectly without problems.
Here an abstract txt
BOLAZI;BOLCLI;BOLDBO;BOLNBO;BOLCAU;BOLNPR;BOLTRE;BOLMAT;BOLDES [........]
[........]
;;;;;;;#Eliminato;#Eliminato
;;;;;;;#Eliminato;#Eliminato
;;;;;;;#Eliminato;#Eliminato
0;474;990204;354;10;1;1; 936;PC Intel Pentium II 400 Miditower
0;474;990204;354;10;4;1; 1890;CD-ROM drive 36X
0;474;990204;354;10;5;1; 1692;HD-SCSI 4.5 Gb IBM Ultrastar WIDE
7200
0;474;990204;354;10;6;1; 1497;HD-SCSI 9.1 Gb IBM DDRS-39130 UWIDE
[........]
Thanks in advance
M.
"Mire" <mary@hotmail.com> wrote in message
news:buo9eo$k39dq$1@ID-57790.news.uni-berlin.de...
> Hi.
> Sorry for my english but I have MS Access in italian.
> My problem is by link a table from IBM As400 (with > 100.000 rows).
>
> The output of the table is many #ELIMINATO (in english "delete" / "erase"..
> I dont't know the exact message).
> I have tried with "requery" or recreating the link without results.
>
> If I *import* the table from AS400 it works perfectly without problems.
>
&...
? connect to db2 as400 server
i'm new to database connectivity through java.
can u help/guide me how to connect to db2 as400 server(os 400) from
client windows/linux terminal through jdbc .
i'v downloaded the jdbc db2 driver from i-net .
tell me the specification regarding where to place the
drivers,classes,libraries etc.
Do i need to edit or create the database.properties file
thanks
-
progpro
-----------------------------------------------------------------------
Posted via http://www.codecomments.co
-----------------------------------------------------------------------
Hi,
you need another driver, you'll find it at
http://www-1.ibm.com/servers/eserver/iseries/toolbox/downloads.htm
its an pure java driver and runs on any java system. The driver class is
com.ibm.access.AS400JDBCDriver
the url you need is
jdbc:as400://HostName/DefaultSchema
Dieter Bender
progprob wrote:
>
> i'm new to database connectivity through java.
>
> can u help/guide me how to connect to db2 as400 server(os 400) from a
> client windows/linux terminal through jdbc .
>
> i'v downloaded the jdbc db2 driver from i-net .
>
> tell me the specification regarding where to place the
> drivers,classes,libraries etc.
>
> Do i need to edit or create the database.properties file
>
> thanks.
>
>
>
> --
> progprob
> --------------------------------------------------------------------...
ADO Connection To AS400Hi All
Hope someone can help me here as I am losing the plot fast.
I am attempting to import data from an AS400 table (The application is
Mapics)
into forms in a Lotus Notes application
Below is the code that I use to connect to the AS400. However when I
attempt to display any value from the record set I get a type mismatch
error. If I change the connection to point to a table in a non-mapics
library I am able to display the value with no problem.
The user profile I am logging on with has the required authority.
I have retrieved data using ADO and Delphi before so this should w...
Sybase Db connection from AS400Hi
I have a webserver written in java and running in tomcat on an iseries.
Currently I connect to the iseries DB2 database with the JDBC driver
com.ibm.db2.jdbc.app.DB2Driver. Now there is a requirement to connect to a
machine that hosts a sybase database do I just need to load up one of
standard sybase JDBC drivers like com.sybase.jdbc.SybDriver or
com.sybase.jdbc2.jdbc.SybDriver onto the iseries? or is there anything
special I need to know?
Thanks in advance
Steve
Hi,
all Type 4 drivers should work without any problems
Dieter Bender
torch wrote:
> Hi
> I have a webserver written in java and running in tomcat on an
> iseries.
> Currently I connect to the iseries DB2 database with the JDBC driver
> com.ibm.db2.jdbc.app.DB2Driver. Now there is a requirement to connect to a
> machine that hosts a sybase database do I just need to load up one of
> standard sybase JDBC drivers like com.sybase.jdbc.SybDriver or
> com.sybase.jdbc2.jdbc.SybDriver onto the iseries? or is there anything
> special I need to know?
>
> Thanks in advance
>
> Steve
...
Best way to connect to AS400What I'm looking for is to find the most efficient way to connect to
the AS400 either using a .Net solution or Java solution.
I know I can connect using ODBC driver for .Net but I know it is quite
slow, but I'm not aware of the speed of a JDBC driver connecting to
the AS400. Depending on which way is more efficient will decide which
language I will be programming my apps in. If there are any other
suggestions, please let me know.
Thank you for the advice.
The .NET & ODBC drivers are going to perform the same as the JDBC driver. What
you need to do is look at your application design and how sound your indexing
strategy is. This is covered in the iSeries SQL Performance Workshop. Goto the
DB2 UDB for iSeries website for more information (ibm.com/iseries/db2)
--
Kent Milligan, DB2 & BI team
PartnerWorld for Developers, iSeries
kmill@us.eye-bee-m.com (spam trick) GO HAWKEYES!!
>>> www.iseries.ibm.com/db2
(opinions stated are not necessarily those of my employer)
I suggest you have a look at StarQuest's drivers (they have JDBC and
ODBC), www.starquest.com. Pretty fast and easy to setup.
Bob
jconnor@as400support.com (J Connor) wrote in message news:<a1baec47.0404131303.7fc93bb1@posting.google.com>...
> What I'm looking for is to find the most efficient way to connect to
> the AS400 either using a .Net solution or Java solution.
>
> I know I can connect using ODBC driver for .Net but I know it is quite
> slow, but...