Rocket® D3® and jBASE®

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

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

Have you heard about the MV event Rocket is hosting at the Gaylord Rockies Resort & Convention Center in Denver from June 11-13, 2025? Whether you're a business leader or a technical expert, this is a perfect opportunity to explore new possibilities for your Rocket® MultiValue applications.   Why attend? Business and technical tracks: Gain the knowledge you need to focus on business strategy or the technical aspects of application modernization. Networking opportunities: Meet with peers and partners who share your goals and challenges. Hands-on labs and demos: Experience the latest innovations firsthand. Thought leadership panels: Hear from industry experts and learn how other customers are modernizing their Rocket Software applications.See the full agendaRegister today ------------------------------Mike RajkowskiMultiValue Product EvangelistRocket Internal - All BrandsUS------------------------------

I have a n old MVBase system and I would like to make an MD file pointer to a directory in windows.  Is this possible?  I found that I can use a UOPEN to open an os file and write to a file. Sorry for reposting.  I made the previous post a question and did not realize I could not reply to a question.   ------------------------------Troy DittbernerPresidentNorthstar Data Services IncBrooklyn Park VA US------------------------------

I inherited a 2000 line EOD proc.  This proc does some reporting, run some programs and also calls other procs which do the same thing.  Is there a way I can turn on tracking on the port this runs on to log what the proc is doing.  I guess I would be interested in what process is ran and a time stamp.  Thanks in advance for any help.------------------------------Troy DittbernerPresidentNorthstar Data Services IncBrooklyn Park VA US------------------------------

We are using the descriptive internal information about programs, specifically last date ran and number of times ran since last compiled. This information doesn't seem to be accurate in all cases. Our theory is if an external subroutine is flash compiled, and the calling program is flash compiled, these don't get updated. Are we accurate in our theory and are there other issues we should be aware of?------------------------------Kevin MarshallDirector of Software DevelopmentTechnical Resource GroupCA US------------------------------

Does any forum member know if you can upgrade to Universe, for free, from mvBase if you have an annual support contract in place for mvBase. I have reached our directly to Rocket but nobody has responded to me.  ------------------------------Richard OldsDirectorCalidore LtdUKrichard@calidore.comwww.caldiore.co.uk------------------------------

Good afternoon, I'm from Venezuela. I'm currently working with D3 version 7.50, which is over 20 years old due to the well-known economic crisis. My name is Rafael Rivas and I'm from Venezuela. I'm currently working with D3 version 7.50, which is over 20 years old due to the well-known economic situation in my country and the lack of resources to update it to the latest version. I'm having ODBC compatibility issues when trying to connect Microsoft Access to my D3 database. Due to these issues, I'm unable to establish a proper connection. If anyone could help me, I would greatly appreciate it. I specifically need the ODBC64 version to resolve this issue. Thank you in advance for any help. Best regards, Rafael Rivas------------------------------Rafael RivasRafael RivasSelf RegisteredLa guaira VE------------------------------

I originally posted this in August of 2022. I'm reposting because 1) it's getting closer to 2030, and 2) I've had a few support cases asking about this issue. Everyone out there know about D3's SET-DATE-WINDOW utility? It's something you can add to your cold start procedure to change the 2-digit year pivot point from 30 to something else. Example if you ICONV a date like 8/1/31, you'll get an internal date in the year 1931, not 2031 as you might expect. I have this in my USER-COLDSTART: SET-DATE-WINDOW 60 This tells my D3 system to assume that any two-digit years from 00 to 59 are 2000 to 2059, where 60 to 99 are 1960 to 1999. This is a LOT handier than handling it in your application. I'm posting this because there's a lot of useful stuff in D3 that I was unaware of until I became a Rocket employee and was actually forced to read the manual. Maybe some of you are in the same boat. https://docs.rocketsoftware.com/bundle/d3_rg_1034/page/d3/d3_all/source/reference_manual/introduction/D3_

Good afternoon,   I'm from Venezuela. I'm currently working with D3 version 7.50, which is over 20 years old due to the well-known economic crisis. My name is Rafael Rivas and I'm from Venezuela. I'm currently working with D3 version 7.50, which is over 20 years old due to the well-known economic situation in my country and the lack of resources to update it to the latest version.  I'm having ODBC compatibility issues when trying to connect Microsoft Access to my D3 database. Due to these issues, I'm unable to establish a proper connection.  If anyone could help me, I would greatly appreciate it. I specifically need the ODBC64 version to resolve this issue.  Thank you in advance for any help. Best regards, Rafael Rivas------------------------------Rafael RivasRafael RivasSelf RegisteredLa guaira VE------------------------------

