Rocket® U2 | UniVerse & UniData®

hello,  when we define a function like  def funcname(a,b,c); return (a * b + c) Can we use keyword argument syntax when calling a method/function ?  like PyCallFunction("module","funcname",a=1,c=2,b=3)   or is it mandatory to use positional argument ? PyCallFunction("module","funcname",1, 3, 2) ?  many thanks------------------------------Manu Fernandes------------------------------

    Key Takeaways:Do not use dimensioned redimensionable-array elements for EXECUTE variable targets for CAPTURING, RTNLIST and SETTING and variable sources for PASSLIST.The areas of concern:1. Information style redimensionable arrays may change size in the executed program.2. Arrays of either flavor compute to a temporary in a PASSLIST that gets overwritten by constructing the command string in a concatenation. This UniVerse bug results in the command string passed to the command as the select list.  Environment:UniVerse 11.3.1.6022Fedora Linux UniVerse supports two kinds of array.  Pick sytle arrays have fixed dimensions at compile time. Each element of the array takes one VARTAB (variable table) slot. VARTAB uses an unsigned short for an index which limits the total number of slots in a compilation unit, program or subroutine, to 64K elements. (This limits an array to a maximum of 64K elements.) Information style arrays specify dimensions at run time and may change and consumes only

I get a lot of survey's everyday. I have received several from Rocket Software on what I would like to see as Enhancements to UniVerse in particular, but multivalue in general. I thought I would toss this our for discussion with the forum members. Any thoughts?Multivalue Enhancements Better overall performance Multithread using data reader/data writer Compile into IL that can be optimized on a given architecture (ECMA 335) Improve connection to alternate database types SQL No-SQL OS Independent OpenQM data type validation, better data cleansing Improve database mirroring Improve Transaction processing Improve Publisher/Subscriber performance Better use of improved system resources Configuration Expert System, Machine Learning Better development environment Visual Code with ability to work on remote servers and multiple accounts VC graphical compiling, cataloging and debugging Extensible Terminal emulator Lint type program to identify problems and poor programming practice

I have a Python script that uploads a program and tries to compile it. But every time it compile my program errors because we use Pick.  Can we set up some options so the command executes using Pick flavor?  I already tried setting the TCLTYPE before running the command, but it doesn't work. Connection establisheddone readingfile uploaded Compiling Unibasic: TESTPROGRAM in mode 'u'.main program: syntax error at or before<line 2578>       READSELECT NH ELSE HN.RECS = ""            -----------------------^Expecting: =,:,+,-,*,/,[,< Any suggestions?  Thanks in advance

Last year, having switched back from Unidata to Universe, you all helped me with simple triggers - which on universe are made as file indexes. Now I am trying to apply that to a NEXT.ID but it's stored in a DICT, not uncommon for PICK. Trying to make an index on a dict, however, didn't work. >CREATE.INDEX DICT KHTEST TRIGGER   Only records of type A, D, I or S allowed! I know this trigger works as I had applied it to the data portion originally. Ideas, suggestions, thoughts? Thanks------------------------------Kathleen HambrickProgrammer at Colwell------------------------------

Hello to all !!!!  THere is always a first time ..... what the heck is this ???  RESIZE: FL_GRPRESIZ bit was set on group 0.  Not resizing file. Thanks to all in advance  ------------------------------David Ricardo Lopez BonaecheaDirector of Software StrategyQuiter Servicios Informaticos SLSantander ES------------------------------

There are two truths I live by - Never start a land war in Africa and PICK (English, retrieve) is HORRIBLE at creating reports! Having moved into a position at a company using Universe, they somehow didn't know that they need a report writer package and have been coding Excel reports through FTD. This is very time consuming and not particularly good at reports. In the past I have used Crystal reports, PHP, ODBC, etc.  Can I get you alls opinion what is the most straightforward, most robust report writer out of Universe (PICK)? Ideally one not overly expensive ;) Thanks! Kathleen------------------------------Kathleen HambrickProgrammer at Colwell------------------------------

I've overcome most of the issues discussed earlier in the following two threads.  The background there may help in addressing this question.Rocket U2 | UniVerse & UniData Rocketsoftware remove preview Rocket U2 | UniVerse & UniData Rocket U2][U2ODBC][2300701]Error ID: 46 Severity: ERROR Facility: DBCAPERR - UCI Error. Func: SQLFetch(XIO); State: S1000; U2 Database code: 20085; Msg: [U2] View this on Rocketsoftware > Rocket U2 | UniVerse & UniData Rocketsoftware remove preview Rocket U2 | UniVerse & UniData I'm using the latest U2 64-+Bit ODBC Driver Version 7.241.02.9004.The ODBC Connection tests successfully and works perfectly in applications that use ODBC, such View this on Rocketsoftware > The current error is the subject error message, which I am receiving when I attempt to query certain "tables" from Microsoft SQL Server Management Studio where the Universe U2 system is configured as a linked server

