Rocket MultiValue

Hi All,We are using Universe 11.3 on Windows.I needed to round a 5DP number up to the Next Whole number, so the result would be ; I could not find a suitable command equivalent to Excel  ROUNDUP, as shown above, so I've manually programmed the required calcs.There does not seem to a be suitable Flag for ICONV / OCONV and INT only grabs the whole numberIs anyone aware of a Function that does what I needed ??Just in case I've missed a  Function, i went through the  UV Basic Command 11,34 pdf guide and could not find anything.However, i spotted in UV Basic Command 12.11 there are 2 x new commands ROUND and also TRUNCWhilst these syntactically don't do what it need, it may help others looking for similar functionality.so as I'd found these new Functions available in V12, it got me thinking, can these new commands be retro applied to earlier versions of UV, obviously I can't just upgrade Universe to access these commands.Secondly as the new to me ROUND function still does no

One of our applications received this error message and aborted. The remote data was never offline. UniData Release 8.2  Build: (1000) (c) Copyright Rocket Software, Inc. 1985-2020. All rights reserved.  Current UniData home is /usr/ud/. Current working directory is /dock/app1/PLT3.   :perform_remexec dp:KMC 870 lblack [1/1] SELECT UNIT.ID SELECT UNIT.ID  1311 records selected to list 0.  In /usr/ud/sys/CTLG/p/perform_remexec at line 225, connect() error(11): Resource temporarily unavailable In /usr/ud/sys/CTLG/p/perform_remexec at line 225, Connect() error (11): Resource temporarily unavailable in UDT_connect. In /usr/ud/sys/CTLG/p/perform_remexec at line 225 Connect dp:/dp/apps/KMC:1155 failed, status 11 In /usr/ud/sys/CTLG/p/perform_remexec at line 225 efs_connect() failed, fname (SAVEDLISTS)In /usr/ud/sys/CTLG/p/perform_remexec at line 228, connect() error(11): Resource temporarily unavailable In /usr/ud/sys/CTLG/p/perform_remexec at line 228, Connect() error (11): Resource tempora

Being used to the Unidata format, when running this command in Universe the file the lock is in does not display. We have common keys across many files so the format of this tool is very unhelpful to us! Does anyone have the syntax, alternate command, or custom ditty that shows all the pertinent info for a lock at one time? IE login, date/time, file, ID, process ID, User ID?Thanks for the help!------------------------------Kathleen HambrickProgrammer at Colwell------------------------------

8.2.4 i believe, and any (rough) eta on when the next version will be available? thanks dougc------------------------------Doug ChancoUniverse ProgrammerSelf Registeredgraham NC US------------------------------

For decades, my customers have been emailing from their D3 applications by using a Windows command line email processor called "Blat." One customer claims that his IT guy told him that Blat will no longer work because their email server requires 2-factor authorization.1. Is the IT guy correct?2. Is there a workaround for 2-factor authorization to allow Blat to work?3. Is there another solution?Thanks.------------------------------Richard GinsburgPresidentGinsburg ConsultingManassas VA US------------------------------

Many years ago when we went to the web we stopped using paragraphs. We have not used a PROC since the early 2000s with any of our clients. So when we moved to the web using UniObjects for Java you could only call subroutines through our API. This meant we had no use for any of the 1000-plus paragraphs that we had written over the years. If we need to select we use EXECUTE to handle getting the data.I was wondering if what I am describing is true for other Unidata, Universe, and D3 customers that have gone through a migration to the web. I have a would-be client that says you can keep all of them. I just don't want to use and EXECUTE to call the paragraph and DATA the need inputs. Am I wrong here?------------------------------Doug AverchOwnerU2logic------------------------------

I think we need a Labour Exchange where those looking for expertise can post their requirements and those with expertise can also post their experience and then they can contact each other.In my case, I am looking for people with expertise in D3/Linux, SB+ and MVS Toolkit, to work on systems that are now over 30 years old and are and have been continuously updated and new projects that are being rolled out on a regular basis.What do you all think?------------------------------Alex PolglazeThe Book-Keeping NetworkPerth Western Australia+61419 776 348apolglaze@book-keepingnetwork.com.auhttps://www.book-keepingnetwork.com.au/------------------------------

I accidentally created an invalid record(s) in a uv 11.2.5 file that I can't get rid of. The file is CONTROL and the record "@ID" contains multiple CHAR(9)'s. Because CONTROL is open to every process and I can't take the system down, I'm hesitant to try commands that might cause issues. My last resort will be to create a new file, copy the valid records and replace the existing, but there has to be a fix that doesn't require taking the system down. I've tried to manually select and delete the record(s). I also wrote a program when that failed. I've tried multiple things in the program, using SELECT statements and creating the ID, but the READ statement hits the ELSE clause because it's not valid. The info below demonstrates that a single record selected is handled as 2 records when I edit them. >SELECT CONTROL = "[19791 ]"1 record(s) selected to SELECT list #0.>>AE CONTROL< 1 > Top of New "LAST.DMD.NEW.DAILY^009* Date of last NEW demand history load" in "CONTROL".*--: EX

