AS400 to AS400 connection
Hi. What`s the rocommended method of copyting data beetween two AS400 (both on V5R1) ? Regards, Tom tom wrote: > Hi. > What`s the rocommended method of copyting data beetween two AS400 (both on > V5R1) ? Probably FTP. "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. 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 wro...

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 print que on windows 2003
I have quoted this text from another message. It is exactly the same problem I am having. We have an AS/400 that is currently printing to a Windows 2000 box using a remote outq. It basically sends an LPR request to a printer share on the windows 2000 box. This works fine. I am trying to set up a second print server, this time using Windows 2003. I change what IP address the AS/400 is sending the print to and have the printers and shares the same but the Windows 2003 box rejects the request. A look at the event log gives this information for each attempt to print: The description for Event ID ( 4008 ) in Source ( LPDSVC ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE=3D flag to retrieve this description; see Help and Support for details. The following information is part of the event: \\192.168.210.146\test, 192.168.3.1 Any help would be greatly appreciated.=20 Reply =BB Shaun Sounds like the Like the LPD service on you windows server is not loaded, stopped or busted. Checked the TCP Print Services service is loaded, running & that the print queue specified on the OUTQ exists on the Windows 2003 server (preferably with no spaces or special characters in the name as this can cause problems) Good luck shaun.guanco@gmail.com wrote: > I have quoted this text from another message. It is exactly the same > probl...

Printing AS400 to Windows Server 2003
I have presently a number of printers on my AS400 printing to shared printers on a Windows 2000 Server. This setup has been working fine for many years. I am installing a new print server and using Server 2003 on the new server. I cannot successfully get the files to spool form the 400 to Server 2003. I have the same shared names on my 2000 server as my 2003 server (all simple short names, no weird characters) and if I simply change the IP address back to the 2000 server, they print fine. The setup of the printers on the two servers is identical. The windows firewall is disabled so that is not an issue. TCP and the Print Spooler service are on the 2003 server and running/ configured. I am getting no errors on either the AS400 logs or the Windows Server logs. I contacted IBM and they confirmed that the AS400 setup was correct and they did a trace from the AS400 and they said the request to print is being rejected by the Windows Server and offered no help beyond that. Has anyone had any similar problems with 2003 server? If so, how did you solve? Thanks in advance for you help. il 05/10/2007 18.15, Scrive BobLindemannInCa@gmail.com 40391552: > I have presently a number of printers on my AS400 printing to shared > printers on a Windows 2000 Server. This setup has been working fine > for many years. I am installing a new print server and using Server > 2003 on the new server. I cannot successfully get the files to spool > form the 400 to Server 2003. ...

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...

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' ...

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...

FTP Problem from AS400 to Windows server 2003 IIS 6.0
Hello, we use to transfert files from AS400 to Windows server 2003 and it works fine with files size <= 1 meg. But sometimes we have to transfert files size between 10 to 20 megs. It works very well, it means it transfered the data but we never receive the confirmation from the remote host ( server window 2003 )here is the log : "Enter an FTP subcommand. put mebug mebugp (file size 1 meg) 227 Entering Passive Mode (10,129,113,249,19,142). 125 Data connection already open; Transfer starting. 226 Transfer complete. 920808 bytes transferred in 4.904 seconds. Transfer rate 187.755 KB Enter an FTP subcommand. put mesoup mesoup(file size is 16meg) 227 Entering Passive Mode (10,129,113,249,19,143). 125 Data connection already open; Transfer starting. No response from remote host; all connections closed." What we must do!!!! please Look at your CHGFTPA settings. Also, are these bat files your running or some kind of script, does it have delays in it maybe. ...

AS400 in windows domain integration with another windows domain
Currently we acquired a company that has AS400 with Kerberos auth/ iSeries navigator in a Windows domain. We built a one way trust to their domain that allows us to access their resources. One of those resources is the AS400 but we are having trouble integrating the iSeries navigator work with another domain. Any suggestions? Advise? Thank you in advance! On Aug 18, 5:36=A0pm, tc <tchang73...@yahoo.com> wrote: > Currently we acquired a company that has AS400 with Kerberos auth/ > iSeries navigator in a Windows domain. We built a one way trust to > their domain that allows us to access their resources. One of those > resources is the AS400 but we are having trouble integrating the > iSeries navigator work with another domain. Any suggestions? Advise? > Thank you in advance! Maybe a port issue, is there a way to bypass the kerberos at all to verify?? ...

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 ...

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...

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...

mapping of AS400 in Microsoft windows
Anyone help with the client access requirements to view AS400 using os400 V3r2 Your Best Bet will be to dig out and Win98 PC, use client access V3R2 (and service pack) this will automatically add your iSeries into the network neighbourhood when configure it. You can then map to this new computer. This is supported using IP, Twinax, SNA adaptors but IP is by far the best even with code this old. Good Luck terry.mayell@iod.com wrote: > Anyone help with the client access requirements to view AS400 using > os400 V3r2 ...

FTP between AS400 and windows server
Hello, I'd like to execute a bat file which is on my windows server from my AS400 with an ftp command. Is it possible and if yes which command should I enter on my AS400. Best regards, If you have CA/400 loaded on the server I think you can use RUNRMTCMD to run a job on the Windows server. If you're open to a commercial solution, take a look at our iSeries Office Integrator software. You can run PC jobs, execute MS Word mail merges, launch web sites and more. Regards, Richard Schoen RJS Software Systems Inc. "The AS/400 and iSeries Report and Data Delivery Experts" Email: richard@rjssoftware.com Web Site: http://www.rjssoftware.com "zebute" <esaulodes@m6net.fr> wrote in message news:ba6d8cb9.0401210205.3b570995@posting.google.com... > Hello, > > I'd like to execute a bat file which is on my windows server from my > AS400 with an ftp command. > Is it possible and if yes which command should I enter on my AS400. > > Best regards, Hllo ! DO "toto.txt" with open namesys or ip adress user xxxx >>> syntax of user and pass no sure see ftp documentation pass xxxx .......put ...get.... After you call in dos command : FTP toto.txt Tomorrow i send one exemple "zebute" <esaulodes@m6net.fr> a �crit dans le message de news:ba6d8cb9.0401210205.3b570995@posting.google.com... > Hello, > > I'd like to execute a bat file which is on my windows server from my > AS400 wi...

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. > &...

AS400 command from DOS/Windows
thanks ...

QNTC and Windows Server 2003
We added our first file server to our network last week. From our ISeries I can view the share documents on my desktop pc's hardrive using WRKLNK '/QNTC/my_pc_name. But when I WRKLNK '/QNTC/our_server' I don't see any files or subdirectories listed. I assume its and permission or authority problem but I'm not sure where to look. Any suggestion on what to check? Eb The same userid/password must exist on both (OS/400 and NT/Win2003) with enough authority. Then you can browse the QNTC server directory "Eb" <emcook@yahoo.com> schreef in bericht news:e6v4k1l44jteruuj0pqoq8ncfpngtjlt7k@4ax.com... > We added our first file server to our network last week. > > From our ISeries I can view the share documents on my desktop pc's > hardrive using WRKLNK '/QNTC/my_pc_name. > > But when I WRKLNK '/QNTC/our_server' I don't see any files or > subdirectories listed. > > I assume its and permission or authority problem but I'm not sure > where to look. > > Any suggestion on what to check? My personal userid/password is on both. Only difference might be uppercase vs lowercase. I'm in the administrator group on the server, and I should have all needed authority on the Iseries side. My joblog keeps recording. WRKLNK '/QNTC/CFCSERVER' Communication error on session to Network Server CFCSERVER. Error connecting to resource IPC$ ...

AS400 batch filetransfer to Windows filesystem
Hi I am going to make a CL with a filetransfer directly from the as400 to a windows file server. Does anyone now with wich commands I can do that? Thank you for your answers ralf > Ralf wrote: > I am going to make a CL with a filetransfer directly from the as400 to a > windows file server. Does anyone now with wich commands I can do that? With the QNTC file system and iSeries NetServer, you can use the CPYTOIMPF command to directly copy a file from the iSeries or AS/400 *directly* to a folder on a Windows system. For more information about NetServer, see: http://www-1.ibm.com/servers/eserver/iseries/netserver/ Steve Landess Austin, Texas (512) 423-0935 <rlutz@kvz-schule.ch> wrote in message news:<3fe292cf$0$774$5402220f@news.sunrise.ch>... > Hi > > I am going to make a CL with a filetransfer directly from the as400 to a > windows file server. Does anyone now with wich commands I can do that? > > Thank you for your answers > > ralf You can also use FTP ...

Connection to DB on AS400 from Windows client
Hi, I am new to AS 400. I have a Database on AS400. I have to write a program that runs in Windows XP Server, it has to access the database on AS400. I have to develop the program in VB or java. Is it possible? Plz suggest me some resources and links where in i can find relavent information. Thank you, Nanda Kishore. You won't have any trouble here. The iSeries Access product, which comes as part of OS/400, has ODBC, JDBC, OLEDB etc. See: http://www-03.ibm.com/servers/eserver/iseries/access/windows/ http://www-03.ibm.com/servers/eserver/iseries/access/dotnet/ http://www-03.ibm.com/servers/eserver/iseries/access/toolkit/ Take a look at the left hand pane on this page, lots of info and exmples too. -- Glenn "Nandu" <dunlop9@gmail.com> wrote in message news:1124858561.507812.230270@f14g2000cwb.googlegroups.com... > Hi, > > I am new to AS 400. I have a Database on AS400. I have to write a > program that runs in Windows XP Server, it has to access the database > on AS400. I have to develop the program in VB or java. Is it possible? > Plz suggest me some resources and links where in i can find relavent > information. > > Thank you, > > Nanda Kishore. > You can use the OLEDB/ODBC driver included with iSeries Access (formerly known as Client Access) to access DB2 data from a windows client. "Nandu" <dunlop9@gmail.com> wrote in message news:1124858561.507812.230270@f14g2000cwb.googlegroups.com...

smb client and Windows 2003 server
I got a strange problem: When I try to copy folders containing many files from Max OS X to a Windows Server 2003 using smb, I get an error -43 somewhen during the operation. However, if the files are copied one-by-one or not many at a time, it works fine. Has anyone some experience with this? Thanks a lot, Matthias Haldimann ...

FTP from AS400 System to Windows System
How to get a Physical file as it is for populating into a excel file, without using i series (plugins, navigators)? On Tuesday, November 26, 2013 2:05:55 AM UTC-5, Muthukumar Kailasam wrote: > How to get a Physical file as it is for populating into a excel file, without using i series (plugins, navigators)? you can use ODBC to query then populate an excel spreadsheet. Make sure iSeries ODBC was installed on the client and it should be pretty straight forward. To keep users from messing up queries (which they will), use stored procedures or Query manager to run the query to an o...

IBM AS400 certfication test papers
Aprax Consulting believes in developing professionals who believe in themselves and are equipped with the latest state of the art in their respective fields, professionals who are confident and can compete in the challenging world. The endeavor is to inculcate a desire for continuous improvement, a sense of healthy competition, and sensitivity towards ethical and moral values. Aprax consulting offers all types of certification test papers, dumps with 100% assurance of passing. 100% Money refunded if failed (except courier charges). All IBM certification including Mainframe certification, AS400 certification test papers available. IBM MAINFRAME DB2 certification IBM AS/400 RPGILE certification Contact: Aprax Consulting Ph(M): +91-9873500678 URL: www.apraxindia.com Email: hr@apraxindia.com Your 1st sentence is grammatically incorrect and doesn't make any sense. One question: Isn't your moral values endeavor compromised by selling dumps? ...

SMB & Windows 2003 server
After running SMBfsys, adding an user, mount_smb fails with the error message "permission denied". The user is registered on the Windows 2003 server, the shared directory got the "total control" for the user. If anybody have an idea... Note that the client is a QNX4.25 machine Bye On 2004-09-15 11:10:03 -0400, Yann KERNIN <ykernin@cmseddyscan.com> said: > After running SMBfsys, adding an user, mount_smb fails with the error > message "permission denied". > The user is registered on the Windows 2003 server, the shared directory > got the "total control" for the user. > If anybody have an idea... > Note that the client is a QNX4.25 machine > Bye You might check the Windows Server 2003 security settings to ensure that its allows downlevel/compatible connections. One setting that typically throws things off with a Samba client (happens on Mac OS X, for example) is the "Always digitally sign" setting. This is done in the Local Security Policy console (or, if in an Active Directory domain, in Group Policy). Just a thought. HTH. -- Scott Lowe Mercurion Systems, Inc. ...

Printing from an AS400 to a Windows or Unix printer
Is it possible to get an as400 (v4r5) to use a printer connected to a windows box sharing its printer or a unix box accepting network printer connections? If so, are there any good docs or links that discuss some of the options? Thanks. Hi, Check out Brooks Internet Software, www.brooksnet.com for some very good yet reasonable LPR/LPD products supporting AS/400. Larry T. The Praetorian <mlutgen@gmail.com> wrote: > Is it possible to get an as400 (v4r5) to use a printer connected to a > windows box sharing its printer or a unix box accepting network printer > connections? Yes. Remote output queues send out print jobs as lpr/lpd jobs. You need to have the AS/400 configured to send to the right lpd queue, and the remote system must accept lpd jobs from the AS/400. I gather that CRTDEVPRT is better than remote output queues, but haven't had a version of OS/400 that provided it to try. If the remote system is Windows XP Pro, you can load the "Print Services For Unix" package to give it a (weak) lpd server. This is likely to have a high suckage factor. I've used FreeBSD with very good results. > If so, are there any good docs or links that discuss some > of the options? Thanks. I've posted a few AS/400 remote output queue definitions here over the last few years. Do a groups.google.com search on my email address and "AS400". -- Warren Block * Rapid City, South Dakota * USA ...