Rocket® U2 | UniVerse & UniData®

Introduction I've installed the U2.EntityFrameworkCore NuGet package and successfully set up basic queries using my DbContext. Now I've hit a roadblock trying to call Universe subroutines Problem Description With basic CRUD operations functioning as expected using my DbContext, my next challenge is to call Universe subroutines. I can't seem to find clear documentation on how to achieve this when using the U2.EntityFrameworkCore package What You've Tried I've gone through the U2 Toolkit documentation, but it doesn't cover EF Core 6 specific implementations. I've also attempted to manually execute the subroutines using various EF Core methods, without any success. Questions Has anyone successfully called Universe subroutines using the U2.EntityFrameworkCore package with EF Core 6? What is the recommended approach for calling Universe subroutines in this setup? Are there any code samples or tutorials avail

Introduction I've also installed the U2.EntityFrameworkCore NuGet package and successfully set up basic queries using my DbContext. Now I've hit a roadblock trying to call Universe subroutines. Problem Description With basic CRUD operations functioning as expected using my DbContext, my next challenge is to call Universe subroutines. I can't seem to find clear documentation on how to achieve this when using the U2.EntityFrameworkCore package. What You've Tried I've gone through the U2 Toolkit documentation, but it doesn't cover EF Core 6 specific implementations. I've also attempted to manually execute the subroutines using various EF Core methods, without any success. Questions Has anyone successfully called Universe subroutines using the U2.EntityFrameworkCore package with EF Core 6? What is the recommended approach for calling Universe subroutines in this setup? Are there any code samples or tutorial

I believe I was told that when upgrading UDT from a previous version maybe 8.2.x to 8.2.4 its possible to update the license programmatically? currently we have to use confprod A message displays: You have 10 days to call U2 before UniData stops working.  5.      Type Ctrl+F

Good day, I'm supporting a IBM Power AIX environment, which I have been working with for about a year. Along with sorting out the general maintenance of the systems and moving to AIX 7.2 there is a large UniVerse environment on the hardware I support. So I've done a little reading, as I didn't build these environments, about recommend tuning. I couldn't find anything specific, so along with what I've found, I wanted to see if there was anything else I could do or look into. We have a number of test environments, and servers that I can build to test these things on.I have found some mention of tuning JFS, first was check the type of filesystem mount, if CIO enabled disable it. Then set 'ioo -p -o j2_dynamicBufferPreallocation=64'. I've also seen mention that j2_nPagesPerWriteBehindCluster should be changed from the default 32 to zero

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

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

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 me

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

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.  

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 Availabil

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?