Rocket® U2 | UniVerse & UniData®

What uniquery syntax will roll up the third column into an unduped list for each unduped item in the second column, all while suppressing display of the first column. Note that the second column also contains values such as L2, L3, etc.------------------------------Shawn Waldieenterprise application developerRocket Forum Shared AccountLos Angeles CA US------------------------------

Trying to understand how the login process works on Windows when we use Accuterm and telnet to the Universe server. One of our users gets this message: Welcome to the Rocket U2 UniVerse Telnet Server.Enter user name: hrs\\BOBEnter password:This directory is not set up for uniVerse.Would you like to set it up (Y/N)? Our other users can login to the database just fine. All users should be connecting to the single Universe directory we have on the server. What directory is this BOB user trying to connect to? How do we get this user to connect to the Universe directory?  ------------------------------Gil SteidleDEVDDI System Incbrick NJ US------------------------------

Many years ago we changed our web-based software to support prompts, menu items, and help to support multiple languages. We did that by using a number for the prompt like 2300 was "Customer Name". Depending on the language you would go to the matching language file to translate the 2300 number to "Nombre cliente" for Spanish and "Nom du client" in French for example. In the 18 years we have demoed this to United States-based companies nobody expressed any interest until last week. This  client would like to have code files like  Code A1 equals Apple or Pomme in Spanish Code Z1 equals Avacado or Avocat in Spanish Our Universe database has a file called Fruits in this example. So my questions for those who have done this are: Do you add a field for every language? Do you add a multivalue field for every language? Do you change the value in the file to a number and translate it to a language field? Do you add a file called Fruit_ES for Spanish? Depending on the method chosen, how does

Here is a record sample: The TESTING column is a multi-valued list, and the pipes represent actual SVMs for readability. I'm looking for a function that will return an associated boolean list indicating whether or not either '1400' or '9101' exists in TESTING, so... In this sample, if one is present so is the other, but that's not always the case. So a 1 should be returned if either exists in what is actually a subvalued list. EDIT 1: A subroutine would make this very easy, I know, but I don't have time for the administrative overhead that comes with developing/delivering one to PROD, so I need this to be "idescriptor" language. Also, there will be subsequent processing, based on a SUM() of the Y/N list for each record, which will be compared to DCOUNT(TESTING,@VM). EDIT 2: I think I found a solution. I didn't realize I could use the INDEX function on lists. Though it will require another step or 2 to get the final result, I think it will work.

Hi, Has anyone experienced executing a Phantom job in Unidata 8.3 on a windows server. Then Sign-out of Server causing the Phantom Job to abort.------------------------------[Darren] [Johnson] [Australia][Snr Dev Engineer]------------------------------

Hi all I 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/bin:/usr/local/sbin:/usr/sbin:/usr/uv/bin >SH -c "uv -version" UniVerse 14.1.0 When using uopy: cmd = uopy.Command() suffix = " " cmd.command_text = 'SH -c "echo $PATH"' cmd.run() print(f'{cmd.command_text} = {cmd.response.removesuffix(suffix)}') cmd.command_text = 'SH -c "uv -version"' cmd.run() print(f'{cmd.command_text} = {cmd.response.removesuffix(suffix)}') The output is: SH -c "echo $PATH" = /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin SH -c "uv -version" = SH: line 1: uv: command not found What's the issue with the uopy connection having an incomplete PATH value?

The Rocket® MV team is pleased to announce the release of Rocket UniVerse 14.1.1 on June 26th, 2024.  Rocket UniVerse 14.1.1 builds upon functionality implemented in version 11.4.1 and 12.2.1, making it the upgrade and modernization path for all customers on all prior versions. UniVerse 14 ensures business continuity and helps you manage your replication environment effectively with key HA/DR features. Replication is faster and more flexible with Field-Level Updates, since the entire record is no longer transmitted during updates, only the individual field that was modified is replicated - significantly improving performance! Facilitate Replication recovery with the uv_repadmin skip option which allows you to skip an incomplete transaction that has caused replication to stop processing. By using the skip option, administrators keep Replication processing and avoid log build-up and the eventual reset and refresh of Replication due to a stalled group. Facilitate Replication recovery wi

I am running AIX and ksh.  At the AIX prompt, I have: AIX $ which matches the value for PS1    PS1='AIX $ ' when I issue the SH command from Universe,  I get to the host system.  I can issue AIX commands (without issue I think)However,  the Prompt is NOT displayed.  It is just blank The shells are linked together: $ ls -al | grep 326868 # -r-xr-xr-x    5 bin      bin          326868 Sep 12 2023  ksh# -r-xr-xr-x    5 bin      bin          326868 Sep 12 2023  psh# -r-xr-xr-x    5 bin      bin          326868 Sep 12 2023  rksh# -r-xr-xr-x    5 bin      bin          326868 Sep 12 2023  sh# -r-xr-xr-x    5 bin      bin          326868 Sep 12 2023  tsh Does some configuration option ne

Hi, We recently encountered a data file corruption on key files. This was causing our app to fail. Does anyone in the forum have knowledge of any tools that will send email alerts once a new entry is logged into the \\U2\\unidata\\bin\\udt.errlog. Thanks in advance for recommendations. ------------------------------[Darren] [Johnson] [Australia][Snr Dev Engineer]------------------------------

Using a BASIC program, I need to read filenames and file dates from an AIX directory and compare them with names and dates held in UniVerse records. If the files are present among the UniVerse records then they need to be moved out of the directory and more files added from another directory. Any advice or code snippets much appreciated.

