Rocket MultiValue

Updating the D3 patch list yet again! In order to help the D3 community stay informed about when patches become available, we will be using the Rocket Forum to announce the availability of new D3 patches and service packs, so make sure that you check back often, or better yet, make sure you receive email notifications from the Rocket Forum. And if you have any questions, please reply to THIS thread, NOT the previous ones! Here's a list of D3 platforms/versions and their current patch levels: D3 AIX 10.3.4D3 AIX 10.3.3: Monitor M8, Flash F3, ABS A14, Install I3D3 AIX 10.3.2: ABS A14D3 AIX 10.3.1: ABS A14D3 AIX 10.2.0: Monitor M1, ABS A82 D3 Linux 10.4.0 ("port" alpha has been removed)D3 Linux 10.3.4*Certified on RedHat, Rocky and Alma v9D3 Linux 10.3.3: Monitor M8, ABS A14, D3_setup_sub*Note that D3_setup_sub will allow D3 Linux 10.3.3 installation on Rocky and Alma Linux v8.xD3 Linux 10.3.2: ABS A14D3 Linux 10.3.1: Monitor M2, ABS A14D3 Linux 10.2.0: Monitor M18, Flash F9, SQL S3, ABS

Hi everyone,How can I use d3py in my Python applications outside of my "d3 box"?I mean, I have created a Python application in my d3 server, and it runs fine using the import d3py, but I want to use it in my Web Server to create my Web App or API endpoint, I have errors to importing d3py outside from my d3server, it says not found the module d3py.How can I implement a Python application with d3py outside of my (D3/Win) Pick server box? It doesn't work moving manually the files or making a map drive.Thank you,

We are running OpenQM 4.0.8 on W2019 in Azure. We are running an Apache web server on a private separate server outside of Azure. we are having what we consider slow and variable response times. we have added a considerable amount of tracking but are unable to find the bottleneck. we are use PHP page to call a function that gets data from the QM server. we are using a http call from the PHP function we call:    (we have 20+ of these calls for different information), for instance: http://web.xyz.com:8280/api/getpurp?fnme="obj.maint" we know that the pageload (and function call) is taking 1.723 seconds. We have tracked the QM side at 8ms. we have looked at the flush time in QM   and tried WFLUSH to make sure that buffering the response is not part of our problem. we are trying to make sure that we don' t have virus checking software causing delay on the W2019 machine we are looking for best practice here. do people use a private tunnel between webserver and DB server ? do people put

I'm pleased to announce the release of MultiValue Integration Server (MVIS)  1.3.3.0. MVIS 1.3.3 is the third maintenance release in the last 18 months. Some of the key highlights in 1.3.3 are: Java 11 support - MVIS now supports Java 11 in addition to Java 8. Support for user defined topic prefixes on Azure service bus - This enhancement provides a way to support multiple mvis/admin pairs on a containerized installation of MVIS, reducing the cost of deployment on Azure (since it removes the requirement for one service bus per MVIS instance). Support for Alpine Linux 3.18 - We've upgraded MVIS containers to the latest version of Alpine Linux, v3.18. 1.3.3 includes 8 bug fixes (refer to the release notes for details) MVIS product lifecycle dates: 30 Jun 2023 GA 30 Jun 2026 EOM 30 Jun 2027 EOS 30 Jun 2028 EOLS ------------------------------Hernando BordaProduct Manager, MultiValue ToolsRocket Softwarehborda@rocketsoftware.com------------------------------

MultiValue Integration Server version 1.3.3 has been released on June 30 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, please

One of my customers has declared end-of-life on their Windows 2012 server upon which we have run 11.3.1 for 10 years or so.?? The new server will be Windows 2022.?? 11.3.1 is not listed as certified for 2022 server.?? Can I have the IT department move our 11.3.1 system to the 2022 server and then install the 11.3.5 to which we are upgrading while we continue to operate on the old server??? Will programs have to be recompiled and recataloged on the new server or will the map still be valid??? Has an upgraded python been included with the UniVerse download and will it be added or replace the current python?Thanks,Dale

Is there a target date for MVIS 2.o release? Any early info on what improvements/changes/enhancements it might contain?------------------------------Nelson SchrothpresidentC3CompleteShop LLCHarrison OH US------------------------------

I have 1.3.1 installed in a test environment. Installation was a real pain since the documentation for the correct version of Java and Python were incorrect in the docs. Thank heaven for Rocket support! We wanted to use Azure for our OAUTH bearer token (like we do through Postman), but could never figure out how to do that in 1.3.1. With Rocket's assistance, we got things working using KeyCloak. I have found 1.3.2 release notes and user guide, but cannot see if anything changed to resolce the above problems. 1) does 1.3.2's zip bundle contain the Python and Java versions that are required? 2) can Azure be used for the Bearer token (OAUTH), and if so how? Would appreciate someone pointing me to some more complete docs that may cover these topics. Thanks in advance.------------------------------Nelson SchrothpresidentC3CompleteShop LLCHarrison OH US------------------------------

