Rocket MultiValue

Hi, I have the following problem: I have been using the Rocket U2 product (Universe|Unidata) as ODBC configured on a SQL Server 2014 Via Linked Server Tecnology and everything It works correctly, I connect the U2 against my Universe database and this with the ODBC of Universe for Windows Server, finally I use the ODBC to create the Linked Server in SQL SERVER 2014. The problems began when upgrading SQL Server to SQL Server 2019, from that moment with the same configuration the linked server has stopped working. Have you reported any ODBC bug of Universe in SQL Server 2019? Does anyone have a similar scenario? I have tried several configurations both in U2 (via Uci Editor) and in the SQL Server and nothing has worked (The linked Server is infinitely loading and dont retrieve data from U2 database).            

Thanks Brian, and yeah, I've used the SQL functions over ODBC before, butit's kind of fiddly to setup. The intent here is to provide something tobootstrap an inexperienced user in installing some new code and artifactsthat go along with the code. You can type "SQL UPDATE ..." but only afterhaving setup the account for SQL (I think?). I get "No privilege on fileVOC!" as an error at least.I was trying to get away from having a basic program, because it'sobviously challenging to a non programmer to understand all the possibleways compiling and cataloging a program can fail. But installing a utilitylike UPDATE.RECORD once and cataloging globally might be the bestcompromise option. I can write my own, with a pretty rigid syntax like"UPDATE.RECORD VOC TEST SET 3=nk jhkjewqh ekjhqwkje jk" since it's notdesigned to be used interactively, just used for updating parameters wheninstalling some new code.Really appreciate the suggestions!On Mon, Feb 27, 2023 at 11:49 PM Brian Speirs via Rocket

Hi all, Happy Monday Morning ;) I am looking for help with an AWForm. Hopefully some of you are pretty good at this interface. I did look through what I have as documentation and did not see this information listed but - we undoubtedly have old and incomplete docs. We have quite a few awforms in use, and I see examples of columns in many. What I am trying to do however is to load the data into a table format such that excel would use. Namely we want the lines between the MV data vertically and horizontally. While a tab will move between cells in the created form, passing in a tab at the end of the first line did not separate the data from MV1 to MV2. There is a horizontal line at the bottom of the array, but not between each line of data. Suggestions?? Here is what my form looks like: PRESS_TYPE CUSTOMER JOB # Due Date Notes CNO JN DTE       PART NUMBER CHIP SIZE RADIUS MATERIAL RM # COLOR NAME HOLE SIZE DESCRIPTION/NOTES RM DIMENSION PROFIL

I have been converting code from R83 to Prime Information, Advance Pick to Unidata, Sequoia Pick to Unidata, D3 to Universe, and even Unidata to Universe, I have seen some really awful code and very morbid. Of course, you are thinking some of the latest Basic commands that I use daily in Universe did not exist in R83 so those programmers did the best they could. While I do not disagree, I am looking at code from customers in 2023 that should have been updated sometime in the last 20 years or at least in the last 10 years. I have detailed below my comments with what I found and what I think it should be. I will ignore for the time being GOTO, GOSUB, and ON RESPONSE, for example. I would love to see what you have found as well because it just makes me LOL when I see it. * Using COUNT instead of DCOUNT MY.ARRAY = 5:@FM:7:@FM:8 MAX.FM = COUNT(MY.ARRAY,@FM)+ 1 * Should be MAX.FM = DCOUNT(MY.ARRAY,@FM) * Not knowing about WHILE in a LOOP statement EXECUTE 'SELECT VOC'

while we suspect a 3rd party program might be causing the issue or at least helping it along , what we are trying to do is isolate or prove it. any suggestion or ideas are welcome as we are running out system info udt - 8.1.2 redhat - 7.9 when unidata locks up  showud shows all the processes running yet any ECL sessions are locked up trying to login via udt hangs, we turned on error logging but the log file only shows the start of unidata and nothing else udtmon - does show a little disk activity we did straces on the udt processes including trying to open a udt session  attached is an strace of a udt session and an ipcs output when the system is hung any ideas or suggestions are welcome as well have been stumped, we are talking to the 3rd vendor as well and like I said we are not positive that the issue but we have seen their process using a lot of memory and cpu stopping unidata and starting it back up and everything works fine, for a while, there is no pattern to when it lock