Could someone explain why these messages appear and the shell window closes when I use Ctrl-C and then option D while running a Unibasic program? ------------------------------Mark MartinNARocket Forum Shared Account------------------------------

We upgraded our development server to Universe 11.3.4 and one of my programmers wants to work with Basic Profiling, in particular the bpf program. Where do we find it? I had understood that it was available on this version, but it's not in $UVHOME\\bin.------------------------------Phillip PotterV.P. R&DData Management Associates Inc DMACincinnati OH US------------------------------

We use @USER0 for an application-level constant.  We set it in the LOGIN paragraph & it should remain constant. I've seen it sometimes - but not always  - get set to 0 after/while? I've used/exited(?)/re-entered(?) RAID.  I haven't pinned down what triggers  it. Ironically, the reassuring thing is that RAID is disgustingly buggy.  I've had problems in RAID that don't happen when real users run things for real.  So it's probably ok in production.  Probably. Anyone else seen something like this?------------------------------Chuck StevensonDBA / SW DeveloperPomeroyUS------------------------------

The Rocket MV team is pleased to announce the release of Rocket UniData 8.3.2 and Rocket MultiValue Performance Experience (MVX: Performance) 1.10 on April 25th, 2024. UniData 8.3.2 is the first UniData release certified with the Rocket MultiValue Performance Experience (MVX: Performance) 1.10, which is available for our customers on maintenance. MVX: Performance monitors the performance of your UniData server and provides DBAs or developers with a better way to track down issues. It determines the root cause of issues, including the server, the operating system, the hardware, or a combination. DBAs can easily receive alerts when over 40 performance monitoring events occur, so constant monitoring is not required.  In addition, UniData 8.3.2 and MVX: Performance 1.10 provide you with an enhanced replication experience, bolstering High Availability and Disaster Recovery (HA/DR) capabilities. UniData 8.3.2 extends the security features introduced in UniData 8.3.1, which included: Enhance

For a conversion project at a customer with 4000 custom programs written over 30 years we're trying to get a handle on which programs are actively used.  One idea that's been floated is running a monitoring program as root from the demo account that does the pseudo code below. By definition we'll be running this in production for a month or three, and there's some justified nervousness about any potential performance impacts.  I don't think the monitoring program will be a performance hog itself, but not sure if doing PORT.STATUS on the probed program has any effect - does it "pause" the probed program so the stack collected is consistent for example?  We're not expecting to get 100% coverage from this, but even 80% would be a huge help. Anyone ever done something like this for real?  Any war stories or hard-won words of wisdom to share?  Thanks for reading! LOOP EXECUTE 'LISTUSER' LOOP FOR EACH ROW IN LISTUSER RUN "PORT.STATUS PID <ROW.PID> CALL.

Hello, Our apps are written in SB+ which use a cached opened files, in named common block SBPLUS & SBFILES, of 30 + 750 = 780 filevars (result of OPEN file TO filevar from BASIC). Some of our app's files are indexed, dynamic or distributed.  It means, with 780 cached filevars, we open more than 1000 os file.  With release 11.x we are used to set MFILES 3000 without never a trouble.  Now r12, r14 introduce SESSION_NFILES limit. Which is session's ActiveFileTable instance. SESSION_NFILES is not defined in uvconfig. CONFIG ALL report SESSION_NFILES = 800 ; aka. MFILES x 4) Then, at basic runtime we encounter OPEN file to fv ELSE CRT STATUS() =  -25 which is Exceeded SESSION_NFILES file table resource.  I try to push MFILES from 200 to 300 or set SESSION_NFILES to 2000 in uvconfig ...  - uvregen accept it  - at uv -admin -start I get  StartService failed (1068)  minidumpexception* Unhandled Exception raised at address 0xE7261759 : Acces

I would like to obtain the workstation hostname when a user logs into a Linux system.  I had it available on our Solaris Unix server but not on our RHEL8 server.  We use this to identify a physical location and to associate network printers nearby.  I am able to get the workstation hostname when in Citrix and by using Accuterm and checking a Session clientname but it is not always present when directly on the network and wondered if it was somewhere else Available to Accuterm.  Where can I found out the PC workstation hostname and what other windows information like this might be available to harvest? 0097:             * Check for citrix environmental variable CLIENTNAME0098:             SCRIPT = 'InitSession.Output Environ("CLIENTNAME") & vbCR'0099:             CRT CHAR(27):CHAR(2):'P':SCRIPT:CHAR(13): ; INPUT CLIENTNAME: ;  IF CLIENTNAME # '' THEN CRT "<-ClientNam

hello,  Under UV r14, these 2 uvconfig GLM_MEM_ALLOC / N_GLM_SELF_BUCKET are documented as :  GLM_MEM_ALLOC - The number of lock nodes allocated for each memory request. This parameter is highly application dependent. if the application requires a large number of locks in one transaction, this setting should be increased to the maximum number of locks per transaction * 2.  N_GLM_SELF_BUCKET - The number of hash buckets for the per-process locking table. This parameter is highly application dependent, If the application requires a large number of locks in one transaction (more than 20), you should increase this setting to the closest prime number to the maximum number of locks per transaction.  So, they are delivered  GLM_MEM_ALLOC 10 N_GLM_SELF_BUCKET 23 So, I try to set locks with READU and I have no problem to set 30'000 locks in one basic loop !  Are they not used if SYSTEM_BUFFER = 0 ?  Thanks for any explain. manu

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------------------------------

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------------------------------

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

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------------------------------

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

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?