Posts by Daniel Buxton on InterSystems Developer Community

Question

Daniel Buxton · Oct 20, 2020

Convert Epoch Time in MS to smalldatetime to perform COUNT

Hey,

I have a value in epoch time in which I need convert in order to be able to lookup a table that has dates in YYYY-MM-DD HH:MM:SS format

I thought the below would work but it is not.

select COUNT ('Arrival Time') FROM dbo.table where 'Arrival Time' < DATEADD(ms, CONVERT(int,LEFT(1603173432000, 20)), '1970-01-01 00:00:00')

#SQL #Caché

0 8

0 305

Question

Daniel Buxton · May 11, 2020

INSERT multiple rows

Hey I would like to INSERT mulitple rows to 1 table. I need to intersystems cache equivelant for

INSERT INTO table_name (column_list)
VALUES
(value_list_1),
(value_list_2),
(value_list_3);

Have tried this post https://community.intersystems.com/post/how-execute-multiple-query-or-script-sql-management-studio
but still got an error

#SQL #Caché

1 10

1 1.5K

Question

Daniel Buxton · Sep 22, 2019

Lost my journal files

I had my journal files all on one disk which died :(

The database files are all fine, but I having issues. Can I bypass the need for the journal files?

#Journaling #Caché

0 5

0 791

Question

Daniel Buxton · Aug 1, 2019

DeepSee security issue

Hey Guys,

Have enabled DeepSee on my cache db via

Do EnableDeepSee^%SYS.cspServer(0)

I have created user with access to a profile with all the %Deep_See options (%DeepSee_Admin, %DeepSee_Analyzer etc etc) as well as %All. I have also added %All to unknownuser

When click the DeepSee page and choose a namespace Architect, Analyzer, Reporting Data Definition and Reporting Builder are all greyed out with 'you do not have privilege to view this page

#InterSystems IRIS BI (DeepSee)

0 3

0 215