Rocket MultiValue

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

hello,If I want to use U2PY (not UOPY)  I do not understand what type of connection (identification/authentification) occurs ?  Is it a heritance of the current (shell) session on the server ? and by the way which uvengine is used ? (uvsh, uvapi_..., ?) .  Thanks for any detail.Manu

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

I'm trying to conditionally compile some code but I can't seem to get the IFDEF to work.This is the source code below, I would expect to see 'Not defined.' but running the program results in 'Defined' being printed. This D3 10.2.2 on Windows if that helps.*$IFDEF PLATFORM.D3PRINT 'Defined.'$ELSEPRINT 'Not defined.'$ENDIF*PRINT 'Always print'Thank you

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 everybody,question how to known the LOCK waiters : -- a/ session1 set a task synchronization lock  with LOCK 9   b/ session2 will set a task synchronization lock  with LOCK 9  without PROMPT NO.WAIT nor  ELSE on basic. (yes bad coding but legacy :-)then session2 is suspended until session1 UNLOCK 9 So, for admin point of view, is there a method to list 'LOCK ' waiters ?like ... session2 wait for lock 9 owned by session1  actually, my solution is to perform PORT.STATUS PORT 2  + VLIST current program + check if adress line is  the command is LOCK ... any idea ? many thanksmanu

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

hello,While using the release 11.x of UV if I want to start a process at the start of Universe on Windows, I'm used to define a ScheduledTask with Trigger OnEvent with a subscription like this <QueryList> <Query Id="0" Path="UniVerse"> <Select Path="UniVerse"> *[EventData[Data="UniVerse (log daemon) started"]] </Select> </Query> </QueryList>​ but, on release 12, I do not get the "UniVerse (log daemon) started" anymore , the only event I can imagine usable is <EventData> <Data> C:\\U2\\UV\\bin\\uvcleanupd.exe Uvcleanupd Daemon started by pid (11828) </Data> </EventData> ok, I must analyse the Data value in my process because EventLog Triggers use limited xpath query and do not support *[EventData[contains(Data,"Uvcleanupd Daemon started")]]Is anyone have another idea on uv/win r12 ? many thanks------------------------------Manu Fernandes------------------------------

Once the UniRPC daemon spawns either a uvcs or uvserver service and the service has established a UniVerse session, is it possible from within the session to determine if the connection is secured via SSL/TLS?The uvcs sessions run the *UOLOGIN subroutine and uvserver sessions run the *ODBCLOGIN subroutine, so there is a possibility to perform BASIC code to query the security status of the current session. I just have not found a way to determine the security status of the session.------------------------------Gregor ScottSoftware ArchitectPentana Solutions Pty LtdMount Waverley VIC Australia------------------------------

Platform: RHEL 8.5DB: Unidata 8.2.1 hf11I have a customer who is seeing this message popup on people's screens.  The process in question isn't doing much of anything but they're obviously concerned.  Any idea what causes this?(You're likely going to tell me that this needs to go through the normal support channels but the VAR that this customer bought from isn't a VAR anymore, or so we have been told.  So they're kinda orphaned.)

A fancier shell for Universe on Linux that has support for persistent history and history searching. It also has easy access to the help files through a MAN command.https://github.com/Krowemoh/NovaShellI've been use it daily for about 6 months now so hopefully its at a point where it's usable by more than just me. I use vt100 and viewpoint as my terminal type usually so that is the most tested but a few other terminal modes should work as well.Let me know if anyone has any ideas or issues, the big thing I'd like to add is color but the ANSI escape codes don't seem to work and I don't want to use the terminal codes.------------------------------Nivethan ThiyagarajahProgrammerAsynchron Systems IncToronto ON CA------------------------------

hello,on our windows server, we change the passwd of the winuser which is the one used by SBXA Communication Server to adress SBXA Admin appliaction server. then all enduser get these error.  where/how to redefine the 'sbxa admin user/pwd' ? thanksmanu