Rocket MultiValue

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   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------------------------------

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.

Hi all We're getting an unexpected error code when users try to log in into Universe and the maximum number of users is reached. Instead of getting the usual 39134 error code we receive 1449750101. It's a weird number, so we did some further investigation Turned into hexadecimal we get 0x56696E55 All the numbers fall into a rather small range, within the letters in the ASCII table. So, turning it into ASCII characters we get "VinU". Accounting for endianess, this is "UniV". We are getting a messed up error code from a (we suspect) dangling pointer that it's pointing to a string area instead of a proper integer. This is under Windows servers, running 11.3.5 UniVerse. ------------------------------Héctor CortigueraQuiter Servicios Informaticos SL------------------------------

Hy to all i discovery this today onlyto use the "tail" inside d3 like its used in linux:first catalog the tail program, in your current accountCATALOG DM,BP, TAILthenuse the comando watchfor exemple:WATCH TAIL LOG.FILE 20386 (10this will refresh the page continuously listing the last 10 lines of the file i don't know why but i had to catalog the program TAIL ------------------------------Alberto LealSystem AnalystMillano Distribuidora de Auto Pecas LtdaVarzea Grande MT BR------------------------------

I am attempting to test a new routine that retrieves file specifications in BASIC (using a combination of the STATUS xx FROM fv statement and the FILEINFO() function). Naturally I have tested against variations of the hashed file types (types 2-18). It attempting to test dynamic files I have found that I cannot create a type-30 file that uses the SEQ.NUM algorithm. >.L RELLEVEL      RELLEVEL0001 X0002 11.3.50003 PICK0004 PICK.FORMAT0005 11.3.5>>CREATE.FILE TEST.DYNAMIC_4 3 DYNAMIC SEQ.NUMCreating file "TEST.DYNAMIC_4" as Type 30.Creating file "D_TEST.DYNAMIC_4" as Type 18, Modulo 3, Separation 1.Added "@ID", the default record for RetrieVe, to "D_TEST.DYNAMIC_4".>ANALYZE.FILE TEST.DYNAMIC_4File name ..................   TEST.DYNAMIC_4Pathname ...................   TEST.DYNAMIC_4File type ..................   DYNAMICFile style and revision ....   64BIT Revision 12NLS Character Set Mapping ..   NONEHashing Algorithm ..........   GENERALNo. of groups (modulus) ....   1 curren

Hi, Today, I share a basic code which build helpfull components used by vs code &  .rmv/documentation from subr of an account. .rmv/documentation/universe/sourcefile_custom.json to define {brief, detail, signature} info SignatureHelp, CustomizeDoc  .rmv/documentation/universe/sysid/subroutineId.md which contain documentation issued from comment at beginning of the subr (try to convert to markdown)  CustomizeDoc  .vscode/sourcefile.code-snippets to define {prefix, description, body} info of each subr. Snippets it's written on uv linux, you can adapt it.  * SYNTAX : IN.VSC.SUBR2SNIP SYSID xx FILES file[,file[,]] {BASEPATH '/dos/vscode/rmv_defn/documentation/universe'} [LIST savedlist[,savedlist[,]]] SYSID refer to SB+ system ; if you do not use it, set it to a word which identify your app  BASEPATH is the destination of result files it uses PYTHON to sort the json files (the plateform python, not u2Python) it uses zip to complete the distribution @Chao Han, please try it to bui

hello,I'll introduce a little enhancement suggestion into MVVS display.Like when I edit a json file, I'll read my current 'in code path' into the header of my file. here is the sample on a json : the 'in code path' show the complete 'xpath' like of my cursor position.  Applied to BASIC, I'll have : Directoryname > Filename > sectionName > indentLevel > indentLevel > ... where :sectionName := the nearest upper Label   in sample WIBASIC > WI.OPENAPI.B > PathItemObject: IndentLevel := the list of nested indent 'word' ... for, if, loop, if  with first next word ... in sample  WIBASIC > WI.OPENAPI.B > PathItemObject: > for ivar > if APP When we edit large basic code, a such 'in code path' can be really usefull. With kind regards------------------------------Manu Fernandes------------------------------

When a program locks up and I have to close Accuterm to get out of it,  the system leaves users logged on.  How can I free up those users without rebooting.------------------------------Hal MalletBusiness OwnerAdvanced Retail & Service SystemsChula Vista CA US------------------------------

Hello,  I am migrating our production application (Prelude) from a UNIX to Linux environment. Currently, I am working on moving the U2 ODBC database. UniData is installed and working on the system and presents correctly in Prelude, however the ODBC database is having some issues. When I attempt to connect using U2 ODBC drivers, I can only interact with 5 out of the 40 tables present. The account used to manage these tables/subtables/views has owner permissions on the db and is part of the same groups as it was on Unix. I am not sure where to continue my troubleshooting efforts here, but direction/suggestions are greatly appreciated.------------------------------Phaelen Stuart-BergIT Systems ManagerRocket Forum Shared Account------------------------------

Hallo Everyone, I have newly installed AccuTerm IO Web Application" (Accuterm for web) and I am the new one for this web application, I want some assistance with the application My question is how will I use GUI designer on AccuTerm IO I am attaching the screen shot of error message. ------------------------------AzarRocket Forum Shared Account------------------------------

We're pleased to announce the availability of UniObjects for Python (UOPY) v1.3.0 on October 12, 2023. UniObjects for Python offers many benefits including:•    Provides remote access to MV servers in Python, great for your developers who don't know BASIC•    Offers full stack development in Python: from web server (UOPY) to database backend (U2py)•    Ability to leverage the Python ecosystem including many 3rd party libraries•    Enables rapid application development•    Delivers an open and extensible UniObjects client•    Helps attract new development talent UOPY v 1.3.0 enhancements and bug fixes: Enhancements•    We've added a new uoserver_timeout attribute to uopy.Session, which allows the UO server to retrieve the timeout value from the unirpcservice file. This feature requires UniVerse 11.3.5, UniData 8.3.1 or later versions.•    The fileInfoEx method of the uopy.File object now provides more fileinfo details for the UniData server•    From within Python, you can now determine

If you are considering upgrading to Rocket® UniVerse 11.4.1 and use either Rocket SB/XA (all releases) or Rocket U2 Web DE 5.3.0 or below, you need to plan your upgrade to avoid disruption to your System Builder and Web DE applications. Rocket UniVerse 11.4.1 includes OpenSSL 3.0. With the upgrade of OpenSSL, we also disabled unsafe encryption algorithms including: Hashing Algorithms / Message Digests: MD2, MD4, MDC2, WHIRLPOOL, RIPEMD160 Symmetric Ciphers: Blowfish, CAST, DES (DES_ECB, DES_CBC, DES_OFB, DES_CFB, DES_CFB1, DES_CFB8 and DESX_CBC), IDEA, RC2, RC4, SEED Key Derivation Function (KDF): PBKDF1 Both SB/XA and U2 Web DE 5.3.0 (and earlier) rely on disabled encryption algorithms and won't work unless you reenable them. For SB/XA your options are: Enable legacy algorithms (instructions below) Postpone your UniVerse upgrade. We are working on a Hotfix for SB/XA 6.5.7 to upgrade the encryption algorithm used by SB/XA. We plan to release the hotfix before the end of 2023. For U

If you are considering upgrading to Rocket® UniVerse 11.4.1 and use either Rocket SB/XA (all releases) or Rocket U2 Web DE 5.3.0 or below, you need to plan your upgrade to avoid disruption to your System Builder and Web DE applications. Rocket UniVerse 11.4.1 includes OpenSSL 3.0. With the upgrade of OpenSSL, we also disabled unsafe encryption algorithms including:•    Hashing Algorithms / Message Digests: MD2, MD4, MDC2, WHIRLPOOL, RIPEMD160•    Symmetric Ciphers: Blowfish, CAST, DES (DES_ECB, DES_CBC, DES_OFB, DES_CFB, DES_CFB1, DES_CFB8 and DESX_CBC), IDEA, RC2, RC4, SEED•    Key Derivation Function (KDF): PBKDF1 Both SB/XA and U2 Web DE 5.3.0 (and earlier) rely on disabled encryption algorithms and won’t work unless you reenable them. For SB/XA your options are:•    Enable legacy algorithms (instructions below)•    Postpone your UniVerse upgrade. We are working on a Hotfix for SB/XA 6.5.7 to upgrade the encryption algorithm used by SB/XA. We plan to release the hotfix before the en

I sometimes see an error message when trying to re-license after an update (which I've been doing a lot recently to get customers up to 3003). "This web address is for US and Canadian customers of RBC.  Please click OK and click the indicated URL to continue." This is from https://rbc.rocketsoftware.com/authprod.asp.  I usually wait a day or two (but not ten!) and go through the process again and it usually seems to work.  I could be entering the details a different way the 2nd time?  The customers work with the VAR to get the license details, so I'm one step removed from requesting and managing the serial numbers, they just call me when they need help. Anyone else seen this, or have advice on what I'm doing wrong? ------------------------------Ian McGowanPrincipal ConsultantRocket Forum Shared Account------------------------------

I'm posting this to alert anyone who's got large multivalued attributes they may want to sum in AQL. A friend of mine logged a case recently where a correlative using the S() function would hang when the file has any items where the attribute in question has more than 32,768 values. Engineering confirmed that this is an AQL limitation because it's using a 16-bit signed variable to track the value count. This variable is used in many places in AQL, and it would be a huge task to rearchitect. In the course of debugging this, Engineering came up with a workaround by using CALL in the correlative. This not only removed the 32,768-value limit, but it is also MUCH faster. Example of the correlative that hangs (using multivalued attribute 9 in the example): 008 A;S(9) Example of the correlative that works (again using multivalued attribute 9 in the example): 008 call bp sumbal Might be a good idea to fully path the subroutine being called. Example of a subroutine in an account called "orders"

I saw some teasers for 8.2.5 a few months back - is there an online "what's coming soon" for Unidata anywhere?------------------------------Ian McGowanPrincipal ConsultantRocket Forum Shared Account------------------------------

Hello I am hoping someone can help with an AccutermIO query. We are following the instructions..... AccuTerm Release Information V8 and we are trying to create a profile. 2 Profiles already exist, thet were created prior to Rocket aquiring Zumasys. When we create a profile we are not getting a check box display for the Role (admin/dev).  We create the profile anyway, but when we launch Accuterm we get the error No profiles have been created. Please login to Portal and create one.  Can anyone please advise on what we are doing wrong. As an aside, the portal we are using is the Zumasys portal, https://zs-portal.rocketsoftware.com/accuterm, as this is where we were redirected.------------------------------Richard OldsSnr DeveloperCalidore Computer Systems LtdGATESHEAD GB------------------------------

I've been asked this before, but did not have an answer!  On Unidata -- in a dictionary -- to do a multivalue OCONV, the command is SUBR("-OCONVS",X,Y) The question I got asked:   "Why is there a "-" in front of that code?" And I was not sure!  Is that because it's a system function?  It's not actually documented as to WHY -- just that it IS. I just looked over the Using UnIData 8.2.4 doc to make sure it was not something documented. Anyone know for sure what the "-" infers or confers beyond my guess that is means 'this is a built in system command'?------------------------------David WolvertonIndependentSunset Programming IncWaltham MA US------------------------------

This is the second MVX: Performance release focused on improving replication as part of a MultiValue HA/DR strategy.  This release includes a new replication dashboard allowing users to quickly and easily perform replication monitoring tasks to assess, in real time, the health of replication activities. The replication dashboard includes details such as a statistical summary of multiple distributions and identifies the stalled LSN causing a subscription group to stop processing. A stalled LSN has been the number one replication-related support case our customers have submitted. This version of MVX: Performance provides resolution steps without users having to reinitialize servers. The dashboard also displays trend information such as pacing time behind and time to catch up.  In addition, v1.8 features three new replication events: ·        Replication disabled event: generated for one event per distribution if any groups are disabled. ·        Replication down event: generated if repl

MultiValue Experiences version 1.8.0.1347 has been released on October 19 2023 for the below platforms/versions:AIX POWER       7.1,  7.2,  7.3AlmaLinux       8CentOS       7,  8RedHat Enterprise Linux Intel       7,  8,  9Rocky Linux       8Windows       Windows 10,  Windows 11,  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.

Nevermind, figured it out. Apparently this forum is an excellent rubber duck. If some kind soul at Rocket would add SQL.WLONGVARCHAR and SQL.WVARCHAR to ODBC.H that would be very nice.