Rocket MultiValue

Hi all, has anyone ever used the drill-down process in SBXA  Selection Process? (F6 Addit in /pd.s) I wonder how to return te selection from the called process to the main-screen where the initial-selction process was called and skip the initial-select.ExcampleF3 - Function on Field calls S.SELECT.ITEMS which selects some items and displays information. The goal is now to give the user the ability to change the displayed fields after the selection has taken place.I got to manage the call of another selection process in the F4 - drill-down slot (e.g. S.SELECT.ITEMS2) which works on the same select list, but after returning from S.SELECT.ITEMS.2 the user still is on S.SELECT.ITEMS instead of returning to the screen with the selected Item from S.SELECT.ITEMS2. I already tried to Set option S and option D  to Options in the called Selection-Process but no luck... Unfortunately i didn't found any documentation how to use the drill-down slot  best regards Thomas --------------------------

Has anyone had success using Git as a source control platform for UV accounts?  We're looking to do true source control (ex. developer branches merging changes into the main branch) and not just copy/pasting say BP's with changes using a simple folder structure. Thanks Steve------------------------------Steven SmithSoftware DeveloperRocket Forum Shared Account------------------------------

We would like to put a UniVerse account (all files, VOC, BP, CUSTOMER...) under source control, we use GIT currently for other software projects. Has anyone been able to successfully do this? Our strategy in our development account was to convert all files into folders (type 19). But the VOC file and Dictionary files (I-types) have problems with being a folder.  Is there a way to elegantly put all files in a UniVerse account under GIT source control management? Or are we just beating our heads against a wall? The closest we've come to success is when we created "mirrored" files for the VOC and Dictionaries that were folders and used light-weight triggers to update them when the production (hashed) files were updated. That worked fine and GIT saw changes in those mirror files. But we then ran into an issue with the GIT and the .gitinclude file configuration. We only want to the show changes in our mirrored files. GIT was adamant about showing differences in all files even the hashes fil

I'm attempting to adjust the pitch to 12 characters per inch so the invoice number (green box) will fit within the designated column: However, the output is not affected, and the HP printer just passes the code through as if it is text to be printed (yellow box). I'm using the following code with the intention of every subsequent print statement resulting in text that is 12 chars/in. X.ESC = CHAR(27)X.PCL.COMMAND = X.ESC:"(s12H"PRINT X.PCL.COMMAND Does anything need to be enabled on the printer (hp4350) for PCL commands to take effect? The printer in question will generate a PCL font list so I think that confirms the required software is present. Also, does every print statement have to include the escape sequence or can it just be invoked once and remain in effect until the page/job is finished? It's been 10+ years since I messed with this (at another site), but I don't recall having any trouble with it.------------------------------Shawn Waldieenterprise application developerRocket

We are seeing UniVerse (v11.3.1) write failures (on Windows 2019 64-bit server) when we repeatedly update a record. Here's the code we use to create this scenario: OPEN '', 'CF' TO FILE.CF ELSE STOP ID = 'TEST' FOR I = 1 TO 1000 READ REC FROM FILE.CF, ID ELSE REC = '' REC<-1> = I:' Iteration'  WRITE REC ON FILE.CF, ID NEXT I END The write failures will occur at random passes through the for/next loop. This particular file is type 19, but we also see failures on hashed files as well. Is there a UniVerse or Windows tunable setting that would help us out? Any other thoughts? ------------------------------Gil SteidleDEVDDI System Incbrick NJ US------------------------------

I had a report of deleting some records from MYFILE was taking longer than it should. Below is the result of ANALYZE.FILE and HASH.HELP.  Can anyone provide some thoughts or advice about the size of MYFILE?   ANALYZE.FILE MYFILE File name= MYFILE File type= 18 File style and revision                 = 64BIT Revision 12 Number of groups in file (modulo)= 2368289 Separation= 4 Number of records= 7225458 Number of physical bytes= 6209269760 Number of data bytes= 3505627456   Average number of records per group= 3.0509 Average number of bytes per group= 1480.2363 Minimum number of records in a group= 0 Maximum number of records in a group= 13   Average number of bytes per record= 485.1772 Minimum number of bytes in a record= 104 Maximum number of bytes in a record= 55112   Average number of fields per record= 110.6418 Minimum number of fields per record= 40 Maximum number of fields per record= 286   Groups   25%     50%     75%    100%    125%    150%    175%    200%  full       288853  5

