I have a task that has been working successfully for some time now but when I attempt to recompiled I get this error:
SQL
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:
Last reply 30 October 2019
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
Last reply 28 October 2019
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
Last reply 25 October 2019
"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.
Last reply 8 October 2019
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?
Last reply 8 October 2019
Hi Everyone!
New video, recorded by @Stefan Wittmann, is already on InterSystems Developers YouTube:
HI
We have a local running WINDOWS MySql, which we connect to via MySQL Workbench :::Mysql@localhost:3306
We have java :: C:\Program Files\Java\jdk1.8.0_221\bin
How do we create a DSN that we can use in the business service settings to connect and run our query?
Do we make a ODBC or JDBC DSN.
What settings for either
Hi,
I've a Service utilising the Adapter EnsLib.SQL.InboundAdapter, which uses a Credentials item set with the details of a local SQL account. This currently works, however, we're looking to use the credentials of an AD domain account.
The domain account is a member of an AD security group, which has the required permissions on the source SQL database. I've checked that access is possible with this account via SQL studio.
I have several BPL's that act like SQL Server Integration Services (SSIS) where they are transferring data. When I do this they are all being written under 1 session id, is it possible to make the BPL create multiple session ID's as it is cycling through a Snapshot, so it is easier to read in the trace?
Thanks
Scott Roth
Last reply 9 March 2018
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!)*
If you have a class that records timestamps when the data is added, then that data will be in sequence with your IDKEY values - that is, TimeStamp1 < TimeStamp2 if and only if ID1 < ID2 for all IDs and TimeStamp values in table - then you can use this knowledge to increase performance for queries against TimeStamp ranges. Consider the following table:
Last reply 6 September 2019
hi,
i have two where-clauses:
a) ... WHERE company=1 and product=7
b) ... WHERE product=7 and company=1
with other words the position of the where fields are swapped.
now the question is:
bring the where clauses a) and b) the same performance(queryplan) or do i have to write it in a special order???
in my point of view, there is a parser/optimizer who cares about this, so i don't have to care about.
Hello,
I have a small SQL question.
Running an example queries in our Samples Namespace:
1. select top 5 Description,Category from Cinema.Film order by Category - runs fine no issues and returns 2 columns as expected
2. select top 5 * from Cinema.Film order by Category - runs fine no issues and returns 8 columns as expected
3. select top 5 Description,Category,* from Cinema.Film order by ID - runs fine no issues, and returns 10 columns, with my first 2 repeated
4. When I try to combine the first 2 queries:
Last reply 5 September 2019
Hi, I have used CSP to exec SQL selects from any own NAMESPACE. But in our servers we have many SQL GATEWAY CONNECTIONS.
I'd like to create a CSP page that could use these gateway to exec SQL using these gateway connections, only Administrators will use that page to launch many select at many dsn. I'm not sure if we must deploy that CSP on %SYS namespace and how to use DSN(SQL Gateway connections) that are defined on server.
Anoyone has made that?
For example:
DSN CLIENT ONE
DSN CLIENT ONE
CSP Webpage:
TEXTBOX: Introduce your select:
Last reply 5 September 2019
.png)
To request a copy of the examples only – please see me, will email them out for free. pmkadow@gmail.com
Hi, I’m trying to setup a Business Operation where the Property is a drop down list of Strings. I was able to produce the desired effect but only using a hard coded list like Property LookupProp As %String(VALUELIST = ",value1,value2"). Instead I would like i
Last reply 3 September 2019
Since Caché 2017 the SQL engine has included new set of statistics. These record the number of times a query is executed and the time it takes to run.
Last reply 3 September 2019
Management Portal, ObjectScript, REST API, SQL, Studio, Caché, Documentation, Online Learning, Worldwide Response Center (WRC)
Hi Guys,
Last reply 15 August 2019
Our team is reworking an application to use REST services that use the same database as our current ZEN application. One of the new REST endpoints uses a query that ran very slowly when first implemented. After some analysis, we found that an index on one of the fields in the table greatly improved performance (a query that took 35 seconds was now taking a fraction of a second).
Last reply 23 August 2019
I have created store procedure using management portal.
how to alter or modify SP using SQL in management portal.
Please refer below screen.
.png)
Last reply 23 August 2019