Rocket MultiValue

We are excited to announce the release of Rocket® Software D3® v10.4 for Windows! Rocket D3 is an 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. Key features in Rocket D3 v10.4 for Windows include: The alignment of the v10.4 Windows and Linux releases, facilitating seamless D3 development in the future Python v3.11 upgrade, leveraging Python updates and new features A total of six enhancements and 20 bug fixes Upgrade now to Rocket® D3 v10.4 on Windows and unlock a whole new level of performance, compatibility, and ease of use. Want to learn more?  D3 10.4 release notes and documentation are now available online. Our team is eager to assist you with any questions or support you may need during the upgrade process.  If you are currently on maintenance, you can order Rocket D3

Hi All Has anyone developed a useful "simple" method to administer source control that they are willing to share?I am using AccuTerm WED and am thinking of writing some macros to "check-in" and "check-out" (as per HitHub) with some logging of who/time date stamp audit.Has anyone done something similar?Thanks Stefano

In BASIC, strings can be delimited with single quotes, double quotes or back-slashes.  The plug-in doesn't recognize \\s as string delimiters. Also, multi-line strings aren't allowed, but if there's unmatched quotes, the string syntax highlighting will continue across multiple lines until a matching quote is found. This is especially noticeable when \\"\\ is used to insert a quote into a string.------------------------------Raymond DeGennaroUV/D3 DBAUnitedHealth Group IncBelvidere IL US------------------------------

Hello all, This is my initial post here. Hope you all are well! I'm searching for some insight. By trade I am more of an Admin, but in my current role I have some developer duties and have inherited some custom work that ranges from fairly simple to robust. Just searching for insight regarding UniQuery. I am actively working for some revisions for Colleague outbound feed; the Select & List criteria currently displays a single list of data. I’m interested in adding an additional column and maybe headers for both.   Currently, the users are only included in the list if they meet the Select criteria. The revisions would result in a full list of users regardless if the meeting the qualifying criteria, a flag being added would solidify yay or nay.  The vendor is requesting a Y or N flag included to be in the data, based on if they meet the selection criteria or not. If a flag doesn’t exist within the Colleague UI to be included in the data output, is it even possible

The setup string I run seems to work ok:                                                                                                                                     001 IT = "!d:latlat -install imap.mail.yahoo.com bobthomson2001@yahoo.com 3                                                           993"                                                    &nbsp

Hello, we are trying to determine how the MVVS tool selects universe accounts (See screenshot).  We have several UV accounts that do not show up in this list and we have been unable to determine the common denominator so far.  Any pointers in the right direction would be greatly appreciated! Thanks, Dave ------------------------------David ScottUtex IndustriesConroe TX US------------------------------

Hello all,  I made a python script to read multivalue data in universe account and write in a file as PDF for example.  When it's time to write I receive this error: 'charmap' codec can't encode character Do you have an universe idea ? :-)  Thank you !  Jean ------------------------------deleuze jeanRocket Forum Shared Account------------------------------

It would be nice if wIntegrate's compile or save mesages contained a date/time stamp. This would be especially helpful when working on a multi-day project. Any way to configure that?------------------------------Nelson SchrothpresidentC3CompleteShop LLCHarrison OH US------------------------------

Hi all OK, so the D3 documentation regarding 10.4 refers to "restore-account" with the "r" option to restore to the FSI.This is NOT what I wish - I require an account so wish to use the account-restore verbI did this by naming the account with the suffix FSI:Now I'm experiencing a problem when the indexes are being generated :(Does anyone else have this? How does one re-generate the indexes to a file - I can't find documentation to do this (index-regen or any combination of the action)ThanksStefano------------------------------Stefano GallottaManaging MemberSimply Red Open SystemsMilnerton ZA------------------------------

