Databases | InterSystems Developer Community

Question

Yongfeng Hou · Jul 1, 2016

在Aix7.1上安装使用root用户安装cache2016.1.1.107，且在安装过程中创建cacheusr用户；更改操作系统上的cacheusr的umask后，通过数据库修改编译后的文件(如，js，csp等)在小机上查看权限不变（-rwxrw-r-- cacheusr cacheusr test.js）。

目的：通过数据库编译后的文件的other用户有读写权限。

#Databases #CSP #Caché

5 3

0 936

Question

Timothy Leavitt · Mar 2, 2016

What determines the value of $$$DefaultLanguage (used for localization) for a new Caché installation?

Is the default language (i.e., $$$DefaultLanguage, which is used as the basis for localization with $$$Text/etc. at compile time) always "en" for new Caché installations, or could it be different? How is this determined? I don't see an option to select a language during Caché installation.

Also, is there a supported/preferred API for setting the default language? Looking at %occMessages.inc, one option would be:

#Caché #Compiler #Databases #Globals #Languages

0 3

0 473

Question

Scott Beeson · Feb 16, 2016

Concatenate columns in results with GROUP BY?

Here is my original query:

SELECT EventType, InitiatedAt, COUNT(*) as cnt
FROM HS_IHE_ATNA_Repository.Aggregation
WHERE EventType = 'LOGIN'
AND LocalDateTime > '2016-02-16 11:00:00'
GROUP BY EventType, InitiatedAt

This gives me data like this:

#Code Snippet #Databases #SQL #Caché

0 3

0 6.8K

Question

Steven LeBlanc · Dec 17, 2015

API equivalent to 'Recreate a database' option in ^DATABASE routine?

Hi,

Is there any API equivalent (within Config.Databases class, or elsewhere) that has the same functionality as the 'Recreate a database' option in the ^DATABASE routine?

This option was added to ^DATABASE (according to internal Devlog CFL1263):

#Databases #System Administration #Caché

1 2

0 349