Rocket® U2 | UniVerse & UniData®

Hi Guys. I've got an audit job that should be run periodically, but it failed yesterday and the only explanation i can think of its hit the maximum number of rows that are allowed in a holdfile spent a while searching for the magic number but can't find anything out in the world of Google Its not my program so can't amend the select, it selects the whole file and one of its functions is to record what was there, before it tidies up and deletes the records, i don't really need the holdfile, but the author thinks it useful i manually assign a holdfile at the start of the job and its previously worked fine, the last time it ran it  had 1.3M rows went into the holdfile perfect well yesterday the job stopped with  1541766 ROWS I've asked the provider to add a date select into the job, but in the mean time if "collective" can let me know if i've hit  the limit for a holdfile, that would eliminate one possible cause of the failure

Is there a way to relate the spot this subroutine is stuck (source line number?) from the layer stack output.  example:Layer type....... Program name.................... Address...BASIC run machine MC.CUST.MATCHCODE 0x00000BE4BASIC run machine CAT.REQUEST 0x00001134BASIC run machine CatRequest 0x0000074EBASIC run machine WW.METHOD 0x0000084CBASIC run machine WW.OBJECT 0x00000508BASIC run machine SPIDER 0x0000443EHaving a problem with this subroutine getting stuck for hours.Appreciate any ideas.Nelson

Does anyone know an easy way to tell if a large file copy is complete?  we have many programs creating/copying files to Type 19 directories and we also have a main program scanning these directories to ftp files to Windows servers to make them available for users.  We need to make sure the main scan program does not pick up a file until the copy is complete.We are on Linux, Universe 11.1.3.

Some Background.Have been developing in UV  platform since VB6 and asp classNow I would like to move on to the latest .NET 5.0 (and future)2 Issues/Question:1. Which client/connectivity should I use..?2. Is there any tool/library where I can convert UniVerse Dynamic String to/from Poco (Plain old Clr Object) or JSON string ? Thank you.------------------------------Koon MIng FongMrRocket Forum Shared Account------------------------------

Hi All,Is there still a U2 personal edition available? If yes, what are the restrictions on use?Thanks In AdvanceCheers Aaron

Hello,I wonder how UNIBASIC manages memory allocated by python modules executed via pyCall which returns PYOBJECT. And especially if the memory is correctly restored at the exit of the programs and subroutines which instantiated these variables.Is anyone who knows ?------------------------------Manu Fernandes------------------------------

Hi ,Using in-basic python I interface function like var=pyCallFuntion(module,function)  how can I define if the var is a uniBASIC Var or a PYOBJECT ? Then, is there a methods from UNI BASIC to perform python str(var). Any help is welcome.------------------------------Manu Fernandes------------------------------

what is the best strategy to backup universe database?we plan to use uvbackup tool. Will this impact performance?------------------------------Abdus ThommilTech ArchitectFlextronics International Management Services LtdSan Jose CA United States------------------------------

I'll claim a senior moment here... An associate is trying to write an I-type dictionary that retrieves the first subvalue in a set of  fields. I can certainly do it with a subroutine and the FIELD function, but the FIELDS function specifically excludes use of the value mark or sub-value mark as delimiters. Suggestons? I'm sure it will be a forehead slapper when presented...The existing data is:ABC@SVMDEF@VMGHI@SVMZBA@VMQARHe wants it to return:ABC@VMGHI@VMQARThanks, in advance!------------------------------Jeff TeterWoodforest National BankThe Woodlands, TX------------------------------

Hi All, Recently we are investigating that how to implement BASIC compilation in VS Code extension. I want to share our ideas, and we are very appreciate if you can provide suggestions and ideas. (The following content is just our initial ideas and design prototypes.) The main use of compilation is to find out the errors or warnings after code change. User can choose to sync the source code to U2 server or not. If yes, source code and objective code on sever would be overwritten after compilation. Before using compilation, user needs connect to a U2 server. And we will provide 2 methods to compile BASIC programs. 1. Compile BASIC programs through VS Code task. User can run VS Code default build task to start compilation. We can provide a target files list in the task configuration file, so that multiple BASIC program files in current account folder could be built together.

Hi All Assuming I have appropriate permissions on the file system can anyone tell me if it is possible to copy/move from a UNIBASIC program?I have explored READBLK and WRITEBLK but the file always seems to be corrupt after writing.Example scenario; move/copy a word doc or PDF file from one directory to another.Alternatively is there a way to shell execute a command to the local server or execute a powershell command etc.Thanks In AdvanceAaron

Hi Can you backup only the data portion of a file with uvbackup?Regards,Thando

UniData 8.2.2Hi All,Does anyone know if Rocket have recently changed the key length for the SAVEDLISTS file? On older versions I had no issues saving keys like -TRAWL*LAZ.PROGS*197609I know about the potential 000-999 issue when the OS tags the chunk numbers onto the end of the key, but I could at least save the list. Now, the response I get from the system is - can not open file: 'SAVEDLISTSTRAWL*LAZ.PROGS*197609I tried tagging some alphas onto the end of the key to get around the numeric chunking clash, but it didn't make any difference. If I hardcode the list key to 'BOB', it saves the list as BOB000 just fine.I don't really want to reduce the length of the key because I want to keep it unique and also visibly descriptive. ThanksLeon

I have several servers with UV 11.3.1.6022 installed and, on one, I'm getting a very odd behavior on selects. This is only happening on our development server, but it's in multiple accounts and the configuration is the same as other servers.If I create a list with only one item in it and then do a "GET-LIST list_name". The system shows zero records selected and will not list the item. It behaves the same if I'm using &SAVEDLISTS& or another file for storing the lists. >CT MLISTS WNB710_20180101.WBP_TEST       WNB710_20180101.WBP_TEST 0001 TEST.FNCODESGET >GET-LIST MLISTS WNB710_20180101.WBP_TEST Zero records SELECTed.  SELECT list number 0 cleared.

