go to post Robert Cemper · Jun 12, 2018 Marco you are RIGHT !The example is just wrong! And never got fixed.Instead of set status = adapter.%Open("R")it should be set status = adapter.Open("R")This are 2 differnet methods with total different incompatible parameters. method Open(mode As %String = "", timeout As %Integer = 0) as %Statusfinal classmethod %Open(soid As %ObjectIdentity, concurrency As %Integer, ByRef sc As %Status = $$$OK) as %ObjectHandleit is good practice to close the file after use by do adapter.Close()
go to post Robert Cemper · Jun 12, 2018 In this case, I'd suggest to contact WRC for help.SMSS seems to select the wrong DSN.
go to post Robert Cemper · Jun 12, 2018 I personally deeply distrust all products from Microsoft and their management toolsBUT:If your Caché is installed on a 64bit Windows you also need to use 64bit ODBC drivers.Removing the 32bit DSN for Caché might solve your issue.As your screenshot says (in German) you can do this only with a 32bit ODBC administrator tool.
go to post Robert Cemper · Jun 12, 2018 I had the same experience.I moved it to "Later" to get it out of sight.
go to post Robert Cemper · Jun 11, 2018 You verified the error message of the original question. This doesn't work.<LIST>%open+3^%stream.You could try to apply the ACCEPTED ANSWER
go to post Robert Cemper · Jun 11, 2018 #1) thanks for the Reminder on IRIS#1) + #2) concentrate on finding. but that's not the key issues.As an example: The problem becomes visible when you run SELECT TOP 10 ArtNr,DescDE FROM Dc.Article WHERE DescDE %Startswith 'BE' ORDER by DescDE The problem is to get control of ORDER which depends on global collation.Example for German:- With Standard collation, you sort A,B,C..,O,...,U,...Z,Ä,Ö,Ü... (classic ANSI sort)- With collation German3, you sort A,Ä,B,C,....O,Ö,....U,Ü,....Z It is mostly the handling of characters with diacritical signs.Hungarian is my worst case with much more diacriticals AND groups of characters in total 44 "character" tokensA Á B C Cs D Dz Dzs E É F G Gy H I Í J K L Ly M N Ny O Ó Ö Ő P Q R S Sz T Ty U Ú Ü Ű V W X Y Z ZsIf you do it correctly then Cx sorts before Cs and Gz should sort before Gy and so on.Now for ORDER BY you typically get your default collation derived from NLS settings.#3) custom index seems to offer the most promising features.
go to post Robert Cemper · Jun 11, 2018 I will publish the actual workaround here later when there are other solutions or proposalsin order not to influence your creativity.########################################################################
go to post Robert Cemper · Jun 10, 2018 on behalf of @pmkadow@gmail.com .You find the examples and tables here
go to post Robert Cemper · Jun 10, 2018 the only thing which i have done was installing some windows updateThis was enough to confuse Eclipse.Run Updates for Glassfish and/ or Eclipse inside Eclipse and the setup is updated.
go to post Robert Cemper · Jun 2, 2018 Clayton,I agree with you, especially for fast inserting multi-server environments.In "slow" environments there is less risk.It depends on where you set your timestamp. So %OnBeforeSave might provide the smallest possible gap.
go to post Robert Cemper · May 30, 2018 Fabian,this is a conceptual issue. If there is no ACCEPTED answer it shows up as UNanswered.- no further comment from my side - while NO answer has really no ANSWER type reply
go to post Robert Cemper · May 29, 2018 I was unsure if I counted all separators right.but if you got it from Message Viewer it should be correct.did you verify you really got the message in hands? eg, by a TRACE or similar ?
go to post Robert Cemper · May 29, 2018 Assuming your separators are |~^&and if I counted correctly than FT1:16.... is empty but FT1:17.4.2 is 06CL
