Rocket® U2 | UniVerse & UniData®

On a Windows system (Windows version is 10.0.20348.1970) running UV 11.2.5 in PICK format, we have a BASIC program that executes a DIR command. EXECUTE "DOS /c DIR" CAPTURING OUTPUT  The time column shows the timestamps in 24 hour format. However from a Windows DOS Command window, if we type DIR the times are in 12 hour format.  My question is how can we get the time format to be in 12 hour format when running the  program? What is UV looking at to determine the time format?  BTW we get same results when we use DOS command at TCL to get to the DOS environment and then type DIR.  Screen shot attached with Windows Command prompt window on left and Accuterm on right. Thanks in advance.

I have a client that runs a 24/7 application on UniVerse (11.3.2).  They are conscientious about keeping their files well sized.  Several years ago they tried the CONCURRENT option on RESIZE and got badly burned when they ended up with corrupted files and lost data.  They have been very gun shy about using CONCURRENT since then.  Has anyone resized UniVerse files with the CONCURRENT option recently?  Is it stable now or is it still a crap shoot on the end result?  If you use it, what is the performance impact?------------------------------Steve Murray-WolfOwnerRocket Forum Shared AccountFirestone CO US------------------------------

Hello! what is the procedures to open a ticket on stand by?  We are upgrading Unidata AIX from a server to the cloud  for a critical software over a weekend and want to be assured that there will be support incase we have issues.  Thanks------------------------------Peter GonzalezSt. Louis, MO US------------------------------

Any U2 Basic program utility available to import JSON object into a dynamic array or Name-Value pair? I expect the U2 program to accept a JSON object as an input, and a list of Variable names to parsed from the JSON object. The output could be a name-value pair.------------------------------suresh anbilOwnerOHM Systems IncCincinnati OH US------------------------------

Has anyone else experienced this?   Since the move to UniData 8.2.4 Build 3003, I cannot use the "BL"  (Break at Line) in the UniBASIC Debugger without getting a mini dump for my troubles. I am unclear if I've just gotten really unlucky, or if something is not working as expected in this build. I have the team I work with opening a case, but wanted to see if this is something that is just my miserable luck, or if something is not quite right. It pretty consistently tells me I have an 'Access violation.  Attempted to 'read from address 0xFFFFFFFF'  ------------------------------David WolvertonIndependentSunset Programming IncWaltham MA US------------------------------

