I have a query that returns around 6000 records that I need to go through and update another MS SQL Table. I would like to execute this once a day. How do you set MaxRowsToGet on a EnsLib.SQL.InboundAdapter service?

Thanks

Scott

So I know we can run routines using both XECUTE or @
However both of them run slower than just running the routine without it. (that is because as far as i understand, XECUTE command for example will re-compile before running?)

the question is: how can I run a routine by name - and keeping the performance as good as possible?

In this post, we'll discuss our project that leverages Pulumi and Docker Compose to automate the deployment of InterSystems WSGI applications on AWS. The focus is on simplicity and efficiency, using pre-built infrastructure templates for provisioning and scaling AWS resources.

Hello Community,

I have encountered the following SQL problem trying to create a table from a SELECT statement.

I narrowed the problem down to the following example:

1. The SELECT statement alone works as expected.

SELECT m.Name, h.Status 
FROM EnsLib_HL7.Message m, Ens.MessageHeader h 
WHERE h.MessageBodyClassName='EnsLib.HL7.Message' AND h.MessageBodyID = m.ID

2. But if "CREATE TABLE ... AS" is added it fails

Hi Community,

Thank you for participating in our recent mini-contest! We received many great ideas, and we hope you enjoyed the process.

The mastermind of the winning concept will receive 5,000 points, while the astute "investors" in said concept will receive 200 points each.

The Winning Concept: Senior people loneliness

Hey Developers! Here is a digest of new solutions and applications submitted to the InterSystems Open Exchange in February 2022.

Hey Community,

Here is a digest of the Developer Community videos on InterSystems Developers YouTube Channel in October 2021:

According to documentation, quotation: "$THIS contains the current class context.
The class context for an instance method is the current object reference (OREF).
The class context for a class method is the current classname as a string value."

Hi Developers!

Welcome to Issue #18 of the InterSystems Ideas newsletter! This edition highlights the latest implemented ideas:

✓ Ideas brought to life during the "Bringing Ideas to Reality" programming contest
✓ Ideas implemented by InterSystems in Q4 2024
✓ New article featuring an idea realized by the talented Musketeers team

Hi Developers!

We're sure you want your ideas from the Ideas Portal to be implemented, so here are some steps you can take to attract attention to them.

Hi Community,

Watch this video to learn how to use HL7® FHIR® Shorthand (a domain-specific, human-readable language for defining profiles, extensions, and other FHIR artifacts) to more efficiently create a FHIR Implementation Guide:

⏯ Using HL7 FHIR Shorthand

https://www.youtube.com/embed/vr58My_qL6E
[This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]

Does InterSystems have plans to add BLOB storage for Document databases?

Can you please provide the package for adding new column in the FHIR table using additional package for the boolean datatype.

1) Package.JSON

2) SearchParameter.JSON

3) StructureDefination.JSON

Please provide all the code for all three file for boolean datatype.