I'm adding some validation to a routine that launches BASIC programs to ensure that the program's object code can be found (and is not a subroutine or function).For main programs I think the search path is as simple as Local VOC GLOBAL.CATDIR (if the program starts with "*" - testing has shown that only globally cataloged programs that start with "*" can be  run ) For subroutines and functions it gets more complicated Local object code of program that will call the sub/function Local VOC GLOBAL.CATDIR (for all the available prefixes: "*", "!", "-", "$" Leaving aside the technical hurdle of pulling apart local object code looking for additional subroutine/functions, and the logic needed to detect if object code is a subroutine/function - that will have to wait for now.Is there anything that I might have missed in these search paths?Is there any case sensitivity settings/toggles that can influence the search in each of these paths? Many thanks------------------------------Gregor Scot

MultiValue Integration Server version 1.3.2 has been released on January 31 2023 for the below platforms/versions:AIX POWER       7.1,  7.2AlmaLinux       8Amazon Linux       2CentOS       7,  8Oracle Enterprise Linux x86       7,  8RedHat Enterprise Linux Intel       7,  8Rocky Linux       8SuSE Linux Enterprise Server Intel       11.0,  12.0,  15.0Windows       Windows 10,  Windows 11,  2016,  2019,  2022This product is available to order immediately via your Rocket software provider or by logging into your RBC account at https://rbc.rocketsoftware.com or https://rbcint.rocketsoftware.com.Additional Product Information is available on the Product Availability Matrix at https://rbc.rocketsoftware.com/matrix.asp or https://rbcint.rocketsoftware.com/matrix.aspFor any questions on product availability, ple

Hello , there. We have a rich client application, written in Delphi that ships (installs) with the follwing dlls dependencies:  As far as I know, there is noother requirement (lib or whatsoever) needed for the client to run. My question is, ¿what is the path that I need to follow to secure comms  (using SSL I guess) this client App ? If there is , ¿can we "pack" the solution with the installer ? . Going PC to PC is out of the equation.Regards, David.  ------------------------------David Ricardo Lopez BonaecheaDirector of Software StrategyQuiter Servicios Informaticos SLSantander ES------------------------------

Looking for a way to put our UniData system in a read-only mode.  I'm not talking about the UniData files, just our production files.I was thinking I'd have to do it at the OS level.  But I thought I'd check with the community to see if such a "switch" exist.  We are running UniData 8.2 on Window2019 server.Thanks.------------------------------David GreenComputer ProgrammerRocket Forum Shared Account------------------------------

We are reviewing the effort vs the benefits with upgrading our current 11.3.1 Universe.Can anyone highlight the effort vs the benefits with such an upgrade pathway?------------------------------[Darren] [Johnson] [Australia][Snr Dev Engineer][Indue][Brisbane] [QLD] [Australia]------------------------------

I'm working on configuring and testing a new server running jBASE 5.8.6At the 'jsh' the backpsace key will not backup and erase.Does anyone know an easy way to change this? Thanks------------------------------Jim EdwardsIT ManagerRocket Forum Shared Account------------------------------

We have a backup script that suspends and restores writes by going into Universe and setting the SYSTEM()  variable 27/43.  We had a problem when after the script suspended writes the unsuspend failed because user license limits were briefly reached.  What is the best way to recover beyond adding more licenses?

Hello is token auth supported for UOPY ??? Can't seem to make it work. It's invalid login all the time. OS User logins O.K. My token : TOKEN_DEF_BEGINTokenType=2TokenId=dlopez@TESTSITETokenPass=*not shown*OSUserId=dlopezAllowedServices=UVCS,UVSERVERMembers=*quiterDomains=TOKEN_DEF_ENDMy code: import uopyprint(uopy.config.connection)with uopy.connect(user='dlopez@TESTSITE', password='xxxxxxxx'):    cmd = uopy.Command("LIST VOC")    cmd.run()    print(cmd.response)My client config : [connection]host = ec2-18-100-159-141.eu-south-2.compute.amazonaws.comaccount = TEST1port = 31438timeout = 100service = uvcsssl = Falseencoding=iso-8859-1[ssl_auth]server_cert_file="c:\\temp\\desktop-ppdt4ds.crt"[pooling]pooling_on = Falsemax_wait_time = 60idle_remove_threshold = 300idle_remove_interval = 300min_pool_size = 5max_pool_size = 15[logging]level = DEBUGbackup_count = 10log_data_max_size = 256------------------------------David Ricardo Lopez BonaecheaDirector of Software StrategyQuiter Servicios In

Hello uv gurus, I post a question about trigger on uv/win 11.3We use a trigger after update on a high frequency update file 'A'.  (10 update/min)The trigger is really simple (get a lock on file B, delete record on file B) Yesterday, we get, 9 time on thousand  executions, the error : Unable to execute trigger as trigger creator "dom\\user" ​ 9 times, the session's user is différent, the PID is différent, the account/VOC and runtime context  is the same. Is someone have any idea what to check ?  With kind regards.------------------------------manu fernandes------------------------------

for those using unidata, what do you'll call the prompt you know where you can type in commands like LIST VOC, etc .....TCL or "the colon prompt"for example, in uv I would say go to TCL and select VOC with the type being Fin unidata would I say go to "the colon prompt"  and select VOC  with the type being For do most use TCL, i keep hearing "colon prompt" and it just seems "wierd" to me I know its a stupid question but I am just curious as to what professional (which you'll are) say/usethanksdougc ------------------------------Doug ChancoUniverse ProgrammerSelf Registeredgraham NC US------------------------------