@Leon Pearce and @Kathleene HunterJust to clear something up here on the question on the SAVEDLIST length question thread. The SAVEDLISTS error with a '*' will only happen on UniData on Windows, in fact there are several characters that Windows forbids in file names so it's not just a '*'. On UniVerse on Windows the disallowed characters are encoded so the list can be saved, Kathleene if you check in your SAVEDLISTS directory on Windows you will find where you had an '*' in your name it's encoded as %A, so this is why you don't see the error on UniVerse. UniData does not encode the disallowed characters.​​​------------------------------Jonathan SmithUniData ATS and Principal EngineerRocket Software------------------------------

Hi Everyone,I'm wondering if there is a built-in way to determine when a BASIC program was last executed on a UniVerse system.  (I'm running v11.1.9 on Linux)  I worked on a different platform years ago that had a DICT item in the BP file that would return that info, but I haven't found anything like it on UniVerse.Thx

Continuing on my search for more information about some of the uvconfig settings and their possible real-world tuning outcomes...The OPTMEM setting reads as an important option that could contribute to the performance of all RetrieVe commands.The uvconfig section reads as:# OPTMEM - This is the amount of memory allocated# for the query optimizer's workspace. It is# specified in 1K units (1024 bytes).OPTMEM 64Has anyone ever changed this setting?If so, what setting was used and what impact does/did it have?Thanks------------------------------Gregor ScottSoftware ArchitectPentana SolutionsMount Waverley VIC Australia------------------------------

I have occasionally wondered what the SCRMIN, SCRMAX and SCRSIZE settings in the uvconfig file actually influence.I know I have never adjusted these values since we started with UV 9 (currently working on our UV 11.3.3 in-place upgrades) so I was wondering if anyone has changed these settings, and if so then to what, and why?From the uvconfig file:# SCRMIN - specifies the minimum size of# UniVerse scratch buffer pool. This# value must be at least 1 and must be# specified before SCRMAX.SCRMIN 3# SCRMAX - specifies the maximum size of# UniVerse scratch buffer pool. This# value must be no smaller than SCRMIN# and must be specified after SCRMIN.SCRMAX 5# SCRSIZE - specifies the size of newly# allocated internal scratch buffer

HelloI'll check performance and CPU charge of program.Usually I use this$OOTIONS TIME.MILLISECONDST=SYSTEM(12)DO...PRINT SYSTEM(12)-TIts about e execution time but I'll identify the CPU charge... To use efficient instructions because the program run for large qty if users. May I use SYSTEM(9) instead system 12?Thanks for any suggestions.------------------------------Manu Fernandes------------------------------

I am in the process of debugging several hundred calls from UniObjects to host routines. I wrote a debug program that gives me SYSTEM(11), the call stack and other items that are written to a file. The problem is that when I sort the file by the CPU time (SYSTEM(11)) there are several (5) calls all at the same time. Is there a way to get a time that has a higher resolution than just  milliseconds?TIA,Steve------------------------------Steve MayoSoftware Engineerbasys------------------------------

Hi There,I have a retrieve sentence that displays the Loan officers number but I also want to display the officer's name.                                                                                                                   I would like to lookup officer's name in another file. Both files can be related using the operator number.The file I am using is APPLICI need to create a dictionary in that file to lookup the officer's name in PR.USER file.Name is the ID  in PR.USER file.Sample of my output APPLIC Id.... LOAN NO.  LO_OFFICER APPLIED....   LOAN AMOUNT Sts Branch  31786L1.2     687168          1012   15 JUN 21      1,025.00   5      6

All,We have a large number of reports printed each day. Users will contact our admin staff to find out why a print job did not print. We get some reports that have a banner page with no other output or no records selected. We would like to identify what report was run and generated no or vague output. Is there some way to modify the banner/separator page to include the report name? Is there a way to force Retrieve to print the headings when no records are selected? I think one way would be to pass the USEROPTS from the SETPTR command to a script grab that and try to keep a list of print jobs and the USEROPTS file in a file somewhere, but it seems really convoluted.

Can someone point me to a download link for UV PE for Windows if it still exists. I've had a look on the Rocket site on the only mention I can see is in the AWS Integration Server instance they're promoting.I want to attempt to set up a Windows Docker instance of UV (to use with a build pipeline). Has anyone done something like this? Should I bother?------------------------------Stuart Boydell------------------------------

Hi All, is anyone using Wintegrate in conjunction with MFA? We're looking to implement DUO to do Radius based authentication. We are using Wintegrate v6.3.6 (Local Clients) to connect to Unidata for Windows (8.2.1. build 9104).I'm thinking we'd login in via Wintegrate as usual, but within the login voc we'd interact with DUO at that stage to do a push to mobile devices etc. for verification.I'd be interested to know if any other users have this in place.------------------------------Norrie SteeleMainetti UK Limited------------------------------

UniVerse version 11.3.3 has been released on May 31 2021 for the below platforms/versions:AIX POWER       7.1,  7.2Amazon Linux       2CentOS       7,  8HP/UX ITANIUM       11.31Oracle Enterprise Linux x86       7,  8RedHat Enterprise Linux Intel       7,  8Solaris SPARC       11Solaris Intel       11SuSE Linux Enterprise Server Intel       11.0,  12.0,  15.0Windows       Windows 10,  2012,  2016,  2019This product is available to order immediately via your Rocket software provider or by logging