go to post Robert Cemper · Jul 30, 2020 @Evgeny Shvarov I went into Studio and then killed the job from Portal by <RESJOB>
go to post Robert Cemper · Jul 30, 2020 Thanks @Eduard Lebedyuk ! Fixed@Evgeny Shvarov It seems to me OEX changes the URL with every update. here appending -1 to original URL.
go to post Robert Cemper · Jul 29, 2020 Hi @Lucas Fernandes It was a little bit more complicated than expected. Anyhow take a lookSQL for ^ERROR Global Thanks to @José Roberto Pereira for the inspiration.
go to post Robert Cemper · Jul 29, 2020 in IRIS if the data type is any numeric (%Integer, %Decimal, %Float, ..... or %Boolean) the value is NOT enclosed in Quotes.
go to post Robert Cemper · Jul 29, 2020 Just to outline my understanding:my package will be rcc.subject.classname rarely eventually zrcc.subject.classname if it should go to %SYS . And I will not touch/ rename existing projects as this means changing not just the codebut also README.md , Descriptions in OEX and Articles in DC, Screenshots, Dependencies (not just my own), ...Over all a good source for mistakes, typos, errrors, confusion,
go to post Robert Cemper · Jul 28, 2020 What is the rule for VERSION in Dependencies ?Is it an EQUAL or a MINIMUM Version. e.g. <Version>0.0.0</Version> would mean any version <Dependencies> <ModuleReference> <Name>holefoods</Name> <Version>0.1.0</Version> </ModuleReference> </Dependencies> Thanks !
go to post Robert Cemper · Jul 28, 2020 The so-called SQLformat doesn't exist in Caché (at least not in the last 20 years)But over the gateway, you can move data from Caché to PostgeSQL. "from a table on CACHE to a POSTGRESQL table" So you need a trigger to do it:- Caché has to be the active part hereyou can start the upload over a webservice, an REST call, even as an SQLprocedure, or automatically by the schedulerAnd if you don't want to touch your target table directly you may have a shadow-copy in PostgreSQL thatthen serves as a source for your final updates. ( some INSERT...SELECT....) So instead of import from CSV, you do an import from a local table in PostgreSQLAnything is better than CSV.This would even allow filling your shadow over the day in small steps instead of a big bang (if needed)
go to post Robert Cemper · Jul 24, 2020 There is a JDBC driver to PostgreSQL available.Using that drive you define an SQL Gateway for your PostgreSQL and establish a link for your tables:The projection can be accessed as if was a table in Caché.Details & HowTo here: https://cedocs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=GSQL_gateway
go to post Robert Cemper · Jul 24, 2020 just tried. the link leads you to :https://openexchange.intersystems.com/package/Simple-remote-server-controlthere is the link to GitHub
go to post Robert Cemper · Jul 23, 2020 You might be inspired by this: https://community.intersystems.com/post/simple-remote-server-controlIn principle, a job is hanging around waiting for orders. Like a cab waiting for a drive.
go to post Robert Cemper · Jul 19, 2020 a little bit cross thinking it reminds me of this https://community.intersystems.com/post/unlimited-unique-index
go to post Robert Cemper · Jul 19, 2020 I 've never seen the 1000 cols limit. (Consider the record size and the related impact to storage !)But in a comparable situation, I used an array with the column name as a key. => unlimited columns, slim storage.And you can work on it in SQL and in classes.BUT this is object thinking, not straight SQL
go to post Robert Cemper · Jul 18, 2020 try it without "CONSTRAINT TestePK PRIMARY KEY (ID)"and without "ID INT NOT NULL, " so you get an autoincremented unique ID by default
go to post Robert Cemper · Jul 16, 2020 This option https://community.intersystems.com/post/terminal-multi-line-optionor the extended one with editor support https://community.intersystems.com/post/terminal-multi-line-command-editorcould be useful.
go to post Robert Cemper · Jul 12, 2020 Studio is an integrated part of Caché, Ensemble, IRIS, ... and part of any installation kit for Windows https://docs.intersystems.com/iris20201/csp/docbook/DocBook.UI.Page.cls?KEY=GSTD
go to post Robert Cemper · Jul 12, 2020 In studio you open the class and click the class attribute in the inspector
go to post Robert Cemper · Jul 12, 2020 to edit a table by DDL the corresponding class hat to be DDL allowed. DdlAllowed - Caché & Ensemble 2018.1.3 — 2018.1.4
go to post Robert Cemper · Jul 9, 2020 FIXED ! I have implemented an extension to %ZJSON.Generator to fix missing JSONTYPE Standard Caché data types don't have a parameter JSONTYPE (!!) so everthing is set to (quoted) "string".Especially numbers and boolean data must not be in quotes. e.g ....."NUMfield":124, "TrueFalse":true, .... instead of ....."NUMfield":"124", "TrueFalse":"true", .... this extension bypasses the missing parameter for these standard data types as indicated in %ZJSON.Adaptor/// number = %BigInt, %Currency, %Decimal, %Double, %Float, %Integer, %Numeric, %SmallInt, %TinyInt/// boolean = %Boolean For customized data classes it is easy to add Parameter JSONTYPE=". . . ."But changing sometihng in SYSLIB is a clear NO-NO to me. ( though it might have been easier) The extended version of %ZJSON.Generator is here: https://github.com/rcemper/Backport-JSON.-to-Cach-/blob/master/MissingJSONTYPE.xml
go to post Robert Cemper · Jul 9, 2020 Great stuff @Vitaliy.Serdtsev https://docs.intersystems.com/iris20192/csp/docbook/Doc.View.cls?KEY=RSQL_json everlasting learning!
go to post Robert Cemper · Jul 9, 2020 Got you! Something like $isJSON() ? like $isobject() or $listvalid()