Rocket® U2 | UniVerse & UniData®

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

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

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

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

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

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

A Collaborative Hub for Modernization and Big Ideas We're excited to launch the Rocket MultiValue Innovation Library - a dynamic, shared forum where MV developers, architects, and innovators can showcase and exchange forward-thinking ideas, prototypes, use cases, tools, and more. This is your space to Share groundbreaking concepts Contribute working demos or prototypes Explore real-world use cases Collaborate with the broader MV community Whether you're looking to modernize legacy applications, experiment with new integrations, or simply spark inspiration, the Innovation Library is designed to accelerate innovation across the MV ecosystem. Join us in building the future of MultiValue — one idea at a time. Start exploring the Rocket MultiValue Innovation Library today — and be part of shaping the future of MV development. ------------------------------Christine RizzaManager, MV Product ManagementRocket Softwarecrizza@rocketsoftware.com------------------------------

Greetings folks! Is anyone on this forum doing any work in Python?  Are you converting current source code into Python? THX! ~Doc------------------------------Doc RuckelPart time programmerRocket Forum Shared Account------------------------------

Hello - I am converting our spooler programs to linux. We use the 'c' record of cups for the job info. The 'd' record stores the data of course. Here is the setptr we are using... SETPTR 0,132,60,0,0,1,AT temp,BRIEF,BANNER KH,EJECT,COPIES 1,"-s" But on linux, using strings (or 'cat') I am not seeing the 'KH' banner text. CREC=attributes-charsetþutf-8Hþattributes-natural-languageþen-usþprinter-uriþ!ipp://localhost:631/printers/tempBþjob-originating-user-nameþkhambricBþjob-nameþcopiesþfinishingsþjob-hold-untilþno-hold!þjob-priorityþjob-sheetsþnoneBþnone!þ    number-upþjob-uuidþ-urn:uuid:b94d739f-56c3-3cfa-60d2-c870b1742125Bþjob-originating-host-nameþ    localhost!þtime-at-creationþhT5,þtime-at-processingþtime-at-completedþjob-idþ    job-stateþjob-state-reasonsþnone!þjob-media-sheets-completedþjob-printer-uriþipp://linuxdev/printers/temp!þjob-k-octetsþdocument-formatþtext/plainþ on Unix (using 'cat') it is stored like this: CREC=Hh50þPkhambricþJtemp-5842þCþLkhambricþA0þBKHþOþK1þT/util/tm