検索

Pergunta
· Jul. 15

Create a local copy of a linked table

As foreign tables are behind a paywall (booo); we have a external cache system using the intersystems ODBC driver or usually a .jar CacheDB.jar. 

The requirement is :

"Create a copy of the external table once a day to perform comparisons to detect changes"

We could go full code and this is what we will do but trying the following should ideally work 

CREATE TABLE Sample.YoungPeopletwo AS
SELECT *
FROM Pennine_TIE_Clinicom_Link.PMISPECIALREGNCA
WITH STORAGETYPE = COLUMNAR

This resulted in 

[SQLCODE: <-400>:<Fatal error occurred>]
[%msg: <Exception caught during dSQL statement %Execute: <UNDEFINED> SQLCODE>]

if we created a table and tested inserting the values '1','2','3' and it worked

But if we tried at once with a single statment with a select into (1 value) it fails 

 

INSERT INTO Sample.YoungPeople (PASReligionCode) values (SELECT internalPatientNumber FROM Pennine_TIE_Clinicom_Link.PMISPECIALREGNCA where InternalPatientNumber=100)

with 1 or all 3 fields popluated we get 

SQLCODE: -12
Message: A term expected, beginning with either of: identifier, constant, aggregate, $$, (, :, +, -, %ALPHAUP, %EXACT, %MVR %SQLSTRING, %SQLUPPER, %STRING, %TRUNCATE, or %UPPER^ INSERT INTO Sample . YoungPeople ( PASReligionCode ) VALUES ( SELECT

It is frustrating linking a cache db doens't seem to work right out of the box and the fact linked tables which seems a linked tables but actually work is behind a paid feature. 

Any ideas of anything to work around the issues other than the plan to go to (complete dummy code i know none is syntax correct)

 

TStart
//Get resultset 
set rs=....

While rs.%Next{
    set sc-&sql (insert into copy table () values rs.1,rs.2...)

if sc not ok TRollback.... quit 
}
if sc is ok TCommit
4 Comments
Discussão (4)2
Entre ou crie uma conta para continuar
Pergunta
· Jul. 15

Reddit Username Generator – Create Unique Reddit Usernames Instantly

Looking to join Reddit or create a new alt account but stuck on choosing a username? You're not alone. With millions of users on the platform, finding an original Reddit name can be tough. That’s why the Reddit Username Generator is the perfect solution.

Whether you're signing up for the first time, creating an anonymous account for niche discussions, or just want a funny or clever name, our Reddit Username Generator offers unique, creative, and available suggestions within seconds.

🚀 Why Use a Reddit Username Generator?

  • No brainstorming – Get instant username ideas
  • Unique names – Avoid names that are already taken
  • Free & simple – No registration or fees
  • Anonymous options – Ideal for private or throwaway accounts

You can even customize your preferences to generate names that are funny, aesthetic, minimal, or anonymous. The Reddit Username Generator adapts to your style and gives you a list of great options to choose from.

👥 Who Should Use This Tool?

  • New Reddit users
  • Anonymous or alt account creators
  • Memers or niche subreddit participants
  • Anyone wanting a creative and clean handle

Don't waste time trying names that are already taken. Use the Reddit Username Generator now and claim a standout name that fits your vibe.

Discussão (0)1
Entre ou crie uma conta para continuar
Discussão (0)1
Entre ou crie uma conta para continuar
Artigo
· Jul. 15 3min de leitura

Guidelines for using Generative AI when writing posts on Developer Community

Our goal on the Developer Community is to foster a high-quality, trustworthy, and original body of technical content created by and for developers. While AI tools like ChatGPT can be helpful in the writing process, we expect all published content to reflect authentic expertise and personal understanding. If you have any questions or wish to discuss your coding problem with an AI, consider using our Developer Community AI chat.

Acceptable Use of AI

We recognize that AI tools can assist with editing and clarity. You may use them in the following ways:

  • To fix grammar, spelling, and punctuation.
  • To improve sentence structure and readability.
  • To rephrase your own content more clearly.
  • As a writing assistant, not as the source of technical ideas or explanations.

Example: Writing an article on how to use the %JSON.Adaptor class yourself, and using ChatGPT to improve sentence flow and clarity.

What’s Not Allowed

To protect the integrity of our platform, the following uses of AI-generated content are not permitted:

  • Writing full articles (or substantial portions) using ChatGPT, Copilot, Gemini, or other large language models.
  • Publishing AI-generated explanations, tutorials, or code descriptions as if they are your own insight.
  • Submitting content that was primarily generated by AI with only minimal editing or review.

Example: Prompting ChatGPT to 'Write a lengthy article highlighting the benefits of the FHIR standard' and posting the response as your own work.

Transparency

To maintain a high quality of content and preserve trust in the community, you should strive to be transparent regarding the use of Generative AI. Specifically:

  • If AI contributed to the writing in a substantial way — even if edited — you should disclose this in a note at the end of the article.
  • You are not required to disclose minor editorial use of AI (e.g. grammar fixes, edits for clarity).

Example: This article was edited using ChatGPT for grammar and readability.

Programming Contests

Generative AI can be a powerful tool when used to accelerate programming and development, but just like human coders it can make mistakes. Coding assistants (e.g. Cursor, Windsurf) and other generative AI products can be used when developing applications to be submitted to a Programming Contest in line with the guidelines above.

Additionally, contest participants are responsible for ensuring that their application meets all contest criteria and represents their own expertise. Submissions that leverage generative AI in their production are subject to the same standards of quality as entirely human-authored code.

Consequences of Misuse

We reserve the right to reject or remove articles or disqualify contest submissions that don’t align with these principles. Repeated violations may result in restrictions on publishing privileges.

Why This Matters

AI can be a helpful assistant, but it cannot replace your perspective. What makes a technical article valuable is your thought process, experience, and understanding. That’s what we want to highlight and support in our community.

Let your voice lead. Use tools responsibly.

4 novos comentários
Discussão (4)3
Entre ou crie uma conta para continuar
Anúncio
· Jul. 15

Discover what's new in Deltanji at our upcoming User Group

Join us on Thursday to see the new features of Deltanji source control, version 8.1.

We'll be demoing our new Git Location Driver along with other functionality and usability improvements.

The Git Location Driver enables Deltanji to integrate directly with Git repositories, makes Deltanji the perfect source control companion to those who use Git-based repos by providing tighter integration with InterSystems IRIS.

Date: Thursday, July 17th 
Time: 11 - 12pm EDT | 4 - 5pm BST | 5 - 6pm CET
Location: Online (register for details) 

Can't make it? Email info@georgejames.com and we'll send you the recording. 

Register here > https://forms.gle/f3cMcnvgoXmyj5tS8

Unfamiliar with Deltanji? 

Deltanji is an enterprise-grade source control solution built for InterSystems IRIS environments, with tight integration directly at the workface. Trusted by organizations globally, Deltanji’s advanced features includes a fully configurable workflow, advanced CI/CD, concurrent development and HealthShare integration. 

Visit our website to find out more, or email us at info@georgejames.com to arrange a demo.

Discussão (0)1
Entre ou crie uma conta para continuar