Rocket MultiValue

SUBROUTINE XMLJEDI(parameters, jedi_command, item_id, data_record, defer_commit, error_code)* 04/27/22 by Dan Ell, Tyler McDonaugh, Jenna Hernandez, Charles Barouch *! ********************************************************************** *! Creates an xpath model of all the tags in an XML document *! and treats the XML document like a read-only jBASE file. *! ********************************************************************** *!! Add this to the current directory to create a jEDI file for XML!! ED . SAMPLE.XML! .I JBC__SOB JediInitSUB XMLJEDI filename=/big/tmp/SampleLarge.xml,xmlmap=SAMPLE.MAP,dict=SAMPLE.XML]D! 001 JBC__SOB JediInitSUB XMLJEDI filename=/big/tmp/SampleLarge.xml,xmlmap=SAMPLE.MAP,dict=SAMPLE.XML]D! .FI!! xmlmap is the item ID to XML.MAPS which holds this information!! ED XML.MAPS SAMPLE.MAP! 001 Sample PLANT xml file <-- Description (not used in this program)! 002 PLANT <-- Record tag pre-defined (not in this program), <Record> ... </Record>! 003

A new jEDI that allows you to access the XML file (currently read-only) as if it was a standard jBASE hashed file with the key being the row of the XML file.XMLJEDI is the JEDI program. MAKEXML will generate a sample XML item with however many data items you want. TEXTXML allows you to test for best blocksize for the XML file. With this new JEDI, you can add dict= portion of param and it will create DICT items when the XML is first mapped.  You can also specify the blocksize.    When run against a 500,000 record XML file with a size of 94Mb, it can LIST the file in 3 minutes and 24 seconds.   Here is an example of the jEDI stub for a sample xml file called /big/tmp/SampleLarge.xml : jsh>ED . SAMPLE.XML<Enter>New Record SAMPLE.XML TOP I<Enter> 001+ JBC__SOB JediInitSUB XMLJEDI filename=/big/tmp/SampleLarge.xml,xmlmap=SAMPLE.MAP,dict=SAMPLE.XML]D,blocksize=63488<Enter> 002+<Enter> FI<Enter>   After you add the jEDI stub to the current directory, you creat

Hello,We are getting the error show below, when we try to connect to MVSToolkit.  It only happens to one of our apps. The problem goes away on its own, if we keep trying to connect for several minutes. Please let me know if you know what may cause this error.Thanks,Chris

I'm working on a script to copy files at the Linux level from one folder to another. The commands are:SH -c"find CIF.IMAGES -type f -exec mv {} /bl1/newfolder \\;"CIF.IMAGES is a folder in my account and I'm trying to move all of the files to the newfolder in /bl1. The issue is that the paragraph interpreter is seeing the "\\" as an unmatched quote and fails, so nothing gets moved.Suggestions?------------------------------Jeff TeterWoodforest National BankThe Woodlands, TX------------------------------

------------------------------Jill OrsiniInside Sales MVRocket Internal - All Brands------------------------------

------------------------------Jill OrsiniInside Sales MVRocket Internal - All Brands------------------------------

In jBASE 5.8, an enhancement to the BASIC (aka jBC) compiler has made comparisons against '' (empty string) dramatically faster.Historically it was quicker to compare the LEN() of a variable against 0 to test if a variable was '' (NULL). For example if you're on 5.7 (or earlier) try the sample code. workVar = STR('the quick brown fox jumps over the lazy dog', 10000) startTime = SYSTEM(12) FOR I = 1 TO 10000 IF workVar NE '' THEN END NEXT I CRT 'First FOR loop took: ':SYSTEM(12)-startTime startTime = SYSTEM(12) FOR I = 1 TO 10000 IF LEN(workVar) THEN END NEXT I CRT 'Second FOR loop took: ':SYSTEM(12)-startTime ​ On 5.8 the statement: IF workVAR NE '' THEN now gets compiled to a special function (this is also true for EQ '') that performs the same as IF LEN(workVar) NE 0 THEN so the sample program (above) will produce similar results (depending on system usage).------------------------------Peter FalsonRocket Internal - All Brands------------------------------

