Rocket MultiValue

Hi There,I have a retrieve sentence that displays the Loan officers number but I also want to display the officer's name.                                                                                                                   I would like to lookup officer's name in another file. Both files can be related using the operator number.The file I am using is APPLICI need to create a dictionary in that file to lookup the officer's name in PR.USER file.Name is the ID  in PR.USER file.Sample of my output APPLIC Id.... LOAN NO.  LO_OFFICER APPLIED....   LOAN AMOUNT Sts Branch  31786L1.2     687168          1012   15 JUN 21      1,025.00   5      6 3981L1        687182          1074   15 JUN 21        275.00   5      6 Please if anyone knows how to create this dictionary would be of great help.RegardsFrancis------------------------------Francis AquilaCore Banking Support OfficerTISAPapua New Guinea------------------------------

All,We have a large number of reports printed each day. Users will contact our admin staff to find out why a print job did not print. We get some reports that have a banner page with no other output or no records selected. We would like to identify what report was run and generated no or vague output. Is there some way to modify the banner/separator page to include the report name? Is there a way to force Retrieve to print the headings when no records are selected? I think one way would be to pass the USEROPTS from the SETPTR command to a script grab that and try to keep a list of print jobs and the USEROPTS file in a file somewhere, but it seems really convoluted.

Can someone point me to a download link for UV PE for Windows if it still exists. I've had a look on the Rocket site on the only mention I can see is in the AWS Integration Server instance they're promoting.I want to attempt to set up a Windows Docker instance of UV (to use with a build pipeline). Has anyone done something like this? Should I bother?------------------------------Stuart Boydell------------------------------

Hi All, is anyone using Wintegrate in conjunction with MFA? We're looking to implement DUO to do Radius based authentication. We are using Wintegrate v6.3.6 (Local Clients) to connect to Unidata for Windows (8.2.1. build 9104).I'm thinking we'd login in via Wintegrate as usual, but within the login voc we'd interact with DUO at that stage to do a push to mobile devices etc. for verification.I'd be interested to know if any other users have this in place.------------------------------Norrie SteeleMainetti UK Limited------------------------------

Generating a date in UTC Date Format The data format for an external entity we were supplying data to had changed. They changed the date format from the international YYYYMMDD format to the UTC format. D3 does not have an intrinsic conversion for this format, so I had to come up with a way of generating this date format. After some research, I found a command using PowerShell that could provide me with this date format, but on execution from within D3 I found it to be too slow, especially in a loop. I needed to use only D3 to create the date format to ensure optimal speed. One of the things to keep in mind is whether daylight savings time is in effect (or not). Again, D3 does not provide this info and calling a Powershell script was just too slow. I had to find a way to store a flag in D3 which could be used by a D3 subroutine to know about daylight savings time (DST) and produce the date in UTC format. My idea was to set a DST flag in D3 once a day when the user logs in. This flag can

Does any member have any practical experience embedding a .NET control into SBXA Application.  Something with a User Interface aspect like a rich text control, RIBBON control, chart etc?#SB/XA------------------------------Aaron GloverDirectorHealthinc Pty LtdNeutral Bay NSW Australia------------------------------​​​​

I'm just thinking out loud here...I personally detest INCLUDEs. Why? Well, for 3 very important reasons: If a change is made to the INCLUDEd item, all programs using it must be recompiled. One or more main programs could be missed, thus still using the old code. When an error occurs inside an INCLUDEd item, only the line number of the INCLUDE is shown, not the line number inside the INCLUDE itself, thus making debugging an INCLUDE more difficult, nigh impossible depending on its size and complexity. INCLUDEs do not isolate the code from the calling/using program, thus accidental (or on purpose) reuse of variables can be a danger, causing unexpected behaviour of the main program. So here's the question: Is there a way for D3 to show the line number in the INCLUDE where the error occurred? Would this be an enhancement request? Would it even be possible?If not, how do people go about debugging an INCLUDE? Short of physically embedding the INCLUDE code in the program (temporarily), I can

Hi All, is anyone using Wintegrate in conjunction with MFA? We're looking to implement DUO to do Radius based authentication. We are using Wintegrate v6.3.6 (Local Clients) to connect to Unidata for Windows (8.2.1. build 9104).I'm thinking we'd login in via Wintegrate as usual, but within the login voc we'd interact with DUO at that stage to do a push to mobile devices etc. for verification.I'd be interested to know if any other users have this in place.------------------------------Norrie SteeleMainetti UK Limited------------------------------

