发布新帖

Rechercher

公告
· 九月 23, 2021

Video: Showcasing New X12 Enhancements

#数据转换语言（DTL） #互操作性 #视频 #2020线上峰会 #Health Connect #HealthShare #InterSystems IRIS for Health

Hi Community,

New video is already on InterSystems Developers YouTube:

⏯ Showcasing New X12 Enhancements

Learn about several key X12 enhancements now included in InterSystems IRIS for Health and InterSystems HealthShare Health Connect. Enhancements include SNIP validation of X12 documents and notable DTL improvements specifically for X12, which enable you to handle X12 data in a variety of interoperability use cases more easily and effectively.

🗣 Presenter: @John Goodgame, Sales Engineer, InterSystems  

Stay tuned! 

讨论 (0)0
登录或注册以继续
公告
· 九月 20, 2021

Video: Kafka! Integrating the World's Favorite Stream Processor with InterSystems IRIS

#互操作性 #视频 #2020线上峰会 #InterSystems IRIS

Hey Developers,

Get an introduction to Apache Kafka, a popular event-streaming platform, and see a demonstration of the upcoming Kafka integration with InterSystems IRIS Interoperability:

⏯ Kafka! Integrating the World's Favorite Stream Processor with InterSystems IRIS


🗣 Presenter: Helen Bang, Systems Developer, InterSystems

Subscribe to InterSystems Developers YouTube. Enjoy and stay tuned!

1 Comment
讨论 (1)0
登录或注册以继续
问题
· 九月 17, 2021

Our back-up is taking 3-4 Gb per day... Why and how to solve it?

#备份 #数据库 #InterSystems IRIS

Hello gentlemen,

I hope you can help me because this is a very serious that I can't wait to resolve... Our back-up is currently taking 3 up to 4 Gb per day and we don't know why. We had 270 Gb yesterday and we are today at 274.3 Gb. We keep a computer history of the messages for only 50 days. Here is a picture of what's currently taking the most data place in our healtshare system:

(don't forget that our DB is also connected to the back-up, maybe it is related, I don't know)

Thanks you in advance,

Thomas

1 Comment
讨论 (1)1
登录或注册以继续
问题
· 九月 14, 2021

Looking for Example of How to Use %SQL.Export.Mgr Export Method

#数据导入和导出 #SQL #InterSystems IRIS

https://docs.intersystems.com/irislatest/csp/documatic/%25CSP.Documatic....

 

method Export(savertn As %Boolean = 0) [ Language = objectscript ]

 

I am looking to export table to a text file in a programmatic way. I am not familiar with this class and how to invoke a "savertn" as input here.

 

Essentially I would like to Export Table (SELECT * FROM Table) and save it as a text file locally on Linux server. Is there any examples out there of that? Perhaps I need to save the query output to a global and then pass that input to the export?

 

Thanks,

James

2 Comments
讨论 (2)0
登录或注册以继续
问题
· 九月 13, 2021

SQL - use specific index

#SQL #Caché

Hello Community,

we want to use a specific index on our sql-class.

The index we want to use is called "iFilter".
Currently we use the following technique of ignoring all other indices because the automatically chosen index is always too slow. 

SELECT TOP 100 d0.ID FROM %IGNOREINDEX Belegindex %IGNOREINDEX KundenNrGlobalindex %IGNOREINDEX Rechnungsnummerindex %IGNOREINDEX Erfassungsartindex %IGNOREINDEX Belegsuche %IGNOREINDEX DatumAuftragindex %IGNOREINDEX OnlineBestellnummerindex %IGNOREINDEX Belegnummerindex %IGNOREINDEX KundenNrGlobalindex %IGNOREINDEX VAMindex %IGNOREINDEX BelegnummerbeiLagerLagerBestellungIndex %IGNOREINDEX iStatusSolr db.BelegeKopf AS d0 WHERE (((d0.KundenNr = 'BUKR01')) AND d0.ErfassungsartBez IN ('AB', 'AN') AND d0.DatumAuftrag >= '2020')

Do you know of a better/shorter way to resolve this?

 

Best regards.

Florian Hansmann

3 Comments
讨论 (3)0
登录或注册以继续