Rocket MultiValue

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

As I wrote in another thread I'm connecting to a database using a custom account. The account's path is: /u2/quiter/POSVENTA5 In that path I open a file, for example: /u2/quiter/POSVENTA5/BP/ACCSCR0 Then I try to click on another definition (ACCSCR0) to open it: * Carga datos IF HAY.AUTOFILL=1 THEN CODIGO.ED=XDATO * Lee registro CALL ACCSCR1(MAT XQ,MAT XXQ,XK,XMACRO,MAT XFIELD,XA,XV,XRESUL,MAT ENTR,XSTACK) END ELSE The editor then tries to open the file in /u2/quiter/POSVENTA5/ACCSCR1 instead of /u2/quiter/POSVENTA5/BP/ACCSCR1 so it fails. How can I fix the search path for the editor? Is there a way to do something like this: https://rocketsoftware.github.io/rocket-mvbasic/usage/Catalog/ for online editing? ------------------------------Héctor CortigueraQuiter Servicios Informaticos SL------------------------------

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 (

We just upgraded one of our Universe servers to 11.4.1 and i'm trying to set up the MVVS extension in Visual Studio Code to connect to remote Universe. I installed extension Rocket MV basic version 2.7.1 set up db.mvbasic.json with: "db:{       "host": "xxx.xxx.xxx.xxx",      "userName": "xxxxxx",       "password": "xxxxxx",       "account": "XDEMO",       "dataSource": "UNIVERSE",      "port": 31438 } When I attempt to F1 -> Connect/Disconnect U2 Server,   nothing at all happens.  I see in the extension Runtime Status: Uncaught Errors (11)  Pending response rejected since connection got disposed  Client is not running and can't be stopped. It's current state is: starting  Client is not running and can't be stopped. It's current state is: startFailed  Pending response rejected since connection got disposed  Client is not running and can't be stopped. It's current state is: startFailed  Client is not running and can't be stopped. It's current state is: startFailed  Client is not run

Hi all I'm trying to connect to our database using the Visual Studio Code extension. I've configured the server data in the JSON file, but it's connecting to a XDEMO account so it's not useful to me. So, the account is XDEMO and it connects to the server in this path: "/usr/uv/XDEMO" In our database, we have several accounts: "POSVENTA5", "GEN4GL", etc. I need to connect to one of this accounts, that are in the path "/u2/quiter/POSVENTA5", etc. How can I do this?------------------------------Héctor CortigueraQuiter Servicios Informaticos SL------------------------------

Attempting to assign this click to a keybinding I guess it's supposed to be "vscode-rocket.mv.basic.command.online.server.connect" but the command registration appears to be broken... ------------------------------Stuart BoydellAU------------------------------