Rocket MultiValue

Edit - can't reply for some reason. I am on UD 8 myself but they are on 7.3 with no upgrade coming anytime soon, so wholefile is out. File has gone all the way down to zero records several times and we're still at ~2M modulo. I have come to the conclusion that merging isn't a thing dynamic files do on this release, so am working this problem from another angle. These files don't have an optimal config, they've got a bunch of random stuff flowing through them. Unidata 7.3.7 Windows I need help understanding merging and dynamic files.   I have a file that I think should be merging, but it never does. Disk space is not a concern, I just need to get the modulo down to something reasonable. Normal state for this file is a low recordcount, but periodic updates push huge amounts of data to it temporarily. Converting it to static or changing it to a DIR-type file are both not options. (Yes, this situation isn't ideal. No, I don't have control over it.) From Jonathan Smith's excellent

Hi, thanks to all your help, my customer wishes to proceed and purchase some licenses for Accuterm 8 - great,  but I am not getting any response from Rocket at all ! Last time was an email from Stephen Fowler in June - my trial has now run out. Can anyone help please and point me in the correct direction   Kind regards Chris Baxter

Hi, I am using UODOTNET, Version=3.171.0.8100 in my Asp.net web api project to connect to Infolease. i would like to know do we required "Microsoft SQL Server, ODBC and OLE DB Driver" to function properly.------------------------------Gopinath GanesanDeveloperRocket Forum Shared Account------------------------------

Hi everyone, We are currently migrating from mvBase to d3/Windows. According to the online documentation Incremental Backups on d3/Windows are not available, is this still the case?  Are there any plans to implement incremental backups.  We use incrementals on mvBase as part of our daily back up strategy. Many thanks Richard------------------------------Richard OldsSnr DeveloperCalidore Computer Systems LtdGATESHEAD GB------------------------------

I am using UODOTNET, Version=3.171.0.8100 in my ASP.NET webapi project to connect InfoLease. I would like to know do we required "Microsoft SQL Server, ODBC and OLE DB Driver"  to connect to InfoLease using UODOTNET?

Hy i was reading D3 Ref today and i found this PICKBASIC-FLASHBASIC/percent_alarm_function.htm i want to know, i can use this to "refresh" my screen with updated data:For exemple:i have an invocice and want to refresh my screen with the update status of the payment          CALL BOX1T(9,44,35,12,CARACTER.S,"Link Pagamento")         URL$SHORT.LINK = OCONV(S241<S241$LINK.PAGAMENTO>,"TSGVAR256;X;;18")         URL$SHORT.SITUACAO = OCONV(S241<S241$LINK.PAGAMENTO>,"TSGVAR256;X;;13")         LINK.SITUACOES    = ""         LINK.SITUACOES<1> = " APRE"         LINK.SITUACOES<2> = " ABERTOPAGORECUSADOEXPIRADO"         LOCATE(URL$SHORT.SITUACAO,LINK.SITUACOES,1;POS$LINK) ELSE POS$LINK = 1         IF URL$SHORT.LINK EQ "" THEN URL$SHORT.LINK = "NAO GERADO"&nbs

I'm happy to share the news of the release of AccuTerm 8.1.1.0. The latest version of AccuTerm is available for download from Rocket Business Connect (RBC). Version 8.1.1 removes the requirement to have a live connection to Rocket software to authorize and activate AccuTerm. Instead, starting with 8.1.1 you will need to enter a license key to activate your product. After you activate AccuTerm you don't need to be able to connect to the internet or rely on Rocket's back-office systems to use or authorize your product. You can obtain your AccuTerm license keys through RBC. For more details on this and other AccuTerm information, you can read the AccuTerm FAQ. Please reach out to your account executive, Rocket support or Rocket product management if you have any questions. AccuTerm 8.1.1 PLC dates: 31 Oct 2023 GA 31 Oct 2026 EOM 31 Oct 2027 EOS 31 Oct 2028 EOLS ------------------------------Hernando BordaProduct Manager, MultiValue ToolsRocket Softwarehborda@rocketsoftware.com-----------

We currently do an automatic back up every night and we used to get an e-mail message of the screen as you would see if you instigated the backup manually. A partial copy is here as a sample; :file-save Is this an Incremental Save (y or <n>)? n Console Listing to printer (y or <n>)? n Send statistics Report to printer (y or <n>)? n Verify save with 't-verify (enlt' (y or <n>)? y Bypass inconsistent groups (y or <n>)? n Do you want to sleep (y or <n>)? n File Save Beginning at 23:59:01 10 Oct 2022 Block size: 500 1 2 etc.,etc. and then cleared the dirty bits and thenthis finished withe final 7 lines as follows;Disconnected from Virtual Machine 'pick0:LINUX' sending incremental file list backup.tape sent 198,933,675 bytes received 99,075 bytes 15,922,620.00 bytes/sec total size is 199,987,305 speedup is 1.00 Now all we get is the final 7 lines and we don't know why. It actually happened o

