All
Accepted answers
Alexander Koblov · Jul 19, 2021 go to post

Hi Muhammad.

Perhaps Zen button does not have such attribute -- "onselect". Maybe you need "onclick" instead?

See the documentation for list of possible attributes

Alexander Koblov · Jul 27, 2021 go to post

do $System.DeepSee.Reset(1) is a very strong command. It clears all BI cache and terminates all running BI processes. That is -- if users are running queries at the moment, they get the errors.

If you find that you are running this command on the regular basis -- contact InterSystems Support

Alexander Koblov · Aug 9, 2021 go to post

You are connecting to the server 'localhost'. This server sends back the certificate. And this certificate says that it is for the server "cache". "cache" is not equal to the "localhost", hence the error.

Either access the server using the name "cache" (e.g. by changing hosts file). Or change the certificate

Alexander Koblov · Aug 18, 2021 go to post

InterSystems IRIS does not have a MEDIAN SQL function. However, it has different window functions.

For example, Percent_Rank might help you here.

create table test(c1 varchar(10), c2 integer)

insert into test(c1,c2) 
select 'a',1
union all
select 'b',2
union all
select 'c',3
union all
select 'd',3
union all
select 'e',3
union all
select 'f',4
union all
select 'g',5
union all
select 'h',6

select c1, c2, Percent_Rank () OVER ( 
	ORDER BY c2 desc
) rank_no 

from test
order by c2 desc

c1 	c2 	rank_no
h 	6 	0
g 	5 	.1428571428571428571
f 	4 	.2857142857142857143
c 	3 	.4285714285714285714
d 	3 	.4285714285714285714
e 	3 	.4285714285714285714
b 	2 	.8571428571428571429
a 	1 	1

Doc: https://docs.intersystems.com/irislatest/csp/docbook/Doc.View.cls?KEY=RSQL_windowfunctions

Also, it's possible to create a user-defined aggregate function. See https://docs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cls?KEY=RSQL_createudaf

Alexander Koblov · Aug 18, 2021 go to post

Should work. What does this function returns? Does it work if you put something very simple in the bat file? E.g.

echo qq > c:\temp\test.txt
Alexander Koblov · Aug 19, 2021 go to post 
USER>d ^quine
 set q = $C(34) kill a //stolen from Wikipedia Java example
 set a($I(a)) = " set q = $C(34) kill a //stolen from Wikipedia Java example"
 set a($I(a)) = " set a($I(a)) = "
 set a($I(a)) = " write a(1),! "
 set a($I(a)) = " for i=1:1:a { "
 set a($I(a)) = "    write a(2),q,a(i),q,! "
 set a($I(a)) = " }"
 set a($I(a)) = " for i=3:1:a {"
 set a($I(a)) = "    write a(i),!"
 set a($I(a)) = " }"
 write a(1),! 
 for i=1:1:a { 
    write a(2),q,a(i),q,! 
 }
 for i=3:1:a {
    write a(i),!
 }
Alexander Koblov · Oct 27, 2021 go to post

SQL Gateway uses %JDBC.Server to connect to 3rd party databases via JDBC.

SQL Gateway connection is the database connection settings. %JDBC.Server settings are the settings for the java process that handles these connections.

"The driver cannot be loaded" most likely means that you specified wrong path to the jar file with the MSSQL driver. Or IRIS process does not have permission to access this jar file.

Try also running two following commands from the terminal. They might give some hint on what's wrong

do $system.SQLGateway.TestConnection("ConnectionName")
zwrite %objlasterror
Alexander Koblov · Dec 10, 2021 go to post

Open settings for the web application (Menu -> Web applications -> [choose web application]) where you run the production and put %CSP.Error.cls as the "Custom Error Page". Reproduce the error. You should see the actual error on the page.

Alexander Koblov · Dec 22, 2021 go to post

I would even advise to use UNION ALL, because with UNION IRIS checks if resulting set has no duplicate rows, and there is no need to do this check with INSERT.

Alexander Koblov · Jun 14, 2022 go to post

"Why our license does not support ECP, if it's for Multi-Server?"

That's the different question from the one you asked in the post. I suggest you contact your Account Manager in InterSystems.

Alexander Koblov · Jun 14, 2022 go to post

Your account manager. If you don't know who this is -- contact the InterSystems office that issued you a license. Or contact WRC.

Alexander Koblov · Jul 21, 2022 go to post

I think you need to declare RunDownload as a ClassMethod, not ClientMethod, that is for JavaScript methods

Alexander Koblov · Jul 25, 2022 go to post

Hi Eddie.

Does it use it's own internal SQL database or are we able to connect to our own database and which databases are certified to run against the platform?

Both.

Supported 3rd party databases are listed here:

https://docs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cls?KEY=ISP_technologies#ISP_relgatewaydbs

Generally, please see "First looks" guides in our doc, particularly for JDBC and ODBC:

https://docs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cls?KEY=AFINDEX