Hello,
I've got a table with many attributes and data. There is 10 000 000 registrations approximatly.
I need to make a research on this table with filters, paging, and order.
You can see an example of my SQL request :
SELECT * FROM ( SELECT TOP ALL * FROM ANCV_Data.Titre WHERE etatTitre = 'Emis' ORDER BY numRemise desc) v WHERE %vid BETWEEN 1 AND 25
Cause there are many data on my table, my SQL req is too long if I don't have index on my attributes BUT there are many associations possible...
BridgeWorks is pleased to announce a VDM, v9.1.0.1. This release includes the following updates:
Updates
Bug Fixes
Hello Community,
I would like to work in SQL developer with the tables from Caché.
Is it possible with JDBC tool?
What is the whole process in order to work in SQL developer? I have the access information to Caché, but i can only choose in SQL Developer software only Oracle or MySQL database type, therefore i think, that have to install any other tool.
Thank you in advance for your help!
br,
bálint
Does Caché have any features similar to PostgreSQL 'WITH RECURSIVE'? Something that allows recursion in SQL.
HI,
I have made a query with class definitions and all their properties and put them in a view.
All is good besides Parameters is showing junk characters. Is there a way to do it cleanly besides getting into the code??
SELECT
CC.ID As CompiledClass,
CC.SqlSchemaName,
CC.SqlTableName,
CP.Name As PropertyName,
CP.SqlFieldName,
CP.Type,
PD.Parameters
FROM %Dictionary.CompiledProperty CP
JOIN %Dictionary.CompiledClass CC
ON CP.Parent = CC.ID
I have the following class:
{
I need to consume the content of ^SPOOL output over SQL.
^%SPOOL utilities don't look so promising
Hi I am experienced with Ensemble but working in my first DeepSee project, so forgive me if this seems elementary.
My question is, how do I clear the data out? Every time I build I am adding more and more data. But I would like to revert my cube to being 0 so I can reload it and start over? Set my row count back to 0?
I am unable to remove/purge through the management portal
-I've tried to kill my cube Do ##class(%DeepSee.Utils).%KillCube("MyCube.Cube") and then Rebuild it.
Thanks In advance
Class Queries in InterSystems IRIS (and Cache, Ensemble, HealthShare) is a useful tool that separates SQL queries from Object Script code. Basically, it works like this: suppose that you want to use the same SQL query with different arguments in several different places.In this case you can avoid code duplication by declaring the query body as a class query and then calling this query by name. This approach is also convenient for custom queries, in which the task of obtaining the next row is defined by a developer. Sounds interesting? Then read on!
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.
I' m facing the problem to take a Snapshot of an object.
Like a Clone but to a different Storage.
Hello InterSystems Community,
We're excited to announce that we've completed our first Open Exchange submission for InterSystems platforms.
BridgeWorks VDM is an ad hoc reporting and graphical SQL query builder application that was designed for any user who needs access to their SQL projections in InterSystems Caché, InterSystems IRIS, InterSystems IRIS for Health databases as well as access to InterSystems DeepSee and InterSystems IRIS BI Cubes with minimal SQL scripting experience.
VDM features:
Hello everyone,
It is my first post in the community. Very recently I started working using IRIS, creating services with Cache.
Today they gave me a new task and I'm really lost.
How can I use an oracle database to create services using iris?
Throughout the day I was looking for a guide to use a remote Oracle database. but unfortunately I only managed the connection in SQL Gateway
I am trying to make architecture for my project. And for it, it needs to make list property in which there is list of objects of another table, the data must be unique, therefore I make sql-query to check objects of another table if it is used or not, but I can't make sql-query to check elements in list in property with elements of another table. Can you help me? In property ID of object is used.
I have a database which needs to be synced to another system and considering to use the SQL Inbound adapter to 'watch' the database. The other system, however, has a bulk API so I'd prefer to send multiple SQL rows in a single message to that system. The SQL Inbound adapter seems to trigger a single call (to a process or business operation) per SQL-row.
Is it possible to use a class parameter in class query?
Example:
Class SomeClass
{
Parameter SOMENAME = "Name1";
Query SomeQuery() As %SQLQuery
{
SELECT ID || ..#SOMENAME || Name FROM Table
}
}
An exciting position has arisen for an Application Support Analyst 3rd Line, in an established support team. The role will suit candidates looking to work in the software industry who want to provide good customer service, enjoy finding solutions for problems and are enthusiastic about software and technology. http://codas.com
An exciting position has arisen for a Junior Application Support Analyst in an established support team. The role will suit candidates looking to enter, or are at the start of their career in, the software industry who want to provide good customer service, enjoy finding solutions for problems and are enthusiastic about software and technology. http://codas.com
Hello everyone,
I try excuting a SQL Query like this SELECT ID, CompanyName FROM Company WHERE CompanyName LIKE 'condition'
But if I want to search CompanyName have special char %, ex: '100% Co' , 'Group of Mr.%', 'The %TaxProp'...
How can I take % to query, with
I have a task that has been working successfully for some time now but when I attempt to recompiled I get this error:
Hi Community,
New video, recorded by @Stefan Wittmann, is already on InterSystems Developers YouTube:
Greetings community. I would like to know how to migrate a BD in production to a local environment. When I have a system in production (BD Sql Server) what we do is mount a local copy to do the analysis with the data and not occupy resources of the system in production. My question is: How do you do it with Intersystems technology?
Hi guys,
I ran into a strange (for me) situation, when I run same query but change the WHERE clause the plan is different and is not connected to the additional condition.
Query that doesn't use the necessary index:
Can anyone tell me how to add a simple running total in Cache SQL.
I'm selecting a quantity in the first column and want a running total in the second:
9 , 9
Hello,
Is there a way to list all items in a production (incl their status/color) by using a sql query? This is for monitoring purposes.
Thank you in advance!
Regards,
Luk
"IN" does not work changing it to "=", "like" the stored procedure will work. Does any one know how to fix this ?
Pass values to code is 'AB','TS','SK','GM'
October 17, 2019
Anton Umnikov
Sr. Cloud Solutions Architect at InterSystems
AWS CSAA, GCP CACE
AWS Glue is a fully managed ETL (extract, transform, and load) service that makes it simple and cost-effective to categorize your data, clean it, enrich it, and move it reliably between various data stores.
