Rocket MultiValue

I need to create a dictionary that takes the multivalue data from a field in FILE, field<1> Say: Field<1> is 123a1]456b2]789c9 I want a dictionary item, say called TEST2 to show only  (a1,b2,c9) Currently i have the Dictionary item TEST2 as I-type with MATCHFIELD(@RECORD<1>,"0N0X",2) in field 2  I want LIST FILE F1 TEST2 to show: FILE     F1………         TEST2……… 1          123a1               a12          456b2               b23          789c9               c9  But what I'm getting is:LIST FILE F1 TEST2 FILE     F1………         TEST2………1          123S1               S12          456S2               456S23          789L9               789L9 I've tried a number of options in the TEST2 dictionary item but no joy.  Can anyone help with this.  I had done something similar decades ago, but cannot remember how.  I want to avoid using a subroutine if I can.  Any advice would be greatly appreciated. Tek.------------------------------Tek IleriRocket Forum Shared Account-----------

I haven't used UV in a while. When I had to convert a D3 account to Universe, there were specific tools to do it.  I can't find them now under Windows and UV 12.2.  The documentation mentions tapein routines or using the import command under Xadmin. Everything is incomplete. Under D3 windows I created a tape pseudo device, set the block size to 512 and used the 'SAVE (TIC" command to create an individual account save that is backwardly compatible. UV documentation has no mention on how to create an entry in the &DEVICE& file to access a windows disk file. Sorting through the VOC verbs I found a command D3RESTORE which looked promising but is not in help system or other documentation. When I used the command  D3restore INFILE "D3ACCOUNT" I get an error "Error Occured at Input Byte: 13" Any help would be appreciated.------------------------------David WilliamsdeveloperComputer Repair & Sales IncWarminster PA US------------------------------

I've been setting up a new machine using Universe 11 and Centos 7 as the host OS and AccuTerm 7.3.2034.0. The Universe programs are all working but I've been having trouble with WED.  When I try to edit certain files it just locks up. The WED editor displays but with nothing open. If I click on it i get "A request to the MultiValue database server is pending....  Clicking on OK just re-displays the message.  The only way out is to click on the cancel button on the Server Mode status window. Once I click on that WED shows a message "The requested operation could not be completed: server not running".  I can click on that and WED goes away but the AccuTerm session is locked up. If I reset the terminal I can get back to TCL. I've tried everything I can think of to  fix it: I've checked all the terminal and stty settings.  I've tried installing older versions of AccuTerm I've tried to re-install the host programs, (That no longer works) I've tried moving the

This is a general question regarding using Test Driven Development in Universe Basic. Has anyone used this to develop their software and is there a testing framework that can be used? I have been asked to try it out and have only found information using object oriented programming languages. So far, I have created an ASSERT function and have started implementing test cases. Thanks in advance for any advice.------------------------------Maureen CollinsUniverse Database ProgrammerTeachers Mutual BankHomebush NSW AU------------------------------

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

I think we need a Labour Exchange where those looking for expertise can post their requirements and those with expertise can also post their experience and then they can contact each other.In my case, I am looking for people with expertise in D3/Linux, SB+ and MVS Toolkit, to work on systems that are now over 30 years old and are and have been continuously updated and new projects that are being rolled out on a regular basis.What do you all think?------------------------------Alex PolglazeThe Book-Keeping NetworkPerth Western Australia+61419 776 348apolglaze@book-keepingnetwork.com.auhttps://www.book-keepingnetwork.com.au/------------------------------

Hello,We would like to use MVS Toolkit with either a web page or a Flutter app. Specifically, I am looking for an example of user authentication. Did you write your own subroutine for tokens?We would like to create a simple shopping cart application. Any suggestions will be appreciated. Thank you,Chris ------------------------------Chris WolczSenior Software DeveloperRocket Forum Shared AccountClifton Park NY United States------------------------------

Hello everyone  ,Anyway where I can extract data directly from universe using python?I want to pull data directly from universe and display it using python. Need some guidance here. Thank you.------------------------------Roland KayverCore Banking SupportRocket Forum Shared Account------------------------------

Hi,I have Universe pgms that return a UniDynArray, but would like to convert the returns into a json format.I am not sure if this has been asked before but really looking for help on this last section of my code please?------------------------------Daniel ConradieRocket Forum Shared Account------------------------------

How can we quickly see if a file (or list of files) are 64bit or 32bitI can see from analyze.file that a file is 64bit. but that was not picked up by the ACCOUNT.FILE.STATS in the STAT.FILEIs there an hidden key in FILEINFO() that will get that information------------------------------neil richardsdbaRocket Forum Shared Accountlake Elsinore CA US------------------------------

Can Unidata do SFTP?  I have written socket language interfaces to SMTP and others.  Is it the same type of interface for SFTP?  I'm having a hard time finding the direct interface commands it needs.  I can connect and get info from the socket but it never asks for User name/Password.Most of the google results point to using WinSCP, but i'd rather do the commands myself.  Anyone been down this path?------------------------------David GreenComputer ProgrammerRocket Forum Shared Account------------------------------