We are in testing a new server where we've installed jBASE 5.8.  We migrated everything from the old server running jBASE 5.7 and are concerned about indexes. Although we rebuilt all the indexes the LIST-INDEX command does not display the indexes on jBASE 5.8 Using the INVOICE file as an example, on jBASE 5.7, "LIST-INDEX INVOICE" displays the following: INDEX definitions for file INVOICE at 11:22:28  06 JUL 2023          PAGE    1 INDEX NAME LOCALE NAME SORT KEYS. LOOKUP.... INDEX DEFINITION................... @18        C           AR         D2/        BY-AR OCONV(19,\\D2/\\)@28        C           AR         D2/        BY-AR OCONV(32,\\D2/\\)@29        C           AR         D2/        BY-AR OCONV(33,\\D2/\\)@3         C           AL                    BY 2@50        C           AL                    BY 50A154       C           AL                    BY 154A19        C           AR                    BY-AR 19A210       C           AR                    BY-AR 210A32        C          

hi folks, I hope someone can help me.  First, I want to add pypi.org packages /modules and have it available to import on script.py executed from RUNPY or BASIC py function. How to do it fom within  Universe ?  Second, I want to distribute our own modules with my basic application. (It's a type19 file (directory) with .py files, each one is a 'module'.) how to deploy it into u2python ?  many thanks------------------------------Manu Fernandes------------------------------

We have a need to create a single URL RESTful service that will give a different response for GET and POST queries. For GET, the service just echoes the data passed, but for POST it must return data from the database in JSON format. I created an "endpoints.yaml" to create the GET, but have not found any way to create a single URL that answers both GET and POST and treats them differently. So we might have, for example, a call to the URL: http://testapi.mbs.net.au:7171/APP/subroutine/TESTSUB?responsecode This would be expected to simply return the string "responsecode" as specified in the URL. However, if data is POSTed to the same URL (minus the "?responsecode" part), then JSON containing database information would be returned. I've tried various things in endpoints.yaml but have had no success. Can the above be accomplished in MVIS and, if "yes", how would we go about doing it?------------------------------Martin ShieldsSenior Technical ConsultantMeier Business Systems PTY LTDCarnegie

Hello , I have been installing and checking MVVS for a few days now and I have a questions , problems :   - GO TO DEFINITION function - always returns "No definition found for '' " - GO TO REFERENCES function - always returns "No references found for '' ".   do i need to set something?? Displayed functions:

Hi, I am trying to build a JSON object using UDO functions. How do I format numeric values to display 2 decimal values, by default the output is either an integer or 6 decimals. Below is a snippet of test code and the output generated:          name = "capitalBalance"      value = 672.500      OBJNAME = udoHeaderData      GOSUB BUILD_JSON_OBJECT            name = "amountAvailable"      value = "617.00"      OBJNAME = udoHeaderData      GOSUB BUILD_JSON_OBJECT            name = "arrears"      value = 77617.00      OBJNAME = udoHeaderData      GOSUB BUILD_JSON_OBJECT       name = "advance"      value = 0.00      OBJNAME = udoHeaderData      GOSUB BUILD_JSON_OBJECT        name = "interestAccrued"      value = 0.27      OBJNAME = udoHeaderData      GOSUB BUILD_JSON_OBJECT       name = "installmentDue"      value = "15437.01"      OBJNAME = udoHeaderData      GOSUB BUILD_JSON_OBJECT            GOSUB TEST_AND_DISPLAY_OBJ      RETURN BUILD_JSON_OBJECT:      ST = UDOSetProperty(OBJNAME, name,

we are working on D3 to QM conversion.  The client had a number of select statements that use wildcards. we already know, and are converting to "pattern matching" from QM. The square brackets all still work.  Is there any characters to use similar to D3      with part.nbr = "A^^3^^" The up carrot was a wild card character for a single character. I have been searching the online docs, but have not found it. (like most docs, if you know what you are searching for, it is easy)------------------------------Jesse TilliaRocket Forum Shared Account------------------------------

in my phantom log  I saw the msg  cp: failed to close (specific file name), I looked at the file checked permissions and  everything looked good. In the program it processed all of the previous files with no errors. the last for file showed these errors. the programs are running on 15 different server and none of the other servers have this issue. comments? help? Thanks, Theo

Another frustrating problem I need some help with.  Added a new laser printer, wired ethernet connection. jBase 5.8.5 on Windows 10 Multi-page program output now prints 60 lines on page 1 , 4 lines on page 2, 60 lines on page 3 and so on.  There is no way to set a default line/page on the printer.  I've tried using TERM to change the printer length to 56  and tried creating a formtype with the shortened length but neither worked.  How do I "override" or work around the misplaced formfeed?? Thanks, Marc------------------------------Marc ZitcerPresDavidson SupplyPaterson NJ US------------------------------

Hi All -  I just found on our system that exiting a program does not clear an active select list. Im unsure if this is universe specific as I did not have to clear select buffers in Unidata, but this has shown to be an issue here. There is a basic CLEARSELECT statement just as there is at TCL. Is that a standard for anyone running Universe? To use CLEARSELECT in your programs? Do you use it generically when entering or exiting a program?  And now that I've seen this - what other pieces should I be on the lookout for that are saved between programs by user? Obviously named commons and passed variables but...any like this savedlist that might not be obvious? Lastly, is there an alternative to changing the code? Like an option I could set at tcl or in code that clears the buffers when exiting a program? Thanks!------------------------------Kathleen HambrickProgrammer at Colwell------------------------------

I'm trying to work out the correct syntax for the "select" option to "limit the returned results" when testing in Swagger using a UniVerse database as the data source. For example, I have a date field and want to select all the dates in a specific year. Is there some documentation that details how this works? I've tried standard UniVerse syntax, standard SQL syntax, but neither of these seem to do what I want to do.

AccuTerm version 8.1.0.0 has been released on June 30 2023 for the below platforms/versions:Windows       Windows 10,  Windows 11,  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, please contact rbc@rocketsoftware.com.

I'm pleased to announce the release of AccuTerm 8.1.0.0 This is the first GA release of AccuTerm as part of Rocket. Most importantly, the product now follows a unified Go To Market for the multiple components of AccuTerm. AccuTerm Desktop and AccuTerm.IO (or AccuTerm web) are now released together as one product with the same version numbering.  There are numerous defect fixes and enhancements that will continue to bring the product forward. Some of the key highlights are: AccuTerm web support for on-premises deployment. This will allow customers to deploy the browser based AccuTerm on their own hardware without depending on the hosted version of AccuTerm.IO. SSO support. AccuTerm can now be configured to use single sign-on and rely on the Windows user credentials to authenticate with an MV application server. Improved GUI for AccuTerm web. This release contains multiple enhancements to bring the GUI on a browser to parity with the AccuTerm desktop version. Security Certification. 8.1

All, I use chatGPT+. I asked it to write a multivalue basic program to calculate a loan payment. This is the result. 0001: PROGRAM LoanPayment0002: PRINT "Enter the loan amount: ";0003: INPUT LoanAmount0004: PRINT "Enter the annual interest rate (as a percentage): ";0005: INPUT AnnualInterestRate0006: PRINT "Enter the loan term in years: ";0007: INPUT LoanTerm0008:0009: MonthlyInterestRate = (AnnualInterestRate / 100) / 120010: NumberOfPayments = LoanTerm * 120011:0012: IF MonthlyInterestRate = 0 THEN0013:    MonthlyPayment = LoanAmount / NumberOfPayments0014: ELSE0015:    MonthlyPayment = LoanAmount * MonthlyInterestRate * (1 + MonthlyInterestRate) ^ NumberOfPayments / ((1 + MonthlyInterestRate) ^ NumberOfPayments - 1)0016: END0017:0018: PRINT "Monthly payment: ", MonthlyPayment 'R2'0019: END It took a bit of cajoling but within three corrections this was the end result. Does anyone have a BNF or ANTLR definition of the BASIC language? I'd like to feed it into chatGPT and see how it i

Intermittently, we are getting the following error message when updating large files.  The files check out OK in jBase and using chkdsk.    Running 5.8.5 on Windows.  Application programs have not been changed in years. Dynamic files READ error number 2007 at position xx:xxxx, File '\\xxx', item id 'xxx' Error 2007 during READ_ERROR to file xxx Enter I to Ignore.... When this happens, I do a 'select' of only the records that reference that particular item.id and re-run the program.  The item will then update properly!  Short term, is there a way to capture the error messages and bypass the prompt so as not to have to interrupt the operation and allow the program to run to completion?  Any diagnostic help would be appreciated. Marc------------------------------Marc ZitcerPresDavidson SupplyPaterson NJ US------------------------------

hello,  when we define a function like  def funcname(a,b,c); return (a * b + c) Can we use keyword argument syntax when calling a method/function ?  like PyCallFunction("module","funcname",a=1,c=2,b=3)   or is it mandatory to use positional argument ? PyCallFunction("module","funcname",1, 3, 2) ?  many thanks------------------------------Manu Fernandes------------------------------

    Key Takeaways:Do not use dimensioned redimensionable-array elements for EXECUTE variable targets for CAPTURING, RTNLIST and SETTING and variable sources for PASSLIST.The areas of concern:1. Information style redimensionable arrays may change size in the executed program.2. Arrays of either flavor compute to a temporary in a PASSLIST that gets overwritten by constructing the command string in a concatenation. This UniVerse bug results in the command string passed to the command as the select list.  Environment:UniVerse 11.3.1.6022Fedora Linux UniVerse supports two kinds of array.  Pick sytle arrays have fixed dimensions at compile time. Each element of the array takes one VARTAB (variable table) slot. VARTAB uses an unsigned short for an index which limits the total number of slots in a compilation unit, program or subroutine, to 64K elements. (This limits an array to a maximum of 64K elements.) Information style arrays specify dimensions at run time and may change and consumes only

My application seems to be blocking the ssh connection from Visual Studio Code to my Linux server. With other Rocket products the user is identified as terminal, phantom, uvnet, etc. Is there a special type for the login from MVVS?