I was exploring our use of the STATUS statement in a simple BASIC program that we use to show info on a file. There wre 3 date/time pairs: Last Access Last Modification Last Status Last access shows a date from years ago, so it "feels" more like a creation date.  Last Status and Last Modification show identical values. What are these supposedly tell me? Nelson------------------------------Nelson SchrothpresidentC3CompleteShop LLCHarrison OH US------------------------------

I'm in the very beginning stages of designing/developing a program that will create a file or files that can be opened/imported by Word to display multiple tables like these (screenshot from a word document): I can handle part that has to calculate these details. However, i'm not sure what my options are for generating a file that can be imported/read by Word. It appears that Word can handle XML documents, so I'm wondering if that would be worth researching. Our current process is very labor intensive and requires a lot of hands-on, so ideally, my program would generate the file(s), and Word could then open and display the info seen above with minimal manual massaging. Any ideas would be appreciated.------------------------------Shawn Waldieenterprise application developerRocket Forum Shared AccountLos Angeles CA US------------------------------

Hi , Please can someone assist with this. We have upgraded our Universe from 11.2 to 11.3 and testing the Universe spooler it seems not to work. When we enter  SP-ASSIGN HS "Queing disabled for requested printer" Also checked the usd usd : Queing disabled on requested printer  We checked all the print queue status and it all in "ready" status.  Did an echo test and it printed out successfully.  Thanks. ------------------------------Roland KayverCore Banking SupportTeachers Savings and Loan Society Limited------------------------------

I am working on an RPM that will install unidata, so as I start down this journey, are there any gotchas other who have gone down a similar path that anyone would care to share?there will be 2 types of installations .....1. on a system WITHOUT unidata installed2. an upgrade of system with unidataI am going to use the parameter file to automate the installation in both cases and when doing #2 I will stop unidata  before preforming the upgrademy main question is about the license file (while developing I will be usings the PE version of unidata so no license issue) but in both cases how do I handle the license?1. do they have to enter  it manually?2. is there a way to "move" the license from version 8.x.x to 8.2.4?also on #2 is there an easy way to tell if unidata is installed and running, I suppose I could look for the unidata daemon to see if its running, but if the system is stopped since I do not know what version of unidata is installed is there something I can look for to see if un

@Jonathan Smith helped me out most recently in this thread... Rocket U2 | UniVerse & UniData Rocketsoftware remove preview Rocket U2 | UniVerse & UniData I've overcome most of the issues discussed earlier in the following two threads. The background there may help in addressing this question.Rocket U2 | UniVerse View this on Rocketsoftware > Is there a similar  parameter I can set to get around this in the UCI Configuration Editor?  I've tried "casting" the AVG_COST_PD column differently so that it would return, but to no avail.As usual, I can query this table fine in the U2ODBC Tester, but not in SQL Server Management Studio, PowerBI and other Microsoft Products.  Although Microsoft Query legacy connection can also return the full table to Excel, and I don't see any outlandish values in the AVG_COST_PD column there.The full error now is:The OLE DB provider "MSDASQL" for linked server "mylinkedservername" supplied invalid metadata for column "AV

Greetings all! We are currently running 11.3.4 on AIX 7.2.  In order to mitigate the newly discovered security issue with unirpc, we have the option of upgrading to the appropriate builds of 11.3.5 or 12.2.1.  Since upgrading involves a great deal of application and integration regression testing, we are considering jumping to 12 instead of staying on 11 now, and then having to jump to 12 later.All of the listings for version 12 in the product matrix have alerts associated with them, listing an issue related to using unmasked kills on UV processes.For the user base - is anyone currently running 12.2.1.xxx on AIX?  If so, have you encountered any issues related to this alert?For the Rocketeers - with the new memory buffer design, is this alert a permanent fixture now, or is there anything in the works to remediate the issue in the near future?To everyone - while this alert is the main cause of concern for us at this time, has anyone discovered any other issues in terms of application co

I am new to accuterm, about a year now, and am still struggling with trying to understand the pieces I need in place to have a graphical accuterm screen display on the internet. I've been told repeatedly that its possible and functioning with my release of accuterm8. Can anyone share with me even a static screen accuterm display on the web? Even just a box that says 'You are here.'There are obviously pieces I need for the web address to access my accuterm display but I don't even know what questions to ask....Anyone?------------------------------Kathleen HambrickProgrammer at Colwell------------------------------

What does "U_insert_part_file error in U_Openfile for file ..." in the udt.errlog.  I've copied and cleared the file; I've also recreated the file same error.  Any advice?------------------------------William MachiSoftware ArchitectSelf RegisteredCommerce CA US------------------------------

