go to post Robert Cemper · Aug 16, 2020 @Dmitry Maslennikov Thanks for the excellent example! The only addon: C/E code has to be separated from IRIS code. (Not really a challenge)
go to post Robert Cemper · Aug 15, 2020 Did you consider to run that single app on IRIS and connect to your Caché over ECP ?It works in both directions.
go to post Robert Cemper · Aug 13, 2020 Finally a serious follower to the FeatureMap we have seen last on C/E 2015.2 https://cedocs.intersystems.com/ens20152/csp/docbook/featuremapCache.csp
go to post Robert Cemper · Aug 13, 2020 newSpeak [Orwell 1984} : ISOS - accepted . or ISCOS ? pls. not IOS !! Not that I used BASIC more than for a quick 5 line demo. It is still visible in Studio. the most remarkable feature: it compiles directly to .obj code without touchable intermediate code (.INT)
go to post Robert Cemper · Aug 13, 2020 @Yuri Marx Thanks for the quick improvement!Question:Is it possible to have some link behind the boxes ?What I have in mind is a fast directory into Documentation, Subjects in DC, Learning & Training, ...If all 3 three (or more) have it in common as a starting point,then search for help and information could become quite easier.
go to post Robert Cemper · Aug 12, 2020 A nice colored table but I miss almost all internal used languages: COS is hidden as "Obs", BUT: No BASIC, NO MultiValue, No HTML, No T-SQL / ISQL, no sign of any kind of Networking Also, Globals as THE core store technology seems to be lost.
go to post Robert Cemper · Aug 11, 2020 You are right.but if the docs were that clear and resistant to misinterpretation,this forum would be rather poor. your question helps others to understand. keep asking!
go to post Robert Cemper · Aug 11, 2020 The gateway server is mainly taking care of Logging and tracing using 53773 as a backward link.So your network experts are right.
go to post Robert Cemper · Aug 11, 2020 Exactly! here is the example Defining a JDBC Connection URL jdbc:IRIS://<host>:<port>/<namespace> where the parameters are defined as follows: host — IP address or Fully Qualified Domain Name (FQDN). For example, both 127.0.0.1 and localhost indicate the local machine. port — TCP port number on which the InterSystems IRIS SuperServer is listening. The default is 51773 (or the first available number higher than that if more than one instance of InterSystems IRIS is installed — see DefaultPort in the Configuration Parameter File Reference). namespace — InterSystems IRIS namespace to be accessed.
go to post Robert Cemper · Aug 11, 2020 AHH! that sounds quite different. First is your super server port really 53773 ?Default is 51773. While 53773 might be a gateway port for reverse connection. you can check in SMP System > Configuration > Memory and Startup Otherwise I suspect telnet as a protocol might be blocked by some firewall by principle.from a terminal prompt in IRIS you might try this: USER>set tcp="|TCP|7000"USER>open tcp:(:7000) use tcp read req#15 So you create a TCP listener on port 7000 hanging aroundThen try to connect from an external server by telnet to port 7000 on your server As soon as you send 15 or more characters the READ will complete and you see the content in variable req As you describe I assume this will fail. Indicating that some firewalls or similar blocks access.Most likely the port is blocked. In addition netstat -a from system prompt or user>$netstat -a from IRIS terminal shows ALL listeners on your system
go to post Robert Cemper · Aug 11, 2020 It's not clear to me what you try: "..so customers can connect to IRIS remotely using JDBC and not ODBC...." So they need the related Java-Libraries to connect. see Establishing JDBC Connections While the setting in your jpg. relate to the SQL-JDBC Gateway that allows access to other DBs over JDBC.You have also a JAVA gateway to run java out of IRIS See Using the Java Gateway.
go to post Robert Cemper · Aug 7, 2020 That's a general problem of a web interface like this.You start a query but it isn't finished before your fall into a browser timeout. An easy workaround: Start a terminal session (terminals don't know about timeout)and from prompt run SQl.Shell or for a multi-line statement just start with an empty line and run with GO It will wait forever until completed
go to post Robert Cemper · Aug 5, 2020 I'm not aware that this is available at SQL / DDL level You can set the default collation for all globals in a database. or specific for an individual global before using it. The available collations have to be added here
go to post Robert Cemper · Aug 3, 2020 https://cedocs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=RSQL_INSERTORUPDATEThe article is pretty explicit on the issues of IDkey.
go to post Robert Cemper · Aug 3, 2020 I see 4 critical points to check: if customerID is autogenerated or calculated you can't insert to it or update it if customerName has some constraints like UNIQUE or fails some other formal checking if the (existing) record is locked by some application running in parallel if some access rights block you
go to post Robert Cemper · Aug 3, 2020 what you are looking for is called global indirection https://docs.intersystems.com/iris20201/csp/docbook/DocBook.UI.Page.cls?KEY=GGBL_using#GGBL_using_indirect set myglobal="^A"write $d(@myglobal@(12))write @myglobal@(12,sub2) and so on
