Rocket® U2 | UniVerse & UniData®

Hello! I’m relatively new to UniVerse and Multi-valued databases, so my experience with BASIC is limited.I was writing a program with subroutine calls that I wanted to abstract via ‘@<var>’. This program had a “create output file data line” subroutine and a “finalize output file” subroutine. When I wrote these local subroutines (explicitly defined, not subroutine labels), I encountered an error where, when calling with ‘@’, only the first locally-defined subroutine would be found; the other subroutine would cause a runtime error, unable to be located. It was not found locally, and so the object database file (.O) was being searched, instead.For example:* ...IS.DONE = @FALSE* Main loopLOOP READNEXT FILE.NAME ELSE IS.DONE = @TRUE ENDUNTIL IS.DONE * ... OUPUT.FILE = "" PREPARE.DATA.SUBR = "" FINALIZE.FILE.SUBR = "" * case 1 BEGIN CASE CASE FILE.TYPE = TYPE.1 PREPARE.DATA.SUBR = "DO.SOMETHING.1" FINALIZE.FILE.SUBR = "END.FILE.1" CASE FILE.TYPE = TYP

helloReally grateful for any assistance, I have been stuck on this for about 1 week now.I have SBXA working with unidata 8.1 sb+ 6.5 on windows 2012R2I have replatformed application to Windows 2022 unidata 8.3 sb+ 6.6.3i have Unidata server and separate commincation server. if i run :C:\Users\<mylogin>\AppData\Local\Apps\2.0\Y2N21CTT.YLM\D6JBB313.34V\sbxa..tion_74d57911d24a77ad_0006.0006_359984abce80fb3f\SBXAWinFxWindow.exeas administrator, intial connection fails: Unable to connect to SB/XAFailed to connect to the application because connecting to the account 'F:\AVANTE9\FLODATA\LIVE\LIVE.DATA.533' on the Application Server with address 'localhost' using U2 User ID 'IUSER\XXX' from the Communications Server failed.Details:[Rocket U2][UCINET - UNIRPC][ErrorCode=81016] The connection was refused as the RPC daemon is not runningSocket Exception caught and WIN32 API Error Code:10061 and Error Message:No connection could be made because the target machine actively refused it 127.0.0.

Hi community,Plateforme : windows server 2016, uv 14.1.1.1002, Over the past few days, we’ve been experiencing random errors on uv static files. The same error messages appear repeatedly — expected blink 0x0 or 0x10000.These errors can occur up to ten times a day and affect various files (e.g., VOC, XXPROCESS, XXPPP, etc.), the most strange is these files are mainly used for read.... To resolve them temporarily, we use fixtool -fix (at boot uv, else the files are locked). Does anybody have any idea what could be causing this?We’ve already checked our antivirus, but the problem persists.Any insights or suggestions would be greatly appreciated ;) With kind regards Manu

Follow the link below to the innovation forum. https://community.rocketsoftware.com/multivalue-innovation-library-home-11/expanding-on-universe-and-unidata-esearch-tool-to-use-python-based-regex-search-27332

Greetings all! Can someone please direct me to documentation to dictionaries in UniVerse and what each attribute is used for? Many THX! ~Doc------------------------------Doc RuckelPart time programmerRocket Forum Shared Account------------------------------

Hi everyone,  Just a quick reminder: starting tomorrow, Rocket Forum will be temporarily locked as we roll out an exciting transformation. We can't wait to welcome you back to a refreshed, more intuitive, and inspiring community experience on October 23rd. Here's what to expect: The Forum will switch to read-only mode from October 15th to October 23rd. You'll still be able to browse existing content, but posting, commenting, and liking will be paused during this time. After the improvement work wraps up on October 23rd, you'll gain access to the new, improved Rocket Forum, featuring simpler navigation, exclusive insights, and even more recognition for your participation. Important: Upon your first log in after October 23rd, you'll be prompted to reset your password. For more information about the changes ahead, please visit this page. If you have any questions, feel free to reach us at community@rocketsoftware.com. Thank you for being a vital part of our community on Rocket Forum.

Hi All, Hopefully this is a quick one, that I did not want to trouble Rocket support with. I know that UV11.3.5 is certified for Windows Server 2019, we aim to get as many of our customers on Windows onto Server 2022. However, we may have some who want to stay on 2019. To your collective knowledge are there any issues in sticking with 2019 for UV11.3.5? Many thanks.

Hi, I can see online documentation refers to The EDA SQL Server driver supports SQL Server 2014 and greater. Is there a driver to support SQL Azure. Thanks------------------------------[Darren] [Johnson] [Australia][Snr Dev Engineer]------------------------------

Hi Running uv 14.1.1 on Windows, we are waiting to receive the patch 1002 Hotfix. Meanwhile, how can we restart uvcleanupd.exe without restarting uv himself !  If I start it from a console, it works but not as a background process. Thanks for any sugg.  Manu

Do we have a version of U2 Toolkit for .NET Developer with U2.Data.Client that supports any .NET 6 or preferably .NET 8 applications? I'm struggling to find information on it.

We have an app that is using the U2.Data.Client (version 2.2.2) to call a subroutine and the app is using transactions for an orchestrated business flow. Part of this orchestration is calling a subroutine and I need to know if that subroutine is, or has a way to, operate within the transaction of the U2.Data.Client. If so, how would I get that to work?

Hey folks, Sorry for the continued PROC questions but the owner of our company loves them...groan! Question for y'all, is there anyway to create a unique list ID within PROC. like "SAVE-LIST LIST.NAME.PORT#" or ...? THX! ~Doc------------------------------Doc RuckelPart time programmerRocket Forum Shared Account------------------------------

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---