Rocket MultiValue

I originally posted this in August of 2022. I'm reposting because 1) it's getting closer to 2030, and 2) I've had a few support cases asking about this issue. Everyone out there know about D3's SET-DATE-WINDOW utility? It's something you can add to your cold start procedure to change the 2-digit year pivot point from 30 to something else. Example if you ICONV a date like 8/1/31, you'll get an internal date in the year 1931, not 2031 as you might expect. I have this in my USER-COLDSTART: SET-DATE-WINDOW 60 This tells my D3 system to assume that any two-digit years from 00 to 59 are 2000 to 2059, where 60 to 99 are 1960 to 1999. This is a LOT handier than handling it in your application. I'm posting this because there's a lot of useful stuff in D3 that I was unaware of until I became a Rocket employee and was actually forced to read the manual. Maybe some of you are in the same boat. https://docs.rocketsoftware.com/bundle/d3_rg_1034/page/d3/d3_all/source/reference_manual/introduction/D3_

Good afternoon,   I'm from Venezuela. I'm currently working with D3 version 7.50, which is over 20 years old due to the well-known economic crisis. My name is Rafael Rivas and I'm from Venezuela. I'm currently working with D3 version 7.50, which is over 20 years old due to the well-known economic situation in my country and the lack of resources to update it to the latest version.  I'm having ODBC compatibility issues when trying to connect Microsoft Access to my D3 database. Due to these issues, I'm unable to establish a proper connection.  If anyone could help me, I would greatly appreciate it. I specifically need the ODBC64 version to resolve this issue.  Thank you in advance for any help. Best regards, Rafael Rivas------------------------------Rafael RivasRafael RivasSelf RegisteredLa guaira VE------------------------------

Can anyone suggest a video showing how to use a simple HELLO WORLD program in Visual Basic that can be executed and run in Visual Studio Code? I installed the Java JDK as instructed by the Rocket extension but when I run the program it keeps asking me to install the extension (even though the Rocket extension shows as already installed). My simple test program has a suffix of '.vb' but the Rocket instructions said it must be '.b'. Does that mean the extension is only for BASIC and not for VISUAL BASIC programs?!? When I did change my simple program's extension from '.vb' to '.b', I received this message from VSC which I don't understand or know how to correct: Java 11 or Open JDK 11 runtime environment is irregular. Please check your Java environment and settings. Thanks in advance to all who reply.Dan reply to Christian Bristow: Thanks for your reply but apparently, the extension referred to in Stack Overflow is no longer available.

Hello, I am currently working on creating a CentOS Steam 10 installation (latest) with the latest version of UV available as of this post (14.1.1.xx) The installation runs but there are many errors that complain about EGREP not being supported so grep -E is automatically being substituted and after the installation gets to "Installing default Global Basic..." there are thousands of VOC LIB errors. Some things that I learned from the installation is that libnsl and libxcrypt-compat are required to even begin it. Perhaps there are other requirements that are not listed in the basic docs that are "assumed" to be installed on a from scratch OS installation that I need to install? Just want to cover my basis before reverting down one level (CentOS Stream 9) due to the installer just not working. Usually, it's a me problem :) Thank you in advance!

Hello - I'm running the debugger on a unidata program and need to set a variable to null. I remember there is a way to do this but do not remember how. I know you can always set a variable to a value through the \\ command...but to set to null. I'm remembering something like save or sv...can't quite remember.  Can anyone help here? Kathleen------------------------------kathleen hambrickProgrammerRocket Forum Shared Account------------------------------

Greetings, all!Environment - UV 11.3.5 on AIX 7.2 Whenever we stop and restart UV, the current logs in $uvhome get saved into the $uvhome/saved_logs folder.  It's not just a straight copy, though.  It appears that the current values get appended to the end of the respective files that were already in saved_logs, but it also appears that some of the information from the front ends of the existing saved_logs files gets removed.  Is there documentation somewhere that says how these files are managed?  Are each of the log files handled the same, or is each managed according to its own unique set of rules?  Are these rules configurable by us? Some of these files can get fairly large, so we're looking to be able to predict/manage what is going to happen, as well as ensure the sizing of the associated filesystem is correct.Thank you!------------------------------Brian Paige------------------------------

