Rocket® U2 | UniVerse & UniData®

Hello, Recently we are looking about Docker to build 'demo' environment of our mv'apps. Then, is anybody with experience of U2 on container ? Linux or Windows ? Then, we will to do it with sbxa apps. I think about one image linux with Uv and one image with sbxaCommMngrClient run on host directly. All suggestions are welcome. Rocketeers, please give your Word about it. Regards Manu------------------------------manu fernandes------------------------------

We are trying to add a subroutine call from an existing trigger.  The subroutines are definitely being called and acting appropriately, except when they attempt to write to a log file.Using "ED" to make a simple change in order to force the trigger, we are getting this error:Program "ED":  pc = 748C, Program "XXX": LINE 409, FATAL:  The locks necessary for database operations at the current isolation level (0) are not held by this process.The subroutine is trying to write to a type 19 log file which works fine from other programs. Commenting out the log file write avoids the error. Because of this error, the write to the CUST file (which is the one with the trigger) also fails.I assume this is something unique to the trigger function.  The trigger subroutine is cataloged globally as expected, so I am wondering if that is making file access in the account unavailable some how?This is running in UniVerse 11.3.1Any ideas would be gratefully appreciated.Nelson

Running guide in a directory with this:# nohup guide -na -ns -Z8 2>&1​ &...and it's terminating like this:[1]+ Segmentation fault (core dumped) nohup guide -na -ns -Z8 . 2>&1If I select all of the files and run guide individually on them, I don't see any failures.  Is there any way to track down which file is causing the segfault?------------------------------Kevin KingPresidentPrecision Solutions, Inc.Longmont CO US------------------------------

I have never had to do any administration and now It has come to my way. Most of my experience is on Unidata as a programmer, with no admin responsibilities. Now I need to do some admin and It starts with creating an account.  How do you do this in Universe on RedHat?------------------------------Gary RhodesUniverse DeveloperNational Auto Parts Warehouse LLCHialeah FL US------------------------------

Inside a proc you can do T I27,"`:" to set the column width of the wintegrate emulator to 80 characters. Is there a listing of what escape sequences exist to manipulate the wintegrate emulator?The end goal is to change the wintegrate terminal type programmatically.Thanks in advance!------------------------------Nivethan ThiyagarajahProgrammerAsynchron Systems IncToronto ON CA------------------------------

Hoping this is the correct forum for a UOPY/U2 question.Using U2 11.3.4 and UOPY I'm having an issue with UOPY sending an SQL select statement that works @ TCLprompt.Retrieve command: This works from Python using BOTH UOPY and TCL prompt:          SELECT TABLE1 WITH ORDER.NO = 177This only returns the index value, but it worksSQL command:This works at TCL prompt, but fails going thru Python/UOPY:      SELECT CITY FROM TABLE1 WHERE ORDER.NO = 177;I have tried with "177"    double quotes or single quotes  '177'.  Also with/out  ; at the endI have tried sending the command as both uppercase and lowercase.What am I missing?Thanks for your time. ​------------------------------Dave EvansProgrammerCombined Transport Inccentral point OR US------------------------------

Hi All,Is there a way from ECL to generate a list of all indexes on all files? (And the index attributes)I know I can do a LIST.INDEX FN at the ECL prompt file by file, and I could script running through all VOC records that are files, but I cant seem to pipe and append this ouput to a text file. Rick

We have data that is stored in an attribute with multiple values and up to two sub-values per value. Using an I-type dictionary, I have found that I can only extract specific sub-values if any sub-value marks are converted to another character first. For instance, the following will not work for attribute 2 (formula) in the dictionary to retrieve the first sub-value: FIELDS( @RECORD<77>, @SM, 1, 1 ) ​​​Instead, we have resorted to using the following: CONVERT( @SM, "`", @RECORD<77> ); FIELDS( @1, "`", 1, 1 ) Just curious if this is an expected behavior or if anyone has found a more elegant solution. Thanks!------------------------------Jeff TeterWoodforest National BankThe Woodlands, TX------------------------------

Hi Guys, we would like to go Paperless  in our Warehouse for our Pick & Pack operations. We currently us SB Client on Windows Laptop and Desktops as the interface to our Business system (IBS from K3), The Business app makes extensive use of F2 and F3 keys and other keyboard input and as such does not lend itself to Touchscreen only use, we currently have any plans to go over to Barcoding at the moment (Thats a long story i shall not bore you with just now) We have as an experiment in our test system, be investigating using small 10" Ruggedised Windows Laptops, for both mobile and for use on Fork Lift trucks. However we are getting significant dropouts from the SB Client Sessions, as we move around the warehouse, We use Meraki for our WIFI and the signal strength from the AP's looks good and we can browse the network and access MS TEAMS, without issue. So this suggests to me that the Meraki's can't currently maintain the transition from one AP to another for the SB Client user sessi

