Rocket® D3® and jBASE®

As the result of the post by Bryan Buchanan I have started have a look at the Java API to interact with D3. I'm working on AlmaLinux 8.9 with D3 10.4 installed. I have downloaded the file MVSPJavaAPI.zip and successfully compiled and used then MVSPJavaAPI/mvspTest/mvspTest.java program. The program connected instantly and all data accesses were instant. Using that as my basis I created a console program but ran into an issue with connecting. The connection in my program is taking 2 to 3 seconds to complete. Data access is instant after the connection occurs. At the same time I am seeing the following message lines in /var/log/messages: Mar 10 20:49:13 Alma8 systemd[1]: Started D3's per connection MVSP server for pick0 (127.0.0.1:53850). Mar 10 20:49:16 Alma8 systemd[1]: D3MVSPpick0@2-127.0.0.1:9000-127.0.0.1:53850.service: Main process exited, code=exited, status=1/FAILURE Mar 10 20:49:16 Alma8 systemd[1]: D3MVSPpick0@2-127.0.0.1:9000-127.0.0.1:53850.service: Failed with result 'exit-c

Good afternoon, D3 hosted on a Windows 2008R2 Server I have recently learned how to add printers to the D3 user-coldstart macro. This is the third printer I have added. The two previous are working perfectly. The last printer I created using a Brother printer (PCL) Windows driver. However all the text coming out of the printer starts with %!, which is an indicator of a postscript text stream. This causes pages of postrscript text to spew out of the printer. I have tried:  changing the driver removing and adding the queue again using a new queue (eg; added a new port 15 and 16) no difference We have 14 printers that work, this one is giving me fits. Ideas welcome. Dumping the printer is an option..but just in case Bret Stern ------------------------------Bret SternPresidentRocket Forum Shared Account------------------------------

I have quite a few customers running Rocky Linux as their OS for D3. Every single one of them has the same problem. A reboot of Linux, not a total shutdown, changes the designation of the USB drives that they use for nightly on-site backups. What was /dev/sdb might come up as /dev/sdd on a reboot. Since they are designated in the PICK0 file for FILE-SAVES, this creates a major problem. How can I prevent this problem?------------------------------Richard GinsburgPresidentGinsburg ConsultingManassas VA US------------------------------

Here's the Rocket Community Portal (RCP) link: https://my.rocketsoftware.com/RocketCommunity/s/release/a0GVx0000007iltMAA/mvs-toolkit-233?c__downloadProduct=Rocket%20MVS%20Toolkit With this new version of the MVS Toolkit, the Jetty web server was upgraded to version 11 to address security concerns. Also contains some minor bug fixes. Here's the important known issues text, just in case you forget to read the readme before installing: MVS Toolkit client and server for Windows requires Visual C++ Redistributable Packages for Visual Studio 2019 to be installed. The MVS Toolkit v2.3.3 installers will not upgrade in-place for versions prior to v2.3.3. Complete the following steps to upgrade: 1. Export your web services.2. Uninstall the previous MVS Toolkit client and server.3. Install the MVS Toolkit v2.3.3 client and server.4. Import your web services. ------------------------------Brian S. CramPrincipal Technical Support EngineerRocket Software------------------------------

I'm seeking a way to ascertain where jBASE is verifying login credentials via an AccuTerm script, or at least show a verbose log or trace of the connection attempt. An AccuTerm 7.3a user logs into their workstation using domain credentials. Those same credentials have been stored by AccuTerm in the workstation's user registry for use when connecting to the jBASE server. The jBASE login fails; jBASE then offers a different login scenario (possibly using local user credentials?), requiring manual entry of the credentials, which succeeds. These are the same credentials saved in the registry and Active Directory. AccuTerm 8.1. behaves similarly. This is jBASE 5.2.23 on Windows Server 2016... Any suggestions? Regards, Bob Wyatt .------------------------------Bob WyattIntegration/Support SpecialistAshwood Computer IncCincinnati OH US------------------------------

