Stack Overflow
Stack Overflow

Questions tagged [sqlmx]

NonStop SQL/MX is designed to run effectively on parallel computers, adding functionality for distributed data, distributed execution, and distributed transactions.

NonStop SQL/MX is designed to run effectively on parallel computers, adding functionality for distributed data, distributed execution, and distributed transactions.

8 questions
2
votes
2 answers

How do you query table names and row counts for all tables in a schema using HP NonStop SQL/MX?

How do you query table names and row counts for all tables in a schema using HP NonStop SQL/MX? Thanks!
Wuf_fang
  • 21
  • 4
1
vote
0 answers

Integrate SQLMX in IntelliJ

I wanted to open in IntelliJ a NonStop/SQLMX database using the driver com.tandem.t4jdbc. After the configuration the connection is successful, I can also open the table with the double click, but it looks like the column are not immediately…
Andrea Magazzini
  • 35
  • 12
0
votes
0 answers

Script for reading CloudFoundry external service credential

We are using CloudFoundry for hosting our micro services. Also, there is an external service related to SQLMX with credentials like username, password, connectionProperties, etc. Can we write a script to read these credentials ? I am just referring…
copenndthagen
  • 49,230
  • 102
  • 290
  • 442
0
votes
1 answer

Unable to connect non stop SQL from Spring boot applivcation

My project uses non stop SQL/MX as RDBMS database, a product from HP.I am not able to connect to the data source using Spring Boot's standard practice of defining JDBC URL, user, password inside application.properties…
harish singla
  • 11
  • 3
0
votes
0 answers

JDBC BigDecimal - Precision Issue

When reading a decimal value with 12 digits after decimal point from a table using resultSet.getBigDecimal("COL1") it returns the value with some additional numbers at the end. For instance, the value on the table is 29963.26, but the value returned…
Thulasi
  • 126
  • 3
  • 19
0
votes
1 answer

HP Nonstop Tandem T4SQLMX driver double precision issue

I use T4SQLMX type 4 jdbc driver to read a double precision field from a SQL/MX table. The Actual value is 29963.26, however, the value read using the jdbc driver seems to be 29963.260000000002. This seems to be an issue even if I read it as…
Thulasi
  • 126
  • 3
  • 19
0
votes
2 answers

JDBC DatabaseMetaData method not implemented by JDBC(T4SQLMX) driver

I am setting up a Spring-boot application to connect to HP NonStop Tandem's SQL/MX. First I achieved this connection by hard-coding the jdbc parameters like dataSource, URL, etc in the service section of the application and it worked (I was able to…
Thulasi
  • 126
  • 3
  • 19
0
votes
1 answer

SQL/MX Insert With Timestamp

Does anyone know how to insert with a timestamp this is on an HP Tandem SQL/MX system. I HAVE SEEN THE FUNCTION CURRENT_TIMESTAMP BUT IT COMES BACK WITH AN ERROR. insert into =BOXTABLE values (71,'A',1,CURRENT_TIMESTAMP,'123456');
CK1
  • 472
  • 1
  • 5
  • 16