Rocket MultiValue

I'm working with UniData 8.2.  I've written a utility that lets me view and treat an SQL table like it was a local UniData file with UniQuery type commands.It's been working fine.  But I am having an issue with one ODBC connection that sends back the rows but not the data for the columns.Has anyone seen this before?  Could it be some type of privilege setting?  I can get data back using an SQL manager tool using the same logon credentials.SQLFetch doesn't bring back any error messages, just no data.I am going from one domain to another, all within our intranet.Thoughts?

We run UV 11.2.5 on RHEL7 servers, and use UniRPC connections a lot.I have been looking for a way to automatically apply reduced priority to some UniRPC connections based on the connecting user id.I have tried creating a new 'conf' file in /etc/security/limits.d.These files get applied by the PAM limits module for new login connections, but when the UniRPC daemon validates the credentials of the in-coming connection it appears to not be running through the PAM modules so when the uvcs / defcs / uvserver session is launched using the supplied user credentials the resulting PID is running with the default priority.Does anyone know of a way to automatically have the launched uvcs / defcs / uvserver process use a non-default priority?

All,When I have no records selected in an INFORM report, the heading does not print. Users are asking the admin staff if a print job was printed. Is there a way I can force the heading to print if no records are selected, or is there a way I can place the report name in the Unix spooler banner page? I get a banner page with no records selected, but I think it is from the Unix spooler. Maybe set an environment variable to put into the banner?Jon

I am looking for recommendations of companies to run the upgrade of a Universe application currently running Universe 11.1.3 to most current Universe version.   The application is running on a Solaris 10 system so it would be upgraded to Solaris 11 but may also be re-platformed to Linux or AIX.  There is a small staff maintaining the application to consult.

Just wondering if there is a function for me to send a message to the runtime-errors file?  Trying to debug a program and if I could send a few notes to the runtime-errors file via a function call it would save me a few steps.ThanksCraig

Hi Everyone We want to make extensive use handheld terminals in our warehouse and Factory for point of activity transaction processing, with a goal to further enhance this and utilise Barcoding to reduce further the amount of manual keying required As there does not appear to be a version of SB Client that will operate natively on anything other than Windows can anyone suggest a handheld that will provide a screen large enough to accommodate SB Menus and also work with a decent touch screen that is not subject to "fat finger" syndrome we have be experimenting with Zebra TC520K android handheld with Velocity Android 2.0 TE terminal emulator. (VT100) this uses Telnet as its connection interface to the UV and SB applications however it does not provide easy Access to "F2" and "F3" keys which are used extensively within our current transaction processes So can anyone recommend a handheld that operates seamlessly with UV and SB applications that provides easy access to "F2" and "F3" functio

Sorry to ask a dumb question but I'm an old school character base programmer from the 80's and am having a great deal of trouble understanding the GUI languages. I've tried several books on JAVA but can't seem to make it work. SO, my question is this: Can anyone suggest a way that I can add a GUI front end to my Unidata database in a language that I can understand?

G'day all   Been having some issues with getting the SSL certificate to work with MVS toolkit. We’ve had it working once before, with a massive amount of tweaking within the certificate to get it working. This time we’re moving to a wildcard certificate and despite going through the same steps (and the same tweaking) we’re having no luck.   Has anyone got a wildcard SSL certificate working with MVS Toolkit? And do you have a consistent procedure to get this to work? =================   The main thing is the consistency – so we can do the same thing each time and get it working without stuffing around with it.

I have a need to do a 400ms sleep in a Unidata program.  Is it possible?

Hi. We have several windows  servers with a lot of big dump files in a universe subfolder called "minidump". Is there a way to avoid  this kind of dumps, in order to prevent disk filling? Thanks in advance. p.d. A sample from eventlog: - <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event"> - <System>   <Provider Name="UniVerse" />   <EventID Qualifiers="49152">1004</EventID>   <Level>2</Level>   <Task>0</Task>   <Keywords>0x80000000000000</Keywords>   <TimeCreated SystemTime="2021-02-12T03:35:21.000000000Z" />   <EventRecordID>11202874</EventRecordID>   <Channel>UniVerse</Channel>   <Computer>XXXXXXXXXXX</Computer>   <Security />   </System> - <EventData>   <Data>Unhandled

