Rocket MultiValue

Hello,Im using XDOM api in Universe 11.3.1 and I'm trying to import 'an xml fragment' from string into a current nodeHandle.Explanations :1 - Im creating an handle with XDOMOpen 2 - Im appending a node into this handleExample, at this time, my handle is a tree like this :<root>  <child>  </child></root> 3 - Im using XDOMLocate to get a new handle to "child" node, nammed childNodeHandle.4 - Now, I want to append to childNodeHandle an 'xml fragment' from a string (for example '<subChild><subSubChild><subSubSubChild></subSubSubChild></subSubChild></subChild>')Problem : if I do a new XDOMOpen with this fragment and get a fragmentHandle, I cant use XDOMIAppend/XDOMInsert(childNodeHandle....fragmentHandle) because childNodeHandle and fragmentHandle are not in the same tree in memory - its normal (I got this error  : DOM Exception code: 4 (A node is used in a different document than the one that created it (that d

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

Hi Members,My organisation is trying to engage Tableau for our reporting system. Currently our universe system is 11 .2. Just wondering if Tableau can connect to universe.Please advise accordingly.Thanks------------------------------Roland KayverCore Banking SupportTeachers Savings and Loan Society Limited------------------------------

Thanks Brian (as usual)!

Is there a way to serialize a UDONode in the UniData debugger?  If not, may I suggest the enhancement; it would be very helpful.!\\RESTMSG a UDO node variable. ------------------------------Elaine LitchfieldOwnerElaine Litchfield ConsultingSan Diego CA US------------------------------

Hello Forum Members!I have a question and hope someone can point me in the right direction.    I recently stumpled across the a file directory named __V__VIEW.     It appears it has something to link UniData to an SQL environment.   My question is this....  Where can I find documentation on this?    I can seem to find it or maybe I'm looking in the wrong places.If someone could lead me into the right direction, I will be most appreciative!!!Thank you for your time and consideration in advance.Sincerely,------------------------------Grant BoicePrincipal Software DeveloperMatheson Tri-Gas Inc.3 Mountainview RoadWarren, NJ 07059------------------------------

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 Python is available in Rocket D3 10.3.1 - The Rocket MultiValue Blog Python is an exciting addition to the Rocket Software MultiValue databases. Following on the success of bringing Python to UniData and UniVerse, Rocket Software in now bringing Python to Rocket D3. In Rocket D3 10.3.1 we have added Python to work with your existing data in a new language. View this on The Rocket MultiValue Blog > Which I have like so :PYHOME=C:\\\\Users\\\\Stefano Gallotta\\\\AppData\\\\Local\\\\Microsoft\\\\WindowsApps\\\\PythonSoftwareFoundation.Python.3.9_qbz5n2kfra8p0PYLIB=C:\\Program Files\\Python\\Python37\\python35.dllAccording to my machine.However, I still get: (obviously I don't have the correct setup) :(Any pointer/ideas/recomms /stuff to read! :)ThanksStefa

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

Hello!In another thread, Jonathan indicated:"At 11.3.1 python was added for Windows and Linux only. If you want to use python on another platform you will have to upgrade past 11.3.1. Solaris was added at 11.3.2 , Aix was added at 12.1.1 and currently is not available for HP."According to the release notes, Python has been supported in UniVerse on AIX since 11.3.2, same as Solaris. Are the release notes incorrect?Brian Paige

Hello everyone  ,Anyway where I can extract data directly from universe using python?I want to pull data directly from universe and display it using python. Need some guidance here. Thank you.------------------------------Roland KayverCore Banking SupportRocket Forum Shared Account------------------------------

As a normal practice I wouldn't be posting example code onto the forum unless someone was needing help about a specific problem. We did have a question come in from a customer this week asking for a new conversion code be added to UniData. This brought up a couple of interesting subjects. The customer was not aware that you could write your own code following a template to create your own conversion codes. It took me some time to find where this was buried in the manuals I can understand why they would not have come across it.So just in case others were not aware you could do this I thought I'd share with you how you do this.SUBROUTINE SUBNAME( return_val, STATUS, input_val, TYPE )***************************************************************** Brief functional description** (c) Copyright notice**************************************************************** Detailed description** Usage, such as return_val = OCONV(input_val,"USUBNAME")**************************************************

When reading uv/errlog events, I would like to know what the call return stack was when the error occurred.In other words, the same info one gets from PORT.STATUS LAYER.STACK, or RAID "T" trace command, or SYSTEM(9001) function call. Create a UVCONFIG parameter for verbose error logging if you think it will be too burdensome to inflict on unsuspecting customers, but with today's system speed and storage capabilities, I think most would opt for more info. Business case: uv/errlog is an underappreciated but powerful tool for application quality improvement by working patterns of errors, correcting data, & -- most importantly! – finding & correcting root causes. Sometimes it is hard to resolve nebulous errors like:- Bad data "Y" for conversion "D2/". Unconverted data used for selection.- RetrieVe: syntax error. Unexpected symbol. Token was "ALL". Scanned command was . . .- Verb `VAN` is not in your VOC- Program "XYZ": Line 1234, Variable "ABC" previously undefined. Empty stri

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

I was wondering if someone could comment on the use of the WIN.GETFTP host subroutine.  Every time we use it, it spits out a message "Invalid conversion type NO".  We have always set the type to "0" for ASCII when we make the call, but no matter what we set it to, we always get this message (and have for many years and versions of wIntegrate).  We currently use v6.4.0.What is it complaining about?------------------------------Nelson SchrothpresidentC3CompleteShop LLCHarrison OH US------------------------------

We currently have two dll installed one for pdf creation and one for qr creation, we did both of them back in 2012.   And of course our notes from then are spars.  We'd like to add another dll for excel creation.   I'm assuming that in 2015 we were using Visual Studio 2012 to compile and link the C code.   We're using VS2019 to do the same for the new dll.   dumpbin for the original two dll's shows linker version 11 (which I believe is VS2012).  When we manually install the dll into bin and add the entry to gci.admin (and confirm the addition to the registry).   we can't get the new dll to show up in GCI.NTMAP.B (the exist two dll's do, with there functions listed).My question(s).   Is there any log file that shows any hint of why the new dll wouldn't load?    Or if VS2019 would not work on win2012r2 or universe 11.2.4?I also, walked through the auto creation of the multiply example (ie gci.admin,

