Rocket MultiValue

Hi allThis time it's OpenDB.I have a spreadsheet, which I can read in D3 and swap the LF to @Am - we know this. It's a CSV file so I know that the columns are delineated by a semicolon (did this on purpose when I spreadsheet was created (SEP=;)Now, when I create an Oracle table with the column headings I always find myself offset by 1 because the item (that D3 writes) writes the KEY in the first attribute :(Now even if I add this (as a first column) in Oracle - I still seem to not be able to line up the rank (of the D3 attributes) and the columns.Has anyone experienced this?  Let me know if you require the example of the D3 Q pointer but I believe I have this correct. Also, if I write the record with a NUL key - I seem to get inconsistent results.@Robert Burke - any solutions that you may have?ThanksStefano

Hi All I''ve just started working with AccuTerm 8. x and as a developer, we sometimes need to break out of code that is processing to debug.Yes, I could place a conditional debug statement in the code but het guess what "Real men don't do that"  :)Anyway - pressing all key sequences (that I know) bears no fruit so I've stopped guessing and put this fwd to this group.I'm running Windows (10 and 11) and set my emulation to Viewpoint onto a Linux installed D3 10. xDoes anyone have the correct key sequence, please?Thanks Stefano

Our MSP company just started supporting a customer that is using version universe dbms 10.1.3.0 on a windows xp system access from other systems via a terminal program.   XP can print to its windows tcp printers.  Customers accounting APP is no longer able to print, I don't think print job is reaching printer. I started looking at manuals online and another article related to printing but I don't have an understanding how to verify the configuration or how the choice of printer would be made by them when they want to print out various documents versus printing checks. I included a screen shot of what I started exploring using the setptr cmd. Glenn

Hello Gang! I'm a newbie with this concept of UniBasic SQL BCI and would like to see if I can find additional resources/examples to help me get "over the proverbial edge". I have read all the the manuals that have material in this subject, but I'm still not comfortable in how to work with is.     My goal here is this...   I would like to use the UniBasic SQL BCI functions/subroutines to retrieve data from a third-party database.   An example of this is to verify a zip code or a geo-code.   I've been programming with UniBasic for many years, but this is the first time that I need to used the UniBasic SQL BCI functions. So, what I'm asking for, if someone could "point me in the right direction" for additional information or examples, that will be very meaningful to me.   Like I stated earlier in my post, I have read the material in the various Rocket documents, but still not quite comfortable in what I need to do. Any feedback will b

This link: SELECT Rocketsoftware remove preview SELECT SELECT retrieves data from the database. View this on Rocketsoftware > Provides some insight as to how to address SQL statement (in D3) I'm looking to do a sample extract - say 10 000 records as we do in "TCL" (select master sampling 10000)The equivalent syntax in SQL is (by example)[see Quora at https://stackoverflow.com/questions/733652/select-a-random-sample-of-results-from-a-query-result] SELECT * FROM emp SAMPLE(25)However executing this in D3 returns a syntax error. can anyone assist, please?RegardsStefano

Hi - and greetings to all the Python "real" men :)I have a problem JUST getting this to work :( I have a Windows machine with this rel of Python installed : It keeps on returning this: What am I doing incorrectly Stefano

Hi, I'm new to SB+ development so please excuse any ignorant questions. I'm trying to amend a screen to: Add a field that should be forced to 'N' unless 2 prior entered fields have particular values. If the prior fields meet the conditions the user should be able to optionally change the value to 'Y' If the prior fields don't meet the condition the user should not be able to change the value. What would be the cleanest/best practice way to achieve this? Regards, Jonathan

Does anyone know what this error is telling me? I see this error come up from time to time and I am not sure what the problem really is. This is Unidata 7.2.9 running on Centos 5.4.  Line 83 of MAIN.PROGRAM is an include, so I find it challenging to find out what it is actually doing when that error hits.  If I step through in the debugger, when it gets to the INCLUDE line it prompts me for the file name where the INCLUDE source resides. When I give it the file name it says that it is not a directory file when it actually is. It won't display the source then.

Hi all. I have the following ODBC driver installed : And I'm receiving the following message from OpenDB "[Rocket Software][ODBC D3 Driver]Logon failed. Check D3 connection parameters and available licenses. {28000}" Any Ideas on how to resolve this? (assuming that there are available licenses) - What is "required" for the D3 connection parameters? IOW - for example - Is a password necessary - and again here I understand that a password is recommended but for the case of clarity - is the password required?Furthermore - is there an ODBC v3.0+ available for D3? (yet) Thanks StefanoThanks

Hello! Unidata 8.2.3 on Windows 2019. Im using putty and cmd and when i attempt to do a LIST on anything it will output results with the prompt "press enter to continue" once i do that it removes the results it just gave me and outputs the next 10 results or so until the LIST is complete. Im hoping there is a setting that would make it so that it would NOT remove the results in the LIST so that i could scroll up and see all results. any ideas on this?

UniVerse 11.3.1 on AIX. In addition to changing mod to read-only, for example, I need a list of things that can be done to a type 18 file that will result in "Fwrite failed at DBwrite" when using the WRITE statement. 

Hello  UV 11.3 on Windows,  His anyone understand the WARNING: Old style truncated data level name "FORTRAE/MARLA.TRAE.104" detected.  on open file.  The VOC is a classic multi-data level defn, where the dalalevel filename is really  MARLA.TRAE.104.... Any idea ? Mamu

I have many account that I work with (UV 11.3.4). I am looking into using BDT and it works fine for a single account. All features work. However if I try to move to another account I get an error message stating: Could not change account to ### on server ###. The account path does not exist, or you do not have enough privileges to access the account path. I close BDT and re-open BDT and I can open the account just fine.  Am I doing something wrong here? We tried using Visual Code, however there were issues we could not overcome. Jon

Hi Everyone, Been a while since my last interaction here and have been up to my armpits in it all. Have a question about transaction processing/commits/boundaries etc and the compatibility with file triggers. Can the two co-exist? I have a feeling the answer will be no but thought i should ask. We're on UV11.3.4. Any info would be great thanks. Regards, Peter

Are there any "How To" manuals for AccumTerm  as I am in reality a new user, who did developed good screen 5 years ago but the customer did not what to change then. Now they are all for it but I can get the basic's out of the manuals and feel completely lost and out of the loop 

Hi All Perhaps a short one, but can someone please confirm that the super Q pointers ONLY work across D3 installations with THE SAME rev version? Assuming the hosts file has been setup correctly for this exercise . IOW, I should NOT expect to communicate (as via a LIST verb) to D3 machine A (where A is D3 version 10.x) and an older D3 version (say 7.x).I am able to do same 7.x to 7.x - that's OK BUT NOT 10.x to 7.xJust require confirmation. Or is there a solution which I don't know of?Thanks

We have created a Python object that sends SMS/text messages using Twilio, and it is working (mostly - see below) . Code: import os                                                            from twilio.rest import Client                                                                                                            def SendSMS(FromNumber,ToNumber,MessageText):                            account_sid = "*****************"                   a

Hello, My company uses a phantom process that runs using the PHANTOM BRIEF. It's a continuous program that compares the current epoch with the epoch +180 (seconds) to determine when the next iteration will kick off. After 8 or more months of running every 3 minutes, the phantom unexpectedly self-terminates. It's a business-critical process that needs to be running at all times. It stopped unexpectedly over the weekend and resulted in a lot of issues. I've been scouring the forums for a few hours to see if I can figure out some way to prevent it from happening, but I can't identify the root cause. The program has had read/write logging set up for several years. Any error opening files or writing to them is logged to a custom flat file on a network drive, but no logs have been written there the past 3 times the phantom terminated. No logs were written to PH--though I'm not sure if that needs manual setup. The errlog file only displays the current day's user errors, preventing me from see

In BDT you can click on the Windows toolbar option and the Editor option allows you to split the window into two panes either vertical or horizontal. It will work with a single file, but how can I open two different programs in either of the panes?

Trying to resize a file but getting error message that file is in use, try again later.

Hi all - any advice here, please? (or please explain my "potential" misunderstanding :) I am experiencing difficulties in understanding why when attempting to use the D3 SQL ISQL commands. I have this version : On executing: which I checked in the code and the code looks for an implementation > 8. Furthermore, from the documentation I see that there is a NT_ISQL verb; which I also attempted  This one just drops to TCL - the code looks for (field function) a '~' separator which I give: And then things get "pear-shaped" 

Working on a routine to take HTML input and convert HTML entities like < and &gt to their character equivalent.  However, HTML entities are case insensitive, so the input string might be <, <, &lT; or ≪.  Is there a clean way to search for < in the string without case sensitivity so the value can be replaced with "<"?

I have this phantom program that runs for a bit and then just stops functioning.  The program continues to run, but doesn't do what it's supposed to do and does not respond to any control inputs other than a Linux kill.  Seems to be caught in some kind of a dead loop.  There are no READU locks preventing the program from running, it just ... doesn't do anything after it's been running for a while. Is there any way to connect the Unidata debugger to the phantom to evaluate variables or step through the program?

I'm a very small shop, only 9 employees.  I recently brought my D3 server back in house after a stint in the cloud.  I'm running D3 on AlmaLinux.  The hardware is an HP Z2 workstation with an i5-12500 6 core processor, 16GB Ram and 2 SSD's.  I do most of my tech support myself, but sometimes farm some work out to a local IT support company, Top Notch.  They're recommending I switch to / embrace virtualization and recommending Windows Server with Hyper-V.  I'm not a big fan of Windows and no next to nothing about virtualization, but I've seen posts about the benefits.  I'm just wondering if the Windows Server is the best solution for me. Any thoughts? TIA, Bruce

I have installed BDT 4.5.0 on my Windows 10 laptop. I'm connecting to UV 11.3.4 on RHEL 8.8. I get errors trying to connect. So the question is: Do I have to give the unirpc process access to write to my VOC file? We just installed 11.3.4 on our server. What updates are needed? What sequential file failed to open (guessing it was a log file of some sort). If anyone can point me in the right direction, it would be appreciated.