Rocket MultiValue

This could be an "I don't know what I'm doing" type issue, as I've rarely had to use this and don't live and breathe this stuff, but I'm running out of ideas so I thought I'd go into beg for help mode. I have a .net core 3.1 app written in C# that communicates with Unidata 8.2 on Windows via WebDE 5.3 using RPC calls. Everything was working great with WebDE 4.x but I'm struggling with 5.3.I can communicate with UniData and retrieve a response. The response is a @AM delimited string on the Unidata side. When I receive the response it's just one long string delimited with the default unicode character, 65533. I looked for someplace to set the character set/encoding but didn't find anything obvious. 1) Are there any updates to the documentation that show current RPC examples? The 5.3.1 docs show the method is setConnection but it appears you need to use ActiveConnection instead. I'm wondering if anything else has changed that I could be missing.2) What needs to be updated in the project s

When I change my slave printer in Accuterm to produce an Adobe PDF, I have to manually name the new file. How do you automate this process such that I can pass a per-determined name for a print job to Accuterm? Thanks.------------------------------Richard GinsburgPresidentGinsburg ConsultingManassas VA US------------------------------

Excuse the brain cramp, but I need some assistance to see if I can create the dictionary PGM.PCT.File data is:<1> PGM1 <mv> PGM2 <mv> PGM3<2> 1000 <mv> 2000 <mv> 3000I want to list F1, F2 & PGM.PCT​ to get this expected output: >LIST DATA.FILE F1 F2 PGM.PCT PROGRAM NAME    COUNT    PGM % PGM1                                1,000          .167 PGM2                               2,000         .333 PGM3                               3,000          .500  I thought (incorrectly) that PGM.PCT would be (@RECORD<2,@MV> / SUM(@RECORD<2>) Can this be done in a simple I-descriptor or am I barking up the wrong tree?​I am in UniVerse 11.3.1 on AIXNelson------------------------------Nelson SchrothpresidentC3CompleteShop LLCHarrison OH US------------------------------

How can we quickly see if a file (or list of files) are 64bit or 32bitI can see from analyze.file that a file is 64bit. but that was not picked up by the ACCOUNT.FILE.STATS in the STAT.FILEIs there an hidden key in FILEINFO() that will get that information------------------------------neil richardsdbaRocket Forum Shared Accountlake Elsinore CA US------------------------------

I've reached the point of presenting a list of maintenance schedule option check boxes for constructing a work order for a vehicle. I would like to present the user with a window sized to the number of scheduled items for the vehicle which may range up to 20. The only way I see to do this is to ATGUICREATEFORM or ATGUICREATEFRAME2 within the program to control HEIGHT. Does it make any difference which or is there a way to do this from a GUI created form?Dale

I’m a bit confused as to which to use to create .NET applications. I’ve been using U2 Toolkit for .NET (u2.Data.Client.dll) because the documentation includes sections on how to convert from U2.UODOTNET applications. When I look at the documentation for UODOTNET (U2Clients_UniObjectsNET), I see it is only a few months older than the U2 Toolkit documentation, and it is much more detailed. Does the “U2 Toolkit” supercede the “U2 Clients”? Can I trust that all the U2 Clients documentation describing the UniObjects and how to use them (such as record locking) applies to the U2 Toolkit UniObjects? Thanks.

MultiValue Experiences version 1.5.0.874 has been released on January 24 2023 for the below platforms/versions:AIX POWER       7.1,  7.2CentOS       7,  8RedHat Enterprise Linux Intel       7,  8Windows       Windows 10,  2016,  2019This 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 rbc@rocketsoftware.com.

I have implement some web service calls in a Linux based D3 system without needing to use the MVS Toolkit. I was wanting to use the same code on a Windows version of D3 and decided to see if the MVS Toolkit would be suitable as the method of accessing D3 on Linux that I used does not appear to be suitable Windows based systems. I have created a web service named "editor" and a web service resource named "explore" for testing purposes. In order to replicate the way the Linux version works I just needed to implement a single resource and use the mvsp.get.http.* subroutines to extract the required data and then submit the data to the other subroutines that implement the business logic. All went well until I tried to use a PUT http method. It has the structure similar to PUT http://server_name:8181/editor/explore/?account=account_name&file=file_name&program=program_nameIn addition the content of the http request is a string representing a JSON object. Under this situation I was exp

Hi I would like to find out where can I download or find any D3 training documentation or material.I'm from a Universe Basic background and would like to learn D3.Regards,Thando Ngayi------------------------------Thando NgayiAxiz------------------------------

HI,I am looking for some help for JDBC Driver response. When our DBA queried the table and got response as below CLAIMS......... Descrip... Doctype... Clmtype...   06040240*09*005 LMCA INFAR C          P                CTION06089078*17*009 01/08/2017 C          P                -31/08/201                706180956*20*004 03.05.20-0 C          P                2.06.20 SE                IZURES06305773*21*001 01/06/2021 C          P                 - 22/10/2                021 However when we run SQL Query using JDBC, getting the response as below.SELECT ID,DESCRIP,DOCTYPE,CLMTYPE FROM CLAIMS SAMPLE 4;ID,DESCRIP,DOCTYPE,CLMTYPE1: "0", "L",    "C",    "P"2: "0", "0",    "C",    "P"3: "0", "0",    "C",    "P"4: "0", "0",    "C",    "P"The data is not returning as same as above. Can someone help?------------------------------Elayaraja KathirvelRocket Forum Shared Account------------------------------

Can someone help for GUI tools (like SQL Server Management studio) for Universe DB? So that I can see list of tables and contents?------------------------------Elayaraja KathirvelRocket Forum Shared Account------------------------------

There are 4 prefixes allowed to be used when globally cataloging programs: "$"  // Used for custom conversion codes (which need to support the call signature "(ANS,STATUS,InputData,TYPE)" "*"  // Globally cataloged programs the command processor will run as a normal main BASIC program "-"  "!" The "-" and "!" are used by subroutines supplied with UV.Does anyone know if there are specific features/functions for the "-" and "!" prefixes, or are they just available to be used and have no specific handling?Does anyone know if the "$" and "*" prefixes have other behaviours/constraints?Thanks------------------------------Gregor ScottSoftware ArchitectPentana Solutions Pty LtdMount Waverley VIC AU------------------------------

Our devops team was  performing a system upgrade from Linux Ubuntu 18.04 to 22.04 late last night.  When they completed the migration, they discovered to their horror that the SystemID had changed.   Not knowing what to do at that hour of the night, they searched for a solution.  They found a link  posted by Martin on the Google Groups: www.openqm.com/emergency.htm   They provided the required information and received the following back: 1. We are concerned that after 7 days pass, this license will expire.  Can someone confirm?2. What is the correct action to take?  Our upgrades are going to take place off-hours, late in the evening.3. Is this expected behavior that an O/S upgrade will change the system ID? Any advice is appreciated.------------------------------Ben Cramer DSI Solutions LLCMansfield TX US------------------------------

Has anyone done this with a conversion program or by hand?

Hi,Can someone help for downloading JDBC driver for accessing from UNIX Server (as Client) to Universe DB?------------------------------Elayaraja KathirvelRocket Forum Shared Account------------------------------

I have this audit file that cannot be selected, counted, or cleared. I am running Universe 12.1 in Windows 2016. Generally, this audit file gets purged daily using date criteria of 90 days back, however, I just noticed the select never comes back. I was able to kill the indexes and was hoping that was the problem, but that was not the case. I should point out that I can add more data to the file with writes but not much else.Besides creating a new file and renaming this one, has anyone seen something like this?Posted 08-27-2022 11:43------------------------------Doug AverchOwnerU2 Logic------------------------------

I have several customers who need real-time sales tax calculation. Has anyone integrated an online sales tax calculator with D3 and is willing to share the code?------------------------------Richard GinsburgPresidentGinsburg ConsultingManassas VA US------------------------------

Hy... does anyone use SNMP to monitor d3 in linux ? to monitor memory use, disk use and other things... if yes... how ?------------------------------Alberto LealSystem AnalystMillano Distribuidora de Auto Pecas LtdaVarzea Grande MT BR------------------------------

hy  i use  the follwing select  :select sgvar614 if a9999 eq "^^^"[401] no items present. but sometimes takes to long...  and i was think... is possible create a index for that ... for exemple CREATE-INDEX SGVAR614 A9999 it would continue acctin as funciction to size.. or would do as the attribute ?------------------------------Alberto LealSystem AnalystMillano Distribuidora de Auto Pecas LtdaVarzea Grande MT BR------------------------------

I've added 3 attachments    file "OPENPYXLTEST.txt"   is this basic program that calls Python program named "openpyxlText.py".  From inside an Accuterm7  windows I RUN OPENPYXLTEST program 3 consecutive times. with out changing any code  or anything.  I get the output below.     As a test I ran this python code in Linux and windows neither test caused an error nor OS failure. We are using universe 11.3.4 The python openpyxl library is the most recent available.  I've attached the requirements20230111.txt file also that I created yesterday.I have a few print() statements in python code to show the flow.====== output from python openpyxlTest.py from AccuTerm 7 window ======>RUN OPENPYXLTESTCalled build_u2_objectLoading variablesreturn control to U2loaded start_U2excel methodAt top of method, load_csv_from_file()loading openpyxl libraryJust after import openpyxl lineran load_csv()>>>RUN OPENPYXLTESTCalled bu

sorry to post this again but for some reason I could not post a follow up question to derek's response, is xadmin the ONLY way to create accounts in unidatathanksdougc------------------------------Doug ChancoUniverse ProgrammerSelf Registeredgraham NC US------------------------------

i can create an unidata account using ext admin tool just fine but in universe (which is where I came from to unidata) there was a uv account that went to a universe menu where you could add/delete accounts amount  a lot of other things, is this not available in unidata?thanksdougc

Please excuse a basic question. but is it possible to delete an item from a select list like you can with an array?SelStr = ' WITH ORD.CODE = "A"  AND ORD.SHIP.DATE < "1/01/2023"'XCmd = 'SSELECT ORDERS' : SelStr : ' TO 1'CRT XCmd ; EXECUTE XCmd  LOOP    READNEXT ORD.ID FROM 1 ELSE EXIT          IF ORD.ID = 12192209 THEN      DELETE ORD.ID FROM 1?????         END   REPEATEND------------------------------Matthew WrightAnalystTomago Aluminium Co PTY Ltd.Tomago NSW AU------------------------------

I've been trying to write an ATGUI program using the data grid.  I want to change the row colors on some of the rows but not all. I was able to do it using the ATGUISETPROPS subroutine but it's pretty slow.  My grid displays that data quickly enough by filling it in with the ATGUISETPROPS and loading them all at once. There are only about 30 rows.  After they're displayed I make a second pass highlighting the special rows. It pops up the "Waiting..." dialog and you can watch the colors flow down.Is there anyway to set multiple row colors all at once like ATGUISETPROPS?When I refresh the grid with new data the highlights stay there. I tried setting all the foreground and background colors for the entire grid by using ATGUISETPROP and setting the col and row values to zero. I couldn't get it to work so instead of just setting the highlight colors I have to reset them all for each row whenever I load new data. Is there a better way to re-initialize the grid colors?Finally, is there any wa

There was an SQL optimization error in 3.4.7 caused by using wildcard characters in your WHERE clause. This build fixes it. If you want this latest version, please contact D3 support and we'll get it to you.------------------------------Brian S. CramPrincipal Technical Support EngineerRocket Software------------------------------