AS400 to AS400 connection
Hi. What`s the rocommended method of copyting data beetween two AS400 (both on V5R1) ? Regards, Tom
tomeks
comp.sys.ibm.as400.misc
9219 articles. 
3 followers.
3 Replies
2240 Views
tom wrote: > Hi. > What`s the rocommended method of copyting data beetween two AS400 (both on > V5R1) ? Probably FTP.
jonball"tom" <tomeks@comp.pl> wrote in message news:c8c9u5$fb4$1@nemesis.news.tpi.pl... > Hi. > What`s the rocommended method of copyting data beetween two AS400 (both on > V5R1) ? > > Regards, > Tom > > It depends how often you are doing the copying & how much there is. If you want say one record but every 3 seconds then you can either store them up for a few hours days or weeks & use FTP, snads or a tape. Or you can do it realtime & use DDMF to zap each record to the other machine as its written. I actually save the data I want sending this way into a file which is read & deleted by a daemon style of job so that if comms or the other machine fails only the daemon is affected. FTP has its upside in that the target is easily resettable for say a unix machine but SNADS has an easy to use & understand message sent to the sender & recipient to verify arrival of the data. -- Jonathan Bailey.
|
0 |
|
jb
5/18/2004 10:55:42 AM
You could install the No Charge SW "Object Connect" from the OS CDs. Once setup you can issue cmds line SAVRSTLIB and SAVRSTOBJ. Give these cmds the LIB or OBJ list and the target system. It then saves/transfers/restores to the target system all with just the 1 SAVRSTxxx cmd. tom wrote: > Hi. > What`s the rocommended method of copyting data beetween two AS400 (both on > V5R1) ? > > Regards, > Tom > >
kgoins
Similar Artilces:
AS400 to AS400 connection issues
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? 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 Toolkit
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 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 transfer
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. 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 #2
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. 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 CCSID
Hi 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 AS400
Does 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 Access
Hello 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 AS400
Hi, 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 connection
Help 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 Connection
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. "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 vpn
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 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 OS390
Message 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 AS400
Looking 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 database
I' 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 AS400
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. 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 AS400
Hi 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 AS400
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 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 AS400
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 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...
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? 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 Toolkit
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 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 transfer
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. 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 #2
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. 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 CCSID
Hi 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 AS400
Does 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 Access
Hello 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 AS400
Hi, 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 connection
Help 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 Connection
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. "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 vpn
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 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 OS390
Message 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 AS400
Looking 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 database
I' 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 AS400
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. 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 AS400
Hi 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 AS400
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 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 AS400
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 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...