# \#SQL-Access **URL:** https://techcommunity.softwareag.com/tag/sql-access/96.md [Latest](https://techcommunity.softwareag.com/latest.md) · [Categories](https://techcommunity.softwareag.com/categories.md) · [Tags](https://techcommunity.softwareag.com/tags.md) --- ## [Adabas-Natural Best Practices for Multi-level Security](https://techcommunity.softwareag.com/t/adabas-natural-best-practices-for-multi-level-security/237610)
**Author:** [@Brian\_Johnson1](https://techcommunity.softwareag.com/u/Brian_Johnson1)\ **Replies:** 0\ **Last updated:** [June 18, 2013, 12:07pm UTC](https://techcommunity.softwareag.com/t/adabas-natural-best-practices-for-multi-level-security/237610 "2013-06-18T12:07:20Z")
By Brian Johnson, Eaton Corporation and Becky Albin, Chief IT Architect, Software AG Security on IBM mainframe platforms, where many installations of Software AG’s Adabas and Natural reside, is considered robust. How… --- ## [Data Privacy and the Role of Data Masking](https://techcommunity.softwareag.com/t/data-privacy-and-the-role-of-data-masking/237589)
**Author:** [@system](https://techcommunity.softwareag.com/u/system)\ **Replies:** 0\ **Last updated:** [September 27, 2012, 4:48pm UTC](https://techcommunity.softwareag.com/t/data-privacy-and-the-role-of-data-masking/237589 "2012-09-27T16:48:55Z")
Test data privacy is critical to all enterprises and data masking is the best way to help secure your test data for better testing results and fewer budget overruns in your projects. Learn more about Data Masking for … --- ## [Is there a service function to "ping" defined data servers?](https://techcommunity.softwareag.com/t/is-there-a-service-function-to-ping-defined-data-servers/208180)
**Author:** [@ChristianHeld](https://techcommunity.softwareag.com/u/ChristianHeld)\ **Replies:** 2\ **Last updated:** [June 3, 2020, 8:20pm UTC](https://techcommunity.softwareag.com/t/is-there-a-service-function-to-ping-defined-data-servers/208180 "2020-06-03T20:20:14Z")
Hello I have a simple question. ACE offers a set of “service” functions which retrieve internal JDBC data. Examples: SELECT CNXCURRENTCONNECTIONS() ,CNXPEAKCONNECTIONS() ,CNXTOTALCONNECTIONS() ,CNXCURRENTSTATEMEN… --- ## [Can Encryption be put on the Data been retrieved from the Mainframe Adabas Database](https://techcommunity.softwareag.com/t/can-encryption-be-put-on-the-data-been-retrieved-from-the-mainframe-adabas-database/227258)
**Author:** [@anon55491631](https://techcommunity.softwareag.com/u/anon55491631)\ **Replies:** 1\ **Last updated:** [June 1, 2020, 3:22pm UTC](https://techcommunity.softwareag.com/t/can-encryption-be-put-on-the-data-been-retrieved-from-the-mainframe-adabas-database/227258 "2020-06-01T15:22:49Z")
We have a customer who want to access data from a Adabas Database on the Mainframe (z/os) through Entire Net-work to the Adabas SQL on LINUX and applications using an ODBC link. this is a bank and need to ensure the da… --- ## [Used of Super Descriptor to Optimize SQL Query](https://techcommunity.softwareag.com/t/used-of-super-descriptor-to-optimize-sql-query/101784)
**Author:** [@Min\_Chai](https://techcommunity.softwareag.com/u/Min_Chai)\ **Replies:** 5\ **Last updated:** [December 22, 2012, 4:20pm UTC](https://techcommunity.softwareag.com/t/used-of-super-descriptor-to-optimize-sql-query/101784 "2012-12-22T16:20:55Z")
We have an Adabas file that looks like this: REPORT name (a5) - a descriptor used-information - PE used-code (a1) used-date (n8 ) This file has a superdescriptor name-used-code-sp which consists of the fiel… --- ## [How to handle Role base access](https://techcommunity.softwareag.com/t/how-to-handle-role-base-access/204626)
**Author:** [@Suresh\_Thogari](https://techcommunity.softwareag.com/u/Suresh_Thogari)\ **Replies:** 1\ **Last updated:** [July 17, 2019, 4:13pm UTC](https://techcommunity.softwareag.com/t/how-to-handle-role-base-access/204626 "2019-07-17T16:13:55Z")
Hi, i would like to know how Software AG will going to handle Role based access. please suggest with any documentation. --- ## [CONNX SSL Encryption Impacting Behaviour of Update/Delete?](https://techcommunity.softwareag.com/t/connx-ssl-encryption-impacting-behaviour-of-update-delete/201565)
**Author:** [@Min\_Chai1](https://techcommunity.softwareag.com/u/Min_Chai1)\ **Replies:** 1\ **Last updated:** [July 15, 2019, 4:21am UTC](https://techcommunity.softwareag.com/t/connx-ssl-encryption-impacting-behaviour-of-update-delete/201565 "2019-07-15T04:21:36Z")
We have enabled SSL on both the CONNX JDBC Server and the CONNX Gateway via AT-TLS. Ever since we turned on CNXLISTENSSL = 1, our java programs which do massive update and delete seem to run significantly slower. 2.5x … --- ## [How do I start and rollback a transaction](https://techcommunity.softwareag.com/t/how-do-i-start-and-rollback-a-transaction/203795)
**Author:** [@Michael\_Trexel](https://techcommunity.softwareag.com/u/Michael_Trexel)\ **Replies:** 1\ **Last updated:** [July 15, 2019, 4:19am UTC](https://techcommunity.softwareag.com/t/how-do-i-start-and-rollback-a-transaction/203795 "2019-07-15T04:19:47Z")
I am using SQL Server 2016 with a linked server to ADABAS using the CONNX 11 SP3 driver. I would like to start a transaction, run one to many transactions, and then commit them at the end of the process, but if any of t… --- ## [How to import the data from ADABAS to AWS Redshift using SQL Gateway/CONNX Driver?](https://techcommunity.softwareag.com/t/how-to-import-the-data-from-adabas-to-aws-redshift-using-sql-gateway-connx-driver/204333)
**Author:** [@Satyender\_Murahari1](https://techcommunity.softwareag.com/u/Satyender_Murahari1)\ **Replies:** 1\ **Last updated:** [July 15, 2019, 4:01am UTC](https://techcommunity.softwareag.com/t/how-to-import-the-data-from-adabas-to-aws-redshift-using-sql-gateway-connx-driver/204333 "2019-07-15T04:01:59Z")
Hi All, Could you please help me in… how to import the data from ADABAS to AWS Redshift using SQL Gateway/CONNX Driver? Thanks, Satyender Murahari satyender.murahari@dds.ca.gov +1 916 817 7427 --- ## [Adabas SQLGateway & Hibernate](https://techcommunity.softwareag.com/t/adabas-sqlgateway-hibernate/85147)
**Author:** [@tamino\_man](https://techcommunity.softwareag.com/u/tamino_man)\ **Replies:** 7\ **Last updated:** [May 22, 2019, 2:21pm UTC](https://techcommunity.softwareag.com/t/adabas-sqlgateway-hibernate/85147 "2019-05-22T14:21:18Z")
Hi. I want to use Adabas SQL Gateway(CONNX) with Hibernate(version 3.1). But Hibernate seem to is not support Adabas SQL Gateway. (Dialect class for Adabas SQL Gateway is not exist.) I must add a new Dialect class? o… --- ## [SQL Gateway / how to do it / List of values, determine MIN, MAX](https://techcommunity.softwareag.com/t/sql-gateway-how-to-do-it-list-of-values-determine-min-max/202688)
**Author:** [@ChristianHeld](https://techcommunity.softwareag.com/u/ChristianHeld)\ **Replies:** 5\ **Last updated:** [March 25, 2019, 5:41pm UTC](https://techcommunity.softwareag.com/t/sql-gateway-how-to-do-it-list-of-values-determine-min-max/202688 "2019-03-25T17:41:56Z")
Hi I need a hint, maybe someone can give an advice I have a SELECT Statement, the structure is: SELECT xyz FROM table where col in ( ). The is specified by the end user. What I need is the MAX( ) and MIN( ) Bas… --- ## [\[08001\]\[unixODBC\]You are not licensed for any databases](https://techcommunity.softwareag.com/t/08001-unixodbc-you-are-not-licensed-for-any-databases/100871)
**Author:** [@hcontreras](https://techcommunity.softwareag.com/u/hcontreras)\ **Replies:** 3\ **Last updated:** [December 6, 2018, 9:14am UTC](https://techcommunity.softwareag.com/t/08001-unixodbc-you-are-not-licensed-for-any-databases/100871 "2018-12-06T09:14:21Z")
What its mean: \[08001\]\[unixODBC\]You are not licensed for any databases. in my connxreg64.db. CONNX.LICENSESERVER : xxx.xxx.xxx and CONNX.LICENSEPORT: 7501. In windows 7 (64 bits) work perfect… what its problem?. my … --- ## [Accessing ADABAS from JAva](https://techcommunity.softwareag.com/t/accessing-adabas-from-java/201294)
**Author:** [@VINOTH\_SIVAKUMAR](https://techcommunity.softwareag.com/u/VINOTH_SIVAKUMAR)\ **Replies:** 2\ **Last updated:** [October 18, 2018, 2:49pm UTC](https://techcommunity.softwareag.com/t/accessing-adabas-from-java/201294 "2018-10-18T14:49:04Z")
Hello I am working legacy migration project which involves migrating business logic written in COBOL to Java. The existing COBOL program interacts with ADABAS thru C program. Now we are trying to bring that section of c… --- ## [Adabas SQL Gateway Community Resources](https://techcommunity.softwareag.com/t/adabas-sql-gateway-community-resources/200786)
**Author:** [@Community-admin](https://techcommunity.softwareag.com/u/Community-admin)\ **Replies:** 0\ **Last updated:** [August 30, 2018, 9:18am UTC](https://techcommunity.softwareag.com/t/adabas-sql-gateway-community-resources/200786 "2018-08-30T09:18:14Z")
Useful resources: Adabas SQL Gateway technical articles Adabas SQL Gateway tips, tricks & code Adabas SQL Gateway videos --- ## [SQL Access To Mainframe Data](https://techcommunity.softwareag.com/t/sql-access-to-mainframe-data/237790)
**Author:** [@system](https://techcommunity.softwareag.com/u/system)\ **Replies:** 0\ **Last updated:** [July 13, 2018, 8:55am UTC](https://techcommunity.softwareag.com/t/sql-access-to-mainframe-data/237790 "2018-07-13T08:55:49Z")
CONNX Mainframe Data Over the decades, many have predicted the death of the mainframe, and all of those predictions were wrong. IBM®, the leader in the mainframe industry, had annual revenues of nearly $80 billion in 1… --- ## [Linked Server does not display tables](https://techcommunity.softwareag.com/t/linked-server-does-not-display-tables/199034)
**Author:** [@N\_N3](https://techcommunity.softwareag.com/u/N_N3)\ **Replies:** 2\ **Last updated:** [May 17, 2018, 11:26am UTC](https://techcommunity.softwareag.com/t/linked-server-does-not-display-tables/199034 "2018-05-17T11:26:58Z")
I have tried to create a linked server via CONNX OLE DB provider to ADABAS. Test Connection to the linked server succeeded and Queries with Openquery work. The problem: An explore of the tables under System Catalogs do… --- ## [Limitation on number of DDMs in a CDD file?](https://techcommunity.softwareag.com/t/limitation-on-number-of-ddms-in-a-cdd-file/194976)
**Author:** [@Brian\_Johnson1](https://techcommunity.softwareag.com/u/Brian_Johnson1)\ **Replies:** 2\ **Last updated:** [June 7, 2017, 4:57pm UTC](https://techcommunity.softwareag.com/t/limitation-on-number-of-ddms-in-a-cdd-file/194976 "2017-06-07T16:57:21Z")
Hello, I did an unload (SYSOBJH) of all DDMs in an environment in order to create a CDD that contained all DDMs. When I tried to import the SYSOBJH file, the list of DDMs only contained the first so many of them (could… --- ## [Writing data to Adabase using the SQL Gateway](https://techcommunity.softwareag.com/t/writing-data-to-adabase-using-the-sql-gateway/92470)
**Author:** [@BrandonK](https://techcommunity.softwareag.com/u/BrandonK)\ **Replies:** 16\ **Last updated:** [February 22, 2017, 12:58am UTC](https://techcommunity.softwareag.com/t/writing-data-to-adabase-using-the-sql-gateway/92470 "2017-02-22T00:58:27Z")
Hello. We originally purchased the SQL Gateway predominately to pull data from our Adabas environment into a datawarehouse, however we would now like to consider using it to write data back to Adabas in potentially large… --- ## [ADABAS SQL Gateway CONNX with File Maker Pro](https://techcommunity.softwareag.com/t/adabas-sql-gateway-connx-with-file-maker-pro/192901)
**Author:** [@MikeWaldron](https://techcommunity.softwareag.com/u/MikeWaldron)\ **Replies:** 29\ **Last updated:** [February 16, 2017, 9:05pm UTC](https://techcommunity.softwareag.com/t/adabas-sql-gateway-connx-with-file-maker-pro/192901 "2017-02-16T21:05:08Z")
I have been testing CONNX ODBC to ADABAS with Excel, MSAccess, Crystal Reports and now working with File Maker Pro. I can import data from the ODBC (CDD) data source with no problem. Has anyone worked with any scripts … --- ## [JDBC Server Sending RACF Userid/Password to SQL Gateway](https://techcommunity.softwareag.com/t/jdbc-server-sending-racf-userid-password-to-sql-gateway/192969)
**Author:** [@Min\_Chai](https://techcommunity.softwareag.com/u/Min_Chai)\ **Replies:** 3\ **Last updated:** [February 3, 2017, 9:20pm UTC](https://techcommunity.softwareag.com/t/jdbc-server-sending-racf-userid-password-to-sql-gateway/192969 "2017-02-03T21:20:05Z")
Our JDBC Server is running on Windows talking to SQL Gateway running on z/OS. All of our SQL queries required that the JDBC server passed along a RACF Userid/Password to the mainframe for authentication against RACF. I… --- ## [How to reset autocounter()](https://techcommunity.softwareag.com/t/how-to-reset-autocounter/192802)
**Author:** [@Min\_Chai](https://techcommunity.softwareag.com/u/Min_Chai)\ **Replies:** 2\ **Last updated:** [February 1, 2017, 7:24pm UTC](https://techcommunity.softwareag.com/t/how-to-reset-autocounter/192802 "2017-02-01T19:24:45Z")
I did an sql like this: select autocounter() from customers {maxrows 3} I get 3 rows with number 1, 2, 3 I then rerun the select and now I get 3 rows back with 4,5,6. How can I get autocounter() to reset back to 1,2… --- ## [CONNX JDBC/ADABAS SQL Gateway Uses Standard SSL/TLS protocol for Encryption?](https://techcommunity.softwareag.com/t/connx-jdbc-adabas-sql-gateway-uses-standard-ssl-tls-protocol-for-encryption/191723)
**Author:** [@Min\_Chai](https://techcommunity.softwareag.com/u/Min_Chai)\ **Replies:** 1\ **Last updated:** [November 23, 2016, 7:13pm UTC](https://techcommunity.softwareag.com/t/connx-jdbc-adabas-sql-gateway-uses-standard-ssl-tls-protocol-for-encryption/191723 "2016-11-23T19:13:53Z")
Does CONNX use standard-based SSL/TLS for the communications between the CONNX JDBC server and the mainframe Gateway task? Please advise. Thanks. --- ## [CONNX data virtualization](https://techcommunity.softwareag.com/t/connx-data-virtualization/237721)
**Author:** [@Harpal\_Gill1](https://techcommunity.softwareag.com/u/Harpal_Gill1)\ **Replies:** 0\ **Last updated:** [October 19, 2016, 3:24pm UTC](https://techcommunity.softwareag.com/t/connx-data-virtualization/237721 "2016-10-19T15:24:36Z")
.pearl-hilighted-word {background-color: #ffffff !important; color: #000000 !important;} Issue 4, 2016 Download PDF Softwar… --- ## [SQL Gateway z/os port assignment](https://techcommunity.softwareag.com/t/sql-gateway-z-os-port-assignment/190931)
**Author:** [@MikeWaldron](https://techcommunity.softwareag.com/u/MikeWaldron)\ **Replies:** 10\ **Last updated:** [September 27, 2016, 7:02pm UTC](https://techcommunity.softwareag.com/t/sql-gateway-z-os-port-assignment/190931 "2016-09-27T19:02:07Z")
Mainframe z/os SQL Gateway V12. V11 was installed about 4-5 years ago and tested. Installed V12 last week. 1st week on site at customer. Received: ACCEPT: Acceptor could not be initialized on Port 6500. Tried V11 v… --- ## [Level of CONNX Encryption](https://techcommunity.softwareag.com/t/level-of-connx-encryption/190552)
**Author:** [@Min\_Chai](https://techcommunity.softwareag.com/u/Min_Chai)\ **Replies:** 1\ **Last updated:** [September 2, 2016, 9:59am UTC](https://techcommunity.softwareag.com/t/level-of-connx-encryption/190552 "2016-09-02T09:59:33Z")
May I ask which bit level does CONNX use to encrypt the data stream between the JDBC server and the ADABAS SQL Server? 256-bit? 128-bit? Thanks. --- ## [Encrypt JDBC Connection from Application Server to CONNX JDBC Server](https://techcommunity.softwareag.com/t/encrypt-jdbc-connection-from-application-server-to-connx-jdbc-server/189930)
**Author:** [@Min\_Chai](https://techcommunity.softwareag.com/u/Min_Chai)\ **Replies:** 1\ **Last updated:** [August 2, 2016, 11:56am UTC](https://techcommunity.softwareag.com/t/encrypt-jdbc-connection-from-application-server-to-connx-jdbc-server/189930 "2016-08-02T11:56:10Z")
Please advise if there is a way we can encrypt the data sent from an application server to the CONNX JDBC server. The connxjdbc.jar is deployed to the application server. We will be testing the encryption feature betwe… --- ## [Infrequent errors on executing query statements.](https://techcommunity.softwareag.com/t/infrequent-errors-on-executing-query-statements/189264)
**Author:** [@Michel\_Risucci](https://techcommunity.softwareag.com/u/Michel_Risucci)\ **Replies:** 5\ **Last updated:** [June 28, 2016, 2:46pm UTC](https://techcommunity.softwareag.com/t/infrequent-errors-on-executing-query-statements/189264 "2016-06-28T14:46:37Z")
Context: Java Web Application running on Tomcat that schedules some DAILY operations over SQL Gateway, currently using CONNX 4.6 JDBC Driver connected to Mainframe. For some awkward unknown reason, one or two times a we… --- ## [Adabas SQL Gateway & Dates](https://techcommunity.softwareag.com/t/adabas-sql-gateway-dates/186280)
**Author:** [@Sandeep\_Kumar3](https://techcommunity.softwareag.com/u/Sandeep_Kumar3)\ **Replies:** 1\ **Last updated:** [January 18, 2016, 7:35pm UTC](https://techcommunity.softwareag.com/t/adabas-sql-gateway-dates/186280 "2016-01-18T19:35:56Z")
Hi, i need to know how to manage the dates using sql gateway I need to the get the date of the system and substract 3 days back, for example is today is 26/09/2015, then i need a formula to get the date 3 days after, re… --- ## [Adabas and Natural Strategy](https://techcommunity.softwareag.com/t/adabas-and-natural-strategy/237690)
**Author:** [@Guido\_Falkenberg](https://techcommunity.softwareag.com/u/Guido_Falkenberg)\ **Replies:** 0\ **Last updated:** [January 11, 2016, 10:36am UTC](https://techcommunity.softwareag.com/t/adabas-and-natural-strategy/237690 "2016-01-11T10:36:38Z")
Issue 1, 2016 Download pdf Innovate and compete in the digital world Software AG is committed to ensuring that Adabas & Natural evolve and adapt to meet new industry standards, business practice… --- ## [CONNX uses certificate to authenticate against RACF?](https://techcommunity.softwareag.com/t/connx-uses-certificate-to-authenticate-against-racf/102170)
**Author:** [@Min\_Chai](https://techcommunity.softwareag.com/u/Min_Chai)\ **Replies:** 3\ **Last updated:** [October 14, 2015, 8:11am UTC](https://techcommunity.softwareag.com/t/connx-uses-certificate-to-authenticate-against-racf/102170 "2015-10-14T08:11:34Z")
Our shop will be requiring front-end users to use certificate to authenticate against RACF. How can the certificate be passed to CONNX to be eventually sent to RACF since we have CNXNOPREAUTHORIZE=0. We have been using… [Next page](https://techcommunity.softwareag.com/tag/sql-access/96.md?match_all_tags=true&page=1&tags%5B%5D=SQL-Access)