Hello all! We are running UniVerse 11.3.4 on AIX 7.2.  We just started this combination 2 months ago, though we've been running on UniVerse/AIX for many years.  Yesterday we received a UV error during one of our users' sessions:        Integer value over the MAXINT (2147483647). Zero used.We've never encountered that error before. I've run searches through the $uvhome directory at the unix level, and the only references I can find to MAXINT are in python.tar.  We're not running Python code and have not even licensed it.We're looking at the issue, and it's most likely a data error, but is has raised my curiosity.  Where is MAXINT set?  Is it something we can control, or is it hard-coded into UniVerse somewhere?  Has anyone ever had a need to modify the value - up or down?------------------------------Brian Paige------------------------------

We are setting up a connection on a new server to connect to our Prelude (UNIDATA) database. I can test the ODBC connection and get success. When we try to use the connection, we get the error below.Error code: 9603Details: Error [0000] [Rocket U2] [U2ODBC] [0302809] Unable to allocate sufficient memory!Error [0000] {Rocket U2] {u2ODBC] [0400182] Connection not open.Activity ID: 47fd30ba-cfa2-4f5b-806c-5f5eb28dc60f.ODBC installed on Windows Server 2022U2 64-bit ODBC Driver  7.241.02.9003when I test the connection to the UNIDATA DB my connection passes. When the connection is used to pull data we get the error.------------------------------Nathan SchultzCertified Power IncFridley MN US------------------------------

After many years of not using wIntegrate, I started again.I'd swear I had ^C  triggering a <break> on the UV server SSH session, but now it isn't.Probably something stupid in the settings, or between the ears.  I can't find it.wIntegrate v6.4.4vt00u2 ssh   port 22Setup > Keyboard >Key Definition Listing> Break Key: <<Ctrl>+CNo special key mapping(looks like what I used to use with Dynamic connect, except ssh)In Putty ssh ^C works.Any advice?  TIAChuck Stevenson------------------------------Chuck StevensonDBA / SW DeveloperPomeroyUS------------------------------

Has anyone got a JDBC connection to UniData 8.x from Tableau working? The JDBC connection to UniData is set up and working, but Tableau can't see it. The 64-bit ODBC driver doesn't seem to communicate well with Tableau at all.  I did get somewhere with the 32-bit ODBC connection, but it's not performant. Things worked much better when accessing it through an intermediary (Microsoft Access, just to mess around with it), so perhaps Tableau can't handle the quirks of the driver (v7.241).All my experimentation has been done with Tableau desktop edition, but I do have other editions available.  I also have inquired with Tableau, but it's slow going on that front. Any help is appreciated.------------------------------Elaine LitchfieldOwnerElaine Litchfield ConsultingSan Diego CA US------------------------------

EXECUTE has an optional CAPTURING clause. I am curious about the frequency of its usage. I can think of a few workload scenarios.1. CAPTURING: Process the resulting output for some information. 2. CAPTURING: Suppress the output so it does not disrupt a terminal screen.3. CAPTURING: Phantom processes where repeated EXECUTE fill a disk with large &PH& file records.4. No CAPTURING: Phantom process where the output could prove useful if something goes awry. Expected possible failures would most likely be caught in the first scenario and logged.I assume that most instances of EXECUTE use CAPTURING for one of the cited examples. Would anyone like to share their thoughts on the fraction of EXECUTE with or without CAPTURING to the whole population of EXECUTE, or other workloads for using or ignoring the CAPTURING clause?The PHANTOM command now supports a BRIEF keyword to suppress output (except for "Messages" according to the documentation). I assume "Messages" are the kinds of errors

I just downloaded ud8.2.3 (trail version) installed it and I am getting the following error:Couldn't start SMM. Please check /usr/ud82/bin/smm.errlogUniData R8.2 NOT started.Starting UniData...Tue Nov 1 14:38:06 2022; UniData license expired.looking at the error log I see:Tue Nov 1 14:38:06 2022; UniData license expired.Tue Nov 1 14:38:06 2022; Exit: SMM error while checking license.I download this from a link in an email I was sent (your unidata for linux download) with a download now button .........whats up with that?dougc------------------------------Doug ChancoUniverse ProgrammerSelf Registeredgraham NC US------------------------------

if in one sentence (or maybe 2/3) you had to answer this question, how would you answer it?why should I choose universe over unidata or unidata over universe?would love to hear answers from rocketeers ..........dougc------------------------------Doug ChancoUniverse ProgrammerSelf Registeredgraham NC US------------------------------

