Question
· Apr 11, 2019

CSP using SQL Gateway Connections?

Hi, I have used CSP to exec SQL selects from  any own NAMESPACE. But in our servers we have many SQL GATEWAY CONNECTIONS.

I'd like to create a CSP page that could use these gateway to exec SQL using these gateway connections, only Administrators will use that page to launch many select at many dsn. I'm not sure if we must deploy that CSP on %SYS namespace and how to use DSN(SQL Gateway connections) that are defined on server.

Anoyone has made that?

For example:

DSN CLIENT ONE

DSN CLIENT ONE

 

CSP Webpage:

TEXTBOX: Introduce your select:

select count(*) from product where stock<100 

OPTION BUTTON:

*CLIENT ONE

*CLIENT TWO

 

Result:

Product One.

Product Two.

Product Five...

Discussion (1)1
Log in or sign up to continue

Jose Antonio, 

I am not sure to understand what you are trying to do. When you use the SQL Gateway connections you will map an external table into one particular namespace. If you have several, you will have several different table names in several namespaces. 

 Then you can use those table names in your SELECT FROM queries, you will need to move to the particular namespace before launching the query (using ZN)