Rocket® U2 | UniVerse & UniData®

Hi Everyone,I have encountered some unexpected behavior using the SPLICE function.  I'm hoping someone can tell me what I'm missing.I'm on UniVerse 11.1.9 (yeah, i know it's old) running on Linux. Consider the following code. ARRAY1 = 'ONE' ARRAY2 = CHAR(246):CHAR(247):CHAR(248):CHAR(249):CHAR(250) CRT CRT 'System Delimiters' CRT 'CHAR(251) = ':CHAR(251) CRT 'CHAR(252) = ':CHAR(252) CRT 'CHAR(253) = ':CHAR(253) CRT 'CHAR(254) = ':CHAR(254) CRT 'CHAR(255) = ':CHAR(255) CRT CRT 'ARRAY1 = ':ARRAY1 CRT 'ARRAY2 = ':ARRAY2 CRT CRT 'Expected = ONE:':ARRAY2 CRT 'Actual = ':SPLICE(ARRAY1, ':', ARRAY2)​ Here is a screenshot of the output.Notice all the colon (":") characters.  Notice also that char(247) seems to have been changed to char(255).What is going on here?

hi, does anyone know how to install python libraries a universe------------------------------Sergio Antonio Navarrete MejíaRocket Forum Shared Account------------------------------

Hi,This is for Unidata 8.2.For years I thought the following was equivalent: ICONV(DTE,'D')ICONV(DTE,'D2/')ICONV(DTE,'D4/)My assumption was that Unidata did not care about the number or the slash and just did an internal date conversion. Today I learned that it is not. While entering 1/11/11  all return 15717 as does 1/11/2011 as does 11 JAN 2011 as does 11 JAN 11 but entering 11012011 does not.ICONV(DTE,'D')          returns 15717ICONV(DTE,'D2/')     returns 19004ICONV(DTE,'D4/)      returns 15717Is this a bug or does this jibe with your understanding?Thanks,Steve

All,I have a PAragraph that runs a program and feeds data into it using the DATA statement to provide input. One of my DATA statements has a pathname with an'@DATE' in it. I.E. C:TEMPFILE@DATE.TXT. I tried C:TEMPFILE@DATA@TIME.TXT, the pathname had the current date but the '@TIME' was just '@TIME'. The documentation was pretty thin on this topic. What at variables are allowed in a DATA statement?Jon​​

This application has been running for over 20 years.  It is on Metro Nashville's cloud network where, as a contractor, I have no visibility of pretty much anything except the virtual server.  These interruptions began occurring about 3 months ago as pandemic inactivity concluded.  These connection closures are sometimes frequent and sometimes infrequent.  Users find themselves disconnected in the middle of an operational function.  They are using Dynamic Connect for telnet.  Has anyone experienced this and found the problem.  Are there any server or workstation firewall or antivirus settings that could have been recently changed by Metro's IT department that could cause this?  Also can anyone recommend an ssh server for Windows that could be substituted for telnet?

Hello all,I am looking for the documentation on 'filepeek'.I want to do:EXECUTE "SH -c "filepeek /path/to/file/name"But the command 'filepeek' requires a 'Q' to quit from the prompt 'Addr:'.I am wondering if there is a flag that I can use so that is terminates itself without the necessity of going into 'Addr:'I am just trying to get the info on the file to see if it is 32 or 64 bit.------------------------------Joe TorreSr DBA AdminOptumWesterville OH United States------------------------------

Has anyone had Universe just hang at the uv command?   We are on an old version 11.1.3 under Solaris 10.  Thought it might be suspend files not getting set back but no.  No errors, could not find anything in the $uvhome logs.  A server reboot bought the system back without any file damage.   Trying to think of other places to look for root cause without any errors to review.  No known changes to system or environment.

We have a very old (clunky) program that displays the last edit date for source and the last compile date for object code. I'm wondering if any of you learned folks have a clean, effective way of doing this that might be helpful? TIA...------------------------------Jeff TeterWoodforest National BankThe Woodlands, TX------------------------------

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 Many thanks Andy

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. 2. Compile modified BASIC programs.User can right click a file in the editor to display context menu and select "

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. If I create a list with multiple items and then do a "GET-LIST list_name", the selected count will consistently show one less item than is in the list. However, if I do the "GET-LIST" and then list the file for the items, all are shown... >CT MLISTS WNB710_20180101.BLBP       WNB710_20180101.BLBP 0001 FNCODESGET 0002 FNCODES

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