How can I access the data that is returned when using the LISTUSER command? What file and account is it being stored in?------------------------------robert modrichDeveloperRocket Forum Shared AccountTEMECULA CA US------------------------------

How can I access the data that is returned when using the LISTUSER command? What file and account is it being stored in?------------------------------robert modrichDeveloperRocket Forum Shared AccountTEMECULA CA US------------------------------

I hope this is the right place to post this ......... if not sorry anywayis there a reason uniobjects and unirpc cannot be turned on in the trail version of universe?  I understand this is to test drive the system and what not, as I am thinking of trying to sell universe with several applications (that I am developing)  but it hard to do when I cannot develop it fully.I have a c# application (developing) that can use couchbase , ms sql, mysql and I would like to add universe as the back end database (there are non production version  and in the case of mysql free versions I can use to demo the application) and then based on which the want or their price point, (how powerful a server they are willing to purchase , how many users etc .....I can recommend a database for them to use.i would LOVE to add pick as a database option (universe and jBase) but I need to be able to connect to a system to test (and develop) before I can think about offering it.  I did look into purchasing a universe

I have the PE versions of both (unidata and universe) and my VM is currently running universe, do I (or should I) spin up a new rocky linux VM to install unidata on or can I install unidata on the machine currently running universe?I guess spinning up a new VM is not a big deal but I was just curious if they both could run on the same system any advice or suggestions  appriciateddougc------------------------------Doug ChancoUniverse ProgrammerSelf Registeredgraham NC US------------------------------

HelloI want to use the FORMAT command from TCL for formatting BASIC code.  It works perfectly and formats my code with a margin of 6 spaces and indents of 3 spaces wherever it is needed.From my dim and distant past, I seem to remember being able to specify a different margin and indent, but I can't remember how to do it.There doesn't seem to be any command-line option to do this.  My recollection is that to do what I want, I need to update an item in a file with the required margin and indent (perhaps VOC?).Can anyone help me with this?Thanks.Philip------------------------------Philip EllisRocket Forum Shared Account------------------------------

Has anyone used AD authentication for ODBC connectivity to Unidata/Uniobjects on Redhat?Working on a project to migrate from AIX to Redhat Linux.  AD authentication for users to login via ssh to the server and run the application is working.  But a small subset of the users have ODBC connections from Excel/Access for some critical pieces.  Authenticating with a local account works, but for various reasons the goal is to eliminate local accounts on the server and have everything controlled by AD.  There's an error when connecting via ODBC that is hard to diagnose - I do see some errors in /var/log/messages that look like a process is core dumping, but nothing in the Unidata logs.Anyone doing this successfully and have hints about what made it work?------------------------------Ian McGowanPrincipal ConsultantRocket Forum Shared Account------------------------------

is there anything that describes the differences between universe and unidata, in particular keywords, and anything related to coding.  I am starting to look at unidata (once I get it setup) and was wondering if there were any documents specific to coding in unidata versus universe (I am going from universe to unidata).I can't imagine there being that much or difference, but I could be totally wrong.  My plan is to get it installed this week-end and then start writing some code in unidata so any advice would be appreciated.I have downloaded the unibasic reference manual as well as a few others as I begin my "experiment" of coding in unidata  (speaking of which is there not a unidata file of all the manuals like there is in universe?  I have been downloading one by one the documents I feel I will need but it would be nice to be able to download 1 file of everything.any simple "gotchas" would be welcome and a document detailing the differences would be AWESOME.  and for now my concentrat

Hi all, We are looking for an experienced UniVerse programmer (full-time position).  If you know of any potential candidates, particularly if they live in Southern New Jersey / Philadelphia area, please invite them to apply: https://www.linkedin.com/jobs/view/3319293783Best regards,Mike LiggeraKeystone Information Systems, Inc.keyinfosys.com------------------------------Mike LiggeraVice President / Finance, Manager Of Client, Vice President For Client Services, Vice PresidentKeystone Information SystemsMaple Shade NJ US------------------------------

MultiValue Experiences version 1.4.0.791 has been released on October 18, 2022 for the below platforms/versions: AIX POWER       7.1, 7.2 CentOS       7,  8 RedHat Enterprise Linux Intel       7,  8 Windows       Windows 10, 2016, 2019 This product is available to order immediately via your Rocket software provider or by logging into your RBC account at https://rbc.rocketsoftware.com or https://rbcint.rocketsoftware.com.Additional Product Information is available on the Product Availability Matrix at https://rbc.rocketsoftware.com/matrix.asp or https://rbcint.rocketsoftware.com/matrix.aspFor any questions on product availability, please contact u2askus@rocketsoftware.com.------------------------------Mary SchulzSenior Product Manager, MVX Experiences------------------------------