http://archive.midrange.com/cobol400-l Mailing list archive for cobol400-l at midrange.com en-us Copyright (c) 1997-2012 midrange.com and David Gibbs as a compilation work david@midrange.com (David Gibbs) 2012-01-26T16:20:10-06:00 This is an XML content feed. It is intended to be viewed in a newsreader or syndicated to another site, subject to copyright and fair use. http://static.midrange.com/images/logo.jpg http://www.midrange.com http://feeds.midrange.com/~r/cobol400-l/~3/AanW9QG-DzA/msg00004.html CRPence 2012-01-26T16:20:04-06:00 The IBM DB2 does have the capability already, and that is called DRDA. However the MS SQL Server does not provide a DRDA AS, so apparently either too few have asked of MS to provide that support or MS ignores their requests. I believe their answer is to use JDBC, which is what I believe you would be doing instead of ARDGate; but then presumably the original questions might need some answers.? Although in the first link in my message to which Dieter has responded, that was a recommendation as alternative to... <p><a href="http://feedads.g.doubleclick.net/~a/aVkczkoy96_YwhYEIn07Gqa9tn4/0/da"><img src="http://feedads.g.doubleclick.net/~a/aVkczkoy96_YwhYEIn07Gqa9tn4/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/aVkczkoy96_YwhYEIn07Gqa9tn4/1/da"><img src="http://feedads.g.doubleclick.net/~a/aVkczkoy96_YwhYEIn07Gqa9tn4/1/di" border="0" ismap="true"></img></a></p><div class="feedflare"> <a href="http://feeds.midrange.com/~ff/cobol400-l?a=AanW9QG-DzA:QIVYP-ZArPM:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/cobol400-l?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.midrange.com/~ff/cobol400-l?a=AanW9QG-DzA:QIVYP-ZArPM:dnMXMwOfBR0"><img src="http://feeds.feedburner.com/~ff/cobol400-l?d=dnMXMwOfBR0" border="0"></img></a> <a href="http://feeds.midrange.com/~ff/cobol400-l?a=AanW9QG-DzA:QIVYP-ZArPM:7Q72WNTAKBA"><img src="http://feeds.feedburner.com/~ff/cobol400-l?d=7Q72WNTAKBA" border="0"></img></a> </div><img src="http://feeds.feedburner.com/~r/cobol400-l/~4/AanW9QG-DzA" height="1" width="1"/> http://archive.midrange.com/cobol400-l/201201/msg00004.html http://feeds.midrange.com/~r/cobol400-l/~3/qK7BOFS9GRQ/msg00003.html Cole Gantz 2012-01-26T15:02:26-06:00 &#xA0; FWiW: https://www.google.com/search?q=ArdGate+&quot;D*B&quot; Syntax for SQL Server 2008 in RPG Pgm http://www.systeminetwork.com/forums/aft/109451 &quot;why don't you use ardgate? its Freeware and you could use normal embdedded SQL in RPG &lt;ed\add: or COBOL&gt; and access MS SQLServer. And you wouldn't have a JVM running in every Job needing to access MS SQL Server.&quot; Access file on Sequel Server from RPG http://archive.midrange.com/midrange-l/201201/msg00443.html http://archive.midrange.com/midrange-l/201201/threads.html#... <p><a href="http://feedads.g.doubleclick.net/~a/kcNV3sxxEKbwkAsw3Wx1shwVAc4/0/da"><img src="http://feedads.g.doubleclick.net/~a/kcNV3sxxEKbwkAsw3Wx1shwVAc4/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/kcNV3sxxEKbwkAsw3Wx1shwVAc4/1/da"><img src="http://feedads.g.doubleclick.net/~a/kcNV3sxxEKbwkAsw3Wx1shwVAc4/1/di" border="0" ismap="true"></img></a></p><div class="feedflare"> <a href="http://feeds.midrange.com/~ff/cobol400-l?a=qK7BOFS9GRQ:UnDo4846v9k:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/cobol400-l?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.midrange.com/~ff/cobol400-l?a=qK7BOFS9GRQ:UnDo4846v9k:dnMXMwOfBR0"><img src="http://feeds.feedburner.com/~ff/cobol400-l?d=dnMXMwOfBR0" border="0"></img></a> <a href="http://feeds.midrange.com/~ff/cobol400-l?a=qK7BOFS9GRQ:UnDo4846v9k:7Q72WNTAKBA"><img src="http://feeds.feedburner.com/~ff/cobol400-l?d=7Q72WNTAKBA" border="0"></img></a> </div><img src="http://feeds.feedburner.com/~r/cobol400-l/~4/qK7BOFS9GRQ" height="1" width="1"/> http://archive.midrange.com/cobol400-l/201201/msg00003.html http://feeds.midrange.com/~r/cobol400-l/~3/21EM_ShWAc4/msg00002.html CRPence 2012-01-26T12:01:19-06:00 FWiW: https://www.google.com/search?q=ArdGate+&quot;D*B&quot; Syntax for SQL Server 2008 in RPG Pgm http://www.systeminetwork.com/forums/aft/109451 &quot;why don't you use ardgate? its Freeware and you could use normal embdedded SQL in RPG &lt;ed\add: or COBOL&gt; and access MS SQLServer. And you wouldn't have a JVM running in every Job needing to access MS SQL Server.&quot; Access file on Sequel Server from RPG http://archive.midrange.com/midrange-l/201201/msg00443.html http://archive.midrange.com/midrange-l/201201/threads.html#00... <p><a href="http://feedads.g.doubleclick.net/~a/2ORhzH0FWX3E7nIB0ounD3ytarA/0/da"><img src="http://feedads.g.doubleclick.net/~a/2ORhzH0FWX3E7nIB0ounD3ytarA/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/2ORhzH0FWX3E7nIB0ounD3ytarA/1/da"><img src="http://feedads.g.doubleclick.net/~a/2ORhzH0FWX3E7nIB0ounD3ytarA/1/di" border="0" ismap="true"></img></a></p><div class="feedflare"> <a href="http://feeds.midrange.com/~ff/cobol400-l?a=21EM_ShWAc4:GDgRaPkx5DU:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/cobol400-l?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.midrange.com/~ff/cobol400-l?a=21EM_ShWAc4:GDgRaPkx5DU:dnMXMwOfBR0"><img src="http://feeds.feedburner.com/~ff/cobol400-l?d=dnMXMwOfBR0" border="0"></img></a> <a href="http://feeds.midrange.com/~ff/cobol400-l?a=21EM_ShWAc4:GDgRaPkx5DU:7Q72WNTAKBA"><img src="http://feeds.feedburner.com/~ff/cobol400-l?d=7Q72WNTAKBA" border="0"></img></a> </div><img src="http://feeds.feedburner.com/~r/cobol400-l/~4/21EM_ShWAc4" height="1" width="1"/> http://archive.midrange.com/cobol400-l/201201/msg00002.html http://feeds.midrange.com/~r/cobol400-l/~3/GreeaqKlz_w/msg00001.html Cole Gantz 2012-01-26T10:16:07-06:00 Howdy All, &#xA0; I'm in need of retrieving data from a MS SQL Server.&#xA0; &gt;From what I understand I can do this with the help of some Java.&#xA0; That's about the extent of my knowledge.&#xA0; I need help on how to call the Java class.&#xA0; I'll be passing it the 'where clause'.&#xA0; I think I can figure out how to code the Java class (any help though would be appreciated).&#xA0; I then need to know how to pass the result set back to the COBOL program.&#xA0; My thought was to limit the result set to 50 records just for simplicity sake. ; Any... <p><a href="http://feedads.g.doubleclick.net/~a/X8qfILWaR__jSTeqS-lR_8HipAc/0/da"><img src="http://feedads.g.doubleclick.net/~a/X8qfILWaR__jSTeqS-lR_8HipAc/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/X8qfILWaR__jSTeqS-lR_8HipAc/1/da"><img src="http://feedads.g.doubleclick.net/~a/X8qfILWaR__jSTeqS-lR_8HipAc/1/di" border="0" ismap="true"></img></a></p><div class="feedflare"> <a href="http://feeds.midrange.com/~ff/cobol400-l?a=GreeaqKlz_w:y4R8TH7xlYc:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/cobol400-l?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.midrange.com/~ff/cobol400-l?a=GreeaqKlz_w:y4R8TH7xlYc:dnMXMwOfBR0"><img src="http://feeds.feedburner.com/~ff/cobol400-l?d=dnMXMwOfBR0" border="0"></img></a> <a href="http://feeds.midrange.com/~ff/cobol400-l?a=GreeaqKlz_w:y4R8TH7xlYc:7Q72WNTAKBA"><img src="http://feeds.feedburner.com/~ff/cobol400-l?d=7Q72WNTAKBA" border="0"></img></a> </div><img src="http://feeds.feedburner.com/~r/cobol400-l/~4/GreeaqKlz_w" height="1" width="1"/> http://archive.midrange.com/cobol400-l/201201/msg00001.html http://feeds.midrange.com/~r/cobol400-l/~3/zzuvRtatIcg/msg00000.html Cole Gantz 2012-01-26T08:28:53-06:00 Howdy All, &#xA0; I'm in need of retrieving data from a MS SQL Server.&#xA0; &gt;From what I understand I can do this with the help of some Java.&#xA0; That's about the extent of my knowledge.&#xA0; I need help on how to call the Java class.&#xA0; I'll be passing it the 'where clause'.&#xA0; I think I can figure out how to code the Java class (any help though would be appreciated).&#xA0; I then need to know how to pass the result set back to the COBOL program.&#xA0; My thought was to limit the result set to 50 records just for simplicity sake. ; Any... <p><a href="http://feedads.g.doubleclick.net/~a/_M1a3pAFZrRhphnxnqpMYrulons/0/da"><img src="http://feedads.g.doubleclick.net/~a/_M1a3pAFZrRhphnxnqpMYrulons/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/_M1a3pAFZrRhphnxnqpMYrulons/1/da"><img src="http://feedads.g.doubleclick.net/~a/_M1a3pAFZrRhphnxnqpMYrulons/1/di" border="0" ismap="true"></img></a></p><div class="feedflare"> <a href="http://feeds.midrange.com/~ff/cobol400-l?a=zzuvRtatIcg:gENH9POcEBc:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/cobol400-l?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.midrange.com/~ff/cobol400-l?a=zzuvRtatIcg:gENH9POcEBc:dnMXMwOfBR0"><img src="http://feeds.feedburner.com/~ff/cobol400-l?d=dnMXMwOfBR0" border="0"></img></a> <a href="http://feeds.midrange.com/~ff/cobol400-l?a=zzuvRtatIcg:gENH9POcEBc:7Q72WNTAKBA"><img src="http://feeds.feedburner.com/~ff/cobol400-l?d=7Q72WNTAKBA" border="0"></img></a> </div><img src="http://feeds.feedburner.com/~r/cobol400-l/~4/zzuvRtatIcg" height="1" width="1"/> http://archive.midrange.com/cobol400-l/201201/msg00000.html