查找

Question
· Nov 11, 2024

Determine a String is an SQL Reserved Word

Hello,

Is there a programmatic way (in ObjectScript) to determine if a string is an SQL reserved word (aside from using embedded SQL to try to name a property with that string and look for the error :-))?

Thank you,

Jean

2 Comments
Discussion (2)1
Log in or sign up to continue
Discussion
· Nov 11, 2024

Which is the "right" installation directory for IRIS on Linux?

The IRIS Installation Guide for Linux, Installation Directory section, says "Do not choose the /home directory, any of its subdirectories, or the /usr/local/etc/irissys directory." but there are no suggestions or any default.

What are your opinions on this? For example, I see that IRIS in a Docker container is installed in /usr/irissys. I'm wondering why that directory was chosen.

The official Linux filesystem docs say:

  • /usr is the second major section of the filesystem. /usr is shareable, read-only data. That means that /usr should be shareable between various FHS-compliant hosts and must not be written to. Any information that is host-specific or varies with time is stored elsewhere. Large software packages must not use a direct subdirectory under the /usr hierarchy.
  • The /usr/local hierarchy is for use by the system administrator when installing software locally. It needs to be safe from being overwritten when the system software is updated. It may be used for programs and data that are shareable amongst a group of hosts, but not found in /usr.
  • /opt is reserved for the installation of add-on application software packages. A package to be installed in /opt must locate its static files in a separate /opt/<package> or /opt/<provider> directory tree, where <package> is a name that describes the software package and <provider> is the provider's LANANA registered name.

From that, it seems like /usr/local/InterSystems/<instance> or /opt/InterSystems/<instance> would be "right." To me that seems better than /usr/irissys, /usr/irissys1, /usr/irissys2, etc.

4 Comments
Discussion (4)1
Log in or sign up to continue
Announcement
· Nov 11, 2024

Recapitulação do InterSystems Developer Community, Outubro 2024

Olá e bem-vindo ao Recapitulação da comunidade de desenvolvedores Outubro 2024.
Estatísticas gerais
28 novas postages publicadas em Outubro:
 22 novos artigos
 6 novos anúncios
3 novos membros ingressaram em Outubro
1,199 postagens publicadas ao todo
595 membros ingressaram ao todo
Principais publicações
Principais autores do mês
Artigos
#InterSystems IRIS
eBPF: Rastreando eventos de Kernel para IRIS Workloads
Por Heloisa Paiva
eBPF: Parca - Criação de perfil contínua para IRIS Workloads
Por Heloisa Paiva
Desenvolvendo Intergrações com o InterSystems IRIS - SOAP Inbound Adapter
Por Julio Esquerdo
Script de Freeze em servidores espelhados
Por Heloisa Paiva
Desenvolvendo Integrações com o InterSystems IRIS - File Inbound Adapter
Por Julio Esquerdo
eBPF: Segurança Tetragon para cargas de trabalho IRIS
Por Heloisa Paiva
Funções do lado esquerdo em ObjectScript
Por Heloisa Paiva
Desenvolvendo Integrações com o InterSystems IRIS - Aplicação REST
Por Julio Esquerdo
Desenvolvendo Integrações com o InterSystems IRIS - SQL Inbound Adapter
Por Julio Esquerdo
Desenvolvendo Integrações com InterSystems IRIS - SOAP OutboundAdapter
Por Julio Esquerdo
Introdução ao suporte WSGI
Por Heloisa Paiva
A minha abordagem pessoal aos Vectores
Por Robert Cemper
Rodando aplicações Flask no IRIS
Por Heloisa Paiva
Rodando aplicações Django no IRIS
Por Heloisa Paiva
Desenvolvendo Integrações com InterSystems IRIS - Chamada Assíncrona no BP
Por Julio Esquerdo
Desenvolvendo Integrações com InterSystems IRIS - CALL no Business Process
Por Julio Esquerdo
Rodando aplicações FastAPI no IRIS
Por Heloisa Paiva
Desenvolvendo Integrações com InterSystems IRIS - SQL Outbound Adapter
Por Julio Esquerdo
Modelos LLM e Aplicações RAG Passo a Passo - Parte I
Por Heloisa Paiva
 
#InterSystems IRIS for Health
 
Anúncios
Outubro, 2024Month at a GlanceInterSystems Developer Community
Discussion (0)1
Log in or sign up to continue
Question
· Nov 11, 2024

Help navigate and extract data in Cache 2017

Hi,

I have a archive backup of a Cache database. I was able to restore the database but having trouble navigating through the globals, classes, namespaces .??? I am not a Cache user and/or developer so I am a bit lost. I am used to relational database such Microsoft SQL but not Cache which to my understand is a different breed of database. If you are looking for some extra money to help me extract some of the data I need i would be greatly appreciated.

Please email me at tamthnguyen@gmail.com or what's app phone +14168985565 I am in Toronto, Canada Eastern Standard Time Zone.

Thanks very much in advance..

Regards,

Tam,

1 Comment
Discussion (1)1
Log in or sign up to continue
Question
· Nov 11, 2024

LOCK on Global vars, is it necessary in this case?

I have a business process that adds data to a global variable on receipt of an HL7 message, and a scheduled task that executes a class method defined within the same business process that removes data from the same global variable. With this in mind it makes sense to consider concurrency and therefore make use of the LOCK command.

My first question is whether this is actually necessary?

My second question is what happens to locks when an error/exception is encountered after a lock but before the code to release the lock, is this managed automatically or should try-catch be used to release the lock given an error?

1 Comment
Discussion (1)1
Log in or sign up to continue