Rocket® U2 | UniVerse & UniData®

hi, May I introduce a suggestion to help the program runtime to check the type of a variable and not crash. There is already a function DESCRINFO(1,variable) which return the type of the variable ; so some type c.f. descrinfo() doc ref  on sellist, pyobject, udo, do, xdom, ... descrinfo() return -1 ...  I'll suggest to implement more descrinfo result value like 11=sellist, 12=pyobject, 13=udo, 14=do, 15=xdom, ... and by extension, if request_code = 2,  descrinfo return a DO with polymorph properties aka. metadata about the variable.  with kind regards------------------------------Manu Fernandes------------------------------

hi, when I try this : var = '' try var->$objecttype() catch e print 'error ':e->$tojson() endtry print 'finished' the error is not cached, the program terminate with echo bad self type: 2 and @SYSTEM.RETURN.CODE = -1  Same behavior with the $fromjson(), $tojson() ...  any idea ? ------------------------------Manu Fernandes------------------------------

on a READU the STATUS() function is returning the incorrect value for the userno if the record is locked but a phantom.  Instead of a negative number is returns the number without the minus sign.  Has this been addressed ? 0001:       OPEN '','INCIDENT' TO FILE THEN                                     0002:          READU X FROM FILE,'21333' LOCKED                                 0003:             PRINT STATUS()                                                0004:          END ELSE                                                         0005:          END                                                              0006:       END                                                                 0007: END                 ? LR                                                                           Account  File        UNO  PID   User       Record Id            Date  Time      -------------------- ---- ----- ---------- -------------------- --------------  KOPS     INCIDENT    -8   9324  

My customer, UniVerse 13.5, is running on Nashville Metro Government's internal cloud.  The network security is so restrictive that it is difficult to get work done for the customer.  I have requested information from the "mypickcloud" website but have received no response.  Does anyone know if that cloud still exists and if so how to contact them.  If they do not exist does anyone have recomendations on other clouds where UniVerse could reside?  I have looked at AWS website and am buffaloed by the complexity of their options.  I would simply want to move my customer's system and data to a cloud server for day-to-day operations. Dale

The python 'dict' object is ubiquitous when interacting with python modules, functions and classes. The process to create a python DICT object using the U2 BASIC Python API is, well, interesting: Create a LIST containing just the 'name' and 'value' for the DICT entry Create a TUPLE from the list Append the TUPLE to another LIST that will be used to create the DICT When the LIST of TUPLE objects is completed, create a DICT using the LIST of TUPLES This all works ok for strings and numbers, but I cannot get a boolean True or False value to use in the tuple. I either get an integer value of 1, or 'None'. This is the code I have tested so far, trying to get a python True object/value: ** Attempting to create a python True object using the PyBASIC API pmo.BUILTINS = PyImport("builtins")if len(@PYEXCEPTIONTYPE) then gosub PY.BADNESS * Using CallMethod to run the "bool(x)" commandtest1 = PyCallMethod( pmo.BUILTINS, "bool", (-1))rslt = PyCallMethod( pmo.BUILTINS, "print", 'test1', test1) *

Hi Expert, I am new to U2 and the EDA Schema Manager tool. I am trying to import data from U2 files into a SQL table using EDA. I have successfully created an ODBC DSN connection and installed the EDA. Additionally, I connected to the U2 server and can see the schema files. However, I am encountering issues with the EDA Source connection.  I correctly created the connection, but when I validated it, I received different error messages each time. Here are the error details: 1. EDA license not authorized.2. Map Schema __CURRENT_MAP_SCHEMA__ failed on lex check.3. Could not write the data source (Connection Name) on Server (U2Server). Could you please advise on the reasons for these errors? Is it a license issue, and if so, how do I obtain a license? Or could it be a configuration issue? I would appreciate your help. Thank you! ------------------------------Marimuthu kalyanasundaramMRRocket Forum Shared Account------------------------------

