I would like to avoid string manipulationDelimiters in the format are required, so you will have to manipulate the strings anyway.
$tr($system.SQL.TOCHAR($h,"YYYYMMDD HH24 MI SS")," ","") or $tr($system.SQL.TOCHAR($h,"YYYY^MM^DD^HH24^MI^SS"),"^","")
LOAD DATA (SQL)2021.2
Ok, the index can be omitted.
The table data is stored in different globals: *D - for data, *I - for indexes, *S - for streams. You can get the size of the data parts you want.
Example [Size()]:
select * from %SYS.GlobalQuery_Size('C:\InterSystems\Cache\mgr\samples','','*D,*S',0,0,1) order by "Allocated MB" descSee the sources of method %SYSTEM.SQL:Export() for a description of the parameters.
Only instead of 0, use 1, for example:
SAMPLES>w $$Export^%qarDDLExport("Sample","*","C:\Temp\Sample.sql","WNS",1,0,0,0,0)Will an undocumented command suit you?
Try the following:
That's what I expected to see.
But need remember that
This method is only available for stored properties.In other words, if the storage changes tomorrow, will have to rewrite a bunch of code.
I meant the length of the code.
I can write like this:
<..> select a->b->c->d into :r from table where %ID=:id <..>
Can you give a complete code example for a->b->c->d using GetStored?
And if you need to get a->b->c->d and they at the same time can be null?
Another option
/// This sample persistent class represents an employee.<br>
Class Sample.Employee Extends Person
{
...
/// The company this employee works for.
Relationship Company As Company [ Cardinality = one, Inverse = Employees ];
Property Cname As %String [ Calculated, SqlComputeCode = {n id,r s id={%%ID} &sql(select Company->Name into :r from Sample.Employee where %ID=:id) s {*}=r}, SqlComputed ];
...
}In this case, you should wait for IRIS 2021.2 with built-in Python and use Jinja directly.
In the meantime, there is the following:
There is a ready-made method for this: getFileslink
Usage example:
s path="C:\Temp" s pExtension=1 s pExtension(1)="*" s pTempNode=$i(^CacheTemp) k ^CacheTemp(pTempNode) d ##class(%SQL.Util.Import).getFiles(path,.pExtension,pTempNode,1) m dirlist=^CacheTemp(pTempNode) k ^CacheTemp(pTempNode) zw dirlist
It's okay, I already have a minus.
It looks like this is my last comment here.
UPD:
w $$Iso8601ToTimeStamp("2021-10-22T08:00:00+0900"),!
w $$Iso8601ToTimeStamp("2021-11-04T11:10:00+0100"),!
w $$Iso8601ToTimeStamp("2021-11-04T11:10:00+0200"),!
w $$Iso8601ToTimeStamp("2021-11-04T11:10:00-0140"),!
Iso8601ToTimeStamp(ts) {
s r=##class(%TimeStamp).XSDToLogical($e(ts,1,22)_":"_$e(ts,*-1,*))
w r," => "
q $zdth(r,3)
}Output:
USER>do ^test 2021-10-21 23:00:00 => 66038,82800 2021-11-04 10:10:00 => 66052,36600 2021-11-04 09:10:00 => 66052,33000 2021-11-04 12:50:00 => 66052,46200
In this case, you can do this:
SELECT %TSQL.ZRAND(%ID+1e16) rnd, ID, Citizenship, DOB, FirstName, Gender, IDNumber, LastName, PatientNumber, PhoneNumber FROM CDR.Patient
Type of rnd - DOUBLE.
Of course, you can convert it to NUMERIC or STRING
For debugging purposes and further query optimization, why not?
I have a legacy code that I need to optimize.
Try calling the ClearBuffers in the GLOBUFF system routine, e.g.:
USER>d ClearBuffers^|"%SYS"|GLOBUFF() Removed 65303 blocks
E.g.:
Class dc.test Extends %ZEN.Component.page
{
XData Contents [ XMLNamespace = "http://www.intersystems.com/zen" ]
{
<page xmlns="http://www.intersystems.com/zen">
<tablePane id="tp" sql="select 1 id, '2021-11-03' DT union select 2, '2022-01-24'">
<column colName="id"/>
<column colName="DT" link="javascript:zenPage.modalGroupCalendar('#(%query.DT)#');"/>
</tablePane>
</page>
}
ClientMethod modalGroupCalendar(val) [ Language = javascript ]
{
var group = zenPage.createComponent('modalGroup');
group.setProperty('onaction','zenPage.calendarAction(group);');
group.show('Select a date:','calendar',val);
}
ClientMethod calendarAction(group) [ Language = javascript ]
{
alert("You selected: " + group.getValue());
// SaveOnServer(); !
}
}Perhaps the built-in function will suit you $TSQL_NEWID()
Try this:
Class dc.test Extends %ZEN.Component.page
{
XData Contents [ XMLNamespace = "http://www.intersystems.com/zen" ]
{
<page xmlns="http://www.intersystems.com/zen">
<tablePane id="tp" sql="select 1 id, 'a' FollowUp union select 2,'b'">
<column colName="id"/>
<column colName="FollowUp" header="FollowUp Comments" width="9%" style="text-align:left;" OnDrawCell="txtFollowUp"/>
</tablePane>
</page>
}
Method txtFollowUp(
pTable As %ZEN.Component.tablePane,
pName As %String,
pSeed As %String) As %Status
{
&html<<textarea name="followup" rows="3" style=" width: 95%;" onchange="zenPage.saveFollowUp(this.value,#(%query("id"))#);">#(%query(pName))#</textarea>>
Quit $$$OK
}
ClientMethod saveFollowUp(
val,
id) [ Language = javascript ]
{
zenAlert(val,' <-> ',id);
}
}This functionality is available when working with ActiveX (however, ActiveX is not recommended for use in new applications):
PS: in the Caché distribution there was even a special library DelphiCallback.dll for Delphi, an example of working with which is in my blog.
I did a small test locally (for Caché).
test.py:
print("success")
exit()From terminal:
USER>w $zf(-1,"python C:\tmp\test.py") 0
From Studio Output Window:
w $zf(-1,"python C:\tmp\test.py") 0
Make sure that your service for Caché/IRIS use an account with administrative rights:
It should be like this (see Work with multiple sql statements):
DELETE FROM TableName WHERE ID = 2 GO DELETE FROM TableName WHERE ID = 3 GO DELETE FROM TableName WHERE ID = 4 GO
In this case you can open the original article and take the code from there (and/or translate it with another service, for example Google translate)
See my old article on my blog: Examples of generating and sending Email using the Caché DBMS (this is machine translation)