Rocket® U2 | UniVerse & UniData®

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

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

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

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

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

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

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

Excellent information sir, thank you.On Wed, Jun 1, 2022 at 4:00 AM Jonathan Smith via Rocket Forum wrote:> Kevin, In terms of intervals and how cleanupd works I have covered this in> several technical presentations in the past. I'd have to check to see...> 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: Unidata 8.1 [AIX] - Cleanupd and Record Locks> > Reply to Group Online> > [image: Jonathan Smith]> > Jun 1, 2022 5:58 AM> Jonathan Smith> > Kevin,>> In terms of intervals and how cleanupd works I have covered this in> several technical presentations in the past. I'd have to check to see if> they are still posted on the Rocket sites. Please excuse the length of> response but this should answer all your questions.>> The cleanupd.log in the