We are excited to announce the release of U2 Toolkit for .NET v2.2.3 on Thursday, December 16th. U2 Toolkit for .NET version 2.2.3 is a Provider release which provides a comprehensive ADO.NET provider, LINQ to Entity provider, and the native UniObjects for .NET API for the U2 databases. U2 Toolkit for .NET is optimized for connection performance to UniData or UniVerse. The U2 Toolkit for .NET Provider is a suite of data-access technologies that are included in the .NET Framework class libraries.U2Toolkit for .NET v2.2.3 enhancements include: Support for .NET Standard 2.0 making the U2 Toolkit for .NET Provider compatible with .NET Framework 4.8, .NET Core 3.0, and .NET 5 Support for Visual Studio 2019 providing support with for .NET Framework 4.6.1 and later Additionally, v2.2.3 includes 19 bug fixes as well as 3 other enhancements.U2 Toolkit for .NET is a free tool now available through Rocket Business Connect (RBC).  ------------------------------Christine RizzaMV Product ManagerR

I posted something similar to this in this thread: Rocket U2 | UniVerse & UniData Rocketsoftware remove preview Rocket U2 | UniVerse & UniData Hi allI have some problems when connecting to servers using uopy, as the PATH variable is wrong.From the terminal console:>SH -c "echo $PATH"/usr/local/bin:/usr View this on Rocketsoftware > I have a variable defined in /etc/environment: [hcortiguera@catalogo20 ~]$ cat /etc/environmentOPENAI_API_KEY=MY_API_KEY I can read it from command-line Python: [hcortiguera@catalogo20 ~]$ /u2/uv/python/bin/python3Python 3.9.2 (default, Jun 15 2021, 01:30:50)[GCC 4.8.5 20150623 (Red Hat 4.8.5-36)] on linuxType "help", "copyright", "credits" or "license" for more information.>>> import os>>> os.environ['OPENAI_API_KEY']'MY_API_KEY' But I can't read it when I call Python from BASIC NOMBRE.VAR.ENTORNO='OPENAI_API_KEY' NOMBRE.SCRIPT='consultaVariableEntorno'NOMBRE.FUNCION='get_var_entorno' RESPUEST

Hi, Does Unidata 8.3.1 or greater support TLS 1.3 protocol, I understand it support TLS 1.2. Thanks ------------------------------[Darren] [Johnson] [Australia][Snr Dev Engineer]------------------------------

While developing an app using OpenInsight for MV (in this case Universe) from Revelation Software Bob Carten at Revelation suggested using commuter modules to manage I Descriptors that use the SUBR call.  (Note that this approach can be used without Revelation - it just happens to be my first use-case).  To establish a convention, each MV table that uses a commuter has a subroutine in the program file that starts with "I_" for I Descriptor.  That way you can see all of these commuters grouped together when listing them.  In this example, the MV Table in Universe is called "BOOKABLE", so the commuter subroutine is named "I_BOOKABLE" and in this example we will be using the dictionary entry "DESCRIPTION" and these are the first 5 lines of that DICT: >ED DICT BOOKABLE DESCRIPTIONThis is a Type "I" Descriptor last compi20 lines long. ----: L50001: I0002: SUBR("I_BOOKABLE","DESCRIPTION")0003:0004:0005: 20L And this is the subroutine I_BOOKABLE SUBROUTINE I_BOOKABLE(RESULT,DICT_ID)*******

Looking for a solution/trick/etc... for the following scenario: We're running a UniVerse 10.1.22 application on AIX 5.3.0. But want to offload a certain module for real-time processing to a new Centos Stream server on a VMware platform running UniVerse 14.1.1. The plan is to have the "core " files needed  NFS mounted and exported to the other server. So that they are viewed as local files to UniVerse and the rest of the application. To move the data, I've been using rsync and planned  to continue using it to keep the Centos server data current, for my purposes it was very efficient. The problem is each time the data is synced, I have to perform a "fnuxi" on the data to perform the byte-swap. Any alternatives to doing this fnuxi each time data is synced ? Is there a certain File type I can use (Type 1 or 19) to avoid this ? Regards, Algis Zyle ------------------------------Al ZyleSenior PICK Developer/ConsultantRocket Forum Shared Account------------------------------

