Rocket MultiValue

I get a lot of survey's everyday. I have received several from Rocket Software on what I would like to see as Enhancements to UniVerse in particular, but multivalue in general. I thought I would toss this our for discussion with the forum members. Any thoughts?Multivalue Enhancements Better overall performance Multithread using data reader/data writer Compile into IL that can be optimized on a given architecture (ECMA 335) Improve connection to alternate database types SQL No-SQL OS Independent OpenQM data type validation, better data cleansing Improve database mirroring Improve Transaction processing Improve Publisher/Subscriber performance Better use of improved system resources Configuration Expert System, Machine Learning Better development environment Visual Code with ability to work on remote servers and multiple accounts VC graphical compiling, cataloging and debugging Extensible Terminal emulator Lint type program to identify problems and poor programming practice

Last year, having switched back from Unidata to Universe, you all helped me with simple triggers - which on universe are made as file indexes. Now I am trying to apply that to a NEXT.ID but it's stored in a DICT, not uncommon for PICK. Trying to make an index on a dict, however, didn't work. >CREATE.INDEX DICT KHTEST TRIGGER   Only records of type A, D, I or S allowed! I know this trigger works as I had applied it to the data portion originally. Ideas, suggestions, thoughts? Thanks------------------------------Kathleen HambrickProgrammer at Colwell------------------------------

Hi All! We have a application (SEMtek developed by Entrinsik) utilizing Universe 11.3 and SB 5.5, with the client being SBC 5.5 (currently).  We've gone through multiple upgrades, however I believe our limit has been reached for UV and SB+ due to some programing limitation in the produce that are no longer being developed.  We've had this running for 15+ years, so all iterations of the supporting software along the line. We're using SBClient uding the GUI for SB.  We've had no issues with SBC up until newer versions of Windows 10 and similar time frame Server OSs.  In Server 2016, all items the app uses in SBC seem to work fine.  In newer releases of Windows 10 and Server 2019, SBC the main interfaces seem to work fine, but some sub menu items completely crashes and closes out the app without error.  I have ticket in with our VAR Entrinsik and will be digging myself to see if I can find what processes this death clicks are using.  Just thought I'd post here to see if someone has any ob

Is there an environment variable or some config setting in jBASE that will prevent a programmer from attempting to write a record with a null record key?  I would prefer this work globally and not based on a particular file.  This system has a lot of very old code that has probably gone through several conversion prior to jBASE.   I am aware I could put a trigger on the file, but I'm finding this issue across multiple files and would like to resolve it quickly.   We're currently running jBASE 5.7 but will soon be upgrading to 5.8.  Thanks. ------------------------------J EdwardsIT ManagerPlimpton & Hills------------------------------

Hello to all !!!!  THere is always a first time ..... what the heck is this ???  RESIZE: FL_GRPRESIZ bit was set on group 0.  Not resizing file. Thanks to all in advance  ------------------------------David Ricardo Lopez BonaecheaDirector of Software StrategyQuiter Servicios Informaticos SLSantander ES------------------------------

hi rocket, thank you for the functionnality.  Really important when we perform remote maintenance... no need to sync all the system. So, here is my first return of experience. 1/ why userid/passwd in clear into json ?  Please, use vscode-api#SecretStorage (same comment about offline editing/connected)  2/ after Connect, the list of UVAccount is not sorted / filtered : can you add a property 'selectOptions' in the server objet configuration then you execute 'SELECT UV.ACCOUNT ' + selectOptions and we can set it like 'WITH @ID LIKE "blabla" BY dictname ... etc 2.1/ add a property ''account.included[]' to the servers settings 3/ when we drill down into an account, rmv.Explorer lists (not clear) ?? all ? Type1 ? ... so can you add into servers settings 'files.included[]' ? 4/ when we drill down into a source directory rmv.Explorer list all source files.  so can you add the same filtering like in the  'Group view'  5/ can we have a local backup   of the file we edit , into the directory whi

