Rocket MultiValue

Suppose you have a file like TEMP that has NAME, ADDRESS, and PHONE where NAME and ADDRESS are both single values but PHONE is multi value. Like so: TEMP..................... NAME...... ADDRESS... PHONE..... 1                         NAME1      ADDRESS1   PHONE12                         NAME2      ADDRESS2   PHONE2-1                                                PHONE2-2                                                PHONE2-3 If you SELECT TEMP NAME ADDRESS then you will get a list where each record supplies two items to the list, namely the NAME as one item and ADDRESS as another item: 001 NAME1002 ADDRESS1003 NAME2004 ADDRESS2 However, if you SELECT TEMP NAME ADDRESS PHONE then you get at minimum 3 elements per item, but if PHONE happens to have mulitple values, no NAME or ADDRESS is supplied to go with each value. 001 NAME1002 ADDRESS1003 PHONE1004 NAME2005 ADDRESS2006 PHONE2-1007 PHONE2-2008 PHONE2-3 How can I get blanks inserted for NAME and ADDRESS when PHONE has multiple

Hello all,         I use ODBC from rocket to open tables universe into excel.   It work pretty well for field with Single Value  (S) but not at all for field with Multivalue (M)   Is it the normal behaviour ? I precise I can read the Multivalue (M) data into the universe shell.          Thank you for your help.------------------------------deleuze jeanRocket Forum Shared Account------------------------------

Hello all,  I made a python script to read multivalue data in universe account and write in a file as CSV for example.  So, for decoding I use cp850.  Until that everithing working. When it's time to write I receive this error: error cp1252: UnicodeEncodeError: 'charmap' codec can't encode character '\\u2591' in position 88: character maps to «undefined» So decode is good with cp850, ok with that ?  Problem is encoding ?  Maybe I can force encoding in utf-8 but I don't know how to do that ? Do you have an universe idea ? :-)  Thank you !  Jean------------------------------deleuze jeanRocket Forum Shared Account------------------------------

Hi allHas anyone else noticed that you need an extra CR when you issue the shutdown (y command in D3 - AFTER it has started the shutdown process?It gets "stuck" (bad word) at a point and unless you hit a CR only then does it do the remainder - shut down the printers and ends the shutdown process to return to Linux. OR should we rather be using the systemctl stop D3svc ?Regards Stefano

The keyboard editor allows you to program function keys with any or all of the standard modifier keys, CTRL, ALT, and SHIFT.  I want to write a program to program a function key but the documentation seems to imply that I can program a CTRL function key (shifted or unshifted) or an ALT function key (shifted or unshifted), but it doesn't seem to allow me to program a CTRL-ALT function key (shifted or unshifted).  I doubt that I would ever personally need a CTRL-ALT-SHIFT function key but I'm writing a little program to allow the user to program his own function key without going into settings.  I'm trying to figure out if I should allow any combination of CTRL, ALT, and SHIFT like it does in the keyboard editor or just allow CTRL (shifted or unshifted) and ALT (shifted and unshifted).------------------------------Steve HenkelDirector of ISRocket Forum Shared Account------------------------------

We are excited to announce the release of Rocket® Software D3® v10.4 for Windows! Rocket D3 is an 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. Key features in Rocket D3 v10.4 for Windows include: The alignment of the v10.4 Windows and Linux releases, facilitating seamless D3 development in the future Python v3.11 upgrade, leveraging Python updates and new features A total of six enhancements and 20 bug fixes Upgrade now to Rocket® D3 v10.4 on Windows and unlock a whole new level of performance, compatibility, and ease of use. Want to learn more?  D3 10.4 release notes and documentation are now available online. Our team is eager to assist you with any questions or support you may need during the upgrade process.  If you are currently on maintenance, you can order Rocket D3

Hi All Has anyone developed a useful "simple" method to administer source control that they are willing to share?I am using AccuTerm WED and am thinking of writing some macros to "check-in" and "check-out" (as per HitHub) with some logging of who/time date stamp audit.Has anyone done something similar?Thanks Stefano

In BASIC, strings can be delimited with single quotes, double quotes or back-slashes.  The plug-in doesn't recognize \\s as string delimiters. Also, multi-line strings aren't allowed, but if there's unmatched quotes, the string syntax highlighting will continue across multiple lines until a matching quote is found. This is especially noticeable when \\"\\ is used to insert a quote into a string.------------------------------Raymond DeGennaroUV/D3 DBAUnitedHealth Group IncBelvidere IL US------------------------------

Hello all, This is my initial post here. Hope you all are well! I'm searching for some insight. By trade I am more of an Admin, but in my current role I have some developer duties and have inherited some custom work that ranges from fairly simple to robust. Just searching for insight regarding UniQuery. I am actively working for some revisions for Colleague outbound feed; the Select & List criteria currently displays a single list of data. I’m interested in adding an additional column and maybe headers for both.   Currently, the users are only included in the list if they meet the Select criteria. The revisions would result in a full list of users regardless if the meeting the qualifying criteria, a flag being added would solidify yay or nay.  The vendor is requesting a Y or N flag included to be in the data, based on if they meet the selection criteria or not. If a flag doesn’t exist within the Colleague UI to be included in the data output, is it even possible

The setup string I run seems to work ok:                                                                                                                                     001 IT = "!d:latlat -install imap.mail.yahoo.com bobthomson2001@yahoo.com 3                                                           993"                                                    &nbsp

Hello, we are trying to determine how the MVVS tool selects universe accounts (See screenshot).  We have several UV accounts that do not show up in this list and we have been unable to determine the common denominator so far.  Any pointers in the right direction would be greatly appreciated! Thanks, Dave ------------------------------David ScottUtex IndustriesConroe TX US------------------------------

Hello all,  I made a python script to read multivalue data in universe account and write in a file as PDF for example.  When it's time to write I receive this error: 'charmap' codec can't encode character Do you have an universe idea ? :-)  Thank you !  Jean ------------------------------deleuze jeanRocket Forum Shared Account------------------------------

