Rocket® D3® and jBASE®

I have put together a JAVA/DataBasic  program for D3 that works with https://messagemedia.com Bulk SMS texting API if anyone's interested goto http://www.custlang.nz -> utilities->SMS for notes and to try it, see also other things such as a Natural Language Demo. ------------------------------Robert DavenportProgrammerCustom Language SolutionsAuckland NZ------------------------------

Due to some security issues, the D3 installers' ability to automatically download dependency packages is no longer available. This makes it necessary to load dependencies manually before running D3_setup. Here are the instructions:First, disable D3_setup's attempt to load dependencies:mkdir /usr/lib/pick  ( if /usr/lib/pick doesn't already exist )cat /dev/null > /usr/lib/pick/d3depends  ( if the depends file doesn't already exist )==================================Manually loading dependencies on Linux versions 7 and lower:D3 Linux versions 9.2 and lower:yum install dialog.i686yum install glibc-develyum install ncurses-develyum install libgcc.i686yum install net-toolsyum install gccyum install pam-develyum install pam-devel.i686yum install glibc-develyum install glibc-devel.i686yum install libuuidyum install openssl098eyum install hal-libsyum install libidnD3 Linux versions 10.1 through 10.3.2:yum install dialogyum install dialog.x86_64yum install gccyum install libcurl-develyum ins

Requirements:D3 Version 10.2 and abovePython 3.11.6 and belowls -l /usr/lib/pick/ | grep d3py_d3pyIO.so          (Low-level I/O operations)d3py.py                (Main Python interface)_d3py.so              (Core C-extension library)libd3pyembed.a   (Static library for embedded operations) Instructions:python3.11 -m venv /var/www/api/.venvecho "/usr/lib/pick" > /var/www/api/.venv/lib64/python3.11/site-packages/d3py.pthNotes:I completed this setup using Red Hat 8 and D3 version 10.3.4, and it has been working seamlessly in my environment.Attached is a Bash script that installs Python from source, along with a wrapper I developed around d3py to provide a more Pythonic approach for retrieving information from D3.I truly hope this helps someone— I spent countless hours working through the challenges involved, and I’d be glad if this saves others some time and effort. from d3_wrapper import D3DataManagerdef main():    with D3DataManager(account='JCAT') as manager:        data = manager.g

The proper way to start D3 Linux 10.4 is: systemctl start d3svc We have run into instances where someone is starting is using D3_setup start, which starts it in foreground, not as a service. OK for debugging, but the problem is that if that thread disconnects or is killed, the entire VME crashes. This is much like starting D3 Windows from a command prompt using d3vme /debug, then closing the command prompt.  So please use systemctl instead of other methods.

There is a bug in the MVS Toolkit (or at least we believe it's the Toolkit) where if you use an OpenSSL version higher than 1.1 to generate a .PKCS12 document, it appears to create just fine, but when you install that in the Toolkit, HTTPS does not work. Rocket is working on this problem, but so far we have not been able to identify what or where the problem is. Meanwhile, I suggest that you use OpenSSL v1.1 or lower to generate your keys, certificate requests and certificates. While we're on the subject, I've worked some cases recently where people generated a private key that was not an RSA private key. It needs to be an RSA private key or the world won't like it. If you have any questions about any of this, or if you want some help with certificate generation (or anything else with the Toolkit for that matter), please open a support ticket and I'll jump on it right away and give you a hand.

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

As I sit here waiting for another Windows update for our MVS Toolkit, I wonder again, and I do mean again, why there is no Linux version for this part of the tool. We stopped using MS Windows over 20 years ago, but had to go and get  a licence and set up vm server to run Windows so that we could interface with the web. Where have all our problems been? On the Windows server. Now if there was a Linux version available, we may have had to set up a vm anyway, but it would have worked a lot better and saved a lot of technician time.

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.

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

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

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