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
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.
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
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.
I am experiencing a problem with an EDI process that uses a SQL Batch Service to connect to our DEV environment. However, when we point the EDI service to our TEST server, it errors out.
I have checked every single property on our TEST and DEV servers as well as the properties on the associated tables. They are identical. Nothing has changed in the SQL either.
Hi, we are a veterinary lab and we use both the LAB and FIN systems of Antrim. Now we are looking to expose the data in a SQL/Object compatible way so we were wondering if same / similar things had been done by other community members already? If so, could you please share your approach / experience / gotchas with us and we are all ears. I can be reached at yang.jiao@antechmail.com . Thank you!
At LifeLabs, we are focused on our vision of building a healthier Canada! We are the largest community diagnostics laboratory in Canada with over 350 collection centers, 21 laboratories and service over 19 million patients each year. As the Software developer, you will be concerned with all facets of the software development process. You will be responsible for the design of application modules, maintain and deploy software applications to meet user and business needs.
Hi All, I am a Data Architect and am trying a method of deploying alter statements onto Cache DB.
My Data Modeling tool generates alters as this.. So question is if the Cache has a way to rename table? If so what is it?
ALTER TABLE <SchemaName>.GROUP_TYPE_NODES RENAME TO GROUP_TYPE_10082019140110000
;
This is giving error.
I know &SQL returns only one result but is
&SQL(SELECT ID FROM Cinema.Film ORDER BY ID DESC)
and
&SQL(SELECT TOP 1 ID FROM Cinema.Film ORDER BY ID DESC)
the same in terms of processing required?
