My new question regards connecting to the external database to insert the data. I have the following code:
Last answer 12 days ago Last comment 9 hours 55 min ago
SQL
About this tag
SQL is a standard language for storing, manipulating and retrieving data in relational databases
Subscribe to SQL content with RSS 
or email
or email 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 2 days ago Last comment 1 days ago
Last answer 6 days ago Last comment 6 days ago
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 6 days ago
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 12 days ago
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 13 days ago
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
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
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
Hi,
Last answer 19 February 2018 Last comment 19 February 2018
No doubt bitmap indexing, if used with a suitable property, performs just impressive!
But there is a major limit: ID key has to be a positive integer.
Last comment 17 February 2018
I noticed that the subscript of the index map is actually the collated field (%SQLUPPER).
Last answer 15 February 2018
I'm trying to learn how To use SQL in CACHE, so I hope I don't bore you with "Dumb" questions....
I'm getting "ERROR #6022: Gateway failed" message following this line of code.
Last answer 14 February 2018 Last comment 12 February 2018
Hi, I am trying to execute a store procedure within an ensemble operation to connect to aMsSQL database and I am having problem to pass the input arguments...
Last answer 9 February 2018 Last comment 9 February 2018
My question is actually about IDKEY since Primary Key is the common concept of SQL.
Why do we need IDKEY? In what kind of scenario, the IDKEY would be different from Primary Key?
Thanks.
Last answer 7 February 2018
This might be more of a math problem than a Caché question.
I have a SQL query that joins two tables. I want to assign a unique ID to each row of the product table.
Last answer 31 January 2018 Last comment 31 January 2018
Last week, we announced the InterSystems IRIS Data Platform, our new and comprehensive platform for all your data endeavours, whether transactional, analytics or both. We've included many of the features our customers know and loved from Caché and Ensemble, but in this article we'll shed a little more light on one of the new capabilities of the platform: SQL Sharding, a powerful new feature in our scalability story.
Last comment 31 January 2018
As I was going though and trying to figure out why our CACHE.dat has increased in size over the past 18 days, I found that EnsLib_HL7.Message is still retaining messages dating back to 2014 even though we have our
Last answer 30 January 2018
I've mapped multiple tables (UNION on mapped SQL classes) into a view, using CREATE VIEW.
Last answer 25 January 2018 Last comment 29 January 2018
I have a large and complex class containing information of various sensibility.
I need to hide some properties completely from Object and SQL for a dedicated application.
Last answer 27 January 2018 Last comment 27 January 2018