Good Evening all. hopefully the collective minds on here will help with a conundrum i have We have for several years been using Watchguard for our Firewalls and the remote users happily instigated  a Windows PPTP VPN connection and used their SB Client to access our Universe DB However, in light of a security review and the current increased security threats that blight our everyday activity, we have now deployed Cisco 1140 firewalls (in place of the Watchguards) and rolled out Cisco Anyconnect to enable the new VPN connection and remove the Windows PPTP security issues This has created a few issues in that some of the remote users intermittently lose their SB Client Telnet Connection and leave a dead session on the server. Not only is this tiresome for the users it could potentially lead to data loss. We did not have this issue with the Windows VPN connected to the WatchguardsSo my question is does anyone else out there use SB Client (Telnet) via an Cisco Anyconnect managed VPN /

Hi,I am using UV 11.3.2 on Linux. I have 2 questions about the new NOW(), TODATE(), TOTIME(), @TZ, etc functionality1.I am using BDT 4.4.1The toolkit does not recognize the new functions/vars for syntax coloring, but shows it as errors. How can I fix this?2.It seems I cannot use TODATE() and TOTIME() in i-descriptors.​​ Is this correct? Will support be added?regards,Ivar

Environ:  UV 11.2.5 on RHEL7I noticed today that when I run 'LIST.READU'  if the locked item ID is longer than 63 characters I see the following The Item ID is truncated visually at the 63rd character The output does not stop at the end of the page After capturing the output via wIntegrate I noticed that the 64th character is actually a control char (so far I have observed char(3), char(4) and char(14) as the truncating character).I also tested using the unix command 'list_readu', as well as the 'LIST.READU INTERNAL' variation.All produced the same result.So is this normal behaviour for the command when dealing with longer Item ID's?Is this as a result of the lock table truncating the ID, or is it just a reporting problem?Is there any significance to the character value at the 64 position in the ItemID?

I attended the last MV Roadmap session, & it was mentioned that MV BASIC for Visual studio would be released at the end of March.   I would be very interested to try it out, once it is released, so can someone from Rocket please advise once it is available, thanks!MARY MULLANE

Hi,Thanks for advising that this is now available.   I followed the instructions up to the point of activating & adding the new association, however, when I enter Edit Configuration of Rocket MV BASIC, I get the following error message - "an error (Running the contributed command: 'vscode-rocket.mv.basic.command.editconfig' failed.)"   Also, on the Configuration page, it mentions that "For Windows platforms, you can find configuration files in "C:Usersyourusername.rmvconfig""., however, I don't seem to have that file anywhere on my PC ?   Any suggestions on how to resolve these issues welcome.Thanks,MARY

I'm attempting to setup EDA on a UV 10.2 system.  I have setup an ODBC data source that is able to connect to SQL Server without any difficulty.  So now I'm in the EDA Schema Manager and attempting to setup the EDA Data Source with the same credentials that worked in the ODBC connection manager.  And I'm getting this error when clicking on the "Test" button:No clue what this means.  The DSN has the ODBC data source name, and that data source does pass the connection tests successfully.  What am I missing?

Hi allI built a Python wrapper for the Intercall library to access an Universe database.Now I'm porting my utilities so they can use the native uopy module. The work is pretty straightforward but I don't find the equivalent call to ic_fileinfo ic_fileinfo (key, file_id, data, buffer, buffer_size, code)​ Is there a way to do this using pure uopy calls or do I have to build a custom UniRPCPacket to simulate the Intercall function?

Hi All, I am running D3 10.3.1.windows single user on an ASUS X555LAB Lpatop with CPU i5-5200U (2 core, hyperthreading) @ 2.20GHz (peaking 2.60GHz). running Windows 10 Home.   The program I'm running takes 4 hours to run doing full processing to find the end point. When I swap subroutines to use a file which already has the end point pre-processed and do a simple compare, it's only 20 minutes faster. It actually took twice as long with the pre-processed compare until I changed the file to be more efficient.   I have changed settings so that it's supposed to be able to use full CPU in all circumstances. (Advanced Power Options -> Processor Power Management -> Minimum or Maximum Power State = 100% for Battery & Plugged In).   Task Manager no longer allows the changing of program priorities (as you were able to in Windows 7).   My thought is that wither Windows 10 Home or the laptop is throttling D3 because when the program is running, it's using around 35% t

The XMAP and result below is from my UniVerse 11.3.1 AIX platform. They represent a simple object model containing two child tables with the same parent table. The data is from the HS.SALES sample/demo tables that come with UniVerse.Using the DB.TOXML command, also provided with UV, produces an XML file containing records from the parent table and related records from each child table. However, the fields for each record from one of the child tables are duplicated within each record node from that table. In fact, further analysis showed that the set of fields mapped for each child table will repeat count(TableMap)–1 times within each child record node in the output. This means that if there are three sibling tables defined under one parent, output for the child TableMap referenced first in the parent TABLECLASSMAP, will contain fields in triplicate; output for the child TableMap referenced second will contain fields in duplicate; and so on.This behavior was noticed during development o