Hi All, We have some CALLX programs saving audit data for certain master files. Function system(45) returns the calling program name but that is always the name of the CALLX program. System(33) is supposed to also return a program name but is always empty. Is there a way to retrieve the "chain" of calling programs - similar to check.pibs but without having to understand 2000 lines of deep code! Also a way to see if the item was updated in the editor/UP as opposed to in a program? Any tech ideas welcome. Thanks in Advance Tom Power------------------------------Tom PowerOwnerPower Business SystemsBenoni ZA------------------------------

We use BEL=CHAR(7) to make a beep on errors.  We would like to have the ability to have 2 beeps or 3 beeps, but multiple beeps get combined into one.  I have only been able to get multiple beeps by adding SLEEP 2 between the BEL's.  Is there another way to get more than one beep to come through? Thanks! Rob Mitchell------------------------------Rob MitchellRocket Forum Shared Account------------------------------

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

I read in an earlier post that someone had created an ANTLR file for BASIC or C. Do you still have the file? I am new to ANTLR but would like to create a parser for users entering at least BASIC code.  Thanks! Lamont ------------------------------Lamont LockwoodIntegration ExpertDallas, Texasl2@integrationexpert.com------------------------------

If you have DX'd an FSI account, the QS pointer probably still exists in the VME's MDS. This can cause a problem with RESTORE-ACCOUNTS as it will create the DX'd account, restore the data from the account following it on the tape, then not restore that following account as itself. Example: you have an account called test followed immediately by an account called orders. You DX the test account and do a file save. You delete the accounts and do a RESTORE-ACCOUNTS. test will exist with the orders account's content and the orders account will not exist. Note that this affects RESTORE-ACCOUNTS but does NOT affect ACCOUNT-RESTORE, so if you stumble on this, you can delete any erroneous accounts and ACCOUNT-RESTORE FSI:<missing account> and you'll be good. Doing a d3vme /fileload is not affected either. Please note that Engineering is aware of this issue and currently working on a resolution. For those of you who need a little more detail on what I mean by "DX'ing an account", I'm refe

The Rocket® Software MultiValue team is pleased to announce the availability of jBASE 6.1.1 on January 9th, 2024. The Rocket jBASE solution is an object-oriented integrated database and application development environment designed for transactional and analytical database applications. It combines scalable, flexible, seamless interoperability with connectivity and low overhead for system management and administration. jBASE 6.1.1 brings new security compliance, certification on RHL 9, a free C++ compiler option for AIX users, Open SSL 3.0 support, and much more including 22+ bug fixes.   Increased security – Polaris compliance For improved data security and reliance, jBASE 6.1.1 includes 300+ mitigated risks in accordance with the Polaris assessment metrics. Polaris, one of Rocket's robust 3rd party security scan suites, sets a standard for all future jBASE releases. Expanded availability. In addition to being available on various versions of Windows and AIX flavors, jBASE 6.1.1 is a

Good day, I'm trying to understand the basics of the D3 environment. Mostly clueless, but not afraid. I'm a 30+ IT person. Started coding in C in early 80's. We currently handle all aspects of networks, integration etc. Have no experience with Pick, want to get up to speed on terminology, best practice environment etc. To start: Application uses Accuterm to connect.I believe D3 is running on the MultiValue environment. It is running on a Windows 2008 server.These folders exist:C:\\ProgramData\\RocketSoftware\\D3C:\\Program Files\\RocketSoftware\\D3C:\\Program Files (x86)\\RocketSoftware\\D3ODBC Our support is provided via Nexustek, but certain tasks, I want to handle and understand. Modifying printer queues. I believe this is handled in COLDSTART Understanding the ODBC connect. I can connect to SQLDEMO, but don't know how to access the live tables. I have some basic environment questions. What version are we running? How do I find out? Best way to connect and play..putty, Accuterm?

