Rocket® U2 | UniVerse & UniData®

Hi all We're doing some development on an internal test server which, unfortunately, has some expired certificates: The code: RESPUESTA=protocolLogging(NOM.FIC.LOG,'ON',10) RESPUESTA=setHTTPDefault('VERSION',VERSION) RESPUESTA=createSecurityContext(SECCONTEXT.HANDLE, PROTOCOLO.SEGURO) RESPUESTA=addAuthenticationRule(SECCONTEXT.HANDLE, SSL_CLIENT, SSL_RULE_SERVER_NAME, SERVER_NAME) RESPUESTA=addAuthenticationRule(SECCONTEXT.HANDLE,SSL_CLIENT,SSL_RULE_STRENGTH,'generous') RESPUESTA=createSecureRequest(URL.SERVICIO,TIPO.LLAMADA,HTTP.HANDLE,SECCONTEXT.HANDLE) MAX.CAB=DCOUNT(DATO.CABECERA,@VM) FOR C=1 TO MAX.CAB RESPUESTA=setRequestHeader(HTTP.HANDLE,DATO.CABECERA<1,C>,VALOR.CABECERA<1,C>) CRT ' Pasa dato en header [':DATO.CABECERA<1,C>:'] [':VALOR.CABECERA<1,C>:'] [':RESPUESTA:'] ' IF RESPUESTA#0 THEN GOTO 90 NEXT C RESPUESTA=setHTTPDefault('BUFSIZE',DIM.BUFFER) RESPUESTA=submitRequest(HTTP.HANDLE,TIME.OUT,'',CABEC

This came up on Youtube today. Weird having this subject come  up on one of my channels. https://www.youtube.com/watch?v=pWZBQMRmW7k------------------------------Joe GoldthwaiteConsultantPhoenix AZ US------------------------------

Hey all:Windows Server 2016Version 8.3.2, Build 2000UDT Configuration: Server, 64-bit(x64)The manual provides the following syntax for RESIZE: RESIZE {DICT} filename modulo {DYNAMIC | STATIC} [BLOCK.SIZE n]D_FUND_ADVICE.LIS recommends we resize DICT FUND.FILE from 7 to 13 and BLOCK SIZE from 1024 to 4096. udtconfig shows SHM_LBA=4096. Yet when I try to resize, this is the result: RESIZE DICT FUND.FILE STATIC 13 BLOCK.SIZE 4096-------------------------------^syntax error RESIZE DICT FUND.FILE STATIC 13 BLOCKSIZE 4096-------------------------------^syntax error What am I missing? ------------------------------Rich LucibellaDirectorRocket Forum Shared Account------------------------------

We are trying to connect our UniVerse (11.3.1.6022 running on AIX 7.2) to Klavyio to send emails. The following works fine from Postman but the authorization line fails from U2 BASIC.  We have tried multiple variations with no luck. Seems like the SETREQUESTHEADER does not support this AUTH.CODE value. Any ideas are appreciated. Here are the essential code lines: POSTURL = ENDPOINT                 <-- actual web address POSTTYPE = "POST" CONTENTTYPE = "application/vnd.api+json" TOKEN = BRAND.API.KEY            <-- proper key for specific web brand  AUTH.VALUE = "Klaviyo-API-Key ":TOKEN   RESULT = CREATEREQUEST(POSTURL, POSTTYPE, REQ_HANDLE) returns RESULT=0 RESULT = SETREQUESTHEADER(REQ_HANDLE, "Content-Type", CONTENTTYPE) returns RESULT=0 RESULT = SETREQUESTHEADER(REQ_HANDLE, "Accept", CONTENTTYPE) returns RESULT=0 RESULT = SETREQUESTHEADER(REQ_HANDLE, "Host", "a.klaviyo.com") returns RESULT=0 RESULT = SETREQUESTHEADER(REQ_HANDLE, "Authorization", AUTH.VALUE) returns RESULT=2---

Folks-I don't know how many have sought AI assistance with UniData but I'm finding Grok to be a game changer. ChatGPT's knowledge of UniData and UniBasic is rudimentary at best. Its ability to change behavior based on previous errors and corrections is frustratingly non-existent.Not so with Grok. From UniData Administration to UniBasic, its base level knowledge is light-years ahead. It also has the ability to recall previous exchanges, learning as it goes. Finally, I've uploaded the key Guides and Manuals and it will actually spit out Guide and Page number in a response. I am absolutely blown away (and just a little frightened) at how fast this industry is moving.Rich------------------------------Rich LucibellaDirectorRocket Forum Shared Account------------------------------

I'm fairly new to the UV world, and a coworker installed a trial version of UV and then had to have emergency surgery so the project was placed with me. I'm trying to sset up a uv database, but i can't seem to find or create a proper bp directory file for basic source code, and I can't type in lowercase at all, all myh input gets converted to uppercase. I've tried turning CASE off but it still converts. Can we default to a lowercase easily?

