Rocket® D3® and jBase®

We're ready for the next round of testing of D3 Linux v10.4 Port!! Since the last round of testing, we have been working hard to make a more complete product. We have addressed a number of bugs, but more exciting than that is that we have added the FSI to our UNIX implementations. This allows us to offer the most highly horizontally scalable multi-value solution on the Unix platforms as we have previously offered on Windows. By decoupling the FSI and VME environments, you can achieve a more seamless cloud experience. Creating a docker instance of your application server (VME) while still utilizing a singular shared Database (FSI) can give you easily deployable instances of your application. If you are interested in assisting us with this exciting newly-architected product, please reply to this post, or email trude@rocketsoftware.com. We are looking fo

Hi allJust your thoughts on how much memory should be allocated to a system with < 20 users? (NO Flash basic - Linux D3 (Ver 7.4))The users are complaining that the system is "slow" with 2.62144 TB. (yes you read correctly 2.62144 Terra Bytes) !In my opinion, this is FAR TOO much - and should be reduced to say 16 GB otherwise there is the chance of (per manual) "High values can result in poor performance of other UNIX processes due to inadequate remaining memory."What say you?------------------------------Stefano GallottaManaging MemberSimply Red Open SystemsMilnerton ZA------------------------------

Looking to see if anyone has successfully integrated D3 with UPS WorldShip using ODBC -When voiding a shipment/package in WorldShip, I receive a duplicate key error because it appears that it's trying to perform an insert instead of an update statement.On void in WorldShip:Execute 0F99B418( INSERT INTO ups_packages ( ...., voided, id, shipment_id )  VALUES ( ..., 'Y', 'PACKAGE ID', 'UPS SHIPMENT ID' ) )Execute 0F99B418( INSERT INTO ups_shipments ( ...., voided, id )  VALUES ( ..., 'Y', 'UPS SHIPMENT ID' ) )Given that these records already exist, and we're just trying to set the voided flag, it should be an update statement:update ups_packages set voided = 'Y' where shipment_id = 'UPS SHIPMENT ID'update ups_shipments set voided = 'Y' where id = 'UPS SHIPMENT ID'Everything else seems to work.Did I miss mapping something in WorldShip?  Is this a known issue?  Any ideas on how to work around thi

have three of these error messages this morning.   Guessing it has something to do with my enabling callx?unix_GetUserLogonMode [82] Your system privilege level is not sufficient for this statement.Both users have sys1 level set.Thanks for any help in understanding the error message.Craig

The MVS Toolkit is our REST services tool for D3 and mvBase. MVSP is the MultiValue Server Protocol that the Toolkit uses to connect to D3 and mvBase. Want to learn more? In just under 90 minutes you can learn all about installation, configuration, and debugging of MVSP and the MVS Toolkit. Even better – you can spend only a few minutes a day. I just made over a dozen short, easy to consume videos. So, you can watch one when you have only a few minutes. Before you know it, you'll have learned a lot.I've tried ot summarize my years of Toolkit experience into this series of videos, sharing best practices and other knowledge I have on the subject. I put them in order to make the series easier to follow and easier to skip subjects you may already have mastered. Ready to watch the first one? If so, click here to get to the playlist on the Rocket Software YouT

Morning,I have never used callx and think I have found a need.  From my understanding a callx will trigger a program on a item change.  Not sure if it can be triggered from a attribute change but a item change would be ok.Question is,  How do you go about setting it up and making it work?  Thanks------------------------------Craig CurtisSystem ProgrammerSevier Valley School DistrictRichfield UT US------------------------------

I am looking at setting up new hardware and was wondering if there is a plan to support RHEL 9 anytime soon?------------------------------Steve CaspersMurphy Automotive IncRosemount MN US------------------------------