I am using Universe 11.3.4 on a RHEL 7 box. I created a trigger on a file and I can create a log every time the file is changed but I can't figure out what program is making the change.  I can see the @TTY, @LOGNAME, and PARASENTENCE DATA but the FILENAME comes back as a blank. I have a Phantom making some of the changes and the PARASENTENCE is giving me the name of the phantom. Is there anyway I can get the Filename of the BP program?Jon CardCombined Transport Inc​​​​

This could be an "I don't know what I'm doing" type issue, as I've rarely had to use this and don't live and breathe this stuff, but I'm running out of ideas so I thought I'd go into beg for help mode. I have a .net core 3.1 app written in C# that communicates with Unidata 8.2 on Windows via WebDE 5.3 using RPC calls. Everything was working great with WebDE 4.x but I'm struggling with 5.3.I can communicate with UniData and retrieve a response. The response is a @AM delimited string on the Unidata side. When I receive the response it's just one long string delimited with the default unicode character, 65533. I looked for someplace to set the character set/encoding but didn't find anything obvious. 1) Are there any updates to the documentation that show current RPC examples? The 5.3.1 docs show the method is setConnection but it appears you need to use ActiveConnection instead. I'm wondering if anything else has changed that I could be missing.2) What needs to be updated in the project s

When I change my slave printer in Accuterm to produce an Adobe PDF, I have to manually name the new file. How do you automate this process such that I can pass a per-determined name for a print job to Accuterm? Thanks.------------------------------Richard GinsburgPresidentGinsburg ConsultingManassas VA US------------------------------

Excuse the brain cramp, but I need some assistance to see if I can create the dictionary PGM.PCT.File data is:<1> PGM1 <mv> PGM2 <mv> PGM3<2> 1000 <mv> 2000 <mv> 3000I want to list F1, F2 & PGM.PCT​ to get this expected output: >LIST DATA.FILE F1 F2 PGM.PCT PROGRAM NAME    COUNT    PGM % PGM1                                1,000          .167 PGM2                               2,000         .333 PGM3                               3,000          .500  I thought (incorrectly) that PGM.PCT would be (@RECORD<2,@MV> / SUM(@RECORD<2>) Can this be done in a simple I-descriptor or am I barking up the wrong tree?​I am in UniVerse 11.3.1 on AIXNelson------------------------------Nelson SchrothpresidentC3CompleteShop LLCHarrison OH US------------------------------

How can we quickly see if a file (or list of files) are 64bit or 32bitI can see from analyze.file that a file is 64bit. but that was not picked up by the ACCOUNT.FILE.STATS in the STAT.FILEIs there an hidden key in FILEINFO() that will get that information------------------------------neil richardsdbaRocket Forum Shared Accountlake Elsinore CA US------------------------------

I've reached the point of presenting a list of maintenance schedule option check boxes for constructing a work order for a vehicle. I would like to present the user with a window sized to the number of scheduled items for the vehicle which may range up to 20. The only way I see to do this is to ATGUICREATEFORM or ATGUICREATEFRAME2 within the program to control HEIGHT. Does it make any difference which or is there a way to do this from a GUI created form?Dale

I’m a bit confused as to which to use to create .NET applications. I’ve been using U2 Toolkit for .NET (u2.Data.Client.dll) because the documentation includes sections on how to convert from U2.UODOTNET applications. When I look at the documentation for UODOTNET (U2Clients_UniObjectsNET), I see it is only a few months older than the U2 Toolkit documentation, and it is much more detailed. Does the “U2 Toolkit” supercede the “U2 Clients”? Can I trust that all the U2 Clients documentation describing the UniObjects and how to use them (such as record locking) applies to the U2 Toolkit UniObjects? Thanks.