Pesquisar

Pergunta

Lynn Lantz · Jun. 25, 2024

I'm trying to keep all writes in local memory.

If you have S %A="""HI THERE"",!,#,33.33,"" "",$ZTIMESTAMP"

and you O 2 U 2 W @%A C 2 ZW ^SPOOL
^SPOOL(1,1)="HI THERE"_$c(13,10)
^SPOOL(1,2)=$c(13,12)
^SPOOL(1,3)="33.33 67016,59246.6188873"

It works just fine and the output is in the ^SPOOL global.

However, I'm trying to avoid writing to disk.

I can't find anything besides using the SPOOL device that will allow the use of the "@" indirection.

I tried using streams but it will not allow @indirection. Neither will set, or execute, or anything.

Is there any easy way to just set a variable to the formatted write output that the @indirection creates??

Thanks!

4 Comments

Discussão (4)2

Entre ou crie uma conta para continuar

Pergunta

Carl (booz Alle... · Jun. 25, 2024

#SQL #InterSystems IRIS for Health

Given a properly formatted ISO 8601 date time of 2024-06-23T06:03:00Z using SQL DatePart results in an error:

[SQLCODE: <-400>:<Fatal error occurred>]

[%msg: <Invalid input to DATEPART() function: datepart='ss', datetime value='2024-06-23T06:03:00Z')>]

If I remove the trailing Z (for Zulu / UTC time) and leave the T, DatePart works fine.

I have also tried various ± offsets from UTC e.g. +0400 and that also results in the same SQL error

I can Trim the trailing "Z", but I would hope that DatePart would work with an acceptably formatted ISO 8601 date time string without having to go through the machinations of trimming the data.

Any help or suggestions on how to use SQL DatePart with ISO 8601 formatted Date Time strings would be appreciated.

This is the query I was experimenting with:

select 'YEAR: '||DATEPART(YEAR,'2024-06-23T06:03:00Z')
UNION
select 'MONTH: '||DATEPART(MONTH,'2024-06-23T06:03:00Z')
UNION
select 'DAY: '||DATEPART(DAY,'2024-06-23T06:03:00Z')
UNION
select 'HOUR: '||DATEPART(HOUR,'2024-06-23T06:03:00Z')
UNION
select 'MINUTE: '||DATEPART(MINUTE,'2024-06-23T06:03:00Z')
UNION
select 'SECOND: '||DATEPART(SECOND,'2024-06-23T06:03:00Z')

2 Comments

Discussão (2)2

Entre ou crie uma conta para continuar

Pergunta

omer · Jun. 25, 2024

#CSP #Caché #InterSystems IRIS

I need to be able to take the size of the request from a given %CSP.request

however it seems the best the docs suggest is to get the length of characters in the request (using $order and Get, Count)...
this is not good enough for what I need to do, Any suggestions?
I scanned the docs and couldn't find anything.

5 Comments

Discussão (5)1

Entre ou crie uma conta para continuar

Pergunta

Yone Moreno · Jun. 25, 2024

#Code Snippet #ObjectScript #InterSystems IRIS for Health

Hello,

Thanks for reading this question.

We need to remove the line feeds and carriage returns from start and end, but not from the middle of a string

We have tested the following ways:

set output = $ZStrip("[line feed](carriage return) str [line feed](carriage return) ing [line feed](carriage return)","<>C")

But it removes also control characters which we need to preserve...

Also we have tested:

set output = $REPLACE("[line feed](carriage return) str [line feed](carriage return) ing [line feed](carriage return)",$C(13,10),"")

But it deletes line feed and carriage return at the middle of the string, so it is not what we need...

How would you recommend us to implement it.

We have read:

https://community.intersystems.com/post/trimming

https://docs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cls...

https://community.intersystems.com/post/zstrip-clean-string

https://docs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cls...

Could you help us please?

Thanks.

7 Comments

Discussão (7)3

Entre ou crie uma conta para continuar

Anúncio

Anastasia Dyubaylo · Jun. 25, 2024

#Developer Community Oficial

Hello and welcome to the Developer Ecosystem Spring News!

This spring was full of online and offline activities in the InterSystems Developer Ecosystem. In case you missed something, we've prepared for you a selection of the hottest news and topics to catch up on!