Rocket MultiValue

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?

The requirements listed for 1.3.0 report a minimum of UV 11.3.1The Product Availability Matric in RBC lists a column named "Advised Minimum", leading me to think it might be possible to run MVIS 1.3.0 against an older UV version, like 11.2.5Is it possible to use MVIS 1.3.0 with older UV versions, or does it have a hard requirement for the newer functionality from 11.3.1 onwards?------------------------------Gregor ScottSoftware ArchitectPentana SolutionsMount Waverley VIC Australia------------------------------

I note that the "requirements" for 1.3.0 list a UV 11.3.1 with connection pool licenses as a minimum.Are the "connection pool" licenses absolutely required for MVIS 1.3.0, or can it be configured to operate using normal UV licenses?------------------------------Gregor ScottSoftware ArchitectPentana SolutionsMount Waverley VIC Australia------------------------------

Hi,Where can I find the download fo MVIS 1.3?Regards,Thando------------------------------Thando NgayiAxiz------------------------------

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?

We have used printer loadable soft fonts to print logos on packing slips for over a decade. I am now unable to find anyone that can provide a service or software to convert images into SPF files. Does anyone have any idea of finding something or a workaround like printing an image directly for every printed page?------------------------------Nelson SchrothpresidentC3 Completeshop LLC------------------------------

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

We use the Import file function in Wintegrate extensively for our quarterly reporting and extracts.   Has anyone automated the process where you call the Import file function (using .wis files predefined) from a program?  Looking to create a batch process for our quarter close and call multiple imports to facilitate data imports into Excel.  I looked through previous threads as well as documentation but could not find anything referencing calling/running the .wis files from a program.------------------------------Cory BelgradeSr ManagerOne America------------------------------

I need to securely store pdf documents.  First thought was to encrypt and store on web server, then keep the key in DB to decrypt.  Second and better thought would be to upload the pdf to the DB and store the binary document in the DB.Just wondering if anybody has attempted to store a PDF document in the db and if they would be willing to share any code/problems.Craig------------------------------Craig Curtiscraig.curtis@seviersd.org------------------------------

Hi Everyone, just a bit of background, we have several Excel Applications that use ODBC to fetch data from UV files and update, and have reached the limits of what is available with the allowed joins and use VBA scripts to perform several queries. We run in to problems that if there are no Client Licences available, for obvious reason the Queries don't execute and this can lead to problems getting the queries to rerun I am sure this is down to MS Excel / MS Query / limitations of the Rocket ODBC drivers. we are using the latest U2CL_5.2.1 I was wondering if anyone has any experience of using MS Access as a vehicle to extract data and if "LINK TABLES" are considered a supportable and reliable way to extract the External Data and then point our Excel process at the Access harvested data rather than Excel extract the data directly from UV I've had a play and only got limited success with the MS ACCESS "Link Table", some tables wont return data and present on ODBC - CALL FAILED error, even

The Rocket MultiValue product management team hosts quarterly livestreams about the MV product roadmaps for Rocket UniVerse, Rocket UniData, Rocket D3, and MultiValue tools. The second quarter event is just 2 days away. Sign up now and pre-register for the third and fourth quarter events as well.Each quarter, Rocket product managers will present both near-future and distant-future plans for MV, as well as the many possibilities we're still thinking about. Additionally, in 2021 we added a cloud roadmap for customers who want help moving to the cloud.Sign up here------------------------------Dave AndrewsHead of Customer EngagementRocket Software------------------------------

The Rocket MultiValue product management team hosts quarterly livestreams about the MV product roadmaps for Rocket UniVerse, Rocket UniData, Rocket D3, and MultiValue tools. The second quarter event is just 2 days away. Sign up now and pre-register for the third and fourth quarter events as well.Each quarter, Rocket product managers will present both near-future and distant-future plans for MV, as well as the many possibilities we're still thinking about. Additionally, in 2021 we added a cloud roadmap for customers who want help moving to the cloud.Sign up here------------------------------Dave AndrewsHead of Customer EngagementRocket Software------------------------------

Every time I've tried to use the Debugger Perspective in U2BDT it crashes the entire application. We're using v4.4.0 of U2BDT, after crashing we get this Java error:Is there anything I should be particularly looking out for configuration wise?------------------------------Matthew WrightTomago Aluminium------------------------------

I have a paragraph which prompts for a branch code to be selected.I want the branch codes to be a dropdown list in the paragraph. example :1 North2 South3 East4 WestMy paragraph output.Enter P to print or D to display report(P/D) =DENTER APPLICATION START DATE =01 FEB 21ENTER APPLICATION END DATE(DD MON YR) =11 FEB 21ENTER YOUR BRANCH NUMBER=Paragraph:SORT MYFILE WITH DATE GE "<<ENTER APPLICATION START DATE >>" AND LE "<<ENTER APPLICATION END DATE(DD MON YR) >>" AND WITH BRANCH EQ "<<ENTER YOUR BRANCH NUMBER>>"AND STATUS = "1" "4" "5" "7" ID STATUS DATE TOTAL AMOUNT BRANCH HDR-SUPP ID-SUPP LPTRAnyone can help?------------------------------Francis AquilaCore Banking Support OfficerTISA------------------------------

Hi,I would just like to say MVIS 1.2.1 is a solid product. 12 months ago I created a POC app to understand the HA element of the solution. It's performance has been outstanding with no downtime and easy cloud integration. Using https://aws.amazon.com/marketplace/pp/Rocket-Software-Inc-Rocket-MultiValue-Application-/B082DLTD53 to build the Back-End & building the Front-End utilising the Angular Framework and deploying both utilising Amazon. We created a simple SPA  to perform our testing of the solution. https://rocket-demo-68270.web.app/login Enjoy.  ------------------------------darren johnsonIndue------------------------------