Hy i just saw in the d3 ref this:https://www3.rocketsoftware.com/rocketd3/support/documentation/d3nt/102/refman/TCL/index_select_command.htm#reference4710 so i tryedindex-select sgvar016 A6(MCNA):" ":2but i got the message[162] Error in icode conversion: 'A6(MCNA):"'; index not found. what is the correct way to use ?------------------------------Alberto LealSystem AnalystMillano Distribuidora de Auto Pecas LtdaVarzea Grande MT BR------------------------------

1. We were using the HP-UX !uuidgen command to create guids for an integration to Salesforce.com. We have installed an SDK on Windows server to give us the same capability, but we don't know how to execute Windows commands from Unidata (Unibasic). Here is the command we are trying to execute: C:\\Program Files (x86)\\Windows Kits\\10\\bin\\10.0.22621.0\\x86>uuidgen.exeThe command will generate a guid: 7c6c5a30-7d67-47d1-aa17-72f7b2652db3 2. On HP-UX, we had many processes scheduled to run in a crontab. On the Windows server, we know we can use Scheduled Tasks, but we don't know the syntax to set up these Unidata (Unibasic) scripts/processes. Thanks. Steve------------------------------Steve KunzmanRocket Forum Shared Account------------------------------

Dear Friends. I have searched the OPENQM manual for the '$ED' command which I have shown below: $ED Created automatically by the ED editor when first required, this file holds pre-stored edit command sequences. The $ED file will be created automatically first time that the .S command is used to save commandsin this file.Multi-line inserts cannot be repeated from a saved command sequence, will cause the .S commandto fail and, if edited into the pre-stored sequence manually, will be cause a warning message to bedisplayed when the command sequence is executed.Alternatively, a user can create a $ED pre-stored item by using the editor:ED $ED item.nameThe first field of the item must contain E as its first character. Subsequent fields each contain oneeditor instruction in the sequence that the user requires the operations to be performed. However, when I try the ED $ED P2  (P2 being the item.name), I get  'FILE NOT FOUND' Any help will be appreciated. I thank you Vish Maharaj----------------

When working between MVIS and the U2 Basic Subroutine, I frequently find the MVIS Admin page timing out. Is there a setting (cm.ini?) to set that timeout to a longer window? Nelson

I have a number of named and unnamed common variables used throughout my programs. I'm getting a common miss-match error on a program with no commons at all. How can I tell what common variables are causing the problem. Is there a way to display named and unnamed common variables active at a given time? I'm sure the code is running a subroutine that may be conflicting with another common, just no way of seeing it from the viewpoint of the program without commons. Jon------------------------------Jon KristoffersonPick ProgrammerSnap-on Credit LLCLibertyville IL US------------------------------

The Rocket MultiValue team is very excited to announce the release of UniVerse 12.2.1, U2 DB Tools 4.5.0 and U2 Common Clients 5.3.0 on October 18th, 2022.  UniVerse has always been efficient and inexpensive to operate delivering a quality data application server that powers thousands of business-critical operations across numerous industries. UniVerse 12 brings with it the ability to handle heavy workloads and reduce the risk of file corruption.  With the two-process architecture of UniVerse 12, customers will see accelerated transaction performance and improved data integrity.  UniVerse 12.2.1 is beta group and focus group tested and is now "ready for release" UniVerse 12.2.1 adds many new features to an already feature rich UniVerse 12 and is beta and focus group tested to ensure the quality and standards meet our customers' expectations.  Two key new features are the 3rd mode (system buffer on/off) for enhanced usability and UV BASIC Profiling for application performance analysis.

Hi, Is there anyone out there that currently runs their D3 filesystem on CEPH? If so, what has the experience been like? Vincent

I have a number of named and unnamed common variables used throughout my programs. I'm getting a common miss-match error on a program with no commons at all. How can I tell what common variables are causing the problem. Is there a way to display named and unnamed common variables active at a given time? I'm sure the code is running a subroutine that may be conflicting with another common, just no way of seeing it from the viewpoint of the program without commons. Jon------------------------------Jon KristoffersonPick ProgrammerSnap-on Credit LLCLibertyville IL US------------------------------