It would be nice if wIntegrate's compile or save mesages contained a date/time stamp. This would be especially helpful when working on a multi-day project. Any way to configure that?------------------------------Nelson SchrothpresidentC3CompleteShop LLCHarrison OH US------------------------------

Hi all OK, so the D3 documentation regarding 10.4 refers to "restore-account" with the "r" option to restore to the FSI.This is NOT what I wish - I require an account so wish to use the account-restore verbI did this by naming the account with the suffix FSI:Now I'm experiencing a problem when the indexes are being generated :(Does anyone else have this? How does one re-generate the indexes to a file - I can't find documentation to do this (index-regen or any combination of the action)ThanksStefano------------------------------Stefano GallottaManaging MemberSimply Red Open SystemsMilnerton ZA------------------------------

hello all,  I have an issue when I make a LOGTO  "ACCOUNT" into shell universe on windows. What is STX :  ifExis() This folder exist at the C location.  If I use XADMIN, I don't have this problem. Only into the shell universe.  i search a solution to enter in my account from the shell.  thanks for your help.  ------------------------------deleuze jeanRocket Forum Shared Account------------------------------

I see in the MVIS config that you can add some username/passwords to be used to force API calls to supply some authorization, namely the username/password configured in the MVIS console.  Wondering if it's possible to do some kind of authorization using the "native" Universe/PICK logins so that when an API is called and then runs a subroutine, that the subroutine being run would think it's being run in the security context of the user based on the supplied credentials.  Maybe something like Basic authorization with the username/password passed in the Authorization header.  Ideally, some kind of token could be generated and this token passed in as a bearer authorization scenario in the headers. Mainly wanting to be able to use the same username/password that a user would  use during a normal login outside of MVIS as part of the  API calls.  Any help/ideas appreciated!