I am learning how index work in OpenQM.  But, my program is aborting when I try to address the "list.var" SELECTINDEXV index.name {, value} FROM file.var TO list.var Here is my test program: PROGRAM TEST.SELECTINDEXV  OPEN "MEMBERS" TO MF ELSE CRT "CANNOT OPEN MEMBERS"; STOP  SELECTINDEXV 6,"999-999-9999" FROM MF TO MEMBER.ID  CRT MEMBER.ID  IF MEMBER.ID="" THEN    CRT "NO VALUE"  ENDEND Here my results with the abort.  MEMBER.ID is the correct ID. :RUN BP TEST-INDEX20050000000121: Value not found where required at line 5 of /usr/qmsys/TEST/BP.OUT/TEST-INDEX2: ------------------------------Tedmund HurlbutSelf RegisteredSimpsonville SC US------------------------------

Hello fellow PICKIES, I am trying to use FTD from Accuterm to run a file download. I need to select and sort the items it is going to list into an excel spreadsheet. I can get this to work through the wizard, but not by passing in the data statements in a program.  Help? This works: 05 ED VOC K66Top of "K66" in "VOC", 63 lines, 983 characters.*--: p001: [Job]002: FileName=mvdb://MultiValue Host*$52370\\*\\K66003: TransferProtocol=Kermit004: TransferMode=Text005: PreserveExtension=Yes006: HeaderRow=1007: Delimiter=Tab008: Direction=Download009:010: [UL]011: TransferType=File012: HostFile=013: SelectOption=SelectAll014: SelectString=015: Database=Excel016: HostItemIds=017: DosPath=018: DosFiles=019: WorkbookName=020: Worksheet=021: Range=022: AccessMDBName=023: AccessTableName=*--: p024: AccessConnectString=025: TextFileName=026: IncludeAllAttributes=False027: Attributes=028: AutoID=False029: SuppressItemID=False030: FirstRowHasColNames=False031: SelectByName=False032: AutoIDPrefix=033

There are two truths I live by - Never start a land war in Africa and PICK (English, retrieve) is HORRIBLE at creating reports! Having moved into a position at a company using Universe, they somehow didn't know that they need a report writer package and have been coding Excel reports through FTD. This is very time consuming and not particularly good at reports. In the past I have used Crystal reports, PHP, ODBC, etc.  Can I get you alls opinion what is the most straightforward, most robust report writer out of Universe (PICK)? Ideally one not overly expensive ;) Thanks! Kathleen------------------------------Kathleen HambrickProgrammer at Colwell------------------------------

I am new to accuterm, about a year now, and am still struggling with trying to understand the pieces I need in place to have a graphical accuterm screen display on the internet. I've been told repeatedly that its possible and functioning with my release of accuterm8. Can anyone share with me even a static screen accuterm display on the web? Even just a box that says 'You are here.'There are obviously pieces I need for the web address to access my accuterm display but I don't even know what questions to ask....Anyone?------------------------------Kathleen HambrickProgrammer at Colwell------------------------------

I've overcome most of the issues discussed earlier in the following two threads.  The background there may help in addressing this question.Rocket U2 | UniVerse & UniData Rocketsoftware remove preview Rocket U2 | UniVerse & UniData Rocket U2][U2ODBC][2300701]Error ID: 46 Severity: ERROR Facility: DBCAPERR - UCI Error. Func: SQLFetch(XIO); State: S1000; U2 Database code: 20085; Msg: [U2] View this on Rocketsoftware > Rocket U2 | UniVerse & UniData Rocketsoftware remove preview Rocket U2 | UniVerse & UniData I'm using the latest U2 64-+Bit ODBC Driver Version 7.241.02.9004.The ODBC Connection tests successfully and works perfectly in applications that use ODBC, such View this on Rocketsoftware > The current error is the subject error message, which I am receiving when I attempt to query certain "tables" from Microsoft SQL Server Management Studio where the Universe U2 system is configured as a linked server

