Rocket MultiValue

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

I have been struggling this for a few days now. This works of course in Terminal. When you right-clock on a program in VSCode, the bottom  two menu items are Catalog and Compile. I have researched this and it would seem several configurations need to be in place.  I do have the ssh configs set up, the BP file in the workspace, but it never finds the file or the program. Does anyone have the steps to rectify this? Thanks in advance,  Roy.

I read through the documentation and compared it to what I am seeing on the system. There is a DEVICES record called OKIDATA.  This has control character definitions and such. In the USER-COLD-START, there is a STARTPTR 0, 0, 0, S13 & STARTPTR 1, 1, 0, S10 and other for the rest. There is also an ASSIGNFQ 1,OKIDATA (C If I do LISTPTR I have several printers, 0, 1, 2, 6 and 7 and all say serial and DEV or PROCESS # is 13, 10, 11, 14 and 9.On the server itself, the OKIDATA printer name is OKI-C711-DCA9AC. How is the OKI-C711-DCA9AC assign to the OKIDATA?  I am thinking it is something to do with a configuration somewhere for the Dev or Process, but not sure what.  Any help would be greatly appreciated.------------------------------Troy DittbernerPresidentNorthstar Data Services IncBrooklyn Park VA US------------------------------

🧠 Jump to Top in Multi-Value Fields – A Simple Trick to Loop Input Have you ever faced the challenge of designing a screen with a fixed number of multi-value lines, and wanted the cursor to jump back to the top once the last line is reached? For a long time, I couldn't find a way to do this. But now I've discovered a simple trick-and I'd like to share it in case someone else has the same need. 🔧 Scenario Imagine you have a screen like this: You want the cursor to jump back to the first line when pressing <Enter> or <Down> on the fourth line. 🛠️ How to Implement It In the Process Before of the MV field, set: (P:@REFRESH = -2) In the Controlling/Dependent Options, press F3 on Control/Dep/Read and enter the following in Process on MV Disp: 4 is the number of maximum MV lines you want. the 1 in /1.1 refers to the StepNo of the field you want to jump back to (in this case, line 1 of field 1). 💬 Final Thought I just wanted to share this idea with the SB community-thanks

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

Hello, In MV Basic for Visual Studio, can you compile within the program?  For example in Accuterm WED your press F10 and it compiles displaying any errors or a successful compile.  Thanks.------------------------------Peter GonzalezSt. Louis, MO US------------------------------

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?