Rocket® U2 | UniVerse & UniData®

HelloI am testing the new-ish 'DT' conversion code in UV 11.3.5 (on RHEL8) and am having no success getting it to do what seems like simple conversions. I put together the following test code to give it a go: -- * Testing the new DT conversion code sys.VAL     = system(99)now.VAL     = now()local.VAL   = datetimel()utc.VAL     = datetimez() crt "NLS status : ":oconv(system(100),"S;'On';'Off'")crt "system(99) : ":sys.VALcrt "now()      : ":now.VALcrt "local      : ":local.VALcrt "utc        : ":utc.VAL lst.TESTS = ''lst.TESTS<-1> = "O": @VM: sys.VAL: @VM: "DT"lst.TESTS<-1> = "O": @VM: sys.VAL: @VM: "dt"lst.TESTS<-1> = "O": @VM: now.VAL: @VM: "DT"lst.TESTS<-1> = "O": @VM: now.VAL: @VM: "dt"lst.TESTS<-1> = "I": @VM: local.VAL: @VM: "DT"lst.TESTS<-1> = "I": @VM: local.VAL: @VM: "dt"lst.TESTS<-1> = "I": @VM: utc.VAL: @VM: "DTIS"lst.TESTS<-1> = "I": @VM: utc.VAL: @VM: "dtis"lst.TESTS<-1> = "I": @VM: local.VAL: @VM: "DT"lst.TESTS<-1

For those wanting to learn MVIS, I have created two (free) step by step guides to creating an MVIS/REST backed website. The first of these uses Vue 3, which is arguably (well I will argue) the most friendly of the client side typescript style of web frameworks, and the second uses Microsoft's .NET Blazor so you can take your pick. The guides will work with the U2 Trial Editions and the software is free. Some knowledge of TypeScript or C# would be useful but you can probably follow on without it. I've posted these on the new Rocket Innovations section, or you can download them from the Free Training section of my website (www.brianleach.co.uk). Have fun and good luck!------------------------------Brian LeachDirectorBrian Leach ConsultingChipping Norton GB------------------------------

A couple of posts outlining how I go about importing and exporting things, I use /etc/passwd as the example as I needed a script to move some users over. I have a bash script to do this but moving more of my workflow into Pick is my goal.  Importing into Pick: https://krowemoh.com/devlog/importing-linux-files-into-pick-.html Exporting out of Pick: https://krowemoh.com/devlog/exporting-pick-records-to-linux.html ------------------------------Nivethan ThiyagarajahProgrammerAsynchron Systems IncToronto ON CA------------------------------

Hello all - we are switching from one box (unix) to another (linux). We have some programs that check server IP, hostname, uname - to know if the user is addressing our test or production environments. Our question is does anyone know of a Unidata environment variable that holds this type of information we could query easily? Thanks for any ideas! Kathleen------------------------------kathleen hambrickProgrammerRocket Forum Shared Account------------------------------

Greetings all! Attempting to: Create a list in PROC Call a catalogued Basic program Using PROCREAD in that Basic program in a LOOP/REPEAT construct Expecting the PROCREAD would pop off list elements until exiting the LOOP/REPEAT construct. To date, I haven't been able to get any data passed.  Does anyone have the mojo to get this bugger working? THX in advance for y'alls always great advice! ~Doc

hi everybody, I search a solution to read the locks info when I'm in a transaction ! I need it to act correctly on LOCKED clause..  OPEN 'MD' TO F ELSE STOP TRANSACTION START THEN CRT 'TR OK' READU R FROM F,'EFV' ELSE R = '' EXECUTE 'LIST.READU' EXECUTE 'PHANTOM LIST.READU' EXECUTE 'SH /C smat -r' EXECUTE 'ANALYZE.SHM -r' TRANSACTION ABORT RELEASE F,'EFV' the runtime says :  12 RUN EFVPROGS TESTTRANS TR OK Verb "LIST.READU" illegal when a transaction is active. Verb "PHANTOM" illegal when a transaction is active. Verb "SH" illegal when a transaction is active. Verb "ANALYZE.SHM" illegal when a transaction is active. Is there a hidden SYSTEM(?) to retrieve the LIIT.READU / list_readu / smat -r output ?  (I can perform all READU before TRANSACTION START and if LOCKED perform what I need but I'm into a generic subr

The latest PE version is 8.3.2 I believe, is it possible to get a PE version of 8.2.4 if not I can work with 8.3.2 just asking as the version we are using in production is 8.2.4  and I would like to stay with our production version but if not that ok, just asking. thanks dougc------------------------------Doug ChancoUniverse ProgrammerSelf Registeredgraham NC US------------------------------

Hi All, We are facing issues with deferred server wherein we can see the error as "Subscriber has no alive RWs(2358)!". Could you please suggest what could be the possible reason behind this error. Thanks! ------------------------------Shubham NigamRocket Forum Shared Account------------------------------

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