Rocket MultiValue

I am indexing a 21,000,000 record file on the invoice date.  It is a single value field, and when I build the index it works correctly based on the records in the file at the time of the build.  After that, new records or changed records are NOT added to the index. Is there a setting related to indexing that must be set to auto update the index? I have read all the UniData documentation on indexing that I can find. I have been using indexes in other versions of Pick for decades and this is the first time I have hit this problem.------------------------------Bob LislePresidentInformation Technology SystemsDallas TX US------------------------------

In AccuTerm Tools Tab -> Settings -> Connection -> Secure Shell there is an option for Authentication -> public key In the Private key submenu, there are several options to find the private key. I don't see any outside authenticators such as  ssh-agent and/or pageant.  Can AccuTerm be configured to use one of these ? Windows now provides ssh-agent. Pageant has become a defacto standard for this.

We have a multi-valued field that is being exploded for a sort. The dictionary item calls a program to convert the value. When we were on D3, this worked correctly. When we moved to Jbase, the sort failed. It seems to only sort on the first multi-value of each record selected. The program call was originally in <8> of the dict item. Another developer moved it to <7> after the issue was discovered. That worked fine for a while as the order of the original format sorted very close to the sort of the updated format. However, additional changes have been made that now make it obviously incorrect. <8> is the proper location for this call. The subroutine being called does use a few ACCESS references. At first I thought it might be something there, but it does do the conversion correctly. So the outputted data is correct with its format, but the sort result is wrong. Stumped.------------------------------Chris RazzanoSenior PICK programmerHouston's Inc-----------------------

I noticed that when I executed two select statements in a basic program, the 2nd one does NOT utilize the results from the first one: CMD1='SELECT FILE WITH ATTR1 EQ "Y"'' EXECUTE CMD1 CMD2-'SORT FILE F1 F2 F3 F4' EXECUTE CMD2 But, if I combine them it works: MULTI.CMD=CMD1:@AM:CMD2 EXECUTE MULTI.CMD Problem: is there a way to keep the 2nd command from running if the CMD1 finds 0 records? ------------------------------Nelson SchrothpresidentC3CompleteShop LLCHarrison OH US------------------------------

Hi Guys, According to the manual the D3 -d command  -d data.arg Stacks data for the process once it is activated. The data argument specified is any string that contains displayable characters and commands prefixed by a backslash. The D3 implementation is Linux (Redhat) 10.3x I run this code in Linux and I can see the entries in the TCL stacker: Please just ignore the commented out lines.  RESCMD = "!d3 -500 -d -' \\r\\r\\r\\rdm\\rdm\\rxxxxxx\\r"       RESCMD = RESCMD:"\\rt-det 5 (uz\\rt-select 5\\rt-rew\\rt-rew\\r" *      RESCMD = RESCMD:"\\rlistfiles \\r"       RESCMD = RESCMD:"\\r\\r\\rt-det\\r\\rsleep 1\\r\\rexit\\r\\r'"       EXECUTE RESCMD * *      DELCMD = "!d3 -500 -d -' \\r\\r\\r\\rdm\\rdm\\rdxxxxxx\\r" *      DELCMD = DELCMD:"\\r\\r\\rt-det\\r\\rtime\\r\\rexit\\r\\r'" *      execute delcmd * *      execute delcmd * *      RESCMD = "!d3 -500 -d -' \\r\\r\\r\\rdm\\rdm\\rdxxxxxx\\r" *      RESCMD = RESCMD:"\\rt-det 5 (uz\\rt-select 5\\rt-rew\\rt-rew\\r" *      RESCMD

hello, So, Universe >= r12 use the same lock system like Udt, I'm looking to deeply understand/tune it. For admin & troubleshooting, there is a tool uvglm_tool / glm_tool  and uvulc_tool / ulc_tool, but they are not documented or I do not found any docs about it nor in Unidata docs.    Is there anyone who have details about it ? How to read the info, use it ? Perhaps docs/pdf/ppt/whitepaper/KB/...  from U2University conferences in the past ?  I thank you by advance. ------------------------------Manu Fernandes------------------------------

Are there any examples written in Flask or other tool that uses REST tocommunicate with Universe using MVIS to do data entry? A customerdemographics app for example. What is a good design pattern to support thesession and record locking?Thanks

Hi, can someone help me?   I have 2 D3 windows servers with the same version.  I used to have a super q-pointer on the second server pointing to an account on the first server.  The q-pointer was deleted when i freed up vme space.  I can't remember the format needed for the super q-pointer.  I also can't find the document that i previously read to setup this.   Thanks!

Our ERP system utilizes UniVerse and I'd like to train some our support team members to become UniVerse Administrators. Is there a Rocket program or Contact I can reach out to for assistance?  ------------------------------Matthew WestDirector of Software DevelopmentIntegrated Supply Network IncLakeland FL US------------------------------