Is there any way one can use the Update Editor to insert an SVM ^m  =  am  ;  ^v  =  vm  ;  ^??? = svm (^  =  <ctrl>)

UniVerse version 11.3.3 has been released on May 31 2021 for the below platforms/versions:AIX POWER       7.1,  7.2Amazon Linux       2CentOS       7,  8HP/UX ITANIUM       11.31Oracle Enterprise Linux x86       7,  8RedHat Enterprise Linux Intel       7,  8Solaris SPARC       11Solaris Intel       11SuSE Linux Enterprise Server Intel       11.0,  12.0,  15.0Windows       Windows 10,  2012,  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 availabilit

The normal "LIST / SORT" commands work ok when EXECUTEd, pausing at the end of each page of content.If the VLIST command is EXECUTEd, it does not pause. Instead, the output from the command scrolls up the screen.Is there a way to force the executed command to pause at the end of each screen, or is this just a VLIST issue?------------------------------Gregor ScottSoftware ArchitectPentana SolutionsMount Waverley VIC Australia------------------------------

We have a strange situation occurring where a phantom process (launched using the UV PHANTOM command) somehow have their linux 'nice' value set to 2. This results in the processes running at a slightly higher (less important) priority of 22.We have no linux scripts that are triggering this, and the command launched does not 'renice' itself so are at a loss to explain how this is happening.Is there anything within UV that will result in a phantom process having it's 'NICE' value adjusted to reduce the PID's impact?Is anyone aware of anything within RHEL that could also lead to a process being automatically reniced this way?------------------------------Gregor ScottSoftware ArchitectPentana SolutionsMount Waverley VIC Australia------------------------------

When copying an item with a "!" in the key, COPY breaks on the "!" as if it's a delimiter between multiple items.  Why?  Can this be overridden somehow?TEST>COPY LIVE.PN.PREFIX 001!PHITO: (PN.PREFIX001 is not in file LIVE.PN.PREFIX!PHI is not in file LIVE.PN.PREFIX0 records copied------------------------------Kevin KingPresidentPrecision Solutions, Inc.------------------------------

Hi,Is there any detailed logs we can check when errors occurs ? - Connect to U2 server failed. ? - Extension not Started can we set a 'log level' somewhere ? many thanks------------------------------Manu Fernandes------------------------------

Hi,I'll share our experience to edit the BASIC code locally with vscode/rocket-mvbasic.Simply, we combine the rocket-mvbasic with sftp extension sftp sync extension for VS Code- setup a ssh service on your db-server c.f. ssh.com/academy- setup the two extensions under vscode.- create a local directory 'local-source'- inside the local-source, create a sub-directory named like your account you will edit the code- start vscode on local-source\\myaccount- save a workspace on local-source\\myaccount (to receive .vscode and .rmv settings)- start CommandPalett > Sftp: Config (which create a sub-dir .vscode and a sftp.json file you edit) { "name": "the name of the profile", "host": "servername", "protocol": "sftp", "port": 22, "username": "userid", "password": "password", "remotePath": "/path/to.myaccount", "uploadOnSave": true, "downloadOnOpen": true, "ignore": [ ".DS_Store", ".git", ".vscode", ".mvx-ide", ".hs_debuginfo", ".rnd", ".rmv",

Hi,Can we receive a enhancement at Symbols/Signature/Outline to include all symbols declared into a INCLUDE item ? Here is a little sample where I define some symbols (equates and variables) into TEST.INC item then I include TEST.INC into my TEST program.1/ the Outline pane do not show the TEST.INC's symbols1.1/ I suggest you create a sub-branch into the Outline tree called like the included item then list all declared symbols  V OUTLINE - TEXT.INC | $ZERO | ONE | TWO - A​ 2/ when I use the TEST.INC's symbols, Signature throw a 'Referenced undefined variable: ' ; which underline the symbols and fill the Problems PanelThis behavior induce a question is it a real error ? ...If you load the INCLUDE's symbols, no Signature problems occurs ... with kind ragards------------------------------Manu Fernandes------------------------------

