I have an sql statement that I would like to execute but I get the error
SQL
A good writer is supposed to draw you in with the title and bury the answer somewhere in the article. I suppose this makes me a bad writer – don’t think less of me, my whole feeling of self-worth comes from the opinions of internet strangers!
Last comment 1 days ago
There are three things most important to any SQL performance conversation: Indices, TuneTable, and Show Plan. The attached PDFs includes historical presentations on these topics that cover the basics of these 3 things in one place. Our documentation provides more detail on these and other SQL Performance topics in the links below. The eLearning options reinforces several of these topics. In addition, there are several Developer Community articles which touch on SQL performance, and those relevant links are also listed.
There is a fair amount of repetition in the information listed below. The most important aspects of SQL performance to consider are:
- The types of indices available
- Using one index type over another
- The information TuneTable gathers for a table and what it means to the Optimizer
- How to read a Show Plan to better understand if a query is good or bad
Hi,
When Creating a custom security role, what privileges do I need to add to it, in order for the users that I grant him the role, to be able to use
Last answer 13 days ago Last comment 6 days ago
Best Practices, Caché, Terminal, Business Service, Java, JDBC, ODBC, SQL, InterSystems Data Platform Blog
As we all know, Caché is a great database that accomplishes lots of tasks within itself. However, what do you do when you need to access an external database? One way is to use the Caché SQL Gateway via JDBC.
Last comment 28 December 2018
Hi Community!
New session recording from Global Summit 2018 is available on Developer Community YouTube Channel:
A very simple SQL
SELECT field1 F1, count(field2) CntF2
FROM GCT.PA_Data
where field1 is not null
group by field1
gives an error back:
Last answer 12 December 2018 Last comment 14 December 2018
Dear all,
In our application made in Caché object script, when we deploy some classes modified we have the option of calling "Purge queries" feature of Caché.
Last answer 12 December 2018 Last comment 11 December 2018
I have a persistent class that represents cities across the United States. It is below, but basically has a City Id, Name, Lat, Lon and a few other unimportant fields for this issue. Anytime I attempt to query o
Last answer 8 December 2018 Last comment 8 December 2018
I am trying to use %INLIST in SQL query using a cursor and the query fails to return results. It appears that the variable I use against %INLIST returns an empty string.
Last answer 3 December 2018
Hello everyone,
I try excuting a SQL Query like this SELECT ID, CompanyName FROM Company WHERE CompanyName LIKE 'condition'
Last answer 29 November 2018 Last comment 29 November 2018
When using the JSON_OBJECT() function in Caché SQL on a %String property that contains JSON syntax, it converts the %String into a JSON object instead of escaping it as a string literal. How can I prevent this?
Last answer 20 November 2018 Last comment 28 November 2018
Hi
Is this a bug? We came across it on an older version of Cache but I've also just tried it in version "Cache for Windows (x86-64) 2017.2.2 (Build 865U)" and got the same result.
Last answer 22 November 2018 Last comment 22 November 2018
Hi,
Most of my classes are mapped from Globals. I want to access Cache classes from a BI software through ODBC connection.
Last answer 10 November 2018 Last comment 12 November 2018
Hello,
I have been trying to pull data through a linked server in SSMS from an InterSystem Cache Database for a while, this is to enable us to join the data to other source systems in our Data Warehouse.
Last comment 1 November 2018
What is the difference between %ID and ID in a database table? Both seem to reference the same column labelled ID.
For context, I am trying to create a viewer class for an existing persistent class.
Last answer 30 October 2018
Hello everyone,
I want to fill data into my select component with sql request and parameter.
Last answer 19 October 2018 Last comment 19 October 2018
I have a ZEN page with nine tablepanes. Each tablepane queries a table in the same SQLServer db.
Last answer 18 October 2018
I have created a view to stage some data in a different format and then want to reference that view in a SQL query from a table that filters the data from the view using a property of the table.
Last answer 17 October 2018
Hi,
I am trying to have the output of a field in sql have double quotes around them. The script is in Studio and I am accessing It through a task.
I have tried """"tect"""" and others...Please help
Last answer 11 October 2018 Last comment 12 October 2018
I'm running this code in our application, and in the terminal:
>set query="SELECT * FROM PMG_Data_Private.RemitInstance WHERE (VoucherNumber %INLIST ? SIZE ((10)))"
Last comment 9 October 2018
Hello,
I have a question about creating properties with curl.
I already did create properties in Java with the following command.
Last answer 4 October 2018 Last comment 4 October 2018