I was exploring our use of the STATUS statement in a simple BASIC program that we use to show info on a file. There wre 3 date/time pairs: Last Access Last Modification Last Status Last access shows a date from years ago, so it "feels" more like a creation date.  Last Status and Last Modification show identical values. What are these supposedly tell me? Nelson------------------------------Nelson SchrothpresidentC3CompleteShop LLCHarrison OH US------------------------------

I'm in the very beginning stages of designing/developing a program that will create a file or files that can be opened/imported by Word to display multiple tables like these (screenshot from a word document): I can handle part that has to calculate these details. However, i'm not sure what my options are for generating a file that can be imported/read by Word. It appears that Word can handle XML documents, so I'm wondering if that would be worth researching. Our current process is very labor intensive and requires a lot of hands-on, so ideally, my program would generate the file(s), and Word could then open and display the info seen above with minimal manual massaging. Any ideas would be appreciated.------------------------------Shawn Waldieenterprise application developerRocket Forum Shared AccountLos Angeles CA US------------------------------

I have developed several screens using the SCRB command in the past but when I went to see some current documentation, the page cannot be found.  It is still listed in the QM Commands.  Has this been removed?  Has it been replaced by something else? Thanks,   Ted------------------------------Tedmund HurlbutSelf RegisteredSimpsonville SC US------------------------------

Hi , Please can someone assist with this. We have upgraded our Universe from 11.2 to 11.3 and testing the Universe spooler it seems not to work. When we enter  SP-ASSIGN HS "Queing disabled for requested printer" Also checked the usd usd : Queing disabled on requested printer  We checked all the print queue status and it all in "ready" status.  Did an echo test and it printed out successfully.  Thanks. ------------------------------Roland KayverCore Banking SupportTeachers Savings and Loan Society Limited------------------------------

We're pleased to announce the release of the Rocket® MV BASIC for Visual Studio Code (MVVS) v2.1.0 with a preview of the new Online Editing feature! Rocket MV BASIC for VS Code (MVVS) offers features to help your developers modernize, simplify, and work more productively in one of the most popular development environments, Microsoft Visual Studio Code (VS Code). MV BASIC for VS Code Online Editing MVP Using the MVVS v2.1.0 extension, you can now view and edit program files on your local machine OR remotely on a Rocket® UniVerse or Rocket® UniData® server with the new Online Editing feature.  We consider the 2.1.0 Online Editing feature to be an MVP* (Minimal Viable Product) and we'll continue to enhance the feature to include more MVVS operations over a series of releases.  ·       *The MVP of Online Editing supports most LSP (Language Server Protocol) features when the extension is connected to a UniData or UniVerse server; however, this preview has some limitations: o   Features lik

The Rocket® Software MultiValue team is pleased to announce the availability of jBASE 5.9.0 on May 30th, 2023. The Rocket jBASE solution is an object-oriented integrated database and application development environment designed for transactional and analytical database applications. It combines scalable, flexible, seamless interoperability with connectivity and low overhead for system management and administration. jBASE 5.9.0 brings with it file level encryption, C-code profiling, and much more including 30+ bug fixes. Increased security – 12 enhancements For improved data security, upgrade to 5.9.0 to encrypt at the file level. jBASE 5.9.0 also features new functionality to data-at-rest encryption including support for external key management. Plus, other enhancements: Encryption run-time additions Key management additions AESGCM encryption support Jsecurity command additions Implemented Rocket's robust 3rd party security scan suite, a standard for all future jBASE releases. Improv

Enrique, if you do a demo of your web system I would ask to be included.DaleSoftware contractor in middle Tennessee