Hi All,We are in a high volume environment running Unidata on AIX. I have a question about the new option.Is anyone useing it? Is there any speed-up in real-world situations?We have a very old code-base. In what situations would this, perhaps, speed some SELECT quieries up? (Or slow them down)Has anyone turned it on and noticed any change, good or bad.We are contemplating turning it on, and are curious about other's experience. Did you test it, etc?Thank you for any feedback or information.Best,Rick Brown :version     Module Name         Version   Licensed UniData RDBMS............ 8.2     Yes ------------------------------Rick BrownSysadminRocket Forum Shared Account------------------------------

Hello everyone,Firstly, I have to say that this is my first experience of attempting to use UOPY so please forgive any obvious mistakes on my part.   The issue which I am looking for some guidance on is as follows:I can log into Universe via an ssh terminal, issue command such as:SELECT CDC.CARD WITH ID = "1234567890123456" TO 1LIST CDC.CARD CARDNUM FROM 1This selects one record into list number one and outputs the ID and CARDNUM values.   CARDNUM Is a calculated field and is decrypted / displayed correctly when the operations are performed as above.However, when using UOPY, I replicate the above using something similar to the below:cmd=uopy.Command(f'LIST {filename} CARDNUM FROM {list_number}',ses) cmd.run()Inspecting the cmd object shows that there's an error in decrypting the value, with the full error message as follows:error:06065064:digital envelope routines:EVP_DecryptFinal_ex:bad decrypt:crypto/evp/evp_enc.c:570I understand that the Command objects should be

Greetings, all! I used to know this answer, but I haven't worried about it in so long I can't remember.Our data is masked with extra decimal positions.  For example, 1.35 may be masked with 2 decimal places and stored as 135.  When using this data for output, which is better performance-wise - OCONV or dividing by 100?Thank you!------------------------------Brian Paige------------------------------

Hi Guys, I needed to dump the contents of a transaction file for our Auditors today and a simple retrieve report should have been the simple solution, as it only need sorting by date with no calcs, and all the dictionary's already setup, and probably not needed again..... However, because of the 32,767 (ROW) page length limit the .CSV hold file with 680,000 rows of data, had many extra "page breaks" to dispense with. I was reluctant to write a one off program, so sorted it in the VOC paragraph, that produced the report, so the Auditors are happy, but  it took me longer than in really should have because of the 32,767 SETPTR limit. So does anyone know why we have such an arbitrary number as the limit for SETPTR and does anyone know of a simple override aside writing a one off program  to poke it directly into &HOLD& rather than using a retrieve report?? Also another thought, the SETPTR command displays your current output settings so these values must be stored for your current

I have a need to provide a user input prompt that times out gracefully after a specific period.I am using !EDIT.INPUT and that captures the input well.What I am missing is a graceful method of setting a timeout for it.I have attempted to use the AUTOLOGOUT command.That does trigger a logoff (an ungraceful exit but an exit non the less).Does anyone know of a way to assign an input timeout period for !EDIT.INPUT - or even just INPUT @ - that allows code to register and react to the non-input of data in a graceful manner?------------------------------Gregor ScottSoftware ArchitectPentana Solutions Pty LtdMount Waverley VIC AU------------------------------

The Rocket Software MultiValue team is inviting all Rocket® UniVerse customers to participate in our UniVerse 11.4.1 beta program.  This is your chance to test, influence and provide feedback on UniVerse 11.4.1. If you decide to participate, here are some new functionality highlights you'll find in UniVerse 11.4.1 and Rocket® MultiValue Performance Experience (MVX Performance) 1.7 for customers on active maintenance. We've enhanced HA/DR and fixed some bugs, making it easier to manage your replication environment while improving performance Improve performance by implementing the Replication Intelligent Queue Manager, which allows a subscribing system to recognize when there are multiple updates in the queue to the same file Easily test a new version of UniVerse on a subscribing system while still running an older version of UniVerse in production because UniVerse 11.4.1 allows a subscriber to receive logs from older protocol levels Recover from stalled subscriber groups using the

Looking for UniData expertise in deploying and optimizing storage performance in Azure.  I have not found any official Rocket technical documentation to support.------------------------------Ralpha LabartaCTOEngage PEOSt. Petersburg FL US------------------------------

I'm using universe 11.3.4 and want to pass in parameters in when running a python program using RUNPY is this possible?------------------------------Neil SherwoodAnalyst ProgrammerHSBC Global Services (UK) LimitedLondon GB------------------------------

One of our Linux Admins asked if there were any Rocket recommendations on RHEL TUNED  package.  I didn't see any references in the knowledgebase and figured others might have input.  Here's the URL he referenced:  https://computingforgeeks.com/optimize-linux-system-performance-with-tuned-adm/------------------------------Charles CarpenterUV DBATailored Shared Services LLCHouston TX US------------------------------