Hi all I'm trying to make sense of the encoding of strings coming and going between Basic and Python. Our Universe database stores its data using OEM encoding, so to pass data to Python we do a series of transformations inside Basic to convert them to UTF-8. Now I want to pass this OEM strings, as they are, directly into Python and do the conversion there, but I'm having some trouble. ALL.CHAR.STR='' ALL.CHAR.STR=ALL.CHAR.STR:CHAR(1):CHAR(2):CHAR(3):CHAR(4):CHAR(5):CHAR(6):CHAR(7):CHAR(8):CHAR(9):CHAR(10):CHAR(11):CHAR(12):CHAR(13):CHAR(14):CHAR(15) * rest of characters... ALL.CHAR.STR=ALL.CHAR.STR:CHAR(241):CHAR(242):CHAR(243):CHAR(244):CHAR(245):CHAR(246):CHAR(247):CHAR(248):CHAR(249):CHAR(250):CHAR(251):CHAR(252):CHAR(253):CHAR(254):CHAR(255) RESPUESTA=PyCallFunction('encoding_test','test_encoding', ALL.CHAR.STR) On the Python side I'm doing this def test_encoding(universe_str: str) -> str: for c in universe_str: print(f'{ord(c)}') return 'OK' This prints t

Other than using the LIST.INDEX command to see if an Index build is required, are there any other tools available to determine if an Index is in-sync with the data file? We are getting false negative results using LIST.INDEX.  Example:  SELECT CUSTOMER WITH NAME = "SMITH" 1 record selected Then if we try: SELECT CUSTOMER WITH NAME = "SMITH" NO.INDEX 3 records selected If we rebuild the INDEX then the Select will return 3 records SELECT CUSTOMER WITH NAME = "SMITH" 3 records selected  Also, what would cause the Index to become out-of-sync with the data file, and how can we prevent this from happening? ------------------------------Gil SteidleDEVDDI System Incbrick NJ US------------------------------

If you have DX'd an FSI account, the QS pointer probably still exists in the VME's MDS. This can cause a problem with RESTORE-ACCOUNTS as it will create the DX'd account, restore the data from the account following it on the tape, then not restore that following account as itself. Example: you have an account called test followed immediately by an account called orders. You DX the test account and do a file save. You delete the accounts and do a RESTORE-ACCOUNTS. test will exist with the orders account's content and the orders account will not exist. Note that this affects RESTORE-ACCOUNTS but does NOT affect ACCOUNT-RESTORE, so if you stumble on this, you can delete any erroneous accounts and ACCOUNT-RESTORE FSI:<missing account> and you'll be good. Doing a d3vme /fileload is not affected either. Please note that Engineering is aware of this issue and currently working on a resolution. For those of you who need a little more detail on what I mean by "DX'ing an account", I'm refe

I am currently unable to connect to u admin tool and receive the message below My U2.DATA.CLIENT applications written in visual Studio vb.net work fine The data base is 8.2 and is running on  my local machine ------------------------------robert modrichDeveloperRocket Forum Shared AccountTEMECULA CA US------------------------------

I am using a windows based universe system.  I want to be able to do a listu type of command to see if a certain program is already running so that I can parse it in a basic program.  I saw the LISTUSER command, but that only shows the account path and not the program that is running.  I also saw the port.status command, but that is not installed on this system.  Can you please advise on how to do this?------------------------------Troy DittbernerPresidentNorthstar Data Services IncBrooklyn Park VA US------------------------------