There doesn't seem to be much love for the MVSP Java toolkit here. I've put together a demo (with all source code) using MVSP Java with Angular and Tomcat - D3 Demo The Java API is fast and easy to use IMO, and allows using D3 as though it was "just a database", just as you'd use (for example) Postgresql with JDBC, except with D3you have an embedded programming environment which is much easier (and flexible) than writing SQL procedures or embedding Java/Javascript functions in an SQL DBMS. It would be straightforward to create a SPA which makes REST calls to a web server using the same technique as the demo. MVSP Java also makes it very easy to create desktop Java Swing apps with D3. I know there's usually a lot of hate for Swing, but it's an extremely well designed UI toolkit. Oracle has committed to keep Swing an integral part of Java, so it'll be around forever, which clearly can't be said for any Javascript frameworks (Angular/React/Vue). Swing can be themed very easily e.g. FlatLa

I am sure  their are some people on here who worked on R83 Pick systems way back . My first taste of MV was helping port a PRIME based system to Pick R83 on a small ICL CLAN mini computer. I was fresh out of college where we worked on huge mainframe machines and when I first saw the ICL CLAN machine I thought it was an air-conditioning unit.  I was just reminiscing a bit on how efficient R83 was in terms of memory.  If I recall correctly each Pick port needed about 500k . This led me to ask myself how many D3/Linux ports I could comfortably run on my desktop PC which has 32 GB of RAM?  BTW I got into the Pick Multivalue arena, quite by accident and I'm still Picking away many years later. :)  ------------------------------Neil PrattSystems Analyst / ProgrammerDaily Express IncUS------------------------------

Morning All (South African Time!), I have a server upgrade coming up for a 65 user customer currently on D3 Linux 10.2. The plan is to go bleeding edge to 10.4 so have started the research and busy playing on a dev server. First off I see FSI and a totally new installation procedure.  Last time I used FSI was 20 yrs back when a customer had D3/Windows on WindowsNT - still have nightmares about WindowsNT :) So the point of my post is to ask for any hints and gotchas from those who have already done a similar migration, as I see there are a number of difference so it's not going to be a filesave & restore kind of migration. We use MVSP and we shell out to Linux occasionally to kick off Bash & PHP scripts. We also use the spooler to kick off Python scripts to create PDFs and/or email reports. Any pointers will be gratefully accepted! Have a great weekend! Thanks Tom------------------------------Tom PowerOwnerPower Business SystemsBenoni ZA------------------------------

I'm looking for some information regarding the use of CALLC. Particularly if my source code will need to include the jsystem.h and where I should store the .so / source code on the system (or setup a path so a jbase program can call it). The old zumasys docs aren't quite enough and I couldn't find anything in the Rocket documentation. If anyone has experience using CALLC I'd appreciate the assistance.------------------------------Derek BandouveresProgrammer------------------------------

Hi everyone, We are currently migrating from mvBase to d3/Windows. According to the online documentation Incremental Backups on d3/Windows are not available, is this still the case?  Are there any plans to implement incremental backups.  We use incrementals on mvBase as part of our daily back up strategy. Many thanks Richard------------------------------Richard OldsSnr DeveloperCalidore Computer Systems LtdGATESHEAD GB------------------------------

Hy i just saw in the d3 ref this:https://www3.rocketsoftware.com/rocketd3/support/documentation/d3nt/102/refman/TCL/index_select_command.htm#reference4710 so i tryedindex-select sgvar016 A6(MCNA):" ":2but i got the message[162] Error in icode conversion: 'A6(MCNA):"'; index not found. what is the correct way to use ?------------------------------Alberto LealSystem AnalystMillano Distribuidora de Auto Pecas LtdaVarzea Grande MT BR------------------------------