We are running UV11.3.1 ( Pick Format ) on AIX 7200-05-08-2420  Yesterday, we started getting reports from the call centers about user's sessions freezing up. Normally, our first thought when this happens is a record lock of some kind.  If we tried to log into the application, we got to the login prompt and were able to authenticate. But once we successfully entered our userid/password to get into the application the session would hang.  We create thousands of uniobjects connections to the DB throughout the day from our web sites and IVR, and these were timing out. Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.[IBM U2][UODOTNET - UNIRPC][ErrorCode=81009] The RPC failed UniVerse itself was running fine. I could start new sessions and as long as I stayed on the UV account ( bypassing the application log

I have a customer who is attempting to setup a Fedex machine, connecting it to Unidata to transfer data.  The same ODBC driver works perfectly on another system.  On this system, we get odd errors and I have zero clue how to research them. For example: DataSource.Error: ODBC: ERROR [SICOO] [Rocket U2][U2ODBC][1801668]Error ID:33 Severity: ERROR Facility: DBCAPERR - The UV/ODBC server or the underlyingdatabase do not provide the requested feature.Details:DataSourceKind=OdbcDataSourcePath=dsn=upsodbc This happened when attempting to retrieve data through the 32-bit ODBC connector using a 32-bit Excel.  It was able to authenticate and return a list of table names, but when attempting to view the fields inside of the tables, this was the error.

Universe 11.3.1 running on AIX We use a sequentil file (0 bytes) "FLAG FILE" to indicate when a remote system has completed the build of a data file on the primary system.  A program on the primary  system trys to open the file, and loops until it is found (and can then start processing). Since this 'FLAG FILE" is not in the VOC, I can OPENSEQ it just fine.  But, I have not successfully found a good way to delete it. Of couse, I can execute a Unix script that will "rm" it, but I would rather do it within the UniVerse Basic program if possible.  (A DELETESEQ would be a good command, but it does not exist.)  Suggestions?------------------------------Nelson SchrothpresidentC3CompleteShop LLCHarrison OH US------------------------------

Hi, I'm Chase. I'm a Technical Recruiter for a company called The Guitar Center. You may have heard of us, been to one of our stores, bought some awesome gear from us, etc.  We're hiring for a Senior Retail Applications Engineer on a full-time, W2 basis (salaried + full benefits). I'm including the link to the job description here.  If you're interested in exploring this, let's talk! Some of the must haves for the role are hands on experience with (Rocket D3, UniData, UniVerse, QM) and Pick Basic/UniBasic) programming. In sum, we're looking for engineers who have experience working with Multivalue technologies in both development and maintenance contexts.  Interested? Shoot me an email to chase.tenen@guitarcenter.com. I'm not a robot, here's my LinkedIn.------------------------------Chase TenenSenior Corporate Recruiter, Technology - The Guitar CenterRocket Forum Shared Account------------------------------

I have a problem with control characters in records. Particularly LF, CR and TAB. Is there a way to find records that contain them? LF messes with any statements I have tried in UniVerse SQL and TCL.------------------------------Greg ClitheroeRocket Forum Shared Account------------------------------

I'm attempting to use UCI with a CALL() statement to write a record in Universe, but my passed argument gets an "Invalid data type" during subroutine execution: ./sql -c 1 "CALL INTERCALL.LOG.COMMENT ('S2734042','1','MTAWEB','This is a test')"PRINT RESULTS:Program "OE.ADD.COMMENT": Line 81, Improper data type. The indicated line in the subroutine is simply a READV call with the second argument to the passed value:READV LED12 FROM LEDFILE,OID,12 ELSE LED12 = '' My called subroutine simply calls OE.ADD.COMMENT, reorienting the arguments.  After getting this error, I thought that perhaps calling ICONV or OCONV on the passed argument might help to convert it to an acceptable data type, but to no avail.  I also checked the values with PRINT and verified that the values are indeed getting passed (so another error didn't cause them to be NULL). The only thing I can think of at this point is that the arguments are tainted, and the use is restricted.------------------------------Tilghman Lesher