Hello, I've looked online, and from what I can tell: there's no information on either of the question. We've run into an issue where a call is issued, but the operation is terminated or cancelled, but there's no way to signal the same to UniVerse. The other problem we've is: we "believe" we're hitting the maximum connections allowed, which leads to delayed responses on the front end as the call "waits" for the connection to become available again. I wonder is there a way to check the connection availability ahead of time, instead of just sitting there. Thank you!

As Rocket's MV evangelist, I'm starting a discussion. What are you thinking or doing with AI around your MV app?------------------------------Mike RajkowskiMultiValue Product EvangelistRocket Internal - All Brands US------------------------------

Jeannette Shea September 17, 2024 Introducing a new e-learning module covering Rocket MVIS, the MultiValue Integration Server. MVIS, a tool for Rocket® UniVerse and Rocket® UniData® customers, that will help you extend business opportunities, expand your workforce with new developers, and get products to market faster. MVIS allows you to easily expose both your MV data and business logic as RESTful APIs. These new APIs allow you to extend existing apps and create new ones using emerging frameworks and languages, which will keep your MultiValue application relevant. Take a look at our customer’s success with MVIS in these case studies: Tailored Brands - Building a Modern Experience with Rocket® UniVerse SMC - Maximizing ERP Investment by Modernizing with MVIS During the e-learning module, you’ll create an API in your own personal Virtual Lab. You’ll learn how: To create endpoints for files and subroutines and how to call these endpoints. To install and configure MVIS. OpenTelemetry

Paul Chang June 6, 2018 Overview Microsoft SQL Server Integration Services (SSIS) is a platform for building high performance data integration solutions, including extraction, transformation, and load (ETL) packages for data warehousing. It can transfer UniData or UniVerse data to SQL Server very easily. If you use a uci connection to access a UniData or UniVerse server, you must normalize your account first with proper schema and permission settings. The U2 Toolkit client also provides a native connection option that does not require normalization. However, the result data set is very different from a uci connection. The users might need to make some adjustment for SQL Server tables. In this blog post, you will learn how to use Visual Studio (VS) 2017 SSIS Designer using .NET Framework 4.6 to create a simple Microsoft SQL Server Integration Services package. The sample package will export UniData file data into a SQL Server table using a native connection. Note You need to register y

Kathy Larson July 12, 2023 We’re pleased to announce the release of Rocket® AccuTerm® 8.1, an established terminal emulator for MultiValue applications. To improve its functionality and security, Rocket AccuTerm 8.1 now offers a seamless single sign-on experience, a true web version (i.e., with no hosted dependencies on Rocket Software) with features that match its desktop counterpart, and adherence to the industry's leading software security standards, including Synopsys Black Duck, Polaris, and VeraCode. These advancements mark a step forward for MultiValue terminal emulation, empowering users with enhanced productivity, accessibility, and ease of use. Single Sign-On With the release of 8.1, Rocket has recognized the importance of simplifying AccuTerm user access and security. The implementation of single sign-on (SSO) eliminates the need for multiple login credentials, providing a seamless experience between Windows desktops and MultiValue systems. With SSO, users can connect to Mu

We have a client requirement to add a QR code to the header of tally slip prints, which are printed directly from D3. Has anyone been able to achieve this?

Hello,I would like to open a thread regarding the possibility of using the MVSP utility for the "D3" database from node.js.I found a JavaScript code snippet online using a rocket-d3 package.Unfortunately, this package is no longer available!Have you heard of it and do you have this package handy? Below is the code snippet found online: The d3 package exists.The rocket-d3 package is no longer available. npm install d3npm install rocket-d3 const d3 = require('d3');const RocketD3 = require('rocket-d3'); const dbConnection = new RocketD3.Connection({host: 'your-db-host',port: 1234,user: 'your-username',password: 'your-password'}); dbConnection.connect((err) => {if (err) {console.error('Error connecting to database:', err);} else {console.log('Connection successful!'); / Query exampledbConnection.query('SELECT * FROM your_table', (err, results) => {if (err) {console.error('Error executing query:', err);} else {console.log('Query results:', results);} dbConnection.close();});}}); Than

We are running into interfaces with Shopify, who is moving to GraphQL as it's standard and Rest APIs  are considered legacy. I cannot find anything to indicate Rocket has any tools/basic subrotines to address this emerging standard? ------------------------------Nelson SchrothpresidentC3CompleteShop LLCHarrison OH US------------------------------

