NonStop SQLMP Experiences ?

Question

Hansel Stange Gaete · Mar 24, 2021

#Compatibility #Databases #Interoperability #InterSystems IRIS

Someone have experiences interconecting NonStop SQLMP with Iris ?

I need if possible some references or tips, actually connected with JDBC driver to interconnect and take many assorted problems, like :

Some queries, not to much, have null fetch, works fine but have no content to fetch, and i'm sure select sentence is not the problem.

Product version: IRIS 2020.1

$ZV: IRIS for UNIX (Red Hat Enterprise Linux for x86-64) 2020.1 (Build 215_0_20373U) Fri Oct 16 2020 11:19:54 EDT

Discussion (1)1

Rich Taylor · Apr 28, 2021

Please expand a bit on what you are attempting to do. Are you trying to execute queries FROM IRIS to the HP NonStop SQL environment? Or are you trying to execute NonStop SQL syntax against IRIS? If this is the latter understand that IRIS implements ANSI Standard SQL with some IRIS specific extensions. NonStop SQL syntax may not work entirely against IRIS as that environment will have its own extensions and syntaxes which may not be standard.

It would help if you could post the SQL you are attempting to run along with any error messages you are receiving.

0 0