I am planning upgrading our D3Linux system and the hardware it runs on.  I am considering setting it up to run on a RHEL virtual machine with the hope that future major version upgrades might be easier on the same hardware. Are there any major cons of running in a VM?    Any configuration and setup tips are welcome.------------------------------Steve CaspersMurphy Automotive IncRosemount MN US------------------------------

Hi All, I'm sure I've posted on this matter before but I just had a bit of a wobble understanding why my code wouldn't compile, until I notice the variable I had used started with the word NEXT (as in Next_Available) and the D3 compile went out and took another shot of tequila and said 'nada - not today hombre'So, just put it out there NEXT (suffix not allowed) and I'm sure there may be others - like NOT and FOR and ...Does anyone care to comment?------------------------------Stefano GallottaManaging MemberSimply Red Open SystemsMilnerton ZA------------------------------

Just noticed that Unidata had a directory called minidump When i looked at files in the folder the files stated "The thread tried to read from or write to a virtual address for which it does not have the appropriate access" What does this mean, should I be concerned, how can I tell what is causing these files to be created------------------------------robert modrichDeveloperRocket Forum Shared AccountTEMECULA CA US------------------------------

Hi Folks, we recently upgraded to 82 Unidata in a testing environment, and are getting the following in SMM logs; In UT.OBJ/_S.READLIST at line 90 insufficient memory, requested size = 37567064. Thu Feb 16 14:28:02; errno=0: ICSubCall returned from basic, ReturnCode=-1. I do not have access to the source code for S.READLIST but it is dealing with very large save lists. Any thoughts on what we might have wrong? Rick Brown------------------------------Rick BrownSysadminRocket Forum Shared Account------------------------------

Anyone using UniVerse and EDA with "virtual" dictionaries?  I have a user running UniVerse 11 and using EDA. EDA is working fine on true attribute dictionaries, but now he's trying to add an I-type like this:      DIV0001 I0002 "10"00030004 DIV0005 10R  Just a hard coded value "10" - but in the SQL Table the column is populating with NULL. ------------------------------Mark EastwoodDeveloperAFS Technologies IncPhoenix AZ US------------------------------

Hi everybody, I'm searching a method to perform communication between 2 running phantoms.  sample : phantomA is a helper which load a lot of info in memory and is capable of complex computing. phantomB manage info and need a computing to be done by phantomA  the method QueueViaDisk :  pantomA read disk on a loop and write the result on disk phantomB write the request on disk, wait, and retrieve the result from disk  a method QueueVia Memory ? QueueVia Socket ? QueueVIA ..... ??  is it possible ? with uv ? with python ? via os ?  Any idea will be welcome. manu 

I am launching a process from a UniVerse Basic program using:       PH.CMD='PHANTOM SQUAWK MY.PROGRAM'      EXECUTE PH.CMD CAPTURING PH.VALS It returns the &PH& log filename and the PID as expected. However, when I de-cataloged the program, it still came back with both values. The only way I realized it was failing was by either running "ps -aef" from Unix or looking in the &PH& file: 0001 Verb "MY.PROGRAM" is not in your VOC. Is there a BASIC program command way to know if MY.PROGRAM actually did launch?------------------------------Nelson SchrothpresidentC3CompleteShop LLCHarrison OH US------------------------------