Voting for DBTA Readers' Choice Awards is open now through Wednesday, May 11, 2022. DBTA will feature the award winners in a special section of the August edition of DBTA Magazine, and at www.DBTA.com. Rocket Software is proud to have Rocket Software MultiValue Suite (D3, UniVerse, UniData, jBASE and OpenQM) in the "Best MultiValue Database" category. Your organization has invested in your business-critical MultiValue-based applications over the course of years. And ensuring those applications can adapt and grow alongside your organization means more return on those investments for years to come. Rocket Software offers the largest range of modernization solutions for the MultiValue (MV) Application Platform that help you avoid risky, costly replatforming initiatives. Analysts like IDC, Gartner and Forrester agree that modernization strategies continue to move to the top of the list for most CIOs. Let Rocket be the engine in your modernization journey and help you develop and implement

Voting for DBTA Readers' Choice Awards is open now through Wednesday, May 11, 2022. DBTA will feature the award winners in a special section of the August edition of DBTA Magazine, and at www.DBTA.com. Rocket Software is proud to have Rocket Software MultiValue Suite (D3, UniVerse, UniData, jBASE and OpenQM) in the "Best MultiValue Database" category. Your organization has invested in your business-critical MultiValue-based applications over the course of years. And ensuring those applications can adapt and grow alongside your organization means more return on those investments for years to come. Rocket Software offers the largest range of modernization solutions for the MultiValue (MV) Application Platform that help you avoid risky, costly replatforming initiatives. Analysts like IDC, Gartner and Forrester agree that modernization strategies continue to move to the top of the list for most CIOs. Let Rocket be the engine in your modernization journey and help you develop and implement

Voting for DBTA Readers' Choice Awards is open now through Wednesday, May 11, 2022. DBTA will feature the award winners in a special section of the August edition of DBTA Magazine, and at www.DBTA.com. Rocket Software is proud to have Rocket Software MultiValue Suite (D3, UniVerse, UniData, jBASE and OpenQM) in the "Best MultiValue Database" category. Your organization has invested in your business-critical MultiValue-based applications over the course of years. And ensuring those applications can adapt and grow alongside your organization means more return on those investments for years to come. Rocket Software offers the largest range of modernization solutions for the MultiValue (MV) Application Platform that help you avoid risky, costly replatforming initiatives. Analysts like IDC, Gartner and Forrester agree that modernization strategies continue to move to the top of the list for most CIOs. Let Rocket be the engine in your modernization journey and help you develop and implement

Voting for DBTA Readers' Choice Awards is open now through Wednesday, May 11, 2022. DBTA will feature the award winners in a special section of the August edition of DBTA Magazine, and at www.DBTA.com. Rocket Software is proud to have Rocket Software MultiValue Suite (D3, UniVerse, UniData, jBASE and OpenQM) in the "Best MultiValue Database" category. Your organization has invested in your business-critical MultiValue-based applications over the course of years. And ensuring those applications can adapt and grow alongside your organization means more return on those investments for years to come. Rocket Software offers the largest range of modernization solutions for the MultiValue (MV) Application Platform that help you avoid risky, costly replatforming initiatives. Analysts like IDC, Gartner and Forrester agree that modernization strategies continue to move to the top of the list for most CIOs. Let Rocket be the engine in your modernization journey and help you develop and implement

------------------------------Kathy LarsonProduct Marketing Manager, MultiValueRocket SoftwareDenver, CO720-225-6531------------------------------