Hey everyone, complete noob here who has been tasked with implementing some stuff with uopy.We have been reviewing the security of our proposed setup and have a few questions around uopy, the Unix user and the UniVerse user that we can't find any definitive answers for, so I'm hoping somebody in the community can lead us to the right bit of documentation for these:1. It seems that uopy has the capability to run SH commands (limited by the VOC?).  Is there a way to completely disable SH?  My limited understanding is that the VOC can be written to by the UniVerse user so can they re-enable access to SH by themselves?2. The uopy library seems to require a Unix user to operate.  If we disable the shell in /etc/passwd (or point their shell entry to /bin/false or something), would that have the effect of also disabling SH access via UniVerse?3. If we have to have a Unix user for our uopy to operate, can be make ownership of all their files read-only so they can't be modified?&

hello folks,I try to define a euro.CVT configuration usable on CUI and GUI  with sbclient.We want to store euro symbol on char(158) 0x9e working on windows-1252, euro U+20AC is 0x80 char(128)so, I define a config file euro.CVT like this :  [input] 0x9E=0x80 [output] 0x80=0x9E [display] ​ and I set it in SBclient Nationality Setup so, it works correctly on GUI mode but on CUI I receive bad char.- at basic INPUT I receive char(95)  - at display the oem2ansi is not done and the display show badchar from codpage/font 'Ç' (0x80) 'hard position into font ... . can you share any idea how to setup correctly to use CUI/GUI together with the same config ? PS : working on universe, CONVERT_EURO is 0 (off)regardsmanu

MultiValue Integration Server version 1.3.1 has been released on June 28 2022 for the below platforms/versions:AIX POWER       7.1,  7.2AlmaLinux       8Amazon Linux       2CentOS       7,  8Oracle Enterprise Linux x86       7,  8RedHat Enterprise Linux Intel       7,  8Rocky Linux       8SuSE Linux Enterprise Server Intel       11.0,  12.0,  15.0Windows       Windows 10,  Windows 11,  2016,  2019,  2022This 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

I'm developing a subroutine that will copy a record from one file to another.Depending on the value of one of the input arguments, the target record will be overwritten if it already exists in the target file.Upon confirmation of a successful copy, and depending on the value of another input argument, the source record could potentially be deleted.I'm looking for methods of confirming the copy was successful; i.e., the target record is identical to the source record.Any suggestions?------------------------------Shawn WaldieManager, Enterprise Application DevelopmentRocket Forum Shared AccountLos Angeles CA US------------------------------

We will soon upgrade UV storage to solid state.  A couple times in my life I've seen fast I/O bring unanticipated timing issues when file updates happen sooner than anticipated by the application design.  I'm struggling to remember details.  One was a multi-write logical transaction where, at some point, some files were moved to a much faster disk or bus than the others, so the writes got temporarily out of synch, creating unanticipated confusion for nearly simultaneous queries.  It wasn't a problem when everything was slower. Would anyone care to share any such gotchas they've seen, particularly when moving to solid state storage? (It does seem an odd thing to complain about:  my system is too fast.)------------------------------Chuck StevensonDBA / SW DeveloperPomeroyUS------------------------------

Hi I am looking to support a scenario where multiple users share a single workstation and want to work in my SBXA application within the context and constraints of their own user accounts.I'd like to make this switch of user accounts (which is frequent) as quick and painless as possible. And my initial thoughts are to explore smart cards/NFC cards and readers to achieve this.Wondering if anyone has given some thought to how one might go about integrating smartcard/NFC readers with SBXA.Initial thoughts are to explore custom control in SB/XA written in .NET and have it listen for commands and invoke BASIC program to login/logout etc.Not sure if there will be any way to programmatically log a different user in, or whether the SH.SEC.API can decrypt a password, or whether switch of users can occur without knowing the password.Note windows single sign on is not and cannot be used.I would welcome some idea or alternative approaches that the community has implemented to address a similar cha

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

We utilize 4 connection pools used by our Web Service calls.  Occasionally we have had web services timing out and not even reaching our U2 programs.  I was hoping for some ideas on how we might  check the connection pools to determine when they are overly busy, or calls are backing up/timing out.  We have not found a way to determine this.  Our web team contacts us when their calls are failing and we must dig around looking for a problem.  Hoping there might be some "tools" that would specifically target the health of the connection pools.------------------------------Nelson SchrothpresidentC3CompleteShop LLCHarrison OH US------------------------------

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 executed. This may be a requirement especially if this is a RESTful API then the initial program will be an EXECUTE from the jbase_agent worker process.The advantage of using -JD or -Jd is not having place a DEBUG statement in your code. Though you may still find this easier depending on your