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
...
Web Servers and AS400Just curious of the groups current thinking regarding running the Web Server
layer (WebSphere, Apache,Tomcat, etc??) on the AS/400 versus a separate box.
I am really looking at 2 boxes (possibly firewalled apart) here not an
embedded Linux on 400 solution which I would still consider to be a single
box solution.
As an extension, I am also keen to see, in the 2 box scenario, how many
people call Java service/apps on the AS/400 or host the Java layer on the
second box and call the AS/400 solely for it's database storage.
Of course, anyone running a separate IIS server (or other??) could respond
to this second option as well as it really is a similar architectual
configuration (i.e. utilising the AS/400 for database activities only).
RJ.
I've had no problem running it on the same box as other apps. The only
time I see it pays to split it up is if you need the resousrces for web
apps vs. other apps. Then data replication/access becomes the problem.
DBDriver wrote:
> Just curious of the groups current thinking regarding running the Web Server
> layer (WebSphere, Apache,Tomcat, etc??) on the AS/400 versus a separate box.
>
> I am really looking at 2 boxes (possibly firewalled apart) here not an
> embedded Linux on 400 solution which I would still consider to be a single
> box solution.
>
> As an extension, I am also keen to see, in the 2 box scenario, how many
> people call Java service/apps on the AS/400 or host the Java layer on ...
Web data to AS400Yes I still call it an AS400. I have someone who as home grown
software and a website hosted by someone else. He wants to be able to
get the web orders into the system automatically and asked me how to
do it. I know there are probably 6 ways to Sunday to get this done,
but I am exploring all options. They have a website programmer, but
no AS400 programmer. The website guy said he knows PHP pretty well
and they are on V5R1. I am fairly good as RPG, RPGLE, CLP programming
and then some.
What would be an easy way to get this information to the system?
Thanking any suggestions,
I do thank all the pros for taking time to post to this group.
"Chad White" <chadwhite12@gmail.com> wrote in message
news:3a886508-1295-4ca1-bffb-b62576d2f863@a21g2000yqn.googlegroups.com...
> Yes I still call it an AS400. I have someone who as home grown
> software and a website hosted by someone else. He wants to be able to
> get the web orders into the system automatically and asked me how to
> do it. I know there are probably 6 ways to Sunday to get this done,
> but I am exploring all options. They have a website programmer, but
> no AS400 programmer. The website guy said he knows PHP pretty well
> and they are on V5R1. I am fairly good as RPG, RPGLE, CLP programming
> and then some.
>
> What would be an easy way to get this information to the system?
>
> Thanking any suggestions,
>
> I do thank all the pros for taking time to ...
AS400 to AS400 connectionHi.
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 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...
browser access to as400 datahow do I secure browser access to as400 data? Should the user be
logging onto the website which provides access to data on the as400?
No doubt, but what should the user name and password be? If the user
logs on with an as400 user name and password, how do you prevent the
password from being transmitted thru the web, from the browser to the
web server?
The web server in this case is a windows xp PC with IIS installed. The
usage has, to date, been limited to users behind the firewall. Now
there is a need for users in another location to access this internal
web server.
thanks,
If you use an HTTPS connection (instead of plain HTTP), there should
be no issues with visible passwords.
Whether the user authenticates as a Windows user to the webserver, or
as an AS/400 user to the underlying database, or whether Single-Sign-
On should be used (authenticating to Windows and AS/400 with the same
credentials) is difficult to say without more information about your
situation.
On Sep 22, 11:28=A0am, "walker.l2" <walker...@ukonline.co.uk> wrote:
> If you use an HTTPS connection (instead of plain HTTP), there should
> be no issues with visible passwords.
>
> Whether the user authenticates as a Windows user to the webserver, or
> as an AS/400 user to the underlying database, or whether Single-Sign-
> On should be used (authenticating to Windows and AS/400 with the same
> credentials) is difficult to say without more information about your
> situa...
FTP between AS400 and windows serverHello,
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...
DTS -- SQL Server Data to AS400Hi,
I'm trying to dug this issue since couple of days but couldn't find
any solution.
I have SQL server 2000 SP 3 and Host Integration Server 2000 SP 1
running. I'm able to download data from AS400/DB2(V5R2M0) into SQL
server, using Microsoft OLE DB Provider for DB2 in DTS.
But when I tried to upload the same table (downloaded from AS400 into
Sql server) back to AS400, I got the following error.
HResult of 0x8004206a(-2147213206) returned Unexpected error occurred.
An error result was returned without error message.
Anyone knows any thing about plese help me with this issue. I'll
really appreciate it.
Thanks in advance
Noor
...
HELP: accessing AS400 data in OracleI'm trying to access data from AS400 using gateway.
e.g. SELECT * FROM LIB.FILE2@AS400
It works for some tables only. All tables are from the same library and
have all privilages granted to Oracle. I just guess that it does not
work for the tables that were added on the AS400 recently but I'm not
sure. I've never used gateway before.
The error I'm getting is the following:
ORA-0942:tableor view does not exist
ORA-02063:preceding line from AS400
Of course I checked AS400. The table exists.
Any help is greatly appreciated.
Thanks
Andrzej Urbanowicz
<andrzeju@yahoo.com> wrote in message
news:1105023866.601325.23650@f14g2000cwb.googlegroups.com...
> I'm trying to access data from AS400 using gateway.
> e.g. SELECT * FROM LIB.FILE2@AS400
> It works for some tables only. All tables are from the same library and
> have all privilages granted to Oracle. I just guess that it does not
> work for the tables that were added on the AS400 recently but I'm not
> sure. I've never used gateway before.
>
> The error I'm getting is the following:
> ORA-0942:tableor view does not exist
> ORA-02063:preceding line from AS400
>
> Of course I checked AS400. The table exists.
> Any help is greatly appreciated.
> Thanks
> Andrzej Urbanowicz
>
Are the table names case sensitive ? Just an idea, I don't know AS400 ...
Matthias Hoys wrote:
> <andrzeju@yahoo.com> wrote in message
> news:110502...
Printing AS400 to Windows Server 2003I 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. ...
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...
Securely Connect AS400 to Unix Web ServerGood morning,
We are building a new website and need to securely send/receive data
to/from Unix web server. I do not know anything about Unix/Linix
boxes and the guy whom I am working with does not know anything about
AS400/iSeries.
Any suggestions would be greatly appreciated.
We are running on:
9406-820
V5R2
Thank you in advance.
Gary
Hi Gary,
A bit more detail might be required here, but really you've got loads
of options. If you need to access the database on the AS/400 from
UNIX, I'd say JDBC or something similar for your language of choice on
UNIX would be fine, would need no extra software on the AS/400.
If you need to access actual files on the AS/400, then automating FTP
could be a decent idea, again, would not require any software on the
AS/400.
If you need to run any programs on the AS/400, to generate data before
sending it over to the UNIX box, then I think maybe a REST service, or
RPC call might be nice, this would require some work on the AS/400
though.
Without knowing exactly what you need though, it's difficult to
suggest a great solution.
Cheers
Garry
On Aug 25, 1:33=A0pm, SegalRea...@gmail.com wrote:
> Good morning,
>
> We are building a new website and need to securely send/receive data
> to/from Unix web server. =A0I do not know anything about Unix/Linix
> boxes and the guy whom I am working with does not know anything about
> AS400/iSeries.
> Any suggestions would be greatly appreciated.
>
> We are runn...
Could anybody point me to comparison of Windows 2K Pro, 2K Server 2003 Server, XP Pro??Hi,
I am searching for a matrix with comparison of different windows
operating systems like Win 2k Professional , W 2k Server, Win 2003 Server,
XP Pro. Microsoft web site has one such thing but it compares Win 2003
server editions.
I would be more interested in core changes between above OSes.
Thanks in Advance,
Arun.
...
Synchronise data from Local FileMaker with Access on web serverDoes anyone know how to get FileMaker to synchronise data with an
Access database file on a web server? I am running FileMaker locally
and want to download information from my web site which uses ASP to
write information to an Access database. I also want to be able to
update the information in the Access database file with new data from
my Local FileMaker.
If any one has done this already or has got any ideas how it can be
done I would be extremely grateful.
Many thanks,
C. Harford.
...
Data Replication between AS400 v5.3 and SQL server 2005Hi All,
We need to provide a solution to our client who is currently using
AS400 v5.3 in which real time stock/inventory details from AS400 are
replicated into another external database (SQL Server) and any change/
update to SQL server is synchronized back to AS400 . So we need a bi-
directional solution, in which changes from both sides are
synchronized based on event detection.
Now our client has mentioned that, due to the company policy, we might
not be authorized to access the AS400 database directly, i.e. they
don't want any third party application to query the AS400 database
directly.
Which technique best suit here. Is Data Mirror the right choice in
this scenario, or is there any more better way to achieve this.
Thanks in advance,
Haroon
hkhokhar wrote:
> Hi All,
>
> We need to provide a solution to our client who is currently using
> AS400 v5.3 in which real time stock/inventory details from AS400 are
> replicated into another external database (SQL Server) and any change/
> update to SQL server is synchronized back to AS400 . So we need a bi-
> directional solution, in which changes from both sides are
> synchronized based on event detection.
>
> Now our client has mentioned that, due to the company policy, we might
> not be authorized to access the AS400 database directly, i.e. they
> don't want any third party application to query the AS400 database
> directly.
> Which technique best suit here. Is Data Mirr...
Integration of AS400 Client Access Emulation into Frame of Web PageHi,
Is it possible to integrate AS400 client access emulation into one
frame of web page? I know it is possible to show the content of the
emulation on a web page but that has been converted into a HTML format
(I supposed). What I want is that the original screen is to appear
within one of the frame of the page so that all the existing keying
function on the emulation still remains. Please advise.
Thanks & regards.
...
AS400 as SQL Server Linked serverHi,
I'm trying to set up DB2 on AS400 as a linked server on SQL Server.
Everything works ok, but, when I try to run an UPDATE, it gives me an
error (OLE/DB Provider 'MSDASQL' IRowsetChange::SetData returned
0x80004005). I've searched a lot on the internet, I've tried some
solutions but without success.
I'm using SQLServer 2000 and Client Access 5 release 1.
Is there any solution or workaround ?
Thanks in advance
Massimo
...
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 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...
Data Access pages with RDS/useremoteprovider so DB is on web serverAnyone able to do this with Access created Data Access Pages, using
UseRemoteProvider parm on DAP and getting RDS configured properly on the
server so the DAP's activeX can access the database on the server?
If so any advise, good references, etc.???
I get the UseRemoteProvider to True
I set the name of the database to \\myservername\dbdirectory\dbname.mdb
and make sure that dbdirectory is a share name on the server
with web access specified.
Tried getting RDS set on my WinXPPro with IIS but don't think it ever
got setup correctly.
Heard about issues with properly configuring mdfsmap.ini on the server.
Would appreciate any help.
Bob
Bob Alston wrote:
> Anyone able to do this with Access created Data Access Pages, using
> UseRemoteProvider parm on DAP and getting RDS configured properly on the
> server so the DAP's activeX can access the database on the server?
>
> If so any advise, good references, etc.???
>
> I get the UseRemoteProvider to True
> I set the name of the database to \\myservername\dbdirectory\dbname.mdb
> and make sure that dbdirectory is a share name on the server
> with web access specified.
> Tried getting RDS set on my WinXPPro with IIS but don't think it ever
> got setup correctly.
> Heard about issues with properly configuring mdfsmap.ini on the server.
>
> Would appreciate any help.
>
> Bob
Found my own answer. Microsoft no longer recommends using RDS - due t...
com.ibm.as400.access.AS400JDBCConnectionHandle.getMetaData(AS400JDBCConnectionHandle.java:330)Hi,
I am running a web app on WAS 5.0 on Linux connecting to iSeries V5R2 for
DB2 access using the tool box driver. Most of the time this works fine but
occasionally I get the stuff listed below. When this happens the app just
crashes out. Its weird because this happens on pages that where running fine
5 minutes ago. It appears like my connections are going stale but my app
thinks they are fine. There is no firewall between the two boxes so I cant
blame it on the firewall killing the connection. Has anyone seen this before
or am I totally off on the wrong track. Any help would be most appreciated.
BTW It does not seem to happen when running on WAS 5.0 on the iseries but
then its on the same machine and the drivers local.
Mutley.
[03.08.21 14:14:10:162 BST] 6bcc1e57 WebGroup X Servlet Error: :
java.lang.NullPointerException
at
com.ibm.as400.access.AS400JDBCConnectionHandle.getMetaData(AS400JDBCConnecti
onHandle.java:330)
at com.ibm.ejs.cm.pool.ConnectO.getMetaData(ConnectO.java:2121)
at
com.ibm.ejs.cm.proxy.ConnectionProxy.getMetaData(ConnectionProxy.java:572)
at
com.ibm.db.db.base.DatabaseConnection.getConnectionMetaData(DatabaseConnecti
on.java(Compiled Code))
at com.ibm.db.db.base.DatabaseConnection.disconnect(DatabaseConnection.java)
at com.ibm.db.db.DatabaseConnection.disconnect(DatabaseConnection.java)
at com.ibm.db.beans.DBSelect.close(DBSelect.java)
at com.ibm.db.beans.DBSelect.close(DBSelect.java)
at com.kdpsoftware.landmark.LogIn.LogInQuery.close(LogInQ...
Constant com.ibm.as400.access.jobList.addJobSelectionCriteria(JobList.SELECTION_JOB_QUEUEI am using the following code to try and return a list of jobs that sre
running in QBATCH5
---
QSYSObjectPathName path = new
QSYSObjectPathName("QGPL","QBATCH1","JOBQ");
jobList.addJobSelectionCriteria(JobList.SELECTION_PRIMARY_JOB_STATUS_ACTIVE,
Boolean.TRUE);
jobList.addJobSelectionCriteria(JobList.SELECTION_PRIMARY_JOB_STATUS_OUTQ
, Boolean.FALSE);
jobList.addJobSelectionCriteria(JobList.SELECTION_JOB_QUEUE,
path.getPath());
For some reason it brings back a list of my Active jobs that show up in
WRKACTJOB...
Shouldn't
jobList.addJobSelectionCriteria(Jo...
FTP Problem from AS400 to Windows server 2003 IIS 6.0Hello,
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.
...