hello, I want to raise errors in my py scripts then these error catch by into @PYEXCEPTIONTYPE , @PYEXCEPTIONMSG, @PYEXCEPTIONTRACEBACK  What can be the best method ?  a/ to re-raise a error from a try sequence : these sample can catch 3 types of error : path not found, json not correct, mykey not found ...  def myfunc(path): result = '' try: f_path = open(path) config = json.load(f_path) a = config["mykey"] except: raise how can I have it at BASIC level into @PYEXCEPTIONTYPE , @PYEXCEPTIONMSG, @PYEXCEPTIONTRACEBACK   in this case, @PYEXCEPTIONTYPE , @PYEXCEPTIONMSG, @PYEXCEPTIONTRACEBACK are null. b/ to raise a error from script : def myfnc(a) if a < 2: raise ValueError(f"integer above 1 expected, got {a}") in this case, @PYEXCEPTIONTYPE , @PYEXCEPTIONMSG, @PYEXCEPTIONTRACEBACK are null. Thanks manu

I'm a little confused as to how D3 10.4 requires the .ini entry to be configured for disk and memory allocation.Is the disk in MB or frames ( / 4096) or GB? Say I required an 80GB disk - what would I need to have as the disk size parameter in the .ini entry?Also the total memory - again is it in MB / GB?Say I wished a total of 6GB of main memory - what would the entry be on the .ini.The install manual is a bit confusing and not that clear (IMO).ThanksStefano

For jBASE users > 5.7, here's a sample class that can get additional information on a port (e.g. the port number and program that is locking another port).Usage:analyze = new object('$analyze')details = analyze->fetch(port_nbr) ;! you can also do analyze->fetch(pid, @true)if details->$hasproperty('blocking') then    crt port_nbr:\\ is blocked by port \\:details->blocking->port:\\ at \\:details->blocking->locationendanalyze.jabba ! $analyze class method $analyze::$analyze() ! ! $system is used to get stats on the port ! this->o.sys = new object('$system') ! ! Get the lock details for the port ! this->o.lock = new object('$lock') ! ! Open the proc dir needed for "call_stack" ! proc_dir = system(1027) open proc_dir to proc then this->proc = proc end else throw \\Cannot open \\:proc_dir end end method method $analyze::fetch() arg = new objec

Hi, As mentioned in previous thread, we're playing with 10.4 on Linux, and I'm new to the VME/FSI world! Is it possible to increase the size of the VME without a re-install? In the D3Vme.ini file there are these statements: <pre>[d3vme.disks.0]name                           = Disk0.d3size                           = 1024000offset                         = 0</pre> I tried adding a [d3vme.disks.1] to mimic the adding a disk to the old pick0 file, but the system wasn't fooled! Any ideas? Thanks Tom------------------------------Tom PowerOwnerPower Business SystemsBenoni ZA------------------------------

Both items are strings. They're not equal. It seems Universe is doing some kind of conversion on them that makes them equal. If I convert the strings to integers it knows they're not equal. If I concatenate a letter on to either string it knows they're not equal.  My client was using smaller numbers in a field but a new specification requires and 18 digit number. They don't want to to through all there programs that compare these numbers and modify them with a alpha character or int conversion. Does anyone know what's going on and how to best fix it?

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

I have RHEL 8.8. It has OpenSSL 1.1.1k. My UniVerse version is 11.3.4. It is OpenSSL 1.1.1b. What is the correct procedure to upgrade UniVerse's OpenSSL to 1.1.1k.  I'm trying to install a Python Module and it throws an error trying to download a new version of OpenSSL. Jon

Hi all, Apologies if I'm in completely the wrong place! We have an appplication running on D3 and have a linked sever in MSSQL using the ODBC connection. When retrieving a date column I am getting error : Error converting data type DBTYPE_DBDATE to date. select * from openquery (LINKEDSERVERNAME, 'SELECT DATE_COMPL FROM SOH SOH WHERE (SOH.DATE_COMPL={d ''2024-03-01''})') From Googling it seems I need to convert it to a string, but I am unsure of the conversion functions in D3. Any assistance would be much appreciated! Many thanks,Michael

I'm embarrassed to even ask this. I've seen the answer a couple of times in the documentation but can't ever seem to find it if I'm looking for it. How do you disable the automatic paging where the program prompts the user to hit the return key to continue. I know I can use the NO.PAGE option when running the program but I want to disable it in the program itself. Most of these programs were written for native Pick and were never designed to handing automatic paging. That's why I want to disable it in the program and not in the menu that run's the program.