Browse all forums dedicated to the Rocket MultiValue product family.
Recently active
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.
🧠 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?
Hi, I need some assistance with my u2 installation of python. UV14.1.1/Windows - python 3.11.1 is installed under c:u2uvpython. I want to install and use a third party python module(s). However, using: >python -m pip install wonderwords gives me an error ERROR: Exception: ... ImportError: cannot import name 'RequirementInformation' from 'pip._vendor.resolvelib.structs' (c:u2uvpythonLibsite-packagespip_vendor esolvelibstructs.py) How should I resolve that? Should I reinstall something? Also, is it possible to use virtual python environments with the u2 python configuration? It seems I can create them but I'm not sure how to activate it from within UV. Thanks Stuart
Hi facultative code folding in vscode languages is a good productivity thing but not enabled by default for the Rocket mvbasic extension. It allows you to hide unimportant code in the editor not already hidable because of indentation. The language-configuration.json configuration file allows for a folding region to be added/enabled. This is the json snippet I manually edit into the client and server config files. "folding": { "offSide": true, "markers": { "start": "^\\\\s*!!\\\\s*#region", "end": "^\\\\s*!!\\\\s*#endregion" } } Could we get default folding markers added please. ------------------------------Stuart BoydellAU------------------------------
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.......................
Already have an account? Login
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.