Every time my [Windows 11 pro] PC is rebooted the "Unidata Database Service 8.2" and the "Unidata Telnet Service 8.2" are both Disabled and have to be re-enabled and then re-started via the Services window. It's funny but the "Uni RPC Service" is not affected. Probably unrelated, or perhaps a clue; When rebooting [the PC], all of my stored logon IDs are gone and have to be re-entered.------------------------------Kevin HondMr.Self RegisteredKingsport TN US------------------------------

We have a file that is used to find customers via a name & address formatted "matchcode".  This matchcode file has an index for customer number, as it has 38M entries.  For example: MATCHCODE:     4537100110WSTLM00000BSHT0001 599386130002 58926904 Often, there are more than one customer number (attributed) associated with a matchcode as shown in this example.  It seems that only <1> is indexed and not the others (.  Is this a function of how UniVerse indexes, or the dictionary value used or is it a function of how the index was created? >LIST-INDEX MATCHCODE ALL Alternate Key Index Summary for file MATCHCODE File........... MATCHCODE Indices........ 1 (0 A-type, 0 C-type, 1 D-type, 0 I-type, 0 SQL, 0 S-type) Index Updates.. Enabled, No updates pending   Index name      Type  Build          Nulls  In DICT  S/M  Just Unique Field num/I-type CUST.NUM         D       Not Reqd  Yes    Yes            S        L       N            1 DICT MATCHCODE    09:50:32am  10 Jul 2024  Pag

Hello, I am trying to integrate a webhook from a third party company in Universe 11.3 on IBM AIX.  The third party company asked for a URL to send their messages and I thought I would be able to build this through RESTful Web Services developer and a Unibasic subroutine.  I  setup an input parameter and hoped it would contain the return data, but that did not work and the parameter was not being populated. Is the RESTful Web Services the best tool for this?  If so, how can I parse the return message (below) in my Unibasic subroutine, so I can update my database?  If not, any tools/ideas you can recommend? Thanks, Larry ------------------------------Lawrence RizzoConsultantLJR Technology Consulting LLCEast Amherst NY US------------------------------

We are upgrading from RHEL 7 to 8 to 9.  Then, we will need to upgrade UV 11.3.1 to 11.4.1. We are considering only going to RHEL 8, but UV 11.4.1 is certified for RHEL 9. Is anyone running UV 11.x on RHEL 9?  Any issues with it? 

Older D3 system running 10.2 Linux. After I loaded the latest patch, they started having System Halts, so I put them back to the original version of 10.2 However, when I recompiled all their BASIC programs, they came up with "0 frames used" for each one. What does this mean and how do I fix it. Their system is up and running, so I'm confused. Thanks. Fixed. Never mind. ------------------------------Richard GinsburgPresidentGinsburg ConsultingLeesburg VA US------------------------------

Hi, I have a routine that takes a data value, and then tries to determine what data type should be used when interfacing with other products (Excel in this case). The process I use is to (a) see if it is a number; then (b) ICONV the data value with various masks to see what is recognised. When I came to test standard QM format masks, I found that these got recognised as TIME values ... which I found surprising. For example: ICONV('8R', 'MT')  returns 28800  (8 hours)ICONV('8L', 'MT') returns 28800ICONV('8C', 'MT') returns 28800ICONV('12*R', 'MT') returns 43200 (12 hours)ICONV('12*R26', 'MT') returns 43226 (12 hours and 26 seconds) I question whether these are sensible return values for a time conversion. I could understand '8H' being returned as 28800, but not '8R', '8L', or '8C', and certainly not something like '12*R26'. i don't look at any of those values and think - that is a TIME value! Can someone from Rocket comment on this? QM 4.0.9 / Windows. Testing on QM 4.0.7 / Windows give

I have this old memory that there is a way to install a subroutine or some program in SB+ 5.x that will allow passwords to be evaluated for length, content, complexity, etc.  I can't find any reference to it in any of the documentation; does anyone remember this or is this a faulty memory?

hi everybody. A strange behavior we do not understand. on a UV/windows / 11.3.5 we have python 3.11  (the one within uv/python - no other python is installed on the machine)  We  use module 'pandas'  in our script, release 2.2.2 is installed.  When executed from osshell, no problem : dos /c "python path/script.py"  When executed from uv/python, from pyCallFunction() or from TCL >PYTHON then import pandas we get this  DLL load failed while importing aggregations: The specified module could not be found.we do not understand what's wrong with the deploy.... What is the difference between a osshelled python call and a uv's python's one ? any idea ?  Many thanks for any advice  Manu 

Hello, Accuterm 7.3.  This is probably a Windows 10 Pro (on a VM accessed via RDP) issue but it involves running Accuterm scripts.  This is Linux D3 via SSH. I have an scott.atsc file that does the D3 Linux login/logon for me and starts my scott.atcf session. When I double-click on that directly, all is good.... works from the desktop short-cut, and also from "C:\\Program Files (x86)\\Atwin71\\scott.atcf", and from "Scott Ballinger > Documents > scott.atsc"  (I copied the .atcf and .atsc files from "C:\\Program Files (x86)\\Atwin71\\" to "Scott Ballinger > Documents", although who knows where the "Desktop" or "Documents" folders actually are in the Windows "one-drive" universe (as in internet file-space, not UV)  anyway? So I dragged-and-dropped the desktop shortcut to the task bar and "pinned" it there. Now when I right-click on the taskbar AT icon I get a list of all the .atsc and atcf files I have ever touched.  If I pick the one on top (scott.atsc)  or the "recent" one, ev

Any one using the Windows ReFS file system for either UniData or UniVerse? What's your experience performance wise?------------------------------Christian BristowTSERocket Software IncWaltham MA US------------------------------

Hi Guys,I've got a weird issue affecting a couple of my users.The users all use SB Client V6.3.1 and login to the GUI interface, where they have access to SB + menus and have the facility to create their own User Menu, they typically put their "FAVORITES" that appears as a "window" on the left hand side of their main screen, which should look similar to this, dependant on what the user has added to the menuHowever this is what the users are seeingas you can see from the above the TEXT for the menu does not display correctly, at the point of logging on the text and menu structure is momentarily displayed.A full removal and re-install of SB Client doe not resolve the problem, nor does right clicking the the menu to Change FONT or any of the other items on this menuHas anyone else seen this problem and if so what is the work-around / fix please ??ThanksAndy

Just a heads up for anyone (like me !) who is not aware. Recent versions of D3 contain Accumath extended precision functions already loaded. I think in the distant past this package was an add-on, but now all the Basic callable functions are in dm,bp, or available directly as user exists. Using Accumath you can easily achieve the 15-16 digit precision of a Java double, or the higher precision of a BigDecimal. Seems to all work remarkable well.------------------------------Bryan Buchanan------------------------------

Rocket MultiValue Integration Server (MVIS) 2.1.0, available today, is a major release with significant new features and enhancements. To learn more about MVIS 2.1, please plan to join us on September 4th, for a product launch webinar. MVIS 2.1 Features and Highlights Power Modernization via the OpenAPI Standard OpenAPI 3.0 Support. OpenAPI 3.0 is the first major release since 2015, when Swagger was adopted as an open standard and transitioned to the OpenAPI Initiative. The 3.0 spec includes numerous changes including a simplified structure for increased reusability. You can find additional details in this blog post https://swagger.io/blog/news/whats-new-in-openapi-3-0/ Enhanced Integration with OpenAPI. In MVIS 1.3, we introduced the notion of Vanity URLs that provide limited support for top-down scenarios. Support for top-down APIs assumes an API developer uses the OpenAPI standard to define an API with full control of the API endpoints as well as a rich typing system based on JSON

Rocket MultiValue Integration Server (MVIS) 2.1.0, available today, is a major release with significant new features and enhancements. To learn more about MVIS 2.1, please plan to join us on September 4th, for a product launch webinar. MVIS 2.1 Features and Highlights Power Modernization via the OpenAPI Standard OpenAPI 3.0 Support. OpenAPI 3.0 is the first major release since 2015, when Swagger was adopted as an open standard and transitioned to the OpenAPI Initiative. The 3.0 spec includes numerous changes including a simplified structure for increased reusability. You can find additional details in this blog post https://swagger.io/blog/news/whats-new-in-openapi-3-0/ Enhanced Integration with OpenAPI. In MVIS 1.3, we introduced the notion of Vanity URLs that provide limited support for top-down scenarios. Support for top-down APIs assumes an API developer uses the OpenAPI standard to define an API with full control of the API endpoints as well as a rich typing system based on JSON

MultiValue Integration Server version 2.1.0 has been released on July 02 2024 for the below platforms/versions:AIX POWER       7.2AlmaLinux       8Amazon Linux       2CentOS       8Oracle Enterprise Linux x86       8RedHat Enterprise Linux Intel       8Rocky Linux       8SuSE Linux Enterprise Server Intel       11.0,  12.0,  15.0Windows       Windows 10,  Windows 11,  2016,  2019,  2022This product is available to order immediately via your Rocket software provider or by logging into your RBC account at https://rbc.rocketsoftware.com or https://rbcint.rocketsoftware.com.Additional Product Information is available on the Product Availability Matrix at https://rbc.rocketsoftware.com/matrix.asp or https://rbcint.rocketsoftware.com/matrix.aspFor any questions on product availability, please contact rbc@rocketsoftware.com.

Hi Rocket,  Can you tell us more about uv r14 ?  Regards------------------------------Manu Fernandes------------------------------