Is there some way to access Sql server from z/OS mainframe and have the result in IBM 3270 terminal

Posted by systempuntoout on Stack Overflow See other posts from Stack Overflow or by systempuntoout
Published on 2010-02-08T07:56:25Z Indexed on 2010/03/15 0:39 UTC
Read the original article Hit count: 449

Filed under:

zos

|

3270

|

sql-server

|

impossible

|

cobol

I tagged this question "impossible" because after a lot of googling, i have not find any trace\reference to a possible answer. I'm asking if there is some way\dirtytrick (possibly cheap) to access Microsoft Sql Server from z/OS mainframe (COBOL programs) and have the result in 3270 terminal emulation; i know that 3270 is a pretty old system, but in bank CED, is still very popular.

© Stack Overflow or respective owner

Related posts about zos

DB2 ZOS String Comparison Problem

as seen on Stack Overflow - Search for 'Stack Overflow'
I am comparing some CHAR data in a where clause in my sql like this, where PRI_CODE < PriCode The problem I am having is when the CHAR values are of different lengths. So if PRI_CODE = '0800' and PriCode = '20' it is returning true instead of false. It looks like it is comparing it like this… >>> More
Writing a docx file to a BLOB using Java 1.4 inside Oracle 10g

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm trying to generate a blank docx file using Java, add some text, then write it to a BLOB that I can return to our document processing engine (a custom mess of PL/SQL and Java). I have to use the 1.4 JVM inside Oracle 10g, so no Java 1.5 stuff. I don't have a problem writing the docx to a file… >>> More
Why do mainframe greybeards refer to DB2/zOS as "he"? [closed]

as seen on Stack Overflow - Search for 'Stack Overflow'
If you ask a DB2/zOS engine DBA a question about DB2's behavior, the DBA will refer to the DB2 engine as "he" much the way a sailor uses "she" to refer to his ship. For example: "Once you fill the freespace, DB2 still wants to keep those rows in cluster order in the tablespace. That's why he'll… >>> More
SQL Error: -443, SQLState: 38111 when accessing table metadata on DB2 zOS

as seen on Server Fault - Search for 'Server Fault'
Hello, I'm getting following error when using Hibernate in a Java application over my DB2 database. This error occurs with one DB2 database and not with another (I'm almost sure the problem is in DB2 server side configuration), and I didn't found the difference between the two databases. The SQL… >>> More
UID/username lookup on IBM z/os USS

as seen on Server Fault - Search for 'Server Fault'
How can I associate a UID to a specific username on IBM z/OS Unix System Services? Within USS, I see content created in my user space which I do not own. File ownership lists a three digit numerical value, rather than a userid, which I presume to be a UID. I've unsuccessfully attempted to make… >>> More

Related posts about 3270

Implement 3270 protocol in Java

as seen on Stack Overflow - Search for 'Stack Overflow'
I've got a big problem with IBM HACL for accessing a server which speaks 3270 protocol. The library keeps crashing, and our JNI wrapper is actually a bug-fixing layer for the poorly-implemented and poorly-documented library (and I suspect we have introduced new bugs with it too). Moreover, in our… >>> More
Is there some way to access Sql server from z/OS mainframe and have the result in IBM 3270 terminal

as seen on Stack Overflow - Search for 'Stack Overflow'
I tagged this question "impossible" because after a lot of googling, i have not find any trace\reference to a possible answer. I'm asking if there is some way\dirtytrick (possibly cheap) to access Microsoft Sql Server from z/OS mainframe (COBOL programs) and have the result in 3270 terminal emulation;… >>> More
two samba servers and one ldap backend

as seen on Server Fault - Search for 'Server Fault'
I had setup a Samba 3 server as PDC with a passdb LDAP backend. Server SID: S-1-5-21-3270... Domain: A Every user has a SambaSID beginning with this Server SID. But now I try to setup a second server for some shares. This server should use the same LDAP backend because I don't want to have two LDAP… >>> More
Oracle announces Brand New Tuxedo 11g Release

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Today Oracle introduced two brand new products within the Tuxedo product line of its application grid portfolio. Oracle Tuxedo Application Runtime for CICS and Batch and Oracle Application Rehosting Workbench provide the ability to automate rehosting of mainframe Online and Batch applications to open… >>> More
Using Synology NAS attached to WDS-Repeater

as seen on Super User - Search for 'Super User'
I'm using the following devices for my home network: Router 1: Speedport W 723 V (192.168.2.1) Router 2: AVM Fritzbox 3270 (192.168.2.2) NAS: Synology DS 207+(192.168.2.3) I successfully set up a WDS connection between the two routers. The Speedport acts as basestation, the Fritzbox repeats the… >>> More