Hi Guys Stupid question here but .... I have a "simple" piece of code to test the commit statement which has left me somewhat surprised by its functionality.I'm probably asking too much if at line 6 when the pgm (stops) I delete the file TEMP from another terminal and then allow the code to continue.I then get (unexpectantly)  I would have expected the commit line to execute and report the error???Am I asking too much? I'm running: ------------------------------Stefano GallottaManaging MemberSimply Red Open SystemsMilnerton ZA------------------------------

  Respecting a rule of this forum about not posting product promotions, I moved the content of this thread as a reply to Katlheen's question  https://community.rocketsoftware.com/discussion/can-anyone-help-me-visualize-a-web-page-using-accuterm ------------------------------Enrique Ignacio MurphySoftware EngineerAleator SRLArgentina------------------------------

In AE and AccuTerm, if I use a '!' to start a comment, the editor ignores that line, leaving where I put it as the author but it does align the '*' comments based on the options set. In the MVVS editor, the "indent.commentLine" option seems to be treating both '!' and '*' comments the same. If it's set to 'true' the comment gets indented the same as the previous line. If it's set to 'false', the comment line(s) are returned to the left margin. Is there a way with the current settings available to retain the capability of '! comments remaining in the position determined by the developer? Below are examples: indent.commentLine set to true, before Format with Rocket MV BASIC       EQUATE CUSTOMER.SUFFIX TO 5       * !******** ! This is the end !******** indent.commentLine set to 'true', after Format with Rocket MV BASIC        EQUATE CUSTOMER.SUFFIX TO 5       *       !********       ! This is the end       !******** indent.commentLine set to 'false', before Format with Rocket MV BASIC  

I am working on an RPM that will install unidata, so as I start down this journey, are there any gotchas other who have gone down a similar path that anyone would care to share?there will be 2 types of installations .....1. on a system WITHOUT unidata installed2. an upgrade of system with unidataI am going to use the parameter file to automate the installation in both cases and when doing #2 I will stop unidata  before preforming the upgrademy main question is about the license file (while developing I will be usings the PE version of unidata so no license issue) but in both cases how do I handle the license?1. do they have to enter  it manually?2. is there a way to "move" the license from version 8.x.x to 8.2.4?also on #2 is there an easy way to tell if unidata is installed and running, I suppose I could look for the unidata daemon to see if its running, but if the system is stopped since I do not know what version of unidata is installed is there something I can look for to see if un

@Jonathan Smith helped me out most recently in this thread... Rocket U2 | UniVerse & UniData Rocketsoftware remove preview Rocket U2 | UniVerse & UniData I've overcome most of the issues discussed earlier in the following two threads. The background there may help in addressing this question.Rocket U2 | UniVerse View this on Rocketsoftware > Is there a similar  parameter I can set to get around this in the UCI Configuration Editor?  I've tried "casting" the AVG_COST_PD column differently so that it would return, but to no avail.As usual, I can query this table fine in the U2ODBC Tester, but not in SQL Server Management Studio, PowerBI and other Microsoft Products.  Although Microsoft Query legacy connection can also return the full table to Excel, and I don't see any outlandish values in the AVG_COST_PD column there.The full error now is:The OLE DB provider "MSDASQL" for linked server "mylinkedservername" supplied invalid metadata for column "AV

I personally do not use ED but we still have a developer that likes to use it and was questioning if there's a config or jBASE environment variable that we can set that will allow him to locate variables regardless of upper/lower case?------------------------------Jim EdwardsIT ManagerPlimpton & Hills------------------------------

Greetings all! We are currently running 11.3.4 on AIX 7.2.  In order to mitigate the newly discovered security issue with unirpc, we have the option of upgrading to the appropriate builds of 11.3.5 or 12.2.1.  Since upgrading involves a great deal of application and integration regression testing, we are considering jumping to 12 instead of staying on 11 now, and then having to jump to 12 later.All of the listings for version 12 in the product matrix have alerts associated with them, listing an issue related to using unmasked kills on UV processes.For the user base - is anyone currently running 12.2.1.xxx on AIX?  If so, have you encountered any issues related to this alert?For the Rocketeers - with the new memory buffer design, is this alert a permanent fixture now, or is there anything in the works to remediate the issue in the near future?To everyone - while this alert is the main cause of concern for us at this time, has anyone discovered any other issues in terms of application co