We run Windows D3, and utilise MVS Toolkit extensively. It's a very stable and useful product, but there is always a three-second timespan between the request and response within the server (shown in the log).Does anyone know of a way to reduce this time, as it can make things quite slow when numerous requests are made? It doesn't seem to be a network-related issue.Many thanks in advance.------------------------------Simon HawkinsGeneral ManagerQueanbeyan Leagues ClubQueanbeyan NSW AU------------------------------

Just started a position at Houston's Inc which uses D3. Apparently, sometimes they are setting group locks and other times they set item locks. However, no one seems to know why it does one over the other. The D3 handbook is unclear. We are trying to remove the group locks from happening as they really should only be item locks within their applications. The manual states that the typical readu, matreadu, etc create the locks. But there is no info on how a group is created vs the item...or perhaps both are created at the same time, but the group lock is released sooner? Looking for a way to identify when the code is generating a group lock instead of an item lock so that we can switch to item locks only.------------------------------Chris RazzanoSenior PICK programmerRocket Forum Shared Account------------------------------

Has anyone out there successfully integrated a credit card mag stripe reader with D3? Looking for something that you swipe a credit card and the information is captured using a BASIC INPUT statement as if the information had been typed on the keyboard. I see a few USB mag stripe readers out there on Amazon, but can't tell if they emulate keyboard input. If you're using one that works, please let me know the make, model, and source.------------------------------Brian S. CramPrincipal Technical Support EngineerRocket Software------------------------------

Hi Guys,Maybe I'm missing something but does D3 (10.3) not have the raise (lower) function to alter @Vm to @Am (or vice versa) ?I guess one could use the swap function but I've been working with Open Insight and ​"miss" this :)------------------------------Stefano GallottaManaging MemberSimply Red Open SystemsMilnerton ZA------------------------------

good morning folks!does anyone in this group have a standardized test plan they use when upgrading RHEL/Linux in general that they can share?if not a plan, testing suggestions?THX,~doc------------------------------[Doc] [Ruckel][IT Guy][Southwest Traders][Temecula] [CA] [USA][Doc]------------------------------

Hi allIs there a way to test the "level" that one has arrived at when the "execute" (verb) is used in code?It is of my opinion, that if one reaches past a certain level, this may cause the code to break (and falls into debug)I remember with the ADDS Mentor implementation, there was a check (some system(??) ) which one could test and take the appropriate action.Failing which, I guess, a simple stack_pointer counter may have to be implemented before such an (execute) statement - but that's messy :)Thanks------------------------------Stefano GallottaManaging MemberSimply Red Open SystemsMilnerton ZA------------------------------

Greetings all!We are about to move our Linux OS from RHEL 6.7 to RHEL 8.3 and our DBMS from D3 9.0.0 to D3 10.3.xFrom a security perspective, is there anything that has to be tweeked for user security and user's ability to connect to D3 from RHEL 8.3 and continue working as they do todayt? As an example, if I log onto D3 as "SomeUser", when I shell out to Linux, and perform a "whoami", the result is "root".It is my understanding that Red Hat has done many things to prevent users from inheriting "root" privileges.  Has that proven problematic with D3 use/users?~doc------------------------------[Doc] [Ruckel][IT Guy][Southwest Traders][Temecula] [CA] [USA][Doc]------------------------------

Thanks Brian (as usual)!

Hi Guys,OK so I'm venturing into the snakey  (or snaky) world of Python here :)According to: Python is available in Rocket D3 10.3.1 - The Rocket MultiValue Blog The Rocket MultiValue Blog remove preview

I work with a set of code that verifies data and emails when something is wrong so these problems can be dealt with right away. It runs overnight as a phantom started by a linux cron job.The often changing nature of this code means it can be more prone to bugs like a variable not assigned.  That's fine, I can see the problems in the runtime-errors next day and fix. My problem is this program quits when it runs into a runtime error but if I run the same code in the foreground it doesn't.Is there a setting where I can control this behavior?Environment is D3 10.2 on CentOS------------------------------Bob FrankSoftware DeveloperJoseph N Golubov Associates IncLeesburg FL US------------------------------