Can someone tell me the proper syntax for SQL statement to Universe. I have a large file that I need to fetch 10000 rows at a time from Universe that will update a remote AZURE DB daily. I don't have control over the AZURE site as EDA seems like a much better solution to keep the remote data current.I have tried:SELECT TOP 10000 * FROM FILE;SELECT * FROM FILE LIMIT 10000;SELECT * FROM FILE FETCH FIRST 10000;SELECT * FROM FILE WHERE ROWNUM < 10000;Thanks JR Moore------------------------------JR MooreIT Special ProjectsRocket Forum Shared AccountHillsboro US------------------------------

i am currently unable to use uniAdmin to change default telnet login account What file can i edit to do this manually.. ------------------------------robert modrichDeveloperRocket Forum Shared AccountTEMECULA CA US------------------------------

The dual terminal debugging feature seems to have stopped working correctly. I am on Windows 11 running Unidata 8.2.3. I used to use this feature heavily when debugging character base screens. Without duel terminal, that task is very difficult. When a debug is encountered, the cmd line program first shows "!" as it should but entry of any valid debug command returns: ***Illegal debugger command. Try 'H' for HELP------------------------------Kevin HondMr.Self RegisteredKingsport TN US------------------------------

I have installed MVIS 1.3.4 and was hoping I would not have to re-key the Subroutines and dynamic arrays.  The manual talks about this on page 37  under "Importing a U2 REST server".  However, it says to use the U2 RESTful Web Services Toolkit to export/import.  I do not have any idea where to find this toolkit? MVIS admin does not have anything except Import/Export config (cm.ini) U2 Web Services Developer Tool contains our SOAP services but not the MVIS subroutines/arrays. There is a file that looks promising in C:\\U2\\CM\\u2rest names <ACCOUNT>.xml.  Is it as simple as copying that XML file from one server to the other?  What am I missing? Nelson------------------------------Nelson SchrothpresidentC3CompleteShop LLCHarrison OH US------------------------------

We recently got an email from our security team regarding an ODBC vulnerability notice sent out from Microsoft. We are not currently using ODBC directly with UniVerse but it's probably still in use by our guys doing SQL. Just curious if anyone else has had to deal with this and if there are any results that may help others in the group. The two vulnerabilities are listed below: VUL0014881 - TEN-175440, Security Updates for Microsoft SQL Server OLE DB Driver (April 2023) VUL0014958 - TEN-175440, Security Updates for Microsoft SQL Server ODBC Driver (April 2023) Thanks!------------------------------Jeff TeterWoodforest National BankThe Woodlands, TX------------------------------

MultiValue Experiences version 1.9.0.1516 has been released on January 25 2024 for the below platforms/versions:AIX POWER       7.1,  7.2,  7.3AlmaLinux       8CentOS       7,  8RedHat Enterprise Linux Intel       7,  8,  9Rocky Linux       8Windows       Windows 10,  Windows 11,  2016,  2019This 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.

Hey all,First time posting so I hope I'm in the correct area. Please correct me if I'm wrong.With the recent dropping of OpenSSL 1.1.1 support, I'm wondering if there has been communications from Rocket Software to support OpenSSL 3 for UniData 8.2.4. This is going to be a huge pain-point for our organization and are trying to prevent issues stemming from this if at all possible.From reading about OpenSSL 1.1 vs OpenSSL 3, there is a possibility of applications that use 1.1 to work with 3.0, but there's no guarantee. Backwards compatibility is limited. Another question because I'm curious: has anyone implemented openssl 3 for UniData 8.2.4 and, if so, were there any issues?Thanks,Brandon------------------------------Brandon BunchERP Solutions Specialist IIRocket Forum Shared Account------------------------------

The dual terminal debugging feature seems to have stopped working correctly. I am on Windows 11 running Unidata 8.2.3. I used to use this feature heavily when debugging character base screens. Without duel terminal, that task is very difficult. When a debug is encountered, the cmd line program first shows "!" as it should but entry of any valid debug command returns: ***Illegal debugger command. Try 'H' for HELP------------------------------Kevin HondMr.Self RegisteredKingsport TN US------------------------------