hello all,  I have an issue when I make a LOGTO  "ACCOUNT" into shell universe on windows. What is STX :  ifExis() This folder exist at the C location.  If I use XADMIN, I don't have this problem. Only into the shell universe.  i search a solution to enter in my account from the shell.  thanks for your help.  ------------------------------deleuze jeanRocket Forum Shared Account------------------------------

I see in the MVIS config that you can add some username/passwords to be used to force API calls to supply some authorization, namely the username/password configured in the MVIS console.  Wondering if it's possible to do some kind of authorization using the "native" Universe/PICK logins so that when an API is called and then runs a subroutine, that the subroutine being run would think it's being run in the security context of the user based on the supplied credentials.  Maybe something like Basic authorization with the username/password passed in the Authorization header.  Ideally, some kind of token could be generated and this token passed in as a bearer authorization scenario in the headers. Mainly wanting to be able to use the same username/password that a user would  use during a normal login outside of MVIS as part of the  API calls.  Any help/ideas appreciated!

hello, I want to raise errors in my py scripts then these error catch by into @PYEXCEPTIONTYPE , @PYEXCEPTIONMSG, @PYEXCEPTIONTRACEBACK  What can be the best method ?  a/ to re-raise a error from a try sequence : these sample can catch 3 types of error : path not found, json not correct, mykey not found ...  def myfunc(path): result = '' try: f_path = open(path) config = json.load(f_path) a = config["mykey"] except: raise how can I have it at BASIC level into @PYEXCEPTIONTYPE , @PYEXCEPTIONMSG, @PYEXCEPTIONTRACEBACK   in this case, @PYEXCEPTIONTYPE , @PYEXCEPTIONMSG, @PYEXCEPTIONTRACEBACK are null. b/ to raise a error from script : def myfnc(a) if a < 2: raise ValueError(f"integer above 1 expected, got {a}") in this case, @PYEXCEPTIONTYPE , @PYEXCEPTIONMSG, @PYEXCEPTIONTRACEBACK are null. Thanks manu

I'm a little confused as to how D3 10.4 requires the .ini entry to be configured for disk and memory allocation.Is the disk in MB or frames ( / 4096) or GB? Say I required an 80GB disk - what would I need to have as the disk size parameter in the .ini entry?Also the total memory - again is it in MB / GB?Say I wished a total of 6GB of main memory - what would the entry be on the .ini.The install manual is a bit confusing and not that clear (IMO).ThanksStefano

For jBASE users > 5.7, here's a sample class that can get additional information on a port (e.g. the port number and program that is locking another port).Usage:analyze = new object('$analyze')details = analyze->fetch(port_nbr) ;! you can also do analyze->fetch(pid, @true)if details->$hasproperty('blocking') then    crt port_nbr:\\ is blocked by port \\:details->blocking->port:\\ at \\:details->blocking->locationendanalyze.jabba ! $analyze class method $analyze::$analyze() ! ! $system is used to get stats on the port ! this->o.sys = new object('$system') ! ! Get the lock details for the port ! this->o.lock = new object('$lock') ! ! Open the proc dir needed for "call_stack" ! proc_dir = system(1027) open proc_dir to proc then this->proc = proc end else throw \\Cannot open \\:proc_dir end end method method $analyze::fetch() arg = new objec

Hi, As mentioned in previous thread, we're playing with 10.4 on Linux, and I'm new to the VME/FSI world! Is it possible to increase the size of the VME without a re-install? In the D3Vme.ini file there are these statements: <pre>[d3vme.disks.0]name                           = Disk0.d3size                           = 1024000offset                         = 0</pre> I tried adding a [d3vme.disks.1] to mimic the adding a disk to the old pick0 file, but the system wasn't fooled! Any ideas? Thanks Tom------------------------------Tom PowerOwnerPower Business SystemsBenoni ZA------------------------------

Both items are strings. They're not equal. It seems Universe is doing some kind of conversion on them that makes them equal. If I convert the strings to integers it knows they're not equal. If I concatenate a letter on to either string it knows they're not equal.  My client was using smaller numbers in a field but a new specification requires and 18 digit number. They don't want to to through all there programs that compare these numbers and modify them with a alpha character or int conversion. Does anyone know what's going on and how to best fix it?

