|
1.Method ( Using Jaguar(Sybase Application Server)) 1 - Create a procedure on AS/400 that includes arguments and "insert values into AS/400 table" statement. 2 - Create a component on Jaguar(Sybase App. Server) using Sybase Application Integrator for Stored Procedure that reference to stored Procedure on AS/400 via Sybase DirectConnect for AS/400. 3 - Create a second component on Jaguar(Sybase App. Server) that runs any SQL statement on Sybase Adaptive Server (Database), and calls the Jaguar component that references the stored procedure on AS/400 using selected data. 4 - As a result of that, when you can call the second component on Jaguar from any client application, it runs SQL statement, returns the data, calls the first Jaguar component with the data as arguments, runs stored procedure on AS/400 and the arguments will be written on the AS/400 table as data. 2.Method (Using "Transfer utility" on Sybase DirectConnect for AS/400)) 1- Take a look at the Access Service User's Guide DirectConnect for AS/400 (http://manuals.sybase.com/onlinebooks/group-dc/dca1200e/as4axsrv) Chapter 9 "Understanding the Transfer Process" explains it and Chapter 11 3.Method (Using "Transfer utility" on Sybase DirectConnect for AS/400)) 1- Take a look at the Access Service User's Guide DirectConnect for AS/400 (http://manuals.sybase.com/onlinebooks/group-dc/dca1200e/as4axsrv) Chapter 11 2 - Execute jaguar component with transfer utility on DirectConnect for AS/400 as below: c:>isql -SAS400_server_name -Uuser_name -Ppassword_name 1>transfer from 'sjaguar_server_name suser_name spass_name'; 2>use procedure ordrproc ???; 5>update as400_table 6>set as4_col1=?, as4_col2=?, as4_col3=? 8>go Best Regards, G�khan YILDIRIM GARANTI TECHNOLOGIES Evren Mah. Kocman Cad. No:22 34550 - Gunesli / Bagcilar ISTANBUL / TURKEY Tel : 90 + (212) 478 30 44 Faks: 90 + (212) 657 04 73 mailto:GokhanY@Garanti.Com.TR -----Original Message----- From: John Myers [mailto:jmyers@sbsusa.com] Sent: Tuesday, March 20, 2001 4:12 PM To: GokhanY@garanti.com.tr Subject: Accessing SYBASE on NT - Thank you! Gokhan, Thank you for your help! Will Direct Connect allow me to access a Sybase Database FROM an AS/400 ? The materials that you send seem to indicate that it will allow access TO an AS/400 ? John >From: "Gokhan Yildirim (Garanti Teknoloji)" <GokhanY@garanti.com.tr> >To: "'MIDRANGE-L@midrange.com'" <MIDRANGE-L@midrange.com> >Subject: RE: Accessing SYBASE on NT >Date: Mon, 19 Mar 2001 11:14:47 +0200 >X-Mailer: Internet Mail Service (5.5.2653.19) >Sender: owner-midrange-l@midrange.com >Reply-To: MIDRANGE-L@midrange.com > >http://www.sybase.com/detail/1,3693,204838,00.html >http://www.sybase.com/detail/1,3693,204839,00.html >http://manuals.sybase.com/onlinebooks/group-dc/dcp1200e/dcinstnt/@ebt-link; p >t=3067;lang=tr?target=%25N%14_3104_START_RESTART_N%25 > ><http://manuals.sybase.com/onlinebooks/group-dc/dcp1200e/dcinstnt/@ebt-link ;pt=3067;lang=tr?target=%25N%14_3104_START_RESTART_N%25>http://manuals.sybas e.com/onlinebooks/group-dc/dcp1200e/dcinstnt/@ebt-link;pt=3067;lang=tr?targe t=%25N%14_3104_START_RESTART_N%25 > > > > >-----Original Message----- >From: John Myers - MM [mailto:jmyersmm@sbsusa.com] >Sent: Thursday, March 15, 2001 5:31 AM >To: MIDRANGE-L@midrange.com >Subject: Accessing SYBASE on NT > > >For a customer proposal, I need to know how to access data in a SYBASE DBMS >running on an existing NT Server FROM an AS/400 RPG program. Both servers >sit on my customer's internal LAN. > >What's the best way to get this done? I would prefer direct data access >rather than writing a PC program & using MQ series to transport the data >between systems. > >TIA for the help! > >John Myers >IBM Certified Specialist - AS/400 Technical Solutions >IBM Certified Specialist - Advisor for e-Business >Strategic Business Systems, Inc. >17 S. Franklin Turnpike, Ramsey, NJ 07446 USA >E-mail: mailto:jmyers@sbsusa.com Phone: +1 (201) EASY 400 x131 >Web: http://www.sbsusa.com Fax: +1 (201) 327-6984 > >Free Sports League Management - Powered by AS/400 > http://www.ScoreBook.com > >Get and route intelligence from your IBM AS/400 web site - WebSurvey/400 > http://www.WebSurvey400.com > >Systems supporting the distribution operations of Motor Vehicle >manufacturers > http://www.VehicleSystem.com +--- | This is the Midrange System Mailing List! | To submit a new message, send your mail to MIDRANGE-L@midrange.com. | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com. | To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com. | Questions should be directed to the list owner/operator: david@midrange.com +---
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact copyright@midrange.com.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.