Hi, We are exploring the option of outsourcing our Unidata support and are looking for recommendations for reliable companies that specialize in this service. If you know of any companies with a strong track record in providing Unidata support, we'd greatly appreciate it if you could share their details. Thanks in advance for your help! MT------------------------------Minh TranRocket Forum Shared Account------------------------------

Is there a document somewhere that lists Unidata limitations?  i.e. longest TCL command line, maximum number of indexes, maximum memory per process, that sort of thing?

I recently upgraded a customer's UniVerse to 11.3.5 and am ready to install a new AccuTerm 8 server account.  I am unable to figure out how to create that ACCUTERM account.  I'm used to Unix and Linux menus to create an account but on winndows I cannot find such a menu or a "CREATE.ACCOUNT" verb in the UV VOC.  I vaugely remember a windows administration program, but can't remember it's name and don't know where to find it.  I tried copying the XDEMO account and entering an ACCUTERM item in the UV.accounts file but that didn't work.  Unless I can get the ACCUTERM account established, I'm afraid the server side of AccuTerm won't work. Dale

How does EDA handle a connected SQL database going offline - do records get queued up & resent once the SQL database comes back online? (assumption is that we have a universe publisher/subscriber setup with replication & EDA is connected to a universe subscriber node)------------------------------Mark MosbauerProject ManagerRocket Forum Shared Account------------------------------

This is very much related to another discussion I started, but I don't want to muddy the waters in that conversation so I'm starting this new one. I'm not certain, but I think this will pertain specifically to the HP/Troy printer we're using. The last line on the the page, which is a remittance advice with check at the bottom, is the MICR line that includes the check number, transit (routing) number, and account number. As a simple test I execute the following statement after setting the print queue: LIST PERSON \\  ID.SUP HDR.SUP COL.SUP COUNT.SUP \\  SAMPLE 1 \\  EVAL "CHAR(027):'(0Q':'C35353C A123456789A 87654321C'" \\  LPTR According to a Troy rep, embedding a 'C' and 'A', tells the printer to generate On-US  and Transit symbols, respectively. And though that's correct, it appears to also be introducing line-feeds (in odd positions no less), as here is a screenshot of the result: This would appear to be doing what I need except for those apparent line-feeds. Anyone have any sugg

Our company is running UniVerse 11.3.5.1002 on RHEL 7.8. We have been running this OS / UV combination for two years since migrating off Solaris. We are in the midst of an OS upgrade to RHEL 8.10 on our UV servers. Our strategy is to first run an in-place upgrade on a development machine. We've decided against creating a RHEL 8 server from scratch followed by the install of UV. After a certain amount of time running on the dev server, the plan is to upgrade the production servers in a similar fashion. Are there any special considerations or specific "gotchas" we should be aware of? I understand this is an ambiguous question without posting more details about our setup. Our SysAdmin group have had challenges upgrading a cloned server, but nothing related to the existence of a UV installation. By no means are we trying to get out of doing the work ourselves. The UV and SysAdmin groups are working together during our clone upgrades and subsequent server upgrades. We will be opening a supp

I am on a Universe system and it does not save the TCL command stack from session to session.  How do i turn that on and have it shared for a user over multiple sessions?  Also, what file is the stack saved in?

I'm happy to share the news of the release of AccuTerm 8.1.2.0. For more details on this latest version, check out the product availability matrix in Rocket Business Connect (RBC). Version 8.1.2 adds support for PRISM P30 and P9 terminal emulation to AccuTerm Web. This new feature allows customers run applications that rely on PRISM emulations on a web browser without the need to make costly and time-consuming application changes. AccuTerm 8.1.2 PLC dates: 3 Dec 2024 GA 3 Dec 2027 EOM 3 Dec 2028 EOS 3 Dec 2029 EOLS ------------------------------Hernando BordaProduct Manager, MultiValue ToolsRocket Softwarehborda@rocketsoftware.com------------------------------