Rocket® D3® and jBase®

Just putting this out there. I’ve had a couple of cases where people upgraded D3 to 10.3.3 or 10.3.4 and started having weird problems with MVSP. In both cases, we upgraded MVSP to 1.8.21 and it solved the issue. When upgrading D3, it’s not good to simply restore your existing MVSP account, especially if you’re going to 10.4. Anybody out there ready to upgrade, please contact me so I can get you the MVSP 1.8.21 version and help you install it. The reason it’s not posted in the RCP Downloads is because the pseudo tape is NOT a patch but rather an account-save, and the steps are different. We can post all day long, but afraid that the instructions will not get read and someone will try to use it as a patch.Most of you know where to find me (bcram@rocketsoftware.com) and many of you already have my cell phone number. If you can’t get to me by other means, just reply to this and I’ll reach out.

Hello,I want to retrieve parameters of my command tcl in a proc.How can you this ?For example :I execute a proc named PROC01 with parameters.I want to know the parameters to use inside the proc.  A proc :PROC01001 PQ002 HSET-DEVICE003 <how to use parameters line command ?>004 PH005 ...  And execute this in prompt :: PROC01 6 In Basic programs, you can use tclread. But, with proc, how to do this ?  Thanks for your response, 

All,Currently we are extracting out JSON data character by character and saving the data in d3.  That works fine for small records.  But, now we are looking at converting a record with the size of 3,147,865.  Character by character manipulation of a string is very cumbersome.   Is there a JSON to d3 program out there that could handle this or does someone have any ideas?Ted Hurlbut

Is there any ETA on when MVSP for Linux - specifically .NET is going to be available? Thanks! g.------------------------------Gene BuckleSr. Programmer/AnalystPly Gem Pacific WindowsUS------------------------------

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

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

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

Ok,  chasing my tail for a bit on this one.   RC = 5061.10 LL = 5061.1 IF LL = RC THEN CRT "WHY, THEY ARE NOT EQUAL" END They don't match!  why does it drop the 0 on the compare?  What is the correct way to fix. ------------------------------Craig CurtisSystem ProgrammerSevier Valley School DistrictRichfield UT US------------------------------

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

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

Before upgrading 10.4.0 or earlier versions of D3 Windows, shut down and do a "standard" uninstall of D3. This will leave all of your data and Device Manager settings in place. This is necessary because of a bug in the 10.4.0.1 installer which will not allow installation of the D3 services once the upgrade is complete.------------------------------Brian S. CramPrincipal Technical Support EngineerRocket Software------------------------------

I opened case 01108919 for the subject. In few words: fresh installa works, update not. Cause:  a lot of files are not updated. Best regards Stefano------------------------------Stefano MaranSenior programmerGTN SpATavagnacco IT------------------------------

Hi everyone, I'm very new to Host Access and D3. We're currently working in a D3 Pick environment using the TCL (Terminal Command Language) prompt, and I need to learn everything from scratch. I do have access to Rocket Software's D3 reference manuals, but they're quite large and a bit overwhelming to read cover to cover. Could anyone please suggest the best places to find learning materials - especially video tutorials that cover basic concepts, TCL commands, creating simple programs, and understanding how everything works with real examples? I really prefer videos or more practical, hands-on resources rather than just manuals. Thanks so much in advance for your help!------------------------------Rima PrajapatiSenior IT SupportRocket Software Forum Member------------------------------

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

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

Can I call a proc from a paragraph? ie,  I want to replace the logon proc PQ [MVSP.PROCS MVSP.ACCOUNT.CHECK] . . . . ------------------------------Paul ReeseIT ManagerPhoenix Systems Group IncYoungstown OH US------------------------------

I have a few vb apps in place.  My latest one of works in vb 2022 but fails when when I install it in on another computer. Here is my code bit: Global:  Private MVSP As MVSP.PickPrivate MVSPFunc As New MVSP.Functions In form load:    Try       '  pool = New rocketsoftware.MVSP.PickPool()        MVSP = New MVSP.Pick       Display("Run Time Type" & MVSP.GetType().ToString)   Catch ex As Exception       Me.Show()       Display("MVSP Failed to init")       MsgBox("MVSP Init Error" & ex.Message)       BtQuit.PerformClick()   End Try The mvsp = new line is failing with error msg: Init Error int path is empty. I installed the d3client 103.4 on the computer, as well as c++ runtime. Nothing changes. I also installed .net 8 runtime  with the install. What strangeness is this?------------------------------David WilliamsDeveloperComputer Repair & Sales IncWarminster PA US------------------------------

I recently was part of a discussion regarding the use of parenthesis with a SELECT statement. My understanding was that parenthesis were not evaluated with respect to AND and OR logic. Is that correct? Looking in the online documentation, the only mention (that I could find) regarding parenthesis use was in relation to OPTIONS. Specifically the the open parenthesis indicated the beginning of an OPTIONS clause and that a close parenthesis could be used to end the clause and that the OPTIONS clause should always be at the end of the statement. If that is the only allowed use for parenthesis then: Why are parenthesis allowed to be used at all in a SELECT statement as follows:SELECT FILE WITH 1 EQ "ABC" AND ( WITH 2 EQ "123" OR WITH 3 EQ "XYZ" )This command executes without an error? Using a file with the following records: TEST..... A1....... A2... 100        A         1200        A         2300    