MultiValue Experiences version 1.2.0.632 has been released on January 28 2022 for the below platforms/versions:AIX POWER       7.1,  7.2CentOS       7,  8RedHat Enterprise Linux Intel       7,  8SuSE Linux Enterprise Server Intel       15.0Windows       Windows 11,  2012,  2016,  2019This product is available to order immediately via your Rocket software provider or by logging into your RBC account at https://rbc.rocketsoftware.com or https://rbcint.rocketsoftware.com.Additional Product Information is available on the Product Availability Matrix at https://rbc.rocketsoftware.com/matrix.asp or https://rbcint.rocketsoftware.com/matrix.aspFor any questions on product availability, please contact u2askus@rocketsoftware.com.

Hi Guys,got a conundrum for you !!!one of my users wanted a simple report to extract details for a part that needed data from the main report file containing most of the required data but also from another file in the same data account. BTW. We are Universe usersThe details in the local file are all single values, however the field for data from the other file is multivalued and the user only needs the first multi-value from the second field in the record in the other file.as this request was likely to be a one off, which I thought would a simple quick and dirty job, I did not want to bother with a sub-routine or create a program to explode the MV's in the other file into a workfile first or indeed write a program to do the whole report which needed to go into Excel.So I naively assumed that extracting this detail would be easily doable with I Descriptors.this is what the data record looks like in the second file0001: 04551VM14550VM04913VM049120002: 15143VM15148VM15150VM151600003: 12VM

Hello,I have a huge problem with D3, hopefully somebody can help me.Description:I open D3: d3vme /debugEverything seems ok until:Unable to open "users" fileand after a while:*** Remote File System Error ***Open (fsi:dem,users,) Cannot Bind Remote Connectionct users'fsi:dm' is not a valid md namect md users  users001 Q002 fsi:dm003 users004005006007008009 I010 18I made my backup by copying the folder D3 in Windows.I hope somebody can give me a hint to solve the problem. If more information is required just ask.Thanks a lotAndy Engel Luxembourg------------------------------Andy EngelRocket Forum Shared Account------------------------------

We are using SBClient v6.3.3 with UniVerse 11.2I've hit situations where when trying to update / delete a record using a SB+ screen it just hangs... or hangs and then logs out, without any error messages indicating the issue.  I've checked the /usr/uv/errorlog file for some indication of the issue, but that to leads no where.   Can anyone point me in the right direction to get under issues like this?   A thought I had is to start setting a bunch of debug statements in the routines... but is there another, not so drastic approach?Best Regards,Michael

Version 2.3.2 of the Rocket MVS Toolkit RESTful services tool for D3 and mvBase was released this afternoon. Installers and documentation can be found on the Rocket Community Portal:https://my.rocketsoftware.com/RocketCommunity#/downloadsWith this new version of the MVS Toolkit, MVSTK logging was upgraded to log4j 2.17.2 to address security vulnerabilities. Also, OpenJDK was upgraded to OpenJDK 11 to support TLS 1.3.------------------------------Brian S. CramPrincipal Technical Support EngineerRocket Software------------------------------

We use wIntegrate v6.4 and we try to set the "Title" preferences under Setup to provide some indication of which system we are logged into.  When trying to indicate "~" for port number, what we get is "U2 SSL" rather than the port number.Are there any other choices that may actually provide the port number?  It would be extremely helpful when dealing with locks, etc.Thanks,Nelson------------------------------Nelson SchrothpresidentC3CompleteShop LLCHarrison OH US------------------------------

Is there a list of the optimizations the Unibasic compiler does available anywhere?------------------------------Elaine LitchfieldOwnerElaine Litchfield ConsultingSan Diego CA US------------------------------

I'm currently using UniVerse 11.3 for development on Windows. I would like to set up a linux server and move my UniVerse there. Does anyone know if it would be possible to also load OpenQM on the same server?Dale