As Rocket's MV evangelist, I'm starting a discussion. What are you thinking or doing with AI around your MV app?------------------------------Mike RajkowskiMultiValue Product EvangelistRocket Internal - All Brands US------------------------------

Hello,I would like to open a thread regarding the possibility of using the MVSP utility for the "D3" database from node.js.I found a JavaScript code snippet online using a rocket-d3 package.Unfortunately, this package is no longer available!Have you heard of it and do you have this package handy? Below is the code snippet found online: The d3 package exists.The rocket-d3 package is no longer available. npm install d3npm install rocket-d3 const d3 = require('d3');const RocketD3 = require('rocket-d3'); const dbConnection = new RocketD3.Connection({host: 'your-db-host',port: 1234,user: 'your-username',password: 'your-password'}); dbConnection.connect((err) => {if (err) {console.error('Error connecting to database:', err);} else {console.log('Connection successful!'); / Query exampledbConnection.query('SELECT * FROM your_table', (err, results) => {if (err) {console.error('Error executing query:', err);} else {console.log('Query results:', results);} dbConnection.close();});}}); Than

Hi everyone. Does anybody know the what the cost would be to upgrade to Universe from mvBase, if they have an active support contract for their mvBase installations? Any insight would be helpful. Best regards, Richard ------------------------------Richard OldsDirectorCalidore LtdUKrichard@calidore.comwww.caldiore.co.uk------------------------------

I've noticed that a number of lppick processes are hanging around long after they should have exited.  I've seen this in v9, but I figured it was just a bug that would get resolved with v10.3.4.  Apparently not. :( Example: In the past, I've just killed these processes but before I go about that this time, I wanted to find out if there was something I can do to ensure that it doesn't keep happening. I should note that this isn't isolated to one of my plants - here's the list from my other plant: Both hosts are on RHEL 9.4 and using D3 v10.3.4. What do I need to do in order to keep these orphan processes from stacking up? Thanks folks! g. ------------------------------Gene BuckleSr. Programmer/AnalystPly Gem Pacific WindowsUS------------------------------

We run d3 on an Windows Server 2008 Can someone describe how to move d3 to a new server (windows 2012)? eg;  Download installer to create the d3 environment Move live data from current server to new server. Explain how the license which allows the application to run is transferred to the new server. Thanks, Bret Stern ------------------------------Bret SternPresidentRocket Forum Shared Account------------------------------

We're looking to upgrade to jBASE 6.2.1.1 but ran into a problem with printed output.  I believe I can solve this problem using SP-TRANSLATE.  Is there documentation more specific than what I could find on the website?  I would like details how to create the translation table and where it should be stored.  Thanks. Jim Edwards------------------------------Jim EdwardsIT ManagerPlimpton & HillsMeriden CT US------------------------------

We are aware of problems with the jBASE 5.8, 5.9, and 6.1 documentation libraries that prevent some topics from being displayed. We are working with the portal vendor and our team to correct the issues as soon as possible. The work around is to use the documentation in the restructured jBASE 6.2 publications, which do not have the same problem as the older versions.  We added an announcement banner about this at the top of the documentation portal as well. We apologize for the inconvenience and will work to resolve the issues as soon as possible.  Thanks for your patience. ------------------------------Kevin KUHNSDirector, Information DevelopmentRocket Internal - All BrandsWest Lafayette IN US------------------------------

Hi, I'm Chase. I'm a Technical Recruiter for a company called The Guitar Center. You may have heard of us, been to one of our stores, bought some awesome gear from us, etc.  We're hiring for a Senior Retail Applications Engineer on a full-time, W2 basis (salaried + full benefits). I'm including the link to the job description here.  If you're interested in exploring this, let's talk! Some of the must haves for the role are hands on experience with (Rocket D3, UniData, UniVerse, QM) and Pick Basic/UniBasic) programming. In sum, we're looking for engineers who have experience working with Multivalue technologies in both development and maintenance contexts.  Interested? Shoot me an email to chase.tenen@guitarcenter.com. I'm not a robot, here's my LinkedIn.------------------------------Chase TenenSenior Corporate Recruiter, Technology - The Guitar CenterRocket Forum Shared Account------------------------------

Looking for other users of Print Wizard to discuss options going forward as Print Wizard future is uncertain.  We use print wizard in most all of our end user installations and depend on it for several of its features.------------------------------Keith GrillPresidentDBMS IncShreveport LA USkeith@dbmsinc.com------------------------------

Currently (as far as I'm aware), the newest version of the MVSP .NET API is using Framework 4.8, which is incredibly old (but still supported).  Are there any plans to move the MVSP API to a more current version of .NET? Thanks! g.------------------------------Gene BuckleSr. Programmer/AnalystPly Gem Pacific WindowsUS------------------------------