Hy to all i discovery this today onlyto use the "tail" inside d3 like its used in linux:first catalog the tail program, in your current accountCATALOG DM,BP, TAILthenuse the comando watchfor exemple:WATCH TAIL LOG.FILE 20386 (10this will refresh the page continuously listing the last 10 lines of the file i don't know why but i had to catalog the program TAIL ------------------------------Alberto LealSystem AnalystMillano Distribuidora de Auto Pecas LtdaVarzea Grande MT BR------------------------------

I'm posting this to alert anyone who's got large multivalued attributes they may want to sum in AQL. A friend of mine logged a case recently where a correlative using the S() function would hang when the file has any items where the attribute in question has more than 32,768 values. Engineering confirmed that this is an AQL limitation because it's using a 16-bit signed variable to track the value count. This variable is used in many places in AQL, and it would be a huge task to rearchitect. In the course of debugging this, Engineering came up with a workaround by using CALL in the correlative. This not only removed the 32,768-value limit, but it is also MUCH faster. Example of the correlative that hangs (using multivalued attribute 9 in the example): 008 A;S(9) Example of the correlative that works (again using multivalued attribute 9 in the example): 008 call bp sumbal Might be a good idea to fully path the subroutine being called. Example of a subroutine in an account called "orders"

Have a quick question. In JED, what is the hot key to enter a TM (char 251) into a record? The VM and SVM are clearly documented. In Universe in ED i would just go into Up Arrow Mode  and change it there, but does not seem Up Arrow Mode is supported in ED on Jbase. Editing this in HEX does not seem supportable and I'd rather not have to create a user interface for this for a super user. I do see it's supported through RAISE() and LOWER(), so it should be there. Also see that @TM is supported. ------------------------------Greg MotterRocket Forum Shared Account------------------------------

Hi all, I have just joined. Our company in South Africa runs a D3/SystemBuilderSB+ asset finance application. There is shortage of programmers/developers in the country and I would like to enquire if there are perhaps any programmers or developers who could perhaps assist in supporting our application. Please respond whereafter we could perhaps communicate directly. The ideal situation is if the timeline of interested parties are as close as possible to the GMT+2 timeline. Regards, Derek Gerber ------------------------------Derek GerberMrRocket Forum Shared Account------------------------------

Help,  I am in desperate need of a 9.0.0 or 9.0.2 installer for client whose system crashed.    Rocket is unable to help as this is the last version from TigerLogic and some contract BS is stopping them from having a copy on their webpage. Anyone out there with a copy, it would be most helpful. Thanks,  Steve Love Computyme PS:  Rocket won't activate  9.0.6 for the same BS reason as not having 9.0.2 -  for other users of 9.0.2 be aware of the lack of availability of this version from Rocket.------------------------------Steve LoveVPComputymeAbington PA US------------------------------

We're testing jBASE 5.9.0.1 and have a hung process that indicates "Program blocked on binary LOCK at OE.SR.DEL.UPDATE,437 Line 437 of that program is attempting to delete a record from the a file. The record is not locked,  jDLS -d -v -L does not indicate any type of lock on the port or process. SHOW-ITEM-LOCKS does not show any type of lock on that port or process-id.  LIST-GROUP-LOCKS shows no locks.   LIST-EXECUTION-LOCKS shows no locks. Anyone have any ideas on how I can identify and resolve this binary lock issue? Thanks.------------------------------Jim EdwardsIT ManagerPlimpton & HillsMeriden CT US------------------------------

Periodically I have to transfer a single file, usually .txt, from D3 to the Desktop. There is a function in SB+ to do this to a Windows Desktop environment, but I want to transfer the file to a Linux Desktop. I have looked at scp, but can't quite understand the source path from the D3 partition. Any ideas or other suggestions welcome. Once I get it working, I intend to establish it as a script in SB+ to be used multiple times. Thanks. Alex ------------------------------Alex PolglazeThe Book-Keeping NetworkPerth Western Australia+61419 776 348apolglaze@book-keepingnetwork.com.auhttps://www.book-keepingnetwork.com.au/------------------------------