Rocket MultiValue

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.

MultiValue Experiences version 1.5.0.874 has been released on January 24 2023 for the below platforms/versions:AIX POWER       7.1,  7.2CentOS       7,  8RedHat Enterprise Linux Intel       7,  8Windows       Windows 10,  2016,  2019This 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, please contact rbc@rocketsoftware.com.

I have implement some web service calls in a Linux based D3 system without needing to use the MVS Toolkit. I was wanting to use the same code on a Windows version of D3 and decided to see if the MVS Toolkit would be suitable as the method of accessing D3 on Linux that I used does not appear to be suitable Windows based systems. I have created a web service named "editor" and a web service resource named "explore" for testing purposes. In order to replicate the way the Linux version works I just needed to implement a single resource and use the mvsp.get.http.* subroutines to extract the required data and then submit the data to the other subroutines that implement the business logic. All went well until I tried to use a PUT http method. It has the structure similar to PUT http://server_name:8181/editor/explore/?account=account_name&file=file_name&program=program_nameIn addition the content of the http request is a string representing a JSON object. Under this situation I was exp

Hi I would like to find out where can I download or find any D3 training documentation or material.I'm from a Universe Basic background and would like to learn D3.Regards,Thando Ngayi------------------------------Thando NgayiAxiz------------------------------

HI,I am looking for some help for JDBC Driver response. When our DBA queried the table and got response as below CLAIMS......... Descrip... Doctype... Clmtype...   06040240*09*005 LMCA INFAR C          P                CTION06089078*17*009 01/08/2017 C          P                -31/08/201                706180956*20*004 03.05.20-0 C          P                2.06.20 SE                IZURES06305773*21*001 01/06/2021 C          P                 - 22/10/2                021 However when we run SQL Query using JDBC, getting the response as below.SELECT ID,DESCRIP,DOCTYPE,CLMTYPE FROM CLAIMS SAMPLE 4;ID,DESCRIP,DOCTYPE,CLMTYPE1: "0", "L",    "C",    "P"2: "0", "0",    "C",    "P"3: "0", "0",    "C",    "P"4: "0", "0",    "C",    "P"The data is not returning as same as above. Can someone help?------------------------------Elayaraja KathirvelRocket Forum Shared Account------------------------------

Can someone help for GUI tools (like SQL Server Management studio) for Universe DB? So that I can see list of tables and contents?------------------------------Elayaraja KathirvelRocket Forum Shared Account------------------------------

There are 4 prefixes allowed to be used when globally cataloging programs: "$"  // Used for custom conversion codes (which need to support the call signature "(ANS,STATUS,InputData,TYPE)" "*"  // Globally cataloged programs the command processor will run as a normal main BASIC program "-"  "!" The "-" and "!" are used by subroutines supplied with UV.Does anyone know if there are specific features/functions for the "-" and "!" prefixes, or are they just available to be used and have no specific handling?Does anyone know if the "$" and "*" prefixes have other behaviours/constraints?Thanks------------------------------Gregor ScottSoftware ArchitectPentana Solutions Pty LtdMount Waverley VIC AU------------------------------