Unidata 8.2.1 on RHEL - what does this error mean? When it happens the system usually locks up (when udt is started from the .profile) and people can't login until Unidata is forced down with stopud -f and restarted.

I am writing a paragraph to script compiling programs and am creating a log record using the DIVERT.OUT capability. So, the DIVERT.OUT command is set up to be:DIVERT.OUT ON log_file THIS.PARA APPENDI want to add the date to the name 'THIS.PARA' so that the command would be:DIVERT.OUT ON log.file THIS.PARA.<<P,THIS.DATE>> APPENDSo, I am trying to set 'THIS.DATE' to a date in the form of 'yymdd'.i have a program that will set paragraph variables but at this point, that program is not yet compiled and available. Suggestions for a simple way to do this just in the paragraph?Thanks!

Hi all.Hope someone could share some light on this for me.I'm calling an API in Python using Basic to fire the call ( WooCommerce ) I then receive a JSON Response in the below format [ { "id": 799, "name": "Ship Your Idea", "slug": "ship-your-idea-22", "permalink": "https://example.com/product/ship-your-idea-22/", "date_created": "2017-03-23T17:03:12", "date_created_gmt": "2017-03-23T20:03:12", "date_modified": "2017-03-23T17:03:12", "date_modified_gmt": "2017-03-23T20:03:12", "type": "variable", "status": "publish", "featured": false, "catalog_visibility": "visible", "description": "<p>Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Vestibulum tortor quam, feugiat vitae, ultricies eget, tempor sit amet, ante. Donec eu libero sit amet quam egestas semper. Aenean ultricies mi vitae est. Mauris placerat eleifend leo.</p> ", "short_description": "<p>Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac

Hello,I am receiving an error code 2 when trying to use the createRequestHeader function.:Source:    stat = setRequestHeader (restPUT, 'Authorization', 'Basic ':AUTHORIZATION.STRING)The REST API I am working with uses an API KEY that is created and converted to base64 and added to the "Authorization" header.  I am receiving the correct response when I test in the Postman software, but cannot get the Universe code to work.  I do see in the documentation that the it seems to be expecting the "normal" format for basic user authentication of user:password.  My guess is that is what's throwing the error as my API KEY is just a long string of characters.  Lastly, I am running Universe v11.3 running on AIX.  Please let me know if you need any other information.Thanks,LarryFrom the documentation:This function supports Base64 encoding for Basic authentication. If header_namecontains either “Authorization” or “Proxy-Authorization,”the header_value shouldth

Hi all, Sorry if this question has been previously asked answered, but I didn't see how to search for a topic. "Server" is Windows 10 running Universe 11. "Workstation" is Windows 10 running various apps and telnets into UniVerse. It has a printer on a USB port and is shared. Server connects properly to the printer and successfully prints a test page. I've checked all the share permissions, and among many others, "everyone" has print and manage privileges. Yet, when I do a SETPTR ,,,[etc] AT \\ENVYW10,HPLJ or AT \\10.1.253.60HPLJ and try to print, I get  Access is denied. Program "BLOCK.PRINT": pc = 2A0, StartDocPrinter failed with error 5 I've tried the usual rebooting, etc, On my old server I seem to recall an entry in the &DEVICE& file, but I am told this is not necessary. Also, the extensible admin utility won't allow the definition of a printer, only a tape drive. Any help will be greatly appreciated! Thanks in advance.

Hello folks,A never answered behavior : how to mix monovalued and multivaluled data into a SREFORMAT result. Here is the a sample uniQuery, SORT + WITH + WHEN + BY.EXP on HS.SALES (demo account into uv)I filter data on STATE (monovalue field) and BUY_DATE (multivalued field) and I display data from monovalued and multivalued field.As expected, with SORT BY.EXP, the monovalued field are replicated on each occurence of multivalued line. SORT CUSTOMER WITH STATE = "MA" AND WHEN BUY_DATE >= "20/01/91" AND <= "29/01/91" BY.EXP BUY_DATE BY CUSTID CUSTID STATE CITY BUY_DATE PRODID ID.SUP Customer ID State City........ Date Purchased Product 8 MA Lowell 21/01/91 M3000 8 MA Lowell 21/01/91 S3000 2 MA Waltham 22/01/91 S3000 3 records listed. ​ so, now I'll send these result to a temporary file with SREFORMAT, which build a record by line of result ; the first column is the key on the temp file.I use the same phrase, replace the SORT verb by SREFORMAT. CREATE.FILE FTEMP 18 53 4 SREFORM