I have a serial object:
Class EmbedObj Extends %SerialObject
which is stored as a property of another object
Class ContainerObj Extends %Persistent
Property InnerObj As EmbedObj;
I have several stored procedures that when I execute them they will only return a single snapshot.
I'm facing a specific sort problem.
There are several thousands of articles sold all over.
Users expect to get a description in local language sorted by their specific collation.
Hello,
I want to know if there is any possible way to use the same query for different ODBC schemas.
Thanks.
Hi Everyone,
I am trying to built a SSIS package thru BIDS Visual Studio 2013. My Datasource is a InterSystems Cache Database, I wanted to Import Tables records from the Datasource to MS SQL Server 2014.
The Art of Mapping Globals to Classes (4 of 3)
The forth in the trilogy, anyone a Hitchhikers Guide to the Galaxy fan?
Does anyone have any sample code for updating Caché users (and specifically Full Name and Comments) via SQL?
Without installing Kerberos has anyone Authenticated a SQL JDBC connection?
Date range queries going too slow for you? SQL Performance got you down? I have one weird trick that might just help you out! (SQL Developers hate this!)*
I have generated a class using the linked procedure wizard however I can't get it to work if the datatype of one of the parameters is VARCHAR(MAX). It works fine if I change it to say VARCHAR(500) and rerun
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)
Hello glabal masters,
I am trying to develop WAS using Cache and Spring Framework.
The ON DUPLICATE KEY UPDATE is not working.
Source :
The documentation only provides the syntax but does not provide any sample DDL for this case.
I have a SQL procedure that I call into and it does some processing and passes back any data validations that fail.
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.
Hello Global masters.
I am junior developer about Intersystems cache in South Korea.
I want to develop process management program on server.
My code :
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
My new question regards connecting to the external database to insert the data. I have the following code:
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
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.
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.
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
I am tasked with using CACHE to insert data retrieved from a CACHE data base and insert it into an sql database.
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?
Has anyone use any other setting then -1 on the Stay Connected setting on a SQL.OutboundAdapter?
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
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 :)
