Rocket MultiValue

It appears that the Personal version of OpenQM  does not support printing - Is that correct (I can't seem to make it 'work' if it does)?------------------------------Gary------------------------------

 We love our mvBase customers and wanted to take this opportunity to provide you with some important details. First and foremost, mvBase applications will continue to be supported While we are moving mvBase through our Product Lifecycle to End of Limited Support in September, this simply means support is available but restricted.  Also, you can still renew your maintenance contract. Rocket Software customers on maintenance are entitled to obtain product upgrades at no additional charge (if new versions are available). To learn more please see the Product Lifecycle Announcement that we updated and shared via email in Sept. 2022, 12-months before moving Rocket Software MultiValue products to new stages in the Product Lifecycle.  Additionally, the Product Lifecycle Definitions and our Product Lifecycle Policy are available on the Rocket Business Connect. Second, mvBase customers have optionsWhile Rocket Software would love for our mvBase customers to migrate to another Rocket MV applicat

We had an unusual issue where it APPEARS Attb 2 of a DIR VOC type cannot exceed a certain length.LIST / SELECT both work as expected.However, AE using an Active SELECT list or just 'raw' would return "New Item" and anything Filed would issue a WRITE error (Status =1) with a 'check for triggers' message -- which cannot be true on UD DIR types.After a while of not figuring out the issue, we moved the folder to make Attb2 of the VOC shorter and viola - the issue resolved.Does anyone know the character count allowed in attribute 2 of a DIR VOC type?  And more weirdly, why is only AE was impacted?  We might have found the issue earlier if SELECT and LIST did not work either -- as it was, we were running down to see if there were some weird permissions issues - and was about 30 minutes in when we realized the path was much longer than usual do to where the folder had been nested.------------------------------David WolvertonIndependentSunset Programming IncWaltham MA US-----------------------

New to Jbase with a background in ADP's Reality. The problem I am having is that items within a COMMON area are not transferring to subroutine. The original system was as follows:program A - $include commons os.inv ( this program sets many variables set within the include )--calls program B - carries the same include of os.inv, it does reference a common variable, but otherwise does not set any----calls program C - carries the include, references a common variableI have basically created the following:program A--program B----program D  - new program, has the same include, but the common variables are not assigned??------program Cno idea why program D, despite being a subroutine and having the same include, has unassigned common variablesAlso, was curious if there was a way to view a program which included the code from the includes. In ADP's reality, they had a command called BLIST with the option of (MEL that would give you a listing of the entire program, with included code, and form

Want to prohibit users from using the DELETE Verb from tcl or the Command prompt, but want to be able to use DELETE from Unibasicif there a way that i can tell where the command is being executed fromUsing Unidata system ------------------------------robert modrichDeveloperRocket Forum Shared AccountTEMECULA CA US------------------------------

Greetings, all! We're running UniVerse 11.3.4 on AIX 7.2If I remember correctly from some previous posts, UniVerse has it's own embedded version of openssl that it uses instead of the AIX version.  If that is correct, is there a way to list (or somehow look up) the ciphers that UniVerse is using? We're making https (443) API calls to a middleware server (Windows-based, running Apache Tomcat) from within the UniVerse environment and we're getting the message:    This combination of host and port requires TLS.If we make the calls over http (80), they work just fine, but we need them to be over 443.Our network folks are thinking we might have a cipher conflict (one side or the other not using the same ciphers), but I don't know how to determine which ciphers UniVerse is using.  Any help with this would be greatly appreciated.  Or, if anyone has seen this issue before and knows the solution to the issue, that would be even better! Thanks!Brian------------------------------Brian Paige------

I'm seeing something strange and I'm not sure what to check next. We have 2 subroutines that work fine (both are called hundreds of times a day), but then on a certain date, both start throwing this message. The error looks like this:I've changed the sub names and parameter names.Unable to perform CALL to subroutine SUBROUTINE.ONE , Line    81 , Source CALLING.PROGRAMPress C to continue or Q to quit                                                Trap from an error message, error message name = SUBROUTINE_CALL_FAIL           Source changed to /data/app/path1/path2/program_dir/CALLING.PROGRAM0081 CALL SUBROUTINE.ONE(PARAM1,PARAM2,FILE1,FILE2,PARAM1,FILE3,FILE4,PARAM2)  This happened first back on 10/20/22. To fix I simply recompiled the subroutine, in this case SUBROUTINE.ONE and it worked fine until this week and it happened again.What is odd is another sub started throwing the same error on the same day and recompiling fixed that one also. That one also broke again at the same time aga

Easter greetings to you  ,Anyone can point me to how to add fields that are in Universe are not showing in our SQL db tables. Please assist show steps to include the missing fields not found in SQL tables for easy access and reporting purposes. Thanks. ------------------------------Roland KayverCore Banking SupportTeachers Savings and Loan Society Limited------------------------------

I am trying to connect to an API and need some helpUsing RHEL 7 and Universe 11.3.4The curl example they provided works in RHEL. curl -X 'GET'   'https://stagingapi.vagustracker.com/CoreVagusAPI/trip/AvailableTrips?vagusAPIKey=1A2B3C-1533-CMBD-8537-123456789'   -H 'accept: text/plain' This is my BASIC Code      URL = "https://stagingapi.vagustracker.com/CoreVagusAPI/trip/AvailableTrips"      KEY = '1A2B3C-1533-CMBD-8537-123456789'      X = addAuthenticationRule(X.CONTEXT,2, "VerificationStrength", "generous")      X.DEPTH = 2      X.SERVER.OR.CLIENT = 2             ; * CLIENT      X.RTN.CODE = setAuthenticationDepth(X.CONTEXT, X.DEPTH, X.SERVER.OR.CLIENT)      X.RTN.CODE = addAuthenticationRule(X.CONTEXT, 2, "ServerName", "stagingapi.vagustracker.com")      HTTP.METHOD="GET"      X.RTN.CODE = createSecureRequest(U

Hello,Has anyone used any of the available migration tools to migrate away from CentOS v7 to either RockyLinux or AlmaLinux?I just came across the AlmaLinux Elevate Project and am wondering if it is worthwhile to try it.As a secondary question, which of the two distributions is preferred?Vincent

We're pleased to announce the availability of the Rocket® MV BASIC for Visual Studio Code (VS Code) v1.10.1 maintenance release. Rocket MV BASIC for VS Code (MVVS) offers features to help your developers modernize, simplify, and work more productively in one of the most popular development environments, Microsoft Visual Studio Code. Starting with Rocket MVVS v1.7.0, a Minimum Viable Product (MVP) release, we shared a debugging preview with you and since then we've made several quarterly maintenance releases available on the VS Code Marketplace. These maintenance releases include new features, enhancements, and bug fixes. Here's a cumulative summary of what's in the last few releases: Enhancements: full path support in UniData $INCLUDE statement disconnect debug session when U2 server is disconnected add functions / labels / subroutines to breadcrumbs Support additional parameters for compilation Support additional parameters for debugging New Features: U2 server connection status

I can capture output from LIST.READU command as follows:EXECUTE 'LIST.READU' CAPTURING OUTPUTEach row can be extracted by looping through using @am to determine number of rows my question is how can one parse out the individual column fields - what delimiter is used to do parsing oris  the  data in each row  simply fixed length.------------------------------robert modrichDeveloperRocket Forum Shared AccountTEMECULA CA US------------------------------

In UniVerse Basic, if we read a record, not present in a file, with locking (after each read the record is not unlocked), it looks like this: OPEN "VOC" TO VOC ELSE STOP 201,"VOC" READU RECORD FROM VOC,"LISTY" THEN    CRT "1: [":RECORD:"]" END ELSE   CRT "1: NOT ON FILE" END READU RECORD FROM VOC,"LISTY" THEN    CRT "2: [":RECORD:"]" END ELSE   CRT "2: NOT ON FILE" END READU RECORD FROM VOC,"LISTY" THEN    CRT "3: [":RECORD:"]" END ELSE   CRT "3: NOT ON FILE" END Running program, the result is: 1: NOT ON FILE 2: NOT ON FILE 3: NOT ON FILE and is as expected, but if we tray this in UniObjects ActiveX o UniObjects .Net, the result looks like this: 1: NOT ON FILE 2: [] 3: [] Oops!! The first read is as expected but the next reads return an empty record like exiting for the THEN clause rather ELSE. If we unlock the record after each read, the result become: 1: NOT ON FILE 2: NOT ON FILE 3: NOT ON FILE The result is the Basic program. Another stuff to take into account.---------------------

Hello everyone, I am trying to parse a string against a pattern and return a delimited list of tokens.  OpenQM has a Parse() function but there is no equivalent in Universe that I can see.  Has anyone done something similar? For instance, if I have something like below: string = "Give me 97 bananas" tokens = Parse(string, "0X0N0X", Char(254)) I would like tokens variable to contain "Give me ":Char(254):"97":Char(254):" bananas" Any help or suggestions would be appreciates. ------------------------------Joseph von ArxSoftware DeveloperData Management Associates Inc DMACincinnati OH US------------------------------

In order to help the D3 community stay informed about when patches become available, we will be using the Rocket Forum to announce the availability of new D3 patches and service packs, so make sure that you check back often, or better yet, make sure you receive email notifications from the Rocket Forum. And if you have any questions, please reply to this thread. Here's a list of D3 platforms/versions and their current patch level: D3 AIX 10.3.2: ABS A7 D3 AIX 10.3.1: ABS A7 D3 AIX 10.2.0: Monitor M1, ABS A80 D3 Linux 10.3.2: ABS A7 D3 Linux 10.3.1: Monitor M2, ABS A7 D3 Linux 10.2.0: Monitor M12, Flash F8, SQL S3, ABS A80, Install I2 D3 Linux 10.1.0: Monitor M8, Flash F7, ABS A51 D3 Windows 10.3: Service Pack 2 D3 Windows 10.2: Service Pack 5 To get these patches or to check patch levels of versions not listed above, please go to the Downloads section of the Rocket Community  ------------------------------Brian S. CramPrincipal Technical Support EngineerRocket Software---------

ODBC Driver. Good day all, thanks for the help with the previous post. Its given me plenty to work on. Along with this, I've had another issue that has risen this week. When Live Partition Mobile'ing a AIX Server, we hit problems with the OCDB driver. Namely that the server moves live with no issue, until you restart UniVerse, then we get license problems. If the server is moved back to the original machine, the license problem still occurs. So it needs to be reset. Now I know that on our Redhat VMware environments this is not a problem, and I'm sure its something that I could fix, but before I re-invent the wheel, I figured I'd ask here. Thanks, ------------------------------Daniel Martin-CorbenRocket Forum Shared Account------------------------------

At Rocket Software we are committed to and value product security.  Rocket Software continually reviews security compliance policies and trends to strengthen our products. We've  recently implemented the Rocket Vulnerability Disclosure Program (VDP) as an added measure of vigilance.  This program allows us to collaborate with valued researchers to respond to vulnerabilities found in Rocket Software products and resolve them on behalf of our customers. Recently, Rapid7 Research discovered several vulnerabilities in Rocket UniData 8.2.4 and reported them through the VDP.  Rapid7 found vulnerabilities with the UniData UniRPC server (and related services) running on the Linux platform.  Due to the nature of the MultiValue applications, Rapid7 believes that widespread exploitation of the vulnerabilities is unlikely; these services tend to be found on the backend and are rarely internet-facing.  That being said, the software stack is commonly used by large organizations to store and manage

Trying to create a generic write/delete trigger subroutine and would like to be able to determine the File name. Is there a way to get back to it from within a Trigger? I'm trying to write to a specific history file, based on the file name. I know I have a File Variable, but I'm not familiar how to parse that or cast it to a normal variable that I could parse. I've looked through the SYSTEM() values at the time and don't see anything obvious set there for the file.I'm really trying to avoid a separate subroutine for each file if possible.Jbase Version 5.6.6. Thanks, EDIT: After posting, I did find out that IOCTL works. IF IOCTL(FILEVAR,JBC_COMMAND_GETFILENAME,FILENAME) THEN     FILENAME = FIELD(FILENAME,'/',DCOUNT(FILENAME,'/')) Is there a simpler way?------------------------------Greg MotterRocket Forum Shared Account------------------------------

In Unidata can you disable the LOGTO verb based upon a user login?------------------------------robert modrichDeveloperRocket Forum Shared AccountTEMECULA CA US------------------------------

Greetings folks! Can someone please share the purpose/s of the WATCHLOG & LOGOFFS files in D3's DM account? Many THX!------------------------------[Doc] [Ruckel][IT Guy][Southwest Traders][Temecula] [CA] [USA][Doc]------------------------------

What are all the valid ways to quote literal strings when assigning them to variables in unibasic on Unidata?------------------------------Shawn Waldieenterprise application developerRocket Forum Shared AccountLos Angeles CA US------------------------------

We are running jBase 5.2 on linux. Back when we were running 4.2  we used to use sudo to run jBase commands. For example we might have this line in a program: EXECUTE "sudo j4 SP-CLEAR BLUE-FQ"  This would clear out all the print jobs from the BLUE-FQ form queue even if a print job was protected. The j4 file just set up some jBase environment variables so sudo would work. My question is - will this still work? If so, what environment variables are needed in the j4 file and where should the j4 file be placed? Thanks for any help.------------------------------Warren MoriarityIT ManagerRocket Forum Shared Account------------------------------

Any idea what this message means? In /data/pub/TEST/SMART/LIVE/CTLG/UOLOGIN at line 56 index: 201 to one dimension                                                                                                                                                              matrix is out of rangelobal HScript=`Set BackPages="18"`lobal HScript=`Set Columns="132"`xecute HScript ------------------------------David Rivera------------------------------

Good day, I am trying to connect to a Universe database using ODBC and have set up my DSN. However when testing the ODBC DSN or opening an ODBC connection to that DSN from C# results in the following error message. System.Data.Odbc.OdbcException: 'ERROR [00000] [Rocket U2][U2ODBC][0302086]Error ID: 46  Severity: ERROR  Facility: DBCAPERR - UCI Error. Func: SQLExecDirect(); State: S1000; U2 Database code: 950088; Msg: [U2][SQL Client][UNIVERSE]UniVerse/SQL: syntax error.  Unexpected symbol.  Token was "?". Scanned command was CALL "*HS.SCHEMA" ( ? .ERROR [00000] [Rocket U2][U2ODBC][0302086]Error ID: 46  Severity: ERROR  Facility: DBCAPERR - UCI Error. Func: SQLExecDirect(); State: S1000; U2 Database code: 950088; Msg: [U2][SQL Client][UNIVERSE]UniVerse/SQL: syntax error.  Unexpected symbol.  Token was "?". Scanned command was CALL "*HS.SCHEMA" ( ? .[Rocket U2][U2ODBC][0400182]Connection not open.' I unfortunately am stuck and cannot find any inf

Our ERP vendor is suggesting that the following compilation errors stem from "...a known UniBasic limitation on the number of constants. Tech Note 1193075 on Rocket Software's support site explains that there is a limit to the number of variables and constants that can be used in a BASIC program. The limits are 32767 variables and 32765 constants. However, the maximum space that constants can take up in a program is 50,000 bytes and this figure is reduced by the actual number of constants." too many constants near line 115 of...too many constants near line 121 of...too many constants near line 149 of...too many constants near line 149 of... However, all that is required to get past it is is commenting out the following variable assignment, which suggests to me that there is something the string that is freaking out the compiler: X.XML.LINE = '<w:p w14:paraId="50845D62" w14:textId="71EB9312" w:rsidR="00C91BE8" w:rsidRDefault="00C91BE8" w:rsidP="00C91BE8"><w:pPr><w:pStyle