Thanks for the suggestion. I primarily use Dynamic Connect, but thatdoesn't work for me either.I still think it's a system setting of some kind, since I cannot get it towork from any emulator.On Tue, Apr 19, 2022 at 3:04 AM John Jenkins via Rocket Forum wrote:> If using wIntegrate or Dynamic Connect, please try Setup -> keyboard ->> Break Key and choose (none) in the selection box - the key should...> Invite your colleagues to join the Rocket Forum and grow our expert> network.> ------------------------------> [image: Rocket Software] > Rocket U2 | UniVerse & UniData> > Post New Message Online> > Invite your colleagues to join the Rocket Forum and grow our expert> network. Share this link. > Re: How can I interrupt programs with ctrl-C (or any keystroke) on Windows> UniData?> > Reply to Group Online> > [image: John Jenkins]> > Apr 19, 2022 6:02 AM> John Jenkins> > If using wIntegrate or Dynamic Connect, please try Setup -> keyboard ->> Break Key and choose (none) in the selection bo

The break key from any emulator I choose does not interrupt programs or UniQuery commands.  The only thing is display "yo" with diacritical marks if at an input prompt.I just do support for existing clients.  I have recently upgraded from a very old mvBase server to UniData on Win10.  I noticed ^C was not interrupting my programs, but I figured it was a emulator setting I could find later.  Well, this is later, and I cannot figure out how to allow interrupts in UniBasic programs.  I don't see any setting that would prevent this.I have tried changing the default Break Key (in Dynamic Connect) to another character.  I have tried compiling with -D.  I have tried another emulator.I have tied never making a mistake in a program so it doesn't get into an endless loop.  But that doesn't always happen.  Then I have to figure out which of my many terminal emulators with the same user and port status (DC doesn't help) I need to kill with a stopudt or

Hello,Oracle client version that is supported by UniData EDA is Oracle client version 11 (read it in UniData EDA doc for 7.x and 8.x).  OS: HP-UX Itanium 11.  Currently, we are using Oracle instant client 11.2 with UniData 7.3.   I was checking $UDTBIN/edasetup.sh script.  It seems like EDA uses following libraries/usr/lib/hpux64/libclntsh.so.11.1@ -> /usr/local/instantclient/libclntsh.so.11.1/usr/lib/hpux64/libnnz11.so@ -> /usr/local/instantclient/libnnz11.so/usr/lib/hpux64/libocci.so.11.1@ -> /usr/local/instantclient/libocci.so.11.1/usr/lib/hpux64/libociei.so@ -> /usr/local/instantclient/libociei.soWe need to upgrade Oracle client to be at least 12.2.  I am wondering if I can force EDA to use higher version of oracle client by changing the above symbolic links.  For example, I want to use 19c client.. maybe change sym link to be like below manually? /usr/lib/hpux64/libclntsh.so.11.1  ->  /blahblah/libclntsh.so.19.1/usr/lib/hpux64/libocci.so.11.1 -> /blahblah/libnnz1

We just updated our tools to handle D3 dictionaries.Unfortunately, we do not have D3 running anymore.Is there anyone willing to test it for me?------------------------------Doug AverchOwnerU2 Logicwww.u2logic.com/tools.html------------------------------

I was an Info/Basic programmer with about ten years of experience working on a PRIME 9955 system.   When Prime went out of business the college I was working for switched to Oracle and I've been working with Oracle since 1996.  As I coast into retirement I'm interested in reviving the multi-value skills I once had.  I downloaded UNIVERSE and UNIDATA from Rockets website and started playing with it.   They seem very similar.For those of you that were once PR1ME Info/Basic, Inform, Primos developers, which environment would you suggest I focus on, UNIVERSE or UNIDATA?Also, is there a cheap way to get a Personal Edition (PE), single seat license?  I really don't want to develop and small or large scale systems.  I'm really interested in reviving the PICK skills I once had.I have a copy of INFO/PC that I installed on an old Windows 98 system I recently rebuilt to play games.  INFO/PC was a cool PE system.ThanksDan ------------------------------Daniel SimsonPresidentRocket Forum Shared