Hey, I am migrating our codebase from Java to Python but when using the same parameters I am unable to get a connection to the Ellucian database.  Any help with troubleshooting this is appreciated!! My code is: import uopy ses = uopy.connect(hostname='databaseURL', user='databaseUser', password='databasePassword', account='databaseAccount') cmd = uopy.Command("LIST STUDENT.TERMS") cmd.run() print(cmd.response) and my error is: "/Users/adam/Documents/Developer Workspaces/python/.venv/bin/python" "/Users/adam/Documents/Developer Workspaces/python/Uniobjects for Python/helloworld.py" (.venv) adam@A010503 python % "/Users/adam/Documents/Developer Workspaces/python/.venv/bin/python" "/Users/adam/Documents/Developer Workspaces/python/Uniobjects for Python/helloworld.py" Traceback (most recent call last):   File "/Users/adam/Documents/Developer Workspaces/python/.venv/lib/python3.12/site-packages/uopy/_unirpc.py", line 152, in __init__     self._socket = socket.create_connection((host,

What uniquery syntax will roll up the third column into an unduped list for each unduped item in the second column, all while suppressing display of the first column. Note that the second column also contains values such as L2, L3, etc.------------------------------Shawn Waldieenterprise application developerRocket Forum Shared AccountLos Angeles CA US------------------------------

Hello,I have a huge problem with D3, hopefully somebody can help me.Description:I open D3: d3vme /debugEverything seems ok until:Unable to open "users" fileand after a while:*** Remote File System Error ***Open (fsi:dem,users,) Cannot Bind Remote Connectionct users'fsi:dm' is not a valid md namect md users  users001 Q002 fsi:dm003 users004005006007008009 I010 18I made my backup by copying the folder D3 in Windows.I hope somebody can give me a hint to solve the problem. If more information is required just ask.Thanks a lotAndy Engel Luxembourg------------------------------Andy EngelRocket Forum Shared Account------------------------------

in my phantom log  I saw the msg  cp: failed to close (specific file name), I looked at the file checked permissions and  everything looked good. In the program it processed all of the previous files with no errors. the last for file showed these errors. the programs are running on 15 different server and none of the other servers have this issue. comments? help? Thanks, Theo

We run d3 on an Windows Server 2008 Can someone describe how to move d3 to a new server (windows 2012)? eg;  Download installer to create the d3 environment Move live data from current server to new server. Explain how the license which allows the application to run is transferred to the new server. Thanks, Bret Stern ------------------------------Bret SternPresidentRocket Forum Shared Account------------------------------

Has anyone successfully been able to transfer binary files from server to client through SBClient (UniData)?It appeared to be possible to do a PD.LO using B and/or X options, and I tried also via UniBasic with OSREAD, but it does not work.  I opened a recent Rocket support case on this and the official answer was, despite some initial success from Rocket's side, ultimately it isn't supported (SBXA-18778).  Despite that news, I'm interested if anyone here has managed to get it working with (any version of) SBClient with some combination of luck and skill?  I have heard rumors it is possible if the file is uploaded through the client to the server in the first place, but that is not the case here.  The use case is, small Excel files are generated for reporting on the server.  The users would like to download these to their desktops.  I could arrange alternate delivery, but they prefer saving on their PC.  They are used to downloading .CSV files, which are text and transfer through SBClie

I think I am missing something basic with the spooler.  For a long time our company was using D3 and the way our software was setup, whenever something was to be printed, it would first generate a hold file and then the user could send the hold file to the printer at their leisure. When we switched to QM I just had things go immediately to the printer because for the life of me I couldn't figure out how to send a hold file to the printer after the fact.  I know this is something very basic but I just don't see it.  The solution must be in some mental blind spot of mine. Can someone help me with this?------------------------------Steve HenkelCIORocket Forum Shared Account------------------------------

There are numerous approaches to turning output pagination OFF from within BASIC code (and I'm not really sure which ones work and which are just hang-overs from other MVDB implementations). What I want to ensure is that output pagination is turned back ON from within BASIC. Does anyone know if a method for achieving this? Thanks ------------------------------Gregor ScottSoftware ArchitectPentana Solutions Pty LtdMount Waverley VIC AU------------------------------

I have been converting code from R83 to Prime Information, Advance Pick to Unidata, Sequoia Pick to Unidata, D3 to Universe, and even Unidata to Universe, I have seen some really awful code and very morbid. Of course, you are thinking some of the latest Basic commands that I use daily in Universe did not exist in R83 so those programmers did the best they could. While I do not disagree, I am looking at code from customers in 2023 that should have been updated sometime in the last 20 years or at least in the last 10 years. I have detailed below my comments with what I found and what I think it should be. I will ignore for the time being GOTO, GOSUB, and ON RESPONSE, for example. I would love to see what you have found as well because it just makes me LOL when I see it. * Using COUNT instead of DCOUNT MY.ARRAY = 5:@FM:7:@FM:8 MAX.FM = COUNT(MY.ARRAY,@FM)+ 1 * Should be MAX.FM = DCOUNT(MY.ARRAY,@FM) * Not knowing about WHILE in a LOOP statement EXECUTE 'SELECT VOC'

All,Running UniVerse 11.3.1 on Redhat.I have been using the data conversion OCONV(DATE(),"DYMD[4'',2'',2]" then the 4'' (2-single quotes) and 2'' (2-single quotes) provides the date in YYYYMMDD without dashed or slashes.  Works great.The BASIC Manual Page 533 shows MT [H] [P] [Z] [S] [c] [[f1, f2, f3]]. I've tried different variations of "MTS''[2,2,2]" (S'' is two single quotes). Is there a way to convert a time into HHMMSS without using a second function to strip away the ':'s.Jon

Are there any Windows GUI applications that can edit Universe DB files on Windows or AIX?------------------------------Phillip PotterV.P. R&DData Management Associates Inc DMACincinnati OH US------------------------------

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?

I have several customers who need real-time sales tax calculation. Has anyone integrated an online sales tax calculator with D3 and is willing to share the code?------------------------------Richard GinsburgPresidentGinsburg ConsultingManassas VA US------------------------------

Hi, We're working on an archive process and we set it up to run as a phantom. When run as a phantom, the process runs over twice as long as it does on a telnet session. Does anyone know a why to bump up the priority of a phantom job on a Windows server?  Thanks Curt------------------------------CURT VALENTINESOFTWARE ENGINEER IIIPaychex------------------------------