Rocket MultiValue

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

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

Good afternoon D3 folks!What is best D3 DBMS practice when it comes to deleting or RESIZE-ing data sections from a files dictionary?If we don't delete these data sections (we use them as work files when compiling report data) we end resizing too many of these data sections/work files. If I delete them, FOF gets populated with much meaningless data.Thank you in advance for your helpful reply/ies!~Doc

Historically, multi-value environments have been somewhat lax in enforcing use of locks when updating files. The locking system is voluntary and, if applications choose not to use locks, data integrity issues may arise. Two processes performing a read/modify/write update of the same record may overlap with one overwriting the other.There is a simple rule that eliminates this problem. Never write or delete a record without locking it first. This could be a simple update lock that protects the specific record or a file lock that effectively locks all records in the file.It is important to understand the significance of the locking system being voluntary. A badly written program that updates a record without locking it is not affected by the locks set by well written programs that follow the rules.This situation should never have been allowed. Attempting to write or delete a record without a lock should lead to some form of application error, however, such a rule cannot be retrospectively

When working in Unidata, I was able to toggle on a display of each executed line as they were executed. What is the equivalent command in Universe please?In Unidata at the debugger command, I would type 'V' to view source before executing the line. In Universe, I can type I or L to show the source line (or Z to display the next 10), but this isn't a toggle. It only does the one line you are on it seems. In Unidata, once the V was toggled 'on', I could do a command to execute the next 50 instructions and would see the source of each line for those 50.  So my question is, how can I see the source for each line executed without typing in the 'L' at every line? Thanks!!------------------------------Kathleen HambrickProgrammer at Colwell------------------------------

Hi allI'm trying to work with a session pool in uopy and I'd like to be able to switch between different sessions as it can be done using the command ic_setsession in the uvic32.dll API.I create them in this fashion: sesiones = [] for i in range(10): sesiones.append( uopy.connect(host='...', user='...', password='...', account='...', encoding='cp850', service=uopy.UV_SERVICE, port=31438)) Is there a way to do this?How can I make sesiones[i] the active session at will?------------------------------Hector CortigueraRocket Forum Shared Account------------------------------

The Rocket MultiValue R&D team understands your applications depend on a stable, high-quality version of UniVerse as you plan upgrades and enhancements to your application(s). To incorporate customer application testing, we are extending our UniVerse 12.2.1 quality assurance (QA) cycle. UniVerse 12.2.1  will be worth the wait and will include: UV BASIC profiling for application performance analysis and insight to help you quickly determine bottlenecks and performance improvement areas in your BASIC code A 3rd mode allowing you to run with the system buffer off and in single-process mode 50+ enhancements 150+ bug fixes Our plan is to complete QA near the end of July and release on August 30th.------------------------------Christine RizzaMV Product ManagerRocket Softwarecrizza@rocketsoftware.com------------------------------

Hi,I've been using a small BASIC program I wrote as my shell environment. Originally for UniVerse, I ported it to D3 and it seems to be working relatively well. The big gains have been getting a permanent history file with arrow keys  to navigate the history. The tab completion is also helpful and having a prompt with which account I'm currently in is useful.You can pull the NSH file and update the DEFINE statements for D3 and your specific platform and them compile it. D3 10.2 and earlier does require some more work as it doesn't support the DEFINE statement so you'll need to use a cleaner program to strip out the conditional code I have to support multiple platforms. GitHub - Krowemoh/NovaShell: A Fancier ShellLet me know if you need any help setting it up! This should work with vt100 and wy50.------------------------------Nivethan ThiyagarajahProgrammerAsynchron Systems IncToronto ON CA------------------------------

I have a customer that wants to leave Auto-Extend Field Length (from /USER.FLAGS) set to "N" so that their users can't type beyond the size of the input.  However, now they want to dip a credit card and the encrypted value returned from the chip reader is a few hundred bytes long, far too long for a single input.  Is there a way to enable the extended field length on just one prompt?In character mode, doing a DATA "@12" in the process before on the prompt does the trick nicely.  However, that doesn't work on GUI.  Hitting Ctrl-End before the card is dipped works to extend the field length but the customer (understandably) doesn't want their users to have to press Ctrl-End before every dip.  Is there anything that can be set to enable the extended field length automatically but only on a single prompt?------------------------------Kevin KingPresidentPrecision Solutions, Inc.Longmont CO US------------------------------

We have a behavior that we have been trying to track down for quite some time and it keeps flaring up.We are on AIX 7.1, Unidata 8.2.2, but also does it on 7.3.3We have nfa connections that will create thousands of these processes "nfauser 29753982 13697148 14 19:28:43 - 0:01 udtsvr -u -o/usr/ud/tmp" A single nfauser connection or a couple of the same will start up remotely, reaching over to another server via a nfa FX pointer. Normally its fine and works like it should, we have thousands of these daily at least and they are fine.  A few applications will cause it sporadically. Below is an example we were able to create that does it, though I had to run 3 or more at once to get it to do it:From ECL command line = "SELECT ORDY CONVO.KEYS.BAD" will trip the condition if ran 3x during testing from our system called "DP" to our "DOCK" system.:ED DICT ORDY CONVO.KEYS.BADTop of "CONVO.KEYS.BAD" in "DICT ORDY", 6 lines, 54 characters.001: V002: SUBR('GET.CONVO.KEYS.BAD',@ID)003:004: Convo.key

