× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  • Subject: RE: Accessing SYBASE on NT
  • From: "Gokhan Yildirim (Garanti Teknoloji)" <GokhanY@xxxxxxxxxxxxxx>
  • Date: Sat, 24 Mar 2001 17:22:47 +0200

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


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 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 [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.