Is anyone able to connect to a remote server?I've added Rocket MV Basic 2.6.0 to VS Code. Have 'Open Folder'ed an empty folder, 'Initialize'd and 'Edit Server Config' setting... {     "datasource": "UNIDATA",     "servers": [         {             "address": "HOSTNAME",             "name": "HOSTNAME",             "username": "xxxx",             "password": "****",             "account": "demo",             "port": 31438         }     ] } [address, name, username and password all obfuscated] On my server 'demo' exists in ud_database. I try to 'Connect' and get an error 'Account demo undefined in UNIDATA'. I can see on the server that a session logs on (by locally cataloguing a UOLOGIN subroutine that logs the log on). I'm able to connect to the same server using the same settings from a U2.Data.Client .NET application. Is the source to this 'Rocket MV Basic' extension on Github so I can attempt to debug? Thanks Simon ------------------------------Simon LewingtonDeveloperCACI Limi

We are running into interfaces with Shopify, who is moving to GraphQL as it's standard and Rest APIs  are considered legacy. I cannot find anything to indicate Rocket has any tools/basic subrotines to address this emerging standard? ------------------------------Nelson SchrothpresidentC3CompleteShop LLCHarrison OH US------------------------------

We recently upgraded our application using U2.Data.Client from version 3.1.1.0 to 3.1.2.0, and we are encountering a different kind of issue with multithreading. Issue on Version 3.1.1.0 Previously, in version 3.1.1.0, our server would spike the CPU usage to 100% and remain at that level. Upon inspecting the thread stack traces, we observed that all threads were stuck on modifying an internal Dictionary inside the ThreadPoolManager: 000000cf40c7de30 00007ffc2322e241 System.Collections.Generic.Dictionary`2[[System.Int32, mscorlib],[System.__Canon, mscorlib]].Insert(Int32, System.__Canon, Boolean) 000000cf40c7dec0 00007ffbce88c056 U2.Data.Client.U2PoolManager+h.c(System.Object) 000000cf40c7df10 00007ffbce8725bb U2.Data.Client.U2PoolManager.a(U2.Data.Client.U2Connection, System.String ByRef, d ByRef, System.Object ByRef) Issue After Upgrading to Version 3.1.2.0 After upgrading to 3.1.2.0, the CPU no longer spikes to 100%, but all requests are now stuck waiting on: 0000000afd67e248 00007ff

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 as Excel, Microsoft Access, and Microsoft Power BI Desktop.I am running a freshly installed local instance of Microsoft SQL Server Developer (64-bit) 15.0.2000.5 on Windows 10 Pro locally.I created a Linked Server connection using the Microsoft OLE DB Provider for ODBC Drivers and it connects to the U2 database successfully, listing out all of the table names.  However, I cannot see any columns, nor can I query any data from the U2 tables.If I try scripting a select statement from a table, it says:[MYU2DATABASENAME]...[MYTABLENAME] contains no columns that can be selected or the current user does not have permissions on that object.Again, I can select all columns and data from these U2 Universe tables using the same credentials in other applications via ODBC.I need to be able to query data via a SQL Server Linked Server co

May 3, 2017 AUDIT LOGGING FOR ROCKET UNIVERSE 11.3.1 & UNIDATA8.2 WHY YOUR BUSINESS REQUIRES AUDIT LOGGING Hardly a day goes by without hearing headline news of IT security breaches. Since your business’s lifeline depends on computerized systems, IT system security has become increasingly vital to enterprises, big and small. Knowing what’s happened and what’s going on inside your enterprise information systems, as well as providing an audit trail to prove it, is not only required by internal operational procedures, but also, for some industries and businesses, is mandated by governmental or industry regulations and standards. In fact, in the US several regulations such as HIPAA, SOX, and industry standard PCI-DSS all have specific requirements for Audit Logging. In European and other countries there are similar standards and regulations. Audit Logging is an automated system that chronologically records who did what to which system resource and when. IT must spend the time up front

Jonathan Smith January 18, 2018 UNIDATA REPLICATION UniDataData Replication is increasingly important in today’s business environments. The enhancements we’ve added to UniData 8.2 are all driven to ensure UniData Data Replication works better and faster in your environment. We’ve enhanced several areas and we will cover a couple in today’s post and more in future posts: Field Level Replication – Only the changed fields in a record are sent to the subscriber – this post Intelligent Write Queue – Enhances the speed of repeated updating of the same record on the subscriber – this post Delayed Standby Replication – Allows a hot-standby system to be a specified time behind the publisher – future post Asynchronous Transactional Updates – Cross Group Transactions can now be handled in an asynchronous or synchronous mode – future post Replication Pacing (introduced in UniData 8.1.2) – Allows the graceful slowdown of UniData Replication to avoid Replication Disablement – future post FIELD LE

Paul Chang February 20, 2019 If you use the U2 ODBC and/or JDBC client with UniData v8.2.1, you need to ensure that all accounts use schema v6.0 files. If they do not, the applications will not work with your UniData account. This blog post shows you how to create new UniData accounts with schema v6.0 files, delete corrupt files and recreate v6.0 schema files, and create new schema v6.0 files or upgrade older versions of these files. Creating new UniData accounts with schema v6.0 files To create new accounts in UniData v8.2.1, use the newacct command or the XAdmin tool to automatically create new accounts. Newly created UniData accounts contain the necessary default system files and schema v6.0 files, as shown in the following example: Directory of C:U2ud82 est_newacct Directory of C:U2ud82 est_newacct [.] [..] [BP] [CTLG] D_BP D_CTLG D_DV_SQLColumns D_DV_SQLSpecialColumns D_D

Jonathan Smith October 16, 2019 What changed at UniData 8: Memory Allocation Prior to UniData 8.1.0, UniBasic variable space was allocated via shared memory from a system wide shared pool (some of these go back to the original design in the 1990s). Why? It was done to reduce total system wide memory consumption and to ensure that UniData had enough memory available for a user application to function. This memory allocation reserved the base memory requirement, as defined by the shared memory parameters, for use by UniData only. And, the shared memory segment was divided into smaller segments, allowing multiple processes to use the same memory area. Shared Memory Challenges prior to UniData 8 If a process overran its allocated shared memory buffer space and UniData did not detect this, the result was the process ran in another process’s working area, possibly causing corruption of the memory area with multiple processes aborting or producing abnormal results. There were constraints wit

Michael Rajkowski January 31, 2023 Starting at UniVerse 12.2.1 and UniData 8.2.4, you have additional control over how your Python environment is maintained during an upgrade. Previously, when you upgraded your Rocket U2 database, a new version of Python replaced the previous version requiring your System Admin/DBA to reinstall needed modules and/or to modify the .pth files (putting them back to the way they were before the upgrade). Now, during the upgrade you are presented with two questions: Do you want to preserve Python .pth files? Do you want to preserve Python module files? If you answer no, (or don’t select the check box on Windows upgrades), the U2 install process will replace the Python version, and you will need to create/modify your .pth files as necessary, and then pip install the modules you are using for the new version of Python. This is helpful when you have been working with Python for a while and would like to start with a clean slate. If you answer yes to both qu

July 12, 2022 I’m happy to introduce to you the Rocket MV BASIC for Visual Studio Code Extension Feature Review series! In this series, I will cover useful features related to editing, compiling, and debugging using the Rocket MV BASIC for Visual Studio Code Extension. I’ll start by covering the editing feature, specifically formatting. Background Reading legacy BASIC code can be challenging because different developers have different coding styles, and BASIC language grammar is so flexible. The formatting functionality can help you unify the BASIC program style and improve readability. Recommended Configuration The formatting functionality provides you with more than 20 configuration options to choose from. To make your BASIC programs more readable and concise, I recommend that you consider using the core format options shown below. Parameters Values Description “style.keywordCase” “uppercase” “lowercase” “titlecase” “keep” All keywords and statements should have the same

Kathy Larson August 21, 2019 MultiValue, Basic subroutines, Pick Systems, uuh, for a summer intern, all these terms were incredibly foreign. As a computer science student, I have some vague understanding (hopefully) of what a database, server, front/back end are supposed to do, but you could imagine my uneasy feelings when I was tasked with building a modern web app using trendy technologies and a legacy database service on the backend. Before I continue, let me introduce myself. My name is Andrew Gorovoy, and I am a 20-year-old student out of Columbia University in the greatest city in the world, New York (sorry Denver). This summer I was given the opportunity to intern as a product manager in the Denver office. Quickly into my internship, it was apparent that there’s a talent shortage in the MultiValue industry. Young engineers out of college are tooled with modern web frameworks, Python, and Java. Most like myself, have no idea how to write a line of Basic code or initialize an MV