Hi, I need some assistance with my u2 installation of python. UV14.1.1/Windows - python 3.11.1 is installed under c:u2uvpython. I want to install and use a third party python module(s). However, using:  >python -m pip install wonderwords gives me an error ERROR: Exception: ... ImportError: cannot import name 'RequirementInformation' from 'pip._vendor.resolvelib.structs' (c:u2uvpythonLibsite-packagespip_vendor esolvelibstructs.py) How should I resolve that? Should I reinstall something? Also, is it possible to use virtual python environments with the u2 python configuration? It seems I can create them but I'm not sure how to activate it from within UV.  Thanks Stuart

We're excited to announce the availability of the Rocket® MultiValue Developer Assistant. This AI-infused assistant enhances MV BASIC proficiency and developer productivity. See below for key features and requirements. For more details, read the Developer Assistant datasheet and register to gain access. The MultiValue Developer Assistant version 1.1.0.0, integrated within the VS Code® Integrated Development Environment (IDE), allows you to: Generate MV BASIC code via natural language queries. Autocomplete MV BASIC code. Explain MV BASIC code in natural language. Generate comments for existing MV BASIC code. Developer Assistant essential information: Program delivery: Hosted by Rocket Software in AWS and free with an MV data server (UniVerse, UniData, D3, jBASE, or OpenQM) serial number on active maintenance. Requirements: Visual Studio Code and internet access To sign up, please complete the registration form. Check out the product availability matrix in Rocket Business Connect (

Hey folks-The following command:guide REMAD.FILE -aproduces this result for GUIDE_STATS.LIS:______________________ REMAD.FILE  Basic statistics:    File type............................... Dynamic Hashing    File size      [dat001].............................. 1073741824      [dat002].............................. 1073741824      [dat003].............................. 1073741824      [dat004].............................. 1073741824      [dat005].............................. 1073741824      [dat006].............................. 271676416      [over001]............................. 1073741824      [over002]............................. 1073741824      [over003]............................. 97075200    File modulo............................. 5508183    File minimum modulo..................... 10007    File split factor....................... 75    File merge factor....................... 40    File split/merge style.................. WHOLEFILE    File hash type.......................

Hi, Is it possible to connect to MQ using LDAP in Unidata 8.2.4. if not, is there any work around to connect and post messages? We are upgrading our IBM MQ version to 9.3 so we are changing the authentication to LDAP CSP and send username and password for authentication. Is there a way for Unidata to accommodate these changes? Any reference to documentation or any inputs will be greatly appreciated. More simple question should be can we use MQCONNX to connect to MQ in Unidata? Regards, Unidata Enthusiast

Greetings folks! Is it possible to call a basic subroutine that returns a counter and items associated with that counter such that someone in PROC could use the counter to pass the item associated with it? THX! ~Doc------------------------------Doc RuckelPart time programmerRocket Forum Shared Account------------------------------

Hi All, Is there any way we can sync the publisher and subscriber, we know there is a sync command which is sometimes helpful but doesn't help us when the replication system is DISABLED.------------------------------Shubham NigamRocket Forum Shared Account------------------------------

As more and more customers are using U2 Replication, they have inquired about how to ensure that our subscriber is synchronized with our publisher and not missing any updates. It is imperative for customers to have trust in the accuracy of the subscriber's database copy. This confidence is essential for relying on it in the event of a failover or for uninterrupted business reporting. This utility offers a continuity check between the publisher and subscriber files for U2 Replication, empowering customers with the confidence they need. The utility and the documentation are available from our knowledge base, by searcing for Article Number 000055107 , or for the description 'U2 Replication File Checker' or using this link https://my.rocketsoftware.com/RocketCommunity/s/article/U2-Replication-File-Checker The utiltly has undergone a closed beta and will initially be maintained by myself and updated via the knowledge base article before making it's way into UV and UD. All feedback is welc

Using the CREATE statement after an OPENSEQ statement to create a record in a type-19 file, we are getting below error in uvrw.errlog (Universe replication). Sample source code: May I know what could be the possible reason for the above error. ------------------------------Shubham NigamRocket Forum Shared Account------------------------------

I have a subroutine that is compiled and cataloged. It gets call by some phantom processes. Periodically a phantom process dies because it cannot load the subroutine. What else can prevent universe from loading the subroutine besides not being compiled and cataloged? Update to the original post:  I have found the error for a common size mismatch but I am not sure why because it will run for hours processing many records without an issue.

MTS returns 13:37:42, but with sending data to SQL, multiple timestamps have the same value. Is there a way to get miliseconds?  We are transmitting multiple records and many would have the same "42" second value. Our best solution is to get the MTS value and add the decimal portion of U2 internal time to it.   For example, if raw time is 49062.2004, MTS retruns 13:37:42. before sending to SQL, we would change it to 13:37:42.2004 SQL date field would get "2025-07-25 13:37:42.2004" which it may not like. Any suggestions?

Hi,  I'm looking to find out if it's possible to install a python module in UV. We are currently running UV 11.3.4 with Python 3.9 embedded. We've had a request from our development if pytest can be added to what we currently have installed? Has anyone had any experience installing this module, and were there any adverse consequences that effected Python as a whole? Thanks, John Koonce

