Rocket MultiValue

does rocket (or anyone else) have a preference of using resize vs memresize and if you do can you elaborate? thanks dougc------------------------------Doug ChancoUniverse ProgrammerSelf Registeredgraham NC US------------------------------

Hi, I have a very simple program to upload a file from the PC to Linux host.  I'm trying to use FTS and the seems to go through the process of uploading but the routine never exits it just hangs once it gets to 100% transfered. Here is my routine.0001:       REMOTE.PATH = "C:USBANK"0002:       REMOTE.FILE = "USBANK.txt"0003:       MODE = 'R,A,T'0004:       RECORD='' ; STAT=''0005:       CALL FTS(MODE,REMOTE.PATH,REMOTE.FILE,RECORD,STAT)0006:       PRINT STAT0007:       PRINT RECORD0008:       STOP0009:    END I'm expecting the routine to finish uploading the print the value of STAT and RECORD.   But it never happens it just hangs. Any ideas?Sam

Hi, This is Keerthana. I'm Senior Software Engineer in TP project at Mitra Innovations. Currently, we are attempting to establish a connection between U2 Python and native Python. Our concern is that what we have done first is used UOPY module to access the subroutine and data file in BP source in XDEMO account using session. But U2 python does not require a session because the u2py module is included in the XDEMO account. But if we want to connect U2 python and native python there must be a configuration or session right? Can we connect this without using a session? Or are there other ways? We checked the .pyconfig file in the UV and tried changing the path to PYHOME and PYLIB there. But we are unable to connect. So Now we are thinking for the connection purpose we can use the any middle ware, Like MVIS. I'm not sure our thought is correct or not. So please anyone have any idea let me know or do you have any refrence please share with me ------------------------ Thank youKeerthana.RSe

I use UniVerseSQL a lot. The absence of the equivalent of TSQL's Replace() function was a handicap so I wrote a wrapper function for BASIC EREPLACE() and added it to the Global Catalog. It works fine but the call is a little messy.EVAL 'SUBR("-REP.CHARS", attribute, "somestring", "anotherstring", 1, 1)' I'm curious if there is something I can put in the VOC to allow it to be called using just a VOC name and the arguments like the native UniverseSQL functions.------------------------------Greg ClitheroeRocket Forum Shared Account------------------------------

The Rocket® MV team is pleased to announce the release of U2 Toolkit for .NET 3.1.1 on August 24th,  2023.    The Rocket® U2 Toolkit for .NET Provider offers a free .NET data provider interface for Rocket UniVerse and Rocket UniData®, while U2 Toolkit for .NET Developer adds the ability to develop in Microsoft® Visual Studio.   U2 Toolkit for .NET 3.1.1 enhancements and improvements include:   ·       .NET 6 support streamlines code development for better performance ·       Entity Framework Core 6 support offers query enhancements, performance improvements, and a range of new features to minimize development time and costs ·       U2 .NET 6 and EF Core 6.0 drivers are now available on NuGet.org, allowing you to seamlessly update to the most recent U2 drivers ·       Visual Studio 2022 support for U2 Toolkit Data Provider only ·       TLSv1.3 protocol support for faster, performant, and more secure connections Install Rocket® U2Toolkit for .NET 3.1.1 today on Rocket Business Connect

As Rocket's MV evangelist, I'm starting a discussion. What are you thinking or doing with AI around your MV app?------------------------------Mike RajkowskiMultiValue Product EvangelistRocket Internal - All Brands US------------------------------

As Rocket's MV evangelist, I'm starting a discussion. What are you thinking or doing with AI around your MV app?------------------------------Mike RajkowskiMultiValue Product EvangelistRocket Internal - All Brands US------------------------------

This is a general question regarding using Test Driven Development in Universe Basic. Has anyone used this to develop their software and is there a testing framework that can be used? I have been asked to try it out and have only found information using object oriented programming languages. So far, I have created an ASSERT function and have started implementing test cases. Thanks in advance for any advice.------------------------------Maureen CollinsUniverse Database ProgrammerTeachers Mutual BankHomebush NSW AU------------------------------

I have been replicating for a while now with cloud systems to our in-house server using Universe and before that Unidata. However, one of our clients asked if you could have the publisher be a subscriber too? And could the subscriber be a publisher too? Posted at: 02-10-2024 10:12

I read in an earlier post that someone had created an ANTLR file for BASIC or C. Do you still have the file? I am new to ANTLR but would like to create a parser for users entering at least BASIC code.  Thanks! Lamont ------------------------------Lamont LockwoodIntegration ExpertDallas, Texasl2@integrationexpert.com------------------------------

I've created the U2 Python program, which is  with the Universe. My current challenge is figuring out how to seamlessly integrate U2 Python (Universe) with Django. Could you please provide guidance or steps on how to achieve this integration?------------------------------Gnanaseelan gnanapirakasamSSERocket Forum Shared Account------------------------------

I read in an earlier post that someone had created an ANTLR file for BASIC or C. Do you still have the file? I am new to ANTLR but would like to create a parser for users entering at least BASIC code.  Thanks! Lamont ------------------------------Lamont LockwoodIntegration ExpertDallas, Texasl2@integrationexpert.com------------------------------

We are pleased to announce the release of MultiValue Performance Experience v 1.9.0.1516 on January 25, 2024.  This is the third MVX: Performance release focused on improving replication as part of a MultiValue HA/DR strategy.  We've added replication charts to provide you with more insights into the replication status and latency of your MV databases. You can now see four different charts showing you the subscriber latency trend, the estimated time to catch up, and the distribution of replication data for all groups or a selected group. This is a big improvement over using XAdmin, where you had to do the mental math to understand the estimated time to catch up. You can also use the Graphical Range drop-down menu in MVX: Performance to select a time range for viewing the data trends. Two of the replication charts now support aggregated group data, which means you can see the combined data for multiple groups in one chart. This can help you compare and contrast the replication performan

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

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

hello folks, I receive an json like this  "number": { "decimalPlaces": "none", "displayAs": "number", "maximum": 1.7976931348623157E+308, "minimum": -1.7976931348623157E+308 } when I perform the udoRead ; I get no problem to read it . number number.decimalPlaces string none number.displayAs string number number.maximum number 179769313486232000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 number.minimum number -179769313486232000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000

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

hello folks, on a Linux/uv 11.3 box, I have a trouble with BASIC  I do this (for short): equ UUID$NEW lit "field(PyGetAttr(PyCallFunction('uuid', 'uuid4'), 'urn'),':',3)" print UUID$NEW and I get a segmentation fault at runtime AND with VLIST ;  basic pcode seams faulty ? It works for month ; and it works on another machines....  After a reboot of the os the trouble is still there !!! Any idea ?  many thanks by advance ManuFV

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