Hi AllHas anyone found a suitable extension such that PyCharm works well - as intended?My use is sans extension and my use is "as is" from a full-screen form, however, the editor has some rather great enhancements for  other languages (Python obvious)Thanks------------------------------Stefano GallottaManaging MemberSimply Red Open SystemsMilnerton ZA------------------------------

Good morning Rocketeers!Thanks much for the very helpful replies to my last thread...has already proven valuable.For D3, I would like to know what Rocket suggests for regular tuning, maintenance, administration.If possible, I had hoped to hear from the general D3 Rocketeer community, what practices they adopted for tuning, maintenance, and administration of the D3 database...THX in advance for your helpful replies!~Doc------------------------------[Doc] [Ruckel][IT Guy][Southwest Traders][Temecula] [CA] [USA][Doc]------------------------------

When developing RESTful service APIs or server side code used for jRemote (e.g. ODBC) it can be cumbersome to use logging and/or temporary writes to a file to trouble shoot the send/receive messages in your jBC server side code. In jBASE 5.8, when you start jbase_agent you can optionally include the following options: -S single session -d (enable debugging) -Jr (redirect debugging to another device) -J[D,d] (force the program/subroutine into the debugger at start up) Note that the -J options are standard jBASE program execution options for debugging. The difference between the D and d are that the D will force a debug on all EXECUTEs whereas the d drops into the debugger on the first program being execu

Good afternoon D3 folks!What is best D3 DBMS practice when it comes to deleting or RESIZE-ing data sections from a files dictionary?If we don't delete these data sections (we use them as work files when compiling report data) we end resizing too many of these data sections/work files. If I delete them, FOF gets populated with much meaningless data.Thank you in advance for your helpful reply/ies!~Doc

Hi,I've been using a small BASIC program I wrote as my shell environment. Originally for UniVerse, I ported it to D3 and it seems to be working relatively well. The big gains have been getting a permanent history file with arrow keys  to navigate the history. The tab completion is also helpful and having a prompt with which account I'm currently in is useful.You can pull the NSH file and update the DEFINE statements for D3 and your specific platform and them compile it. D3 10.2 and earlier does require some more work as it doesn't support the DEFINE statement so you'll need to use a cleaner program to strip out the conditional code I have to support multiple platforms. GitHub - Krowemoh/NovaShell: A Fancier ShellLet me know if you need any help setting it up! This should work with vt100 an

I'm trying to conditionally compile some code but I can't seem to get the IFDEF to work.This is the source code below, I would expect to see 'Not defined.' but running the program results in 'Defined' being printed. This D3 10.2.2 on Windows if that helps.*$IFDEF PLATFORM.D3PRINT 'Defined.'$ELSEPRINT 'Not defined.'$ENDIF*PRINT 'Always print'Thank you

Hi,What is the correct way to reset page headers and numbers when using the BASIC "HEADING" statement after issuing a PRINTER CLOSE statement?We have a program that generates multiple reports based on the same SELECT list.???? Each report must start at page number 1.The only time it works is by issuing the following statements: * PRINTER ON * HEADING ...... * PAGE 1This, however, generates a blank first page on each report.How can we correct this?-- Best regards and keep safe,Vincent ???Kim??? ElliottITC CoordinatorBearings & Accessories Ltd.83 Harbour StreetKingstonJamaica, W.I.Tel: 876-922-1950Cell: 876-315-2739Email:vincent.e@bearingsandaccessories.com

Anybody out there familiar with an application called "Prelude"? I've got an end user out there who's migrating to Prophet ( Profit? ) 21 who is having trouble extracting the data they need. The developer modified and locked down Prelude, passworded everything, removed any source, then died taking all knowledge with him. It would be nice to know stuff like "blah blah is the invoice file, blah blah is the customer file..." etc.------------------------------Brian S. CramPrincipal Technical Support EngineerRocket Software------------------------------