I have a python script that uses the "requests" package. When I run the Universe program that calls the function I get the "requests" package not found. I then created another python script that calls the python script that contains the "requests" package and it works when I call that script from Universe.  I must have something wrong in my path setting when coming from Universe and it cannot find the "requests" package. If I run the python script in Linux the program executes perfectly. If I invoke python from universe and import requests it works fine and finds the requests package. Both scripts are in the default location /XDEMO/PP. u2.pth /usr/ibm/bin/usr/ibm/XDEMO/PP Universe program:  SUBROUTINE SUB.BASEVEHICLE(VEHID,VEHOUT)       CMD = "REINIT.PYTHON OFF"       EXECUTE CMD       ModuleName = "callbaseveh"      FuncName = "getbasevehinf"       RESULT = PyCallFunction(ModuleName , FuncName, VEHID

The Chicago Distribution Center (owned by the Univ of Chicago) is looking for a Senior level U2/UniVerse programmer in the Chicago Area.  This is a hybrid position and most of the time you can work from home but it will require some time in the office which is located near 111th and I-94 (Pullman area).   The link shows certifications but they are not required.  If you're interested, you can apply using the link below. Senior Software Development Engineer Myworkdayjobs remove preview Senior Software Development Engineer Department Press Information Technology About the Department Since its origins in 1890 as one of the three main divisions of the University of Chicago, the University of Chicago Press has embraced as its mission the obligation to disseminate scholarship of the highest standard and to publish serious works that promote education, foster public understanding, and enrich cultural life. View this on Myworkdayjobs > -------------------------

When I run HASH.HELP.DETAIL APPOINTMENTS I get the following summary ---- >HASH.HELP.DETAIL APPOINTMENTS File APPOINTMENTS  Type= 5  Modulo= 149  Sep= 8      14:58:16  15-07-25  PAGE 1      138  total keys in file     578  total bytes in all keys       3  smallest key      10  largest key    4.19  average bytes per key      138  total records in file  696388  total bytes in all records    2492  smallest record    6964  largest record 5046.29  average bytes per record        0  average records per group  (optimized)    5009  average bytes per group  (optimized) Press any key to continue... ---- When I run FILE.STAT APPOINTMENTS I get the following results: ---- >FILE.STAT APPOINTMENTSFile name                               = APPOINTMENTSFile type                               = 5File style and revision                 = 64BIT Revision 12NLS Character Set Mapping               = NONENumber of groups in file (modulo)       = 149Separation                              = 8Number of r

Hi I would like to enquire when rocket would release the next version of wIntegrate, the current version is 6.4.4 is there a later version------------------------------Jorge CatalinoOwnerTecfinity CCZA------------------------------

As a valued Rocket MultiValue customer, your success is at the core of all we do. With technology evolving at a rapid pace—and security, reliability, and feature demands increasing—it’s more important than ever to keep your MultiValue Application Platform current. Upgrading is not just about getting new features; it’s an investment in your application’s future and your organization’s peace of mind.  Here are the top 10 reasons to upgrade your MultiValue Application Platform annually:  10. Reduce Third-Party Compatibility Surprises: Staying current minimizes the risk of unexpected issues as third-party vendors update their software. Rocket puts every major update through rigorous compatibility testing, ensuring support for contemporary platforms and documenting all changes.  9. Upgrade with Confidence in the Future: Incremental upgrades are simpler and less disruptive than major, infrequent leaps. By upgrading regularly, you minimize the gap between versions, allowing easier test

Hi All,Query regarding replication:We are aware there is an EXCLUDE_FILE config in repconfig which can be used to exclude a file but we are not looking to exclude all the records of that file instead just a single record of that file which is created every morning.Kindly suggest if there is any way to do so.------------------------------Shubham NigamRocket Forum Shared Account------------------------------

Greeting folks! Are any of y'all of anyway to include Excel formatting characters in a CSV file? THX in advance for your helpful replies! ~Doc ------------------------------Doc RuckelPart time programmerRocket Forum Shared Account------------------------------

I updated my ssl certificate on my target server.  It has been working great.  I am using this chunk of code to call it:    st2 = createSecurityContext(ctx2, "TLSv1.2")   st2 = createSecureRequest(purl, pmethod, pobjRequest, ctx2)   st2 = setRequestHeader(pobjRequest, "OPPSAUTH",AUTH)   st2 = setRequestHeader(pobjRequest, "OPPSSERVER",SERVER)   st2 = setRequestHeader(pobjRequest, "Content-Type","application/json")   st2 = submitRequest(pobjRequest, 5000, POST.DATA, pheaders, pdata, httpstatus)I reissued my cert and updated it and now when I try to call the server, I am getting:  1896:error:14090086:SSL routines:ssl3_get_server_certificate:certificate verify failed:.\\ssl\\s3_clnt.c:1258:I tried to do some testing by copying the program and simplifying it and when I compile, it give the same error the first time I compile it, but then it will compile, but still does not work.If I put the old cert back, it works fine again.  I also tried calling a different server and that works fine as