Rocket MultiValue

This is for a UNIVERSE environment. I've tried setting the account to use in servers.mvbasic.json, as it is using XDEMO by default at the moment which causes the authentication process to fail. I need to manually specify which account is used. Looking at the logs, it appears this is passed in during the "connect U2 start" stage as accountName, but both this and account seem to have no impact. Is this controllable? 

Enhancing Your Development Experience with New Features and Fixes in Rocket Software MV BASIC for VS Code 2.7.0 In the ever-evolving world of software development, staying ahead of the curve means continuously improving tools and workflows. We're excited to announce several new features and enhancements that will significantly boost your productivity and streamline your development process when using Rocket Software MV BASIC for VS Code. Separate Compile and Catalogue Option One of the standout features in our latest update is the separate compile and catalogue option. This enhancement allows developers to compile their programs independently from cataloguing them. By decoupling these processes, you gain greater flexibility and control over your development workflow. This means you can compile your code, test it thoroughly, and only catalogue it when you're confident it's ready for deployment. This separation helps in reducing errors and improving the overall quality of your software.

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

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

Does anyone know of a quick way to print from OpenQM (Windows) on a HP OfficeJet Pro 9120e Series printer?------------------------------Jack YatesCIO/ConsultantUnited Refining CompanyWarren PA US------------------------------

Greetings, y'all! Is anyone aware of ERP/MRP systems available to the automotive aftermarket or performance auto parts? As always, thanks for your helpful replies... ~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------------------------------

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

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 Guys, So we're migrating to D3 we have had initial success following the online documentation but just wondering if anyone else out there has done the same and has any tip or advise for a smooth transition. Thanks in advance Steve------------------------------Steven ReidDeveloperSandiford Solutions LtdManchester GB------------------------------

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

Hi sb users, I'll share a vsCode extension to edit Sbparagraph code.  Use a trigger on XXPROCESS to sync P type in a Directory.  Use sftp/sync to have it on the client Edit your code Use a ssh RUN program to sync back, copy into XXPROCESS, regen the process (like f2), run GC. It return ProblemMatcher info.  Capabilities : syntaxe coloris, all sb common vars, all SBExpression, all sbSubrs, Formater (indent), Hover, SignatureHelp. You can provide custom intellisensitems for Hover and Signature Help. I share all my expérience with pleasure.  Manu------------------------------Manu Fernandes------------------------------

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

Watching videos, starting to use the cli. for example, I want to find the customers table (correct my terminology if you don't call them tables).  I entered "listf" didn't see a customers table. Saw users ...entered list users..saw the system users. Cool How do I find the accounts or folder where the customers /cust table lives? If you need more info, please let me know thanks ------------------------------Bret SternPresidentRocket Forum Shared Account------------------------------

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

Recently a survey was sent to MVIS customers asking to provide the following usage information: API request volume:- Average number of API requests per day:- Peak number of API requests per day:- Total number of API requests in the past 30 days: Data volume: - Average size of data per request (in KB or MB):- Total data transferred via API in the past 30 days (in GB): Usage patterns:- Typical hours of peak usage (e.g., 9 a.m. – 5 p.m. UTC): One customer logged a support case asking how they could extract the information from the MVIS logs. I believe that the following information can be extracted from the "Perfstats_PER_REQ.log" which is created if you enable performance monitoring in all versions of MVIS. API request volume:- Average number of API requests per day:- Peak number of API requests per day:- Total number of API requests in the past 30 days: Usage patterns- Typical hours of peak usage (e.g., 9 a.m. – 5 p.m. UTC): The basic program "MVIS.REQUEST.TOTALS" (See below) should re

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