Ever get on a D3 system and run WHERE LZ looking for stuff but get barraged by PIBs in some normal status? I got tired of that and wrote a BP that goes through WHERE LZ output and strips out the trivial stuff. Posting it here for anyone's use, but also to get opinions on improvements. Don't be shy!!* whereLZ - bsc -09/05/2024** ver 1.1 - bsc - 06/05/2025 - detect if hot backup secondary*tclread wCmdslpTim = field(wCmd," ",2)'cn' ;* set sleep secondsif slpTim else slpTim = 2      ;* default is 2passes = field(wCmd," ",3)'cn' ;* set number of passesif passes else passes = 3      ;* default is 3isSecondary = 1 ;* call checkFHBRole(isSecondary)for passNo = 1 to passes  crt "Pass ":passNo  execute \\where lz\\ capturing whereTxt  aMax = dcount(whereTxt,@am)  for aX = 4 to aMax    line = whereTxt<aX>    if index(line,"inconsis",1) then      crt line ;* corrupt FCB/DCB/whateverCB    end else      wPib = line[2,4]      if wPib matches "4n" then        wMode = field(line[33,99],":",1)   

I have an Access database that currently connects to the SQLDEMO tables. That's great. When I look at the server running D3, I see the SQLDEMO folder in the D3Databases folder. Fine So now I want to connect to some live data. Specifically the inventory tables. I have lots of documentation, but I can't seem to find the steps to make the tables visible to my odbc dsn. The folder I think I am after is the MISPR folder. If I'm correct, how do I get access to the values in the tables? I was told I need to define a translation table..yes/no Regards ------------------------------Bret SternPresidentRocket Forum Shared Account------------------------------

What's the most efficient/fastest way to securely get data in/out of a jBase system? The last time I had to do this, we wrote a CGI interface and accessed the system via HTTPS. This time, we have no need for the full CGI environment, we just need to parse some JSON data, and return a JSON response.  Similarly, MVIS is overkill. Is there a "jClient", like there is with qm? We could just listen to a port, but the inbound connections will be coming from multiple clients, so we really don't want to run multiple transactions through the same process. We like the statelessness of separate connections.  Since jBase apps compile to OS executables, the current thought is to establish an ssh connection, with keys, run the appropriate routine, return the JSON and then exit.  We're wondering if there's something simpler.  ------------------------------Raymond DeGennaroOwnerSelf RegisteredBelvidere IL US------------------------------

I recently discovered that d3vme /fileload on D3 Windows does NOT build indexes in the FSI accounts. VME accounts only. This was discovered when working with someone who was using d3vme /fileload on D3 Linux 10.4, since entering d3 from a Linux prompt then taking the F option is no longer the way to restore the system. The problem was further masked by the fact that list-index DOES show all of the index references even though the indexes never got built. This is because the index references in a file's D-pointer (file-defining item) get restored when the file is restored, but no further action is taken. The way around this is to run indexer from TCL in the DM account after the file-load is complete. Indexer reads all of the index references in the D-pointers and builds the indexes accordingly. As of now, we are treating this as a documentation issue since this has always behaved this way and the work-around is quite simple. I would appreciate any comments from anyone who uses d3vme /fi

d3 all versions. To my knowledge, this has been around forever; but it has always been something I thought was totally inconsistent: File A and File B are related to each other. An attribute on File B is a mv. From File A I wish to use a dictionary item that returns that File B attribute; and so use a t-correlative such as:T(FILEB;X;;n)where n is the integer amc number of the attribute on File B I want. This works perfectly if n is single valued; but if n is multi-valued the result is all the values delimited by a <space>; not returned as a mv. Why? It strikes me this is entirely inconsistent with mv principles. Now, with that said; is there a way around this in a dictionary item [apart from doing a call subroutine] using F or A type syntax? Cheers, ------------------------------David KnightSenior Software EngineerH3O Business Technologies Limited------------------------------

Technology decisions are never easy, especially when it comes to mission-critical systems like Rocket® D3. That's why we want to reaffirm why Rocket D3 remains a smart, strategic choice for your business. With our continued commitment to reliability, security, and long-term value, you can be confident in the success of your operations both now and in the future.The smart choice: Why you chose D3For years, Rocket D3 has been the backbone of your operations. Whether you've relied on it for several years or decades, D3 has delivered proven stability, reliability, and flexibility. From managing large volumes of transactional data to providing unparalleled performance for your business-critical applications, Rocket D3 scales alongside your business needs.D3 Delivers: Continued ROI and proven valueChoosing Rocket D3 means you've already built a solid foundation. Over the years, you've experienced a significant return on investment (ROI) as D3 has enabled your business to streamline operation