Greetings, all!We are running UniVerse 11.3.4 on AIX 7.2.  We received the following error in the UniVerse errlog file:       Fri Feb 17 15:24:34 -144 root /usr/ibm/uv/bin Failure to login as remote user. There are only 3 of us that know the root password, but none of us were logged in.  Additionally, direct logins using the root user are not allowed by our system - neither through ssh nor through the software application we use (which comes in through uvapi and uvcs).  UV itself does run as root, though.   How can it say that the login failed, when there's already a port number assigned? The uv and unix logs have been checked, and so far there is no evidence of any connection made by the root user at that time. What does the error actually mean?  Any info would help us figure out where to look to determine what happened. Thanks!Brian ------------------------------Brian Paige------------------------------

Hello there, I am writing a data to xml in  Universe Basic. Its seem some invalid ASCII characters were included in the data which causing an error in xml. Could anybody advise what is the command to exclude these bad characters or convert to null in Universe Basic before got written to xml please. Your help would be appreciated. Thanks. ------------------------------Yossy TanSenior Universe DeveloperA2B AustraliaBrisbane QLD AU------------------------------

https://en.wikipedia.org/wiki/Garbage_collection_(computer_science) There really is very little to nothing in this article about how Pick BASIC does Garbage Collection. I feel like there is a disservice in not addressing multi-user environments and how they have special garbage collection requirements.------------------------------Will JohnsonSystems AnalystRocket Forum Shared Account------------------------------

We just posted a patch for MVS Toolkit version 2.3.2 in the Downloads section of the Rocket Customer Portal (RCP). It is a .zip file that contains three .jar files and a readme. If you have any questions, please reply or reach out by other means. Readme content: The default directories for the .JARs you are about to deploy are as follows: Linux:        /usr/local/RocketSoftware/mvs/server/libs/serverWindows:    C:\\Program Files\\Rocket Software\\MVS\\server\\libs\\server If the default MVS path was overridden at installation time, please adjust your path accordingly. To install the new scripts: 1.    Stop the MVS server2.    Make a backup of the existing .JARs3.    Copy the new .JARs to the appropriate directory4.    On Linux, chmod the .JARs to add execute permissions (if not already present)5.    Start the MVS server On Windows, stopping and starting the Rocket MV Web Service is done using the Windows Service Control manager. On Linux, use "service mv.serv stop" and "service mv.se

Hi All,We are using Universe 11.3 on Windows.I needed to round a 5DP number up to the Next Whole number, so the result would be ; I could not find a suitable command equivalent to Excel  ROUNDUP, as shown above, so I've manually programmed the required calcs.There does not seem to a be suitable Flag for ICONV / OCONV and INT only grabs the whole numberIs anyone aware of a Function that does what I needed ??Just in case I've missed a  Function, i went through the  UV Basic Command 11,34 pdf guide and could not find anything.However, i spotted in UV Basic Command 12.11 there are 2 x new commands ROUND and also TRUNCWhilst these syntactically don't do what it need, it may help others looking for similar functionality.so as I'd found these new Functions available in V12, it got me thinking, can these new commands be retro applied to earlier versions of UV, obviously I can't just upgrade Universe to access these commands.Secondly as the new to me ROUND function still does no

One of our applications received this error message and aborted. The remote data was never offline. UniData Release 8.2  Build: (1000) (c) Copyright Rocket Software, Inc. 1985-2020. All rights reserved.  Current UniData home is /usr/ud/. Current working directory is /dock/app1/PLT3.   :perform_remexec dp:KMC 870 lblack [1/1] SELECT UNIT.ID SELECT UNIT.ID  1311 records selected to list 0.  In /usr/ud/sys/CTLG/p/perform_remexec at line 225, connect() error(11): Resource temporarily unavailable In /usr/ud/sys/CTLG/p/perform_remexec at line 225, Connect() error (11): Resource temporarily unavailable in UDT_connect. In /usr/ud/sys/CTLG/p/perform_remexec at line 225 Connect dp:/dp/apps/KMC:1155 failed, status 11 In /usr/ud/sys/CTLG/p/perform_remexec at line 225 efs_connect() failed, fname (SAVEDLISTS)In /usr/ud/sys/CTLG/p/perform_remexec at line 228, connect() error(11): Resource temporarily unavailable In /usr/ud/sys/CTLG/p/perform_remexec at line 228, Connect() error (11): Resource tempora