Looking for a way to locate the proper attribute in an output record where the appropriate data could end up on different attributes depending on conte Example,  I 1st need to differentiate the type of record, which can be done with something like :    IF INDEX(@ID,"WoJournal",1) THEN <acttion1> else if INDEX(@ID,"PoJournal",1) THEN <action2> ELSE <action3> 2nd, each action will need to find the proper attribute where the "STATUS" is logged. Then it will need to extract the STATUS itself from the line which can use FIELD statements. Looking for the best way to find the attribute # (2nd step) ------------------------------Nelson SchrothpresidentC3CompleteShop LLCHarrison OH US------------------------------

Troy,What terminal emulator are you using? Many of them intercept the CTRL-C key sequence thinking you want to use it for cut and paste. If it looks like all the settings in UV are correct, check the emulator settings.Brian

Does anyone have a guide or tips for setting up ODBC on Red Hat for use with the CONNECT command? UV 12.1, Red Hat 7.9. Our goal is to write to SQL tables directly from Universe programs - is this the correct approach? ------------------------------Matthew WrightAnalystTomago Aluminium Co PTY Ltd.Tomago NSW AU------------------------------

The Rocket® Software MultiValue team is pleased to announce the availability of jBASE 6.1.1 on January 9th, 2024. The Rocket jBASE solution is an object-oriented integrated database and application development environment designed for transactional and analytical database applications. It combines scalable, flexible, seamless interoperability with connectivity and low overhead for system management and administration. jBASE 6.1.1 brings new security compliance, certification on RHL 9, a free C++ compiler option for AIX users, Open SSL 3.0 support, and much more including 22+ bug fixes.   Increased security – Polaris compliance For improved data security and reliance, jBASE 6.1.1 includes 300+ mitigated risks in accordance with the Polaris assessment metrics. Polaris, one of Rocket's robust 3rd party security scan suites, sets a standard for all future jBASE releases. Expanded availability. In addition to being available on various versions of Windows and AIX flavors, jBASE 6.1.1 is a

Hi all. I'm using the inspect module to extract information about our code. The code runs well in the Python console but when called from Universe Basic I'm getting a Python runtime error. The Python side is really simple. I've reduced my code to a minimal example that reproduces it: File: leer_documentacion_min.py This is the module that does the inspection import inspect import json import sys def parameter_as_string(name, p): def_value = f' = {p.default}' if (not type(p.default) == type(inspect._empty)) else '' typ_annot = f':{p.annotation.__name__}' if (p.annotation.__name__ != '_empty') else '' return f'{name}{typ_annot}{def_value}' def leer_documentacion_y_funciones(script): try: if script in sys.modules: sys.modules.pop(script) modulo = __import__(script) # rest of the code documentacion = modulo.__doc__ if modulo.__doc__ else 'Sin documentacion.' funciones = inspect.getmembers(modulo, inspect.isfunction)

Good day, I'm trying to understand the basics of the D3 environment. Mostly clueless, but not afraid. I'm a 30+ IT person. Started coding in C in early 80's. We currently handle all aspects of networks, integration etc. Have no experience with Pick, want to get up to speed on terminology, best practice environment etc. To start: Application uses Accuterm to connect.I believe D3 is running on the MultiValue environment. It is running on a Windows 2008 server.These folders exist:C:\\ProgramData\\RocketSoftware\\D3C:\\Program Files\\RocketSoftware\\D3C:\\Program Files (x86)\\RocketSoftware\\D3ODBC Our support is provided via Nexustek, but certain tasks, I want to handle and understand. Modifying printer queues. I believe this is handled in COLDSTART Understanding the ODBC connect. I can connect to SQLDEMO, but don't know how to access the live tables. I have some basic environment questions. What version are we running? How do I find out? Best way to connect and play..putty, Accuterm?