By storing your data in internal format in your MV database, you can easily convert the data to a desired display format.   One of the most common uses for conversion codes is dealing with dates.  In MV the internal representation of the date is an integer.   For example the internal format for "04 Dec 2014" is 17140.  Those familiar with U2 BASIC know they can get the internal format to the display date format by using the OCONV function.   I.e   PRINT OCONV(17140, "D")   The 'D' is the Date conversion code and it is used with both the ICONV function as well as the OCONV function.   With the introduction of the u2py modulo, these functions have been exposed as methods of the u2py.DynArray object. python> test = u2py.DynArray("04 Dec 2014")python> itest =  test.iconv("D")python> itest<u2py.DynArray value=b'17140'> Since the itest variable now has a date in internal format, you can use a different conversion code to get other display formats.  python> itest.oconv("D4

Hi,What is the correct way to reset page headers and numbers when using the BASIC "HEADING" statement after issuing a PRINTER CLOSE statement?We have a program that generates multiple reports based on the same SELECT list.???? Each report must start at page number 1.The only time it works is by issuing the following statements: * PRINTER ON * HEADING ...... * PAGE 1This, however, generates a blank first page on each report.How can we correct this?-- Best regards and keep safe,Vincent ???Kim??? ElliottITC CoordinatorBearings & Accessories Ltd.83 Harbour StreetKingstonJamaica, W.I.Tel: 876-922-1950Cell: 876-315-2739Email:vincent.e@bearingsandaccessories.com

Anybody out there familiar with an application called "Prelude"? I've got an end user out there who's migrating to Prophet ( Profit? ) 21 who is having trouble extracting the data they need. The developer modified and locked down Prelude, passworded everything, removed any source, then died taking all knowledge with him. It would be nice to know stuff like "blah blah is the invoice file, blah blah is the customer file..." etc.------------------------------Brian S. CramPrincipal Technical Support EngineerRocket Software------------------------------

I remember being able to open an index file on Universe within basic and reading the records in an xref type fashion. Where I am working now isn't using indexes but rather executing multiple external selects from within a program, not ideal.Does anyone have a simple ditty showing how to open this file within the basic program? Anything special about the VOC entry for the index file?Thanks,Kathleen------------------------------Kathleen HambrickProgrammer at Colwell------------------------------

Hi - as ive mentioned in previous threads, I just switched from unidata to universe.  A coworker mentioned a trigger but I do not see a version of my unidata commands:CREATE-TRIGGER, LIST-TRIGGER, DELETE-TRIGGERI do see the LIST.SICA command, which lists universe triggers on SQL files....do we not have triggers on regular PICK files in universe?------------------------------Kathleen HambrickProgrammer at Colwell------------------------------

If you installed FlashConnect on Linux in the non-default location and the fcservice won't start, try the following command to reference the actual location of the flashconnect.conf file:   ./FCService -C/path/to/file/flashconnect.conf   Where "/path/to/file/" is the actual fully-pathed reference to the directory containing the flashconnect.conf file. Example:   ./FCService -C/products/apps/flashconnect/flashconnect.conf------------------------------Brian S. CramPrincipal Technical Support EngineerRocket Software------------------------------

I am wondering if anyone has experience with using the logs captured by U2 Audit to feed in to Azure Application Insights (or similar). It seems to me these logs would be a great source of data for visualization and analysis. If you have done this, what issues and roadblocks did you find? What tools did you use for visualization and for analysis? Thanks.------------------------------John GreenHead of TechnologyUltradata Australia Pty LtdMalvern East VIC AU------------------------------

The internal UniData lock mechanism has advantages over those used in UniVerse, so for UniVerse to benefit from those it was decided as part of UniVerse 12 that the UniVerse would use the same mechanism.This is a presentation I delivered internally to the support team here at Rocket when the UniData lock mechanism was moved into UniVerse 12. So the information is correct for UniData and for UniVerse 12 and onwards (i.e below UniVerse 12 still uses UniVere's old lock mechanism).------------------------------Jonathan Smith UniData ATSRocket Support------------------------------

Hi all,In the Rocket Documentation, there is information regarding version 4.5 of the U2 DB Tools, but on the Rocket Software site, only version 4.4.1 is listed for download.Does anyone know where I can download version 4.5 of the U2 DB Tools?Best regards.------------------------------Miguel Esteban Rodriguez GonzalezRocket Forum Shared Account------------------------------