go to post Andreas Schneider · Apr 9, 2022 @Vitaliy.Serdtsev thanks for this great idea! In the past i have also missed this feature myself from time to time. So far the pain has not been great enough ;-) But now I know that other users also miss this feature...
go to post Andreas Schneider · Feb 11, 2022 Freut mich wenn ich helfen konnte. Gerne mit DU ;-) Andreas
go to post Andreas Schneider · Feb 9, 2022 The column parameter has MAXLEN 229: parameter As %Library.String(MAXLEN = 229) [ SqlColumnNumber = 6 ]; that is why the insert fails
go to post Andreas Schneider · Feb 9, 2022 The rejected insert has 239 chars in the fifth column. The working insert has 186 chars. So check your table defintion. How are the columns defined?
go to post Andreas Schneider · Feb 9, 2022 Are you shure that you match the column list? An INSERT without a column list is not very stable about changes.
go to post Andreas Schneider · Jan 9, 2022 I think it is always a good idea to avoid reserved words in the data model. Even if the quick import of a CSV tempts to take it not so exactly. Especially because messages from IRIS don't always point exactly to the cause of the problem ... or it leads to problems later. This saves unnecessary troubleshooting. https://docs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cls...happy loading! ;-) Andreas
go to post Andreas Schneider · Jan 3, 2022 If I check the Locktable in Caché 2018.1.0.184 it looks like this: (Used "LOCK Aviation.Aircraft IN EXCLUSIVE MODE" in SAMPLES Namespace) If I check the Locktable in IRIS 2021.2.0.617 it looks like this:(Used "LOCK TABLE dc_data_flights.airports IN EXCLUSIVE MODE") A "UNLOCK TABLE dc_data_flights.airports IN EXCLUSIVE MODE" removes the lock
go to post Andreas Schneider · Jan 3, 2022 Maybe you haven't send the complete statement?This works for me via JDBC, tested with Caché2018.1.0.184 and IRIS 2021.2.0.617 LOCK TABLE dc_data_flights.airports IN EXCLUSIVE MODE -- OR LOCK dc_data_flights.airports IN EXCLUSIVE MODE -- OR LOCK TABLE dc_data_flights.airports IN SHARE MODE -- OR LOCK dc_data_flights.airports IN SHARE MODE If try this I get the same error like you: -- this create an error, the "IN EXCLUSIVE MODE" or "IN SHARE MODE" is missing LOCK TABLE dc_data_flights.airports Andreas
go to post Andreas Schneider · Jan 3, 2022 Setting the JVM arg for the %Java Server can be done by Portal or console: set srv = $system.external.getServer("%Java Server") set srv.JVMArgs = "-Dfile.encoding=UTF-8" set modifiedserver = $system.external.modifyServer(srv)
go to post Andreas Schneider · Jan 3, 2022 Thanks @Benjamin De Boe! It works like a charm ;-) set srv = $system.external.getServer("%Java Server")set srv.JVMArgs = "-Dfile.encoding=UTF-8"set modifiedserver = $system.external.modifyServer(srv)
go to post Andreas Schneider · Jan 2, 2022 Kevin, can you give me tip please how I can set this JVM Argument via console? I want to integrate this setting in my docker image.Thanks! Andreas
go to post Andreas Schneider · Dec 31, 2021 New SQL DATA LENS release 3.02 is out! Download here Driver of InterSystems IRIS 2021.2.0.617 is included. With that you can evaluate the new LOAD DATA command.Details about what is new?
go to post Andreas Schneider · Dec 30, 2021 Thank you for the suggestions!My problem seemed to consist of at least two parts1. There are characters in the files that LOAD DATA can not process2. LOAD DATA is currently terminated with an error even in case of success.I think it would be a helpful enhancement for the LOAD DATA feature if erroneous lines e.g. would be redirected to a textfile for later analysis.Maybe an option for 2022.2
go to post Andreas Schneider · Dec 30, 2021 Thanks! I have made the changes you suggested and I could load all rows. My encoding problem is also gone with the JVM Param The LOAD DATA statement still finish with error SQLCODE: <-400>:<Fatal error occurred>] ... *%qparsets>] but the data are there, but you have pointed out that this problem will be solved in version 2022.1.0
go to post Andreas Schneider · Apr 10, 2021 Attention, I am now advertising on my own behalf ;-)You can do that very easily with Caché Monitor Caché Monitor connect via TCP to Caché\IRIS (like the ODBC driver).Andreas
go to post Andreas Schneider · Mar 10, 2017 David thanks for detailed post! I've question about "When the Caché Spark connector is released, Spark-based applications will be able to make full use of Caché as an open analytics platform".Did you have any details about plans from Intersystems to develop a "Caché Spark connector"? Links about that? Thanks!Andreas
go to post Andreas Schneider · Mar 6, 2017 I'll created a fork on github (https://github.com/andreas5588/zeppelin) for Apache Zeppelin. My plan is to create a Caché Interpreter (first JDBC based) to learn and unterstand the architecture of Zeppelin.After this it would be great to extend this Interpreter to allow to query the Caché Data via COS. For this I'll contact the "Caché Web Terminal" guys maybe they can help...All are very welcome support this open source Interpreter. So feel free to jump in and support this project by coding, idea, testing ... or what ever ;-)
go to post Andreas Schneider · Feb 28, 2017 Thanks Benjamin!Yes I've checked the sourcecode to see how a interpreter is done. It looks not like rocket science.. probably I've not completely understand the details, so I can say that ;-)But! ... I have no idea which functionality would be helpful in an more advanced Caché interpreter. Can you give me a hint on what features do you think, please?It should be very easy to implement something like a simple code completion with Caché Keywords to use in a notebook. But at this time I think all is limited to the JDBC interface, and with that to SQL.Would be really great if we could use also COS to fetch data... !?
go to post Andreas Schneider · Nov 25, 2016 Take a look at CREATE DATABASEFROM the Docs: The CREATE DATABASE command creates a namespace and two associated databases. This allows you to create a namespace within SQL.http://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=RSQL_createdatabase
go to post Andreas Schneider · Nov 25, 2016 I think also like Michael that this is an issue related to the data.Maybe you can delimit this beavior to the caused column by execute your SQL statement with only one column at a time to test the columns one by one.Like"SELECT Name FROM ZenCrm.OAdress" -> works?"SELECT Type FROM ZenCrm.OAdress" -> works?and so on.