%Studio.Project).InstallFromGbl(... rejects explicitly for Versions before 2013.1 in line 1440
You better contact WRC for help with this 10 year old version
Bonsoir Sylvain!
Are you looking for something similar to this;
Property MonJour As %String
[ InitialExpression = "31/12/1840" ];
Property Jour As %Date [ InitialExpression = 0,
SqlComputeCode = {set {*}= $ZDH({MonJour},4) },
SqlComputed, SqlComputeOnChange = MonJour ];
(Multiline just for readability)
Thanks for the test data!
It confirms known behavior:
Great job !
What You See Is What You Get
#1) what type of "routine" do you try to handle ?
#2) what is the Format you get those "routines"
some combinations may allow "command line" examination
In ENSEMBLE default namespace SAMPLES holds a collection, CSP examples.
there is a basic misunderstanding:
inside the <CSP:WHILE...> block you are in HTML context
but you issue instead JavaScript >>>> which just prints it out.
To illustrate this see this simple example:
But changing to JS_context solved my simple demo with alert();
<csp:WHILE CONDITION="resultSet.Next()">
<!-- xValues.push(#(resultSet.Get("StatsDate"))#)
yValues.push(#(resultSet.Get("Value"))#) -->
<p>#(resultSet.Get("StatsDate"))#<br>#(resultSet.Get("Value"))#</p>
<script LANGUAGE="JavaScript">
alert(#(resultSet.Get("StatsDate"))#+'>>>'+#(resultSet.Get("Value"))#);
</script>
</csp:WHILE>Puoi dare un suggerimento in Ideas Portal
Penso che ci sia abbastanza supporto lì.
Perciò ?? @Luca Ravazzolo ??
Great Stuff!
This matches seamlessly to the "real" Customer benchmark I did in 2009 (with Caché)
against PostgreSQL and MySQL
Years went by but the principles haven't changed.
Glad to see that this is still as valid as it was since ever.
After so many years, all new technology tricks didn't change that.
find One-Line-Installer here ZPM is rather on top
It is still in IPM. OEX seems to have lost it. ???
zpm:USER>search global-dump-sql
registry https://pm.community.intersystems.com:
global-dump-sql 1.0.2
zpm:USER>install global-dump-sql
[USER|global-dump-sql] Reload START (C:\InterSystems\IRIS\mgr\.modules\USER\global-dump-sql\1.0.2\)
[USER|global-dump-sql] Reload SUCCESS
[global-dump-sql] Module object refreshed.
[USER|global-dump-sql] Validate START
[USER|global-dump-sql] Validate SUCCESS
[USER|global-dump-sql] Compile START
[USER|global-dump-sql] Compile SUCCESS
[USER|global-dump-sql] Activate START
[USER|global-dump-sql] Configure START
[USER|global-dump-sql] Configure SUCCESS
[USER|global-dump-sql] Activate SUCCESS
Just providing the global name results in a full global dump.
Example:
USER>zn "user"
IRISAPP>d $system.SQL.Shell()
SQL Command Line Shell
... select TOP 5 * from zrcc_G.dump where zrcc_G.Dump('^%SYS','"JOURNAL"')=1
Thank you Maksym !
You reached 100% ObjectScript.
I was really impressed by your Part2 on day 23 + 24
Hi all,
All challenges of AOC 2023 are published.
You are invited to publish your solutions before Dec.28th:
I'll clone your repos on early Dec 28th. no late coming.
Actual ranking by verified completion in ObjectScript
DCrank AOCrank Scores Stars ok% ----- Code Parts OK ----- Name
0 --- ---- ---- --- ----*----*----*----*----* --- DC Members ---
1 1 6825 50 100 3333333333333333333333333 Kevin An
2 2 6812 50 100 3333333333333333333333333 maxymczech
3 3 6697 50 100 3333333333333333333333333 Yuval Golan
4 13 4646 36 74 3333333331313333--111311- Oliver Wilms
5 14 4305 35 70 3333333333313133-1111--1- Ivo ver eeckeThank you Yuri ! 😊
A great initiative. A really surprising experience to see the echo of the community.
for those interested in details without personaö self-promotion.
Best wishes - especially HEALTH -- to everyone in the community
And special thanks to the excellent team running this community. 💐🌺🌹🌼🌻🌟
If you want to clear all old data you have to use ..%DeleteExtent(..) that you inherit from %Persistent.
Changing from %Persistent to %SerialObject is a compiler-related action.
The compiler doesn't take care of your storage.
In this case only the access methods change, but not the underlying storage and its content
there are command line utilities i Namespace %SYS down from ^DATABASE %SYS>d ^DATABASE 1) Create a database 2) Edit a database 3) List databases 4) Delete a database 5) Mount a database 6) Dismount a database 7) Compact globals in a database 8) Show free space for a database 9) Show details for a database 10) Recreate a database 11) Manage database encryption 12) Return unused space for a database 13) Compact free space in a database 14) Defragment globals in a database Option?
in addition Class SYS.Database holds a long list of utility methods
you have to dig into Class docu
indeed the numbers sometimes overlap:
twoneight became. 218 !! that was really nasty
only removing the first found char was the workaround
Try to check your code against the 2 test sets in my OEX package:
sometimes there is a problem if the last line of input.txt is missing a line terminator.
try to keep always an empty line in the end.
Hi all,
The first half of the competition is over!
To anticipate questions related to the ranking:
My sorting is Stars > verified ObjectScript (ok%) > Scores
After finish when 50 Stars + ok=100% are reached Scores defines the ranking.
You see now an extended ranking list.
Code Part OK signals the modules that have passed the function test against the Test Sets in OEX
1 => Part1 OK, 2 => Part2 OK, 3 => Part 1+2 are OK, - => nothing OK the position indicates the day.
ok% is the percentage of parts verified OK of the 100 parts in totals in the competition.
Congratulations to the Winners ! 👏🥂
Ah, some improvements.
I personally always used UTC since the introduction of ENSEMBLE (ages back)
Your time zone is taken from your settings in the underlying operating system
$ZTZ shows the offset from UTC. You can set it to whatever you need.
but ATTENTION this affects $H for the whole IRIS instance !!!
take a serious look into documentation on mostly not wanted the side effects
to be precise:
also classes & routines starting with %SYS. * exact with uppercase and dot go to IRISSYS / CACHESYS
https://docs.intersystems.com/iris20233/csp/docbook/DocBook.UI.Page.cls?KEY=GSA_config_namespace_addmap#GSA_config_namespace_addmap_global
Similar to previous years I will provide the results of our private leaderboard
DCrank AOCrank Scores Stars ok% ----- Code Parts OK ----- Name 0 --- ---- ---- --- ----*----*----*----*----* --- DC Members --- 1 1 6825 50 100 3333333333333333333333333 Kevin An 2 2 6812 50 100 3333333333333333333333333 maxymczech 3 3 6697 50 100 3333333333333333333333333 Yuval Golan 4 12 4868 39 0 ------------------------- Jaume Ferre 5 13 4646 36 74 3333333331313333--111311- Oliver Wilms 6 14 4305 35 68 3333333333313133--111--1- Ivo ver eecke 7 15 4138 34 0 ------------------------- Oskari Kosonen 8 17 3054 24 0 ------------------------- Keith Avery 9 29 1368 12 0 ------------------------- Dieter PAUL 10 30 1046 9 0 ------------------------- TylerFeldhege 11 36 415 4 0 ------------------------- Chris Marais 12 38 302 3 0 ------------------------- Daniel Aguilar 13 39 259 2 0 ------------------------- Muhammad Umar Waseem 14 40 114 1 0 ------------------------- rhodery 15 10 5504 44 0 ------------------------- isc-Junhee Lee 16 19 2326 19 0 ------------------------- isc-Chris Stewart 17 23 1820 15 0 ------------------------- isc-Rebecca Agustin 18 27 1541 12 0 ------------------------- isc-Ajinkya Sonawane 19 37 333 3 0 ------------------------- isc-bquirk 20 41 104 1 0 ------------------------- isc-Arwa A. 21 42 100 1 0 ------------------------- isc-Raj Singh 22 --- ---- ---- --- ------------------------- --- unknow in DC --- 23 6 6476 50 100 3333333333333333333333333 Test Set1 24 7 6353 50 100 3333333333333333333333333 Test Set2 25 4 6604 50 0 ------------------------- Joaquin Derrac Rus 26 5 6573 50 0 ------------------------- Dominik Znidar 27 9 6062 50 0 ------------------------- Dang Quang Vi 28 8 6184 48 0 ------------------------- Jarjar 314 29 11 5139 42 0 ------------------------- Sloan Kanaski 30 16 3163 27 0 ------------------------- (anonymous user #3860190) 31 9 2491 21 0 ------------------------- Paul Langelaan 32 18 2353 19 0 ------------------------- Jesper Olsson 33 20 2145 18 0 ------------------------- Luke Schuurman 34 22 1947 17 0 ------------------------- Michael Cheng 35 21 2091 16 0 ------------------------- Gary Nguyen 36 24 1719 16 0 ------------------------- SubstantialProduct27 37 25 1661 14 0 ------------------------- hazamashoken 38 26 1619 13 0 ------------------------- nwattana 39 28 1422 12 0 ------------------------- Nahuel 40 31 1015 9 0 ------------------------- Geoffrey Lu 41 32 800 7 0 ------------------------- (anonymous user #214666) 42 23 697 6 0 ------------------------- j-dolenc 43 33 669 6 0 ------------------------- Dominique Dordain 44 34 482 4 0 ------------------------- LFY 45 35 476 4 0 ------------------------- Robert Trifan
Also a candidate for the 1 liner category
much better than the official SQL extension.