Being used to the Unidata format, when running this command in Universe the file the lock is in does not display. We have common keys across many files so the format of this tool is very unhelpful to us! Does anyone have the syntax, alternate command, or custom ditty that shows all the pertinent info for a lock at one time? IE login, date/time, file, ID, process ID, User ID?Thanks for the help!------------------------------Kathleen HambrickProgrammer at Colwell------------------------------

8.2.4 i believe, and any (rough) eta on when the next version will be available? thanks dougc------------------------------Doug ChancoUniverse ProgrammerSelf Registeredgraham NC US------------------------------

For decades, my customers have been emailing from their D3 applications by using a Windows command line email processor called "Blat." One customer claims that his IT guy told him that Blat will no longer work because their email server requires 2-factor authorization.1. Is the IT guy correct?2. Is there a workaround for 2-factor authorization to allow Blat to work?3. Is there another solution?Thanks.------------------------------Richard GinsburgPresidentGinsburg ConsultingManassas VA US------------------------------

Many years ago when we went to the web we stopped using paragraphs. We have not used a PROC since the early 2000s with any of our clients. So when we moved to the web using UniObjects for Java you could only call subroutines through our API. This meant we had no use for any of the 1000-plus paragraphs that we had written over the years. If we need to select we use EXECUTE to handle getting the data.I was wondering if what I am describing is true for other Unidata, Universe, and D3 customers that have gone through a migration to the web. I have a would-be client that says you can keep all of them. I just don't want to use and EXECUTE to call the paragraph and DATA the need inputs. Am I wrong here?------------------------------Doug AverchOwnerU2logic------------------------------

I think we need a Labour Exchange where those looking for expertise can post their requirements and those with expertise can also post their experience and then they can contact each other.In my case, I am looking for people with expertise in D3/Linux, SB+ and MVS Toolkit, to work on systems that are now over 30 years old and are and have been continuously updated and new projects that are being rolled out on a regular basis.What do you all think?------------------------------Alex PolglazeThe Book-Keeping NetworkPerth Western Australia+61419 776 348apolglaze@book-keepingnetwork.com.auhttps://www.book-keepingnetwork.com.au/------------------------------

I accidentally created an invalid record(s) in a uv 11.2.5 file that I can't get rid of. The file is CONTROL and the record "@ID" contains multiple CHAR(9)'s. Because CONTROL is open to every process and I can't take the system down, I'm hesitant to try commands that might cause issues. My last resort will be to create a new file, copy the valid records and replace the existing, but there has to be a fix that doesn't require taking the system down. I've tried to manually select and delete the record(s). I also wrote a program when that failed. I've tried multiple things in the program, using SELECT statements and creating the ID, but the READ statement hits the ELSE clause because it's not valid. The info below demonstrates that a single record selected is handled as 2 records when I edit them. >SELECT CONTROL = "[19791 ]"1 record(s) selected to SELECT list #0.>>AE CONTROL< 1 > Top of New "LAST.DMD.NEW.DAILY^009* Date of last NEW demand history load" in "CONTROL".*--: EX

I'm adding some validation to a routine that launches BASIC programs to ensure that the program's object code can be found (and is not a subroutine or function).For main programs I think the search path is as simple as Local VOC GLOBAL.CATDIR (if the program starts with "*" - testing has shown that only globally cataloged programs that start with "*" can be  run ) For subroutines and functions it gets more complicated Local object code of program that will call the sub/function Local VOC GLOBAL.CATDIR (for all the available prefixes: "*", "!", "-", "$" Leaving aside the technical hurdle of pulling apart local object code looking for additional subroutine/functions, and the logic needed to detect if object code is a subroutine/function - that will have to wait for now.Is there anything that I might have missed in these search paths?Is there any case sensitivity settings/toggles that can influence the search in each of these paths? Many thanks------------------------------Gregor Scot