This was highlighted to me by the Director of Development as a feature when we were shipping UniVerse 4.4.4. The command syntax is: verb [DICT] filename [records | FROM list#] … where verb is among 18 options including CHECKSUM, COUNT, and LIST. Do we care if the file name can be almost anywhere in the query? Do we want to advertise this feature in the documentation? Should we just follow the documentation which wants [DICT] filename first? Is this for compatibility with some legacy multivalue environment? Is this capability simply a side effect of the lex/parse implementation? Does anyone do things like the following?: LIST DICT F1 VOC (Split DICT and filename) LIST F1 DICT MD (Filename after fields) LIST VOC DICT (At least this does NOT work – if DICT is not a dictionary field) Thoughts? ------------------------------Mark A BaldridgePrincipal ConsultantThought MirrorNacogdoches, Texas United States------------------------------

As a discussion starter, I'd like to throw out a few wish list items that would be helpful in our environment and, I assume, might be helpful to others:1. Block commentsThere are times when it would be very helpful to have the capability to use block comments. In BASIC programs, using a 'IFDEF()' sort of works but this capability should be available in all source code environments, e.g., BASIC programs, procs, paragraphs, etc. This would allow using markdown for documentation and would simplify program maintenance and management.2. Default text file typeFiles using Type 1 and Type 19 are intended for storing text data. Type 1 is a throwback (way back) to old Pick capabilities and, on current systems (Linux or other) is just another piece of tedium to deal with. I would like to suggest a configuration item that would indicate the type of file to use for standard text files. So, if a new account is created, those system files (like &SAVEDLISTS&) would be created as Type 19, rathe

Our MSP company just started supporting a customer that is using version universe dbms 10.1.3.0 on a windows xp system access from other systems via a terminal program.   XP can print to its windows tcp printers.  Customers accounting APP is no longer able to print, I don't think print job is reaching printer. I started looking at manuals online and another article related to printing but I don't have an understanding how to verify the configuration or how the choice of printer would be made by them when they want to print out various documents versus printing checks. I included a screen shot of what I started exploring using the setptr cmd. Glenn

Hi, I am struggling to run SQL statements (UPDATE) on my universe files.  If we run the same command as a root user then the SQL command is successful. This would indicate a permissions problem. Does anyone know which files need to be given permissions to, in order to  allow SQL updates on normal Univere files ? Thanks, Greg------------------------------Greg LivingstonUniverse Practice LeadOUTsurance InsuranceCenturion GA ZA------------------------------

Hi All, Im back to MV-World after a 20-year break. Formerly i was developing an application with advanced Pick / SB+. I want to activate Database triggers on a UV Database for some UV Datafiles to get dependent tables updated. But im struggling right at the beginning. I created  the following: FILE TEST.TRIGGER FILE TYPE 18 BAISC SUBROUTINE B.TESTTRIGGER with the needed parameters. After that I try to activate the Trigger with CREATE TRIGGER TESTTRIGGER BEFORE INSERT OR UPDATE TEST.TRIGGER B.TESTTRIGGER -> I Get the message TEST.TRIGGER unexpected. I thought that I have to convert the file to SQL Table befor so i tried the following command: CONVERT.SQL TEST.TRIGGER -> I Get the Message: Can't run CONVERT.SQL: 'UV11TEST-TL\\Administrator' is not an SQL User So i logged in as Administrator User and tried: GRANT DBA TO t.ludwig or GRANT DBA TO Administrator  -> I Get the message: UniVerse/SQL: "UV11TEST-TL\\Administrator" is not an SQL user.   I think the problem is to get the f

Hello Gang! I'm a newbie with this concept of UniBasic SQL BCI and would like to see if I can find additional resources/examples to help me get "over the proverbial edge". I have read all the the manuals that have material in this subject, but I'm still not comfortable in how to work with is.     My goal here is this...   I would like to use the UniBasic SQL BCI functions/subroutines to retrieve data from a third-party database.   An example of this is to verify a zip code or a geo-code.   I've been programming with UniBasic for many years, but this is the first time that I need to used the UniBasic SQL BCI functions. So, what I'm asking for, if someone could "point me in the right direction" for additional information or examples, that will be very meaningful to me.   Like I stated earlier in my post, I have read the material in the various Rocket documents, but still not quite comfortable in what I need to do. Any feedback will b

I have a 5 gig  file that has 7 million records. the record ids are like this : 7060834*11, 5425655*84, 1931679*19. Should this be a hashed file or a dynamic file? Is there a set of rules that should be used to help with the choice?------------------------------[Gary] [Rhodes] [Universe Developer][NPW Companies][Hialeah] [FL] [USA]------------------------------

Dear all,Has anyone implemented data encryption at rest using AIX Logical Volume Manager (LVM) with UniVerse?If you have done this, what issues or roadblocks did you find?Thanks,AndrewUltradata Australia Pty LtdThis message contains privileged and confidential information intended only for the use of the addressee named above. If you are not the intended recipient of this message you are hereby notified that you must not disseminate, copy or take any action or place any reliance on it. If you have received this message in error please notify the sender immediately via return email. Any views expressed in this message are those of the individual sender, except where the sender specifically states them to be the views of the company.

What IDE is everyone using for Universe DB to see the data etc... just want to see if there is anything better than dynamic connect?------------------------------Daniel ConradieRocket Forum Shared Account------------------------------

Introducing UniVerse 11.4.1 – Unleash the Latest New Features!   The Rocket MV team is pleased to announce the release of UniVerse 11.4.1 on August 17th,  2023.    UniVerse 11.4.1, along with MVX Performance 1.7.0, provides an enhanced replication experience, bolstering High Availability and Disaster Recovery (HA/DR) capabilities.   ·       UniVerse 11.4.1 HA/DR enhancements and bug fixes help you manage your replication environment more effectively: o   Utilize the Replication Intelligent Queue Manager in version 11.4 whichallows a subscribing system to recognize multiple updates in the queue for the same file, significantly enhancing performance o   Enable subscribers to receive logs from older protocol levels. This facilitates testing of a newer release of UniVerse on a subscriber while maintaining production on an older release o   Leverage the new uv_repadmin option to facilitate recovery from stalled subscriber groups ·       MVX Performance 1.7.0 integration with UniVerse 11.4

Working with a group of developers, I'd like to modify the system prompt in UniVerse from the standard '>' to include the account in which they are working. The 'WHO' command can give misleading results as it shows the folder in which they are running which may or may not be the UniVerse account. For instance, my developers each have a folder that contains the various accounts that they need for testing and source control. An example might be '/bl1/DEV_ABC/COM' and the 'WHO' command returns 'COM' but the UV.ACCOUNT record for this path is 'COM_ABC'. So, I'd like to modify the system prompt to show 'COM_ABC>'. I would assume that this could be set either in the 'LOGIN' script or in 'UV.LOGIN'. That will provide a visual cue that they are not in a production account. So far, searching the documentation has not produced an answer. TIA!------------------------------Jeff TeterWoodforest National BankThe Woodlands, TX------------------------------

Just checking to find out if there are any known issues with installing UniData 8.2.2 on Azure. Just basic database functions required.------------------------------James BrenzaPresidentMate PCSEllicott City MD US------------------------------

Does anyone know what this error is telling me? I see this error come up from time to time and I am not sure what the problem really is. This is Unidata 7.2.9 running on Centos 5.4.  Line 83 of MAIN.PROGRAM is an include, so I find it challenging to find out what it is actually doing when that error hits.  If I step through in the debugger, when it gets to the INCLUDE line it prompts me for the file name where the INCLUDE source resides. When I give it the file name it says that it is not a directory file when it actually is. It won't display the source then.

MV Product Version Lifecycle Changes Taking Effect September 1st, 2023 The Rocket MultiValue (MV) Product Lifecycle allows customers to plan upgrades so they can take advantage of the modernization and innovation features in fully supported, generally available (GA) product releases.  Effective September 1st, 2023 many MV product versions will move through the lifecycle.  Versions statuses and dates for each product can be found on the Product Availability Matrix.  Additionally, the MV lifecycle policy and status definitions on available on Rocket Business Connect (RBC). Plan your upgrade now to get the most value out of your support and maintenance dollars!------------------------------Christine RizzaSr. MV Product ManagerRocket Softwarecrizza@rocketsoftware.com------------------------------

I am creating an API using the python fastapi library.  The API is running pick programs off the back of the various endpoints using the u2py library.  There is an alias setup to ensure the universe python is being run rather than any other version.  We change dir at os level before running u2py commands.  This all works fine when the universe account has no menu in the login paragraph, otherwise it's getting stuck in the menu.  An example code snippet below works if I run from python prompt at universe level but not if i run python from linux level.  I think it's the @TTY I need to somehow set to 'phantom' stop it ending up in the menu, any thoughts how to achieve this? import u2pyimport os os.chdir('/opt/universe') f_UV_ACCOUNT = u2py.File('UV.ACCOUNT')------------------------------Neil SherwoodAnalyst ProgrammerHSBC Global Services (UK) LimitedLondon GB------------------------------

Hello! Unidata 8.2.3 on Windows 2019. Im using putty and cmd and when i attempt to do a LIST on anything it will output results with the prompt "press enter to continue" once i do that it removes the results it just gave me and outputs the next 10 results or so until the LIST is complete. Im hoping there is a setting that would make it so that it would NOT remove the results in the LIST so that i could scroll up and see all results. any ideas on this?

UniVerse 11.3.1 on AIX. In addition to changing mod to read-only, for example, I need a list of things that can be done to a type 18 file that will result in "Fwrite failed at DBwrite" when using the WRITE statement. 

Are there Python resources available on GitHub? Searching GitHub for "Rocket" and "UniVerse" has not yielded results. As I recall, there were some sample libraries that were are result of a Python class done in Dallas several years back. I'm hoping to find some of those examples. Thanks!------------------------------Jeff TeterWoodforest National BankThe Woodlands, TX------------------------------

Hello  UV 11.3 on Windows,  His anyone understand the WARNING: Old style truncated data level name "FORTRAE/MARLA.TRAE.104" detected.  on open file.  The VOC is a classic multi-data level defn, where the dalalevel filename is really  MARLA.TRAE.104.... Any idea ? Mamu

I have many account that I work with (UV 11.3.4). I am looking into using BDT and it works fine for a single account. All features work. However if I try to move to another account I get an error message stating: Could not change account to ### on server ###. The account path does not exist, or you do not have enough privileges to access the account path. I close BDT and re-open BDT and I can open the account just fine.  Am I doing something wrong here? We tried using Visual Code, however there were issues we could not overcome. Jon