Hi All
I'm looking for the a simple-quick-easy solution to monitor a SQL table thought Ensemble.
I have a process that update a DataBase ,a scheduled task that runs every night (Not Ensemble)
SQL
Last comment 25 May 2018
Hello glabal masters,
I am trying to develop WAS using Cache and Spring Framework.
The ON DUPLICATE KEY UPDATE is not working.
Source :
Last answer 25 May 2018 Last comment 25 May 2018
The documentation only provides the syntax but does not provide any sample DDL for this case.
Last answer 19 May 2018 Last comment 19 May 2018
Beginner, Caché Objects, Databases, Business Operation, SQL, Stored Procedures (SQL), Ensemble (SQL)
I have a SQL procedure that I call into and it does some processing and passes back any data validations that fail.
Last answer 14 May 2018 Last comment 14 May 2018
Hello Global masters!
I developed Web with Spring framework (JAVA, Jdbc Cache) and I wrote SQL when I made it.
And Window program with VB6, Cache Object and VisM.
Last answer 11 May 2018 Last comment 11 May 2018
Hello Global masters.
I am junior developer about Intersystems cache in South Korea.
I want to develop process management program on server.
My code :
Last answer 10 May 2018 Last comment 11 May 2018
Is there a way to create a table for the results of a SQL statement ?
Example: Consider the below query and results.
Select ID,Name,DOB,Gender from EMS.EMS
RESULT
Last answer 8 May 2018 Last comment 11 May 2018
My new question regards connecting to the external database to insert the data. I have the following code:
Last answer 13 April 2018 Last comment 9 May 2018
Any insights, news, alternatives or experience about sequence pattern querying like with Oracle's MATCH_RECOGNIZE, more declarative, less simple direct COS way? Both obvious solutions (shadowing data to oracle clo
Last comment 4 May 2018
I have a lookup table and record batch Table I would like to do a count on the records stored in that batch by counting the number of records in that batch that have a certain key on the responseKey column.
Last comment 4 May 2018
Hi,
The following sql statement is working through the SMP but couldn't make it work through the code.
The table is a linked table to oracle db.
Last answer 23 April 2018 Last comment 24 April 2018
Last answer 19 April 2018 Last comment 18 April 2018
This is a sample Ensemble/Health Connect production which demonstrates how to receive an HL7 order (ORM) inbound from a file, extract fields (in this case, basic demographic information), and insert those into a t
Last comment 19 April 2018
I am tasked with using CACHE to insert data retrieved from a CACHE data base and insert it into an sql database.
Last answer 7 April 2018 Last comment 13 April 2018
Will an upgrade from 2015.2 to 2017.1.2 or higher freeze the query plans from 2015.2? Is there some minimum source version where this will work?
Last answer 4 January 2018 Last comment 12 April 2018
Has anyone use any other setting then -1 on the Stay Connected setting on a SQL.OutboundAdapter?
Last answer 6 April 2018 Last comment 9 April 2018
Morning guys I have a SQL operation that I use to read data and results to a record map. But seems to have trouble saving the objects to a record map as I get this message
Last answer 5 April 2018
Hi all.
I have some problem with getting data from external source (PostgreSQL) via JDBC and load it in DeepSee and I resolved some problems while writing this question :)
Last answer 22 March 2018 Last comment 28 March 2018
I came across How to import a tab separated text file into a SQL table programmatically?, which a
Last answer 17 February 2018 Last comment 14 March 2018
I have several BPL's that act like SQL Server Integration Services (SSIS) where they are transferring data.
Last answer 9 March 2018 Last comment 9 March 2018
I'm trying to get a count of specific message type with a specific entry and thought I could build the query in Message Viewer but this does not provide counts (as far as I am aware).
Last answer 7 March 2018
It is often necessary to sort the results of a query on a string field containing a combination of alphabetic and numeric characters.
Last comment 6 March 2018
I am working my way through some SQL documentation.
The documentation follows and my question comes after.
Last answer 21 February 2018 Last comment 22 February 2018
I don't quite understand the %NOMERGE mentioned in the documentation.
Last answer 21 February 2018 Last comment 21 February 2018