Rocket® D3® and jBASE®

Hi AllI've been baffled by this, but I will regard the instance as possible serendipity!By chance (and a good measure of trust) I copied the original load of D3 of the Pick0 file into my home directory (in Linux)This Pick0 would only have 16 ports etcI then proceed to amend the number of ports to a greater number. The manual for 10.3 states to reload D3 - which I did :) I now discover that starting D3 from my home directory takes THAT entry (of Pick0) rather than the true entry in /usr/lib/pick!!!!I guess this "could be great" in a development environment when you wish to have a minimum number of pibs, but it is rather confusing when it doesn't take what you amended in as the /usr/lib/pick/pick0 entry.So, tip - launch D3 from /usr/lib/pickRocket - please be aware of this - unless otherwise.Also, can anyone give me a reason why Linux kills D3 processes? Especially when I do a backup/restore or even a re-index. Is it swap space? memory?Thanks Stefano

Hi all I have a particularly disturbing situation that's just come about.I have BASIC code (source) which I compile in which I purposely place a DEBUG statement.Whereas before the DEBUGGER would provide me with the source code lines - I now am presented with the response:no source and sometimes get : * remote file system error Remote file has been moved or deleted The D3 account is in the FSI portion and the code is simply: 1< >debug <2 >crt 'hello' Any ideas (please)? p.s. Yes I bounced the D3 machine and the Linux machine and redid and got the same results.

Hi all I know I posted this (somewhere) before but it got "lost"I'm experiencing "hanging" after I issue a shutdown command with the new 10.4x on Linux. Follow me through with this. The shutdown command executes the odbc-setup command with a 'close' option (line 412) The odbc-setup option expects a confirmation of this option (line 167) which it never receives (from the original shutdown command)This results in the process "hanging" until a CR is issued. Please confirm - because that's what I'm experiencing. Thanks Stefano

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

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

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

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

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

Hi all, Apologies if I am in completely the wrong place! We have an application running on D3 and have a linked server set up in our MSSQL server using the D3 ODBC. When selecting a date column I'm getting the below error. Google tells me I need to convert it to a string somehow, but I'm not sure of the functions in D3 to achieve this. Any help would be much appreciated! Error converting data type DBTYPE_DBDATE to date. select * from openquery (LINKEDSERVER, 'SELECT DATE_COMPL FROM SOH SOH WHERE (SOH.DATE_COMPL={d ''2024-03-01''})') Many thanks,Michael

There is a command in D3, RENAME-FILE, which changes the name, but does not appear to change the name in Processes where that particular file, or data from it is used. Is there a straightforward way to change all references to the file where it is accessed throughout the system? Thanks

Is there a way to call both FlashBASIC subroutines (compiled using the "(o" option) as well as standard subroutines from a single BASIC programme? I can of course mirror the non-Flash ones, but that's a bit untidy. I can't just Flash the non-Flash ones, as they are used all over the place by other BASIC programmes. I need to use the Flash option for a socket sender subroutine.

Hy i was reading D3 Ref today and i found this PICKBASIC-FLASHBASIC/percent_alarm_function.htm i want to know, i can use this to "refresh" my screen with updated data:For exemple:i have an invocice and want to refresh my screen with the update status of the payment          CALL BOX1T(9,44,35,12,CARACTER.S,"Link Pagamento")         URL$SHORT.LINK = OCONV(S241<S241$LINK.PAGAMENTO>,"TSGVAR256;X;;18")         URL$SHORT.SITUACAO = OCONV(S241<S241$LINK.PAGAMENTO>,"TSGVAR256;X;;13")         LINK.SITUACOES    = ""         LINK.SITUACOES<1> = " APRE"         LINK.SITUACOES<2> = " ABERTOPAGORECUSADOEXPIRADO"         LOCATE(URL$SHORT.SITUACAO,LINK.SITUACOES,1;POS$LINK) ELSE POS$LINK = 1         IF URL$SHORT.LINK EQ "" THEN URL$SHORT.LINK = "NAO GERADO"&nbs

We currently do an automatic back up every night and we used to get an e-mail message of the screen as you would see if you instigated the backup manually. A partial copy is here as a sample; :file-save Is this an Incremental Save (y or <n>)? n Console Listing to printer (y or <n>)? n Send statistics Report to printer (y or <n>)? n Verify save with 't-verify (enlt' (y or <n>)? y Bypass inconsistent groups (y or <n>)? n Do you want to sleep (y or <n>)? n File Save Beginning at 23:59:01 10 Oct 2022 Block size: 500 1 2 etc.,etc. and then cleared the dirty bits and thenthis finished withe final 7 lines as follows;Disconnected from Virtual Machine 'pick0:LINUX' sending incremental file list backup.tape sent 198,933,675 bytes received 99,075 bytes 15,922,620.00 bytes/sec total size is 199,987,305 speedup is 1.00 Now all we get is the final 7 lines and we don't know why. It actually happened o

Hi, Is there anyone out there that currently runs their D3 filesystem on CEPH? If so, what has the experience been like? Vincent

Hi, We operate D3/Linux 10.2 in a VM that has 16Gb of RAM assigned to it. As our database is currently only 6.1 Gb in total, is there anyway to pre or force load the entire database into RAM rather than just waiting on it to be loaded during the normal course of use?  Vincent

In the world where OpenDB can write D3 data to (say) an Oracle Table, have any of you had the experience to (for whatever reason) write from Oracle to D3? In other words – (say using the ODBC) - I can use SQL statements to INSERT/UPDATE and DELETE a row; this "instruction" is driven from the Oracle side in order to facilitate a D3 file (record) to be modified (WRITTEN TO / UPDATED / DELETED). How do you deal with the aspect of Multivalued fields – the D3 SQL documentation is a little flaky IMO and there are no real examples of what I wish to achieve and that is to INSERT/UPDATE a value within a MULTIVALUE (defined) attribute. The “safe” alternative is to write to a “normalised” D3 table and then have a function in D3 to sort things out! I'd like to know how you may have solved this in a more elegant manner. Regards Stefano

Can anyone explain when the ODBC driver returns a DUP_COUNTERS result?Google very "unhelpful" here :(

Hi all:Let's start with "known"<1> *a9999 provides the size of an item<2> Similarly the u7000 user exit returns the size of an item. <3> LEN(My_Variable) returns the length of  My_VariableI need to prevent overflow so I need to defensively check for a certain "overflow" value (to be determined). ByteSize = function{variable}If ByteSize > {a predetermined value} then {defensive code}Else {variable := {continue to build variable } I searched for some function to do this but alas.Does anyone out there have an elegant solution?ThanksStefano

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

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

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

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"