We are developing a C# ASP.NET application in .NET 6 using U2 EntityFramework Core implementation. My development license is 3 Users with 10 Devices. If I understand this correctly, I should be able to open 30 connections. I have a basic API loading an entity from the database. These are the values I'm setting on the connection. _u2ConnectionStringBuilder.Database = database; _u2ConnectionStringBuilder.UserID = userId; _u2ConnectionStringBuilder.Password = password; _u2ConnectionStringBuilder.Server = server; _u2ConnectionStringBuilder.PersistSecurityInfo = true; _u2ConnectionStringBuilder.Pooling = false; _u2ConnectionStringBuilder.ServerType = "UniVerse"; _u2ConnectionStringBuilder.RpcServiceType = "uvserver"; _u2ConnectionStringBuilder.AccessMode = "Uci"; _u2ConnectionStringBuilder.FirstNormalForm = false; _u2ConnectionStringBuilder.ExpandMultiValueRows = true; Then via Postman, I run performance tests with multiple users. With 3 users I never run

So you might have read my other posts regarding Dynamic (Type-30) files in UniVerse. Until recently I have not had much to do with dynamic files. Now that I am looking at them in detail I am looking for resources that will help me get a handle on how to size them correctly and build them to suite the intended data load. Are there any in-depth resources on Dynamic files available? Thanks Gregor Scott ------------------------------Gregor ScottSoftware ArchitectPentana Solutions Pty LtdMount Waverley VIC AU------------------------------

Hi, We operate D3/Linux 10.2 in a VM that has 16Gb of RAM assigned to it. As our database is currently only 6.1 Gb in total, is there anyway to pre or force load the entire database into RAM rather than just waiting on it to be loaded during the normal course of use?  Vincent

Hi   Thanks to all the support I have been getting, I now feel in control of creating Accuterm screens etc     Now I need to start allowing my client to start testing the work I have done but have come across  a stumbling block.   I have recorded a script to run to logon to their account in jBase but need to make this script auto start when they select the correct session under the file tab.   I know I am missing something simple like a tick boss but cant find it. Can anyone help please  Thank you all in anticipation Chris Baxter------------------------------Chris BAXTERMDCB SoftIPSWICH GB------------------------------

Has anyone come across this error message before?  Is the number of files that can be open listed somewhere?  The application uses an openfile routine to keep track of the most recently opened file and assigns the file variable of the open file instead of opening it again.  The array in it may be too large and need to be reduced. Program "!SET.PTR": pc = A96, Unable to create capture file.[EMFILE] Too many open files

Further to the fun I had trying to get the SEQ.NUM option to work on a dynamic file creation in a Pick account, I am now having extra fun with dynamic files. I'm kind of thinking the manuals on this subject are not at all helpful - there are lots of plain syntax explanations but none of the nuanced guidance needed to actually master this stuff. My current challenge is to create a Dynamic file with specific Dictionary specifications (the default of 'Type 3, Modulo 1, Separation 2' are not appropriate) and with non-default dynamic file settings. Given the issues with Pick-style CREATE.FILE and dynamic files I thought I would simply create the DICT file first, then create the data file. This is how that turned out: >CREATE.FILE DICT TESTFILE1 53,2,18Creating file "D_TESTFILE1" as Type 18, Modulo 53, Separation 2.Added "@ID", the default record for RetrieVe, to "D_TESTFILE1".>ICREATE.FILE DATA TESTFILE1 30 GENERAL GROUP.SIZE 6 MINIMUM.MODULUS 2456"TESTFILE1" already has a DATA defini

What do GA, EOM, EOS, and EOLS mean?

Is ANALYZE.FILE meant to give different averages for the same items in different spec'd Dynamic Files? I had an expectation that record size averages would not change regardless of the setup of the dynamic file. I was wrong, aparently. This is my initial test file >ANALYZE.FILE TEST_DYN STATS NO.PAGEFile name                               = TEST_DYNFile has 301 groups (each * represents 10 groups analyzed).******************************File name ..................   TEST_DYNPathname ...................   TEST_DYNFile type ..................   DYNAMICFile style and revision ....   64BIT Revision 12NLS Character Set Mapping ..   NONEHashing Algorithm ..........   GENERALNo. of groups (modulus) ....   301 current ( minimum 1, 0 empty,                                            300 overflowed, 300 badly )Number of records ..........   2455Large record size ..........   1619 bytesNumber of large records ....   1951Group size .................   2048 bytesLoad factors ...............   8

AccuTerm version 8.1.1.0 has been released on October 31 2023 for the below platforms/versions:Windows       Windows 10,  Windows 11,  2019,  2022This 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.