I think I am missing something basic with the spooler.  For a long time our company was using D3 and the way our software was setup, whenever something was to be printed, it would first generate a hold file and then the user could send the hold file to the printer at their leisure. When we switched to QM I just had things go immediately to the printer because for the life of me I couldn't figure out how to send a hold file to the printer after the fact.  I know this is something very basic but I just don't see it.  The solution must be in some mental blind spot of mine. Can someone help me with this?------------------------------Steve HenkelCIORocket Forum Shared Account------------------------------

I have RHEL 8.8. It has OpenSSL 1.1.1k. My UniVerse version is 11.3.4. It is OpenSSL 1.1.1b. What is the correct procedure to upgrade UniVerse's OpenSSL to 1.1.1k.  I'm trying to install a Python Module and it throws an error trying to download a new version of OpenSSL. Jon

Hi all, Apologies if I'm in completely the wrong place! We have an appplication running on D3 and have a linked sever in MSSQL using the ODBC connection. When retrieving a date column I am getting error : Error converting data type DBTYPE_DBDATE to date. select * from openquery (LINKEDSERVERNAME, 'SELECT DATE_COMPL FROM SOH SOH WHERE (SOH.DATE_COMPL={d ''2024-03-01''})') From Googling it seems I need to convert it to a string, but I am unsure of the conversion functions in D3. Any assistance would be much appreciated! Many thanks,Michael

I'm embarrassed to even ask this. I've seen the answer a couple of times in the documentation but can't ever seem to find it if I'm looking for it. How do you disable the automatic paging where the program prompts the user to hit the return key to continue. I know I can use the NO.PAGE option when running the program but I want to disable it in the program itself. Most of these programs were written for native Pick and were never designed to handing automatic paging. That's why I want to disable it in the program and not in the menu that run's the program.

I have a client who started their business on R83 and are now on D3 Linux. All of their USERS were created long before D3 and by my former partner. In every account on this particular system, regardless of where you are, a CTRL-BREAK re-executes the MD item - BASIC or PROC - when you type END from the debugger. I reached out to Rocket support and was unable to get a solution, so I poked around in my old reliable R83 manual and found that if Attribute 9 in the USERS item is set to R, that's exactly what will happen. If it's set to L, then END leaves the user at TCL. The moral? Never trash your old manuals.------------------------------Richard GinsburgPresidentGinsburg ConsultingManassas VA US------------------------------

I have noted that the MV BASIC extension creates ".vscode" subdirectories with a simple settings.json file containing "settings": {    "[rocket-mvbasic]": {      "editor.codeLens": false    }} This appears to be how the Code Lens functionality is turned off by default. If I adjust this file to use "true" instead of "false" then I do get the functions and variables presented in the Outline view as well as in the breadcrumbs facility. What I don't get is the reference count functionality shown in Code Lens - Rocket MV BASIC Rocketsoftware remove preview Code Lens - Rocket MV BASIC Code lens allows you to review your code and find references to variables, functions or subroutines without leaving the editor. To list these references, click the hyperlink as illustrated below. The hyperlink is highlighted when you hover your cursor over the text. Since 1.2.0 release, this feature is disabled by default. View this on Rocketsoftware > I can use the <ctrl&gt

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

Is there a way in PROC to test the @TTY variable and exit if it is equal to phantom? Sorry, Prime Information guy here, not much PROC. Jon

Hello All, We have a huge bunch of UniVerse Basic Routine. Now we wish to move to the modern world..specifically ASP.NET.  How should we go about doing this ? While keeping the structure intact and reusing the UV Basic Routine ?------------------------------Koon MIng FongMrP & O Global Technologies SDN. BHD.KUALA LUMPUR MY------------------------------