hi, How can I add languages references : I get errors like  :- Referenced undefined variable: @LOGNAME -> use as a var- Referenced undefined function: SET.PTR  -> used into CALL !SET.PTR()- Referenced undefined variable: @VM ->used as a var- Referenced undefined variable: not   -> used into if not(var) then ...Thanks for your help.------------------------------Manu Fernandes------------------------------

As you may have seen in our Announcements, D3 10.3.3 has been released for D3 Windows, Linux and AIX. They can be downloaded from the Downloads section of the Rocket Community Portal. Download the release notes for your platform and see what's new and what's fixed in this release. I for one am really excited about the fact that the D3 Windows VME size is now unlimited. So upgrade now!!------------------------------Brian S. CramPrincipal Technical Support EngineerRocket Software------------------------------

U2 Web DE version 5.3.1 has been released on June 04 2021 for the below platforms/versions:ALL       ALLThis 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.

Hi Brian,When that is done, no items are returned at all... the  reason being that the value returned from A8, in that instance, is not a valid date "Dec-2012" ... FWIW, the SS connective used in context would look similar to this: LIST fn WITH some.selector = "xxxyyyzzz" BY some.sortfield break-on some.sortfield SS start.date end.date SUMMARY.ATTRIBUTE det-supp ... Best regards and keep safe, Vincent "Kim" ElliottITC CoordinatorBearings & Accessories Ltd.83 Harbour StreetKingstonJamaica, W.I. Tel: 876-922-1950Cell: 876-315-2739Email: vincent.e@bearingsandaccessories.com  

Hi All,Given an item ID such as 001000885$25BIW06GN-1$16407 and a dictionary item such as:001 S002 0003 MONTH004005006007 A;0(G2$1]DMA]T1,3):"-":0(G2$1]DY)008 G2$1009 R010 8A LIST or SORT on the dictionary item returns the correct value "Dec-2012".  However, when this same dictionary item is passed to the SS connective as in LIST ... SS MONTH "01/01/2012" "31/12/2012"  UNITS ..., the value returned is garbage as in "-"  and the totals a single column of all zeroes (we use European date format).Have I structured the dictionary item incorrectly or is there a bug in the SS handling of the dictionary item?Vincent

We've just moved to a new server running RedHat 7 with UV 11.3.1.6022. A program that was running properly on the old system is failing on the new in a line attempting to start access to an XML file. The message we se is as follows: SDN001: 119: MSL.STATUS = PrepareXML(INPUT.FILE,SDN_XML):: SProgram "SDN001": Line 119, Can't load "/u1/uv/bin/libu2icudata.so.50": /u1/uv/bin/libu2icudata.so.50: file too shortWhen I checked the path in /u1/uv/bin, I see the following:-rwxrwxrwx. 1 root wnb 0 May 25 10:05 libu2icudata.solrwxrwxrwx. 1 root wnb 15 Oct 28 2020 libu2icudata.so.50 -> libu2icudata.soInterestingly, I don't see either of these files anywhere on the old server. Anyone else run into similar?TIA------------------------------Jeff TeterWoodforest National Bank[Phone]------------------------------

My program was simply opening a file using the name from the VOC @ID and then doing a STATUS.I get the same error doing a LIST from TCL.     >CT VOC TKEYCODE     0001 F     0002 TKEYCODE     0003 D_TKEYCODE     >LIST TKEYCODE     Invalid Partblock for "TKEYCODE".     Invalid or missing Partblock for "TKEYCODE".     Invalid Partblock for "TKEYCODE".     Invalid or missing Partblock for "TKEYCODE".     Unable to open "TKEYCODE" file.The files exist on AIX:       -rwxrwxrwx 1 slice staff 17408 May 28 16:29 D_TKEYCODE     -rwxrwxrwx 1 slice staff 1024 Nov 23 2001 TKEYCODENot sure why it got this error?  The file is old and probably no longer in use, but in 20 years in MV I have never see this error???env:  AIX 7.2 running UniVerse 11.3.1​Thanks in advance for any insights.Nelson

Follow this link https://rocket.wd5.myworkdayjobs.com/en-US/rocket_careers/job/GBR-Home-Office/Associate-Technical-Support-Engineer_R2021-1343------------------------------Jonathan SmithUniData ATS and Principal EngineerRocket Software------------------------------

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?