Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.

Messages - Per E. Johannessen

Pages: 1 2 [3] 4 5 ... 14
Storage / Re: eSata
« on: December 13, 2020, 05:28:07 pm »
Roberto,  I meant to ask for the brand/model of the disk cabinet/enclosure, sorry for being unclear.
I see now that you don't use any external enclosure at all so I'll try to get such a cable that you mentioned.

Storage / Re: eSata
« on: December 12, 2020, 08:57:46 pm »
Well, that's a surprise to me. I never thought that we would achieve USB 3 transfer speeds that the hardware manufacturers lists as max speeds but only 20% of what they should be able do is very disappointing.
Slow, or not, I will eventually need an external USB 3 drive and will also continue trying to find eSATA solution.

Storage / Re: eSata
« on: December 12, 2020, 03:54:46 pm »
Thanks to all for info.

Doug, I had hardware controlled RAID in mind when mentioning an enclosure for 2 disks.
Not really necessary, just that I'd like to try it.

Pete, I was actually looking at various Icy Box disk enclosures but couldn't find any wth eSATA.

Anyway, both of you mentioned USB 3 so I think I'll go for that.

Storage / Re: eSata
« on: December 11, 2020, 06:03:18 pm »
What external disk brand/model do you have?

Storage / eSata
« on: December 11, 2020, 04:43:12 pm »
I have a ThinkStation P520 with an eSATA port and I'm trying to find some "external SSD disk system" to connect to it.
All systems I find use either USB 3.0 or Thunderbolt. Preferably I'd like to have an external enclosure/cabinet that can hold one or two SSD's. Any ideas?

Programming / Re: ODBC VX-Rexx/DBExpert
« on: December 02, 2020, 12:00:44 am »
Hi Sean, sent you a pm......

Programming / Re: ODBC VX-Rexx/DBExpert
« on: November 25, 2020, 09:41:19 pm »
Hi Dave,

To get an idea of how unixODBC works I think it's best to install the old version:

Long ago I had it installed but had some problems with the odbc driver. Don't remember exactly what the problem was so I'll install it again when I've set up a "test system".

Programming / Re: ODBC VX-Rexx/DBExpert
« on: November 22, 2020, 02:43:20 pm »
For simple SQL statements the DBE drivers do work with VX-Rexx, using JOIN or AS in queries fail.

Did try UNIXODBC quite some time ago but had some trouble with that package also.
At that time I also tried SmartSuite's odbc driver (Intersolv?) and it keeps displaying a popup window
when used with other programs.

UNIXODBC looks promising so a more recent port would be nice.
Unfortunately I don't have the skills to do that.

Programming / Re: ODBC VX-Rexx/DBExpert
« on: November 16, 2020, 04:23:35 pm »
Found the SQL statement in a file named window1.vry and it is identical to the one produced by DBExpert.

Does anyone happen to have Watcom SQL?
Believe that one is doing well with VX-Rexx so I'd like to try it if it was available anywhere.

Programming / Re: ODBC VX-Rexx/DBExpert
« on: November 15, 2020, 12:19:26 am »
Yes, can do without 'INNER JOIN' in this case, but this was just an example to trigger the error.
Most queries in this project are quite simple, however I a need a few that involves up to four tables and several joins.

Have tried to find the actual syntax/code VX-Rexx creates by searching the various sections involved but no luck so far.

Programming / Re: ODBC VX-Rexx/DBExpert
« on: November 14, 2020, 05:55:55 pm »
Here is an example of an error I get when running the SQL statement with VX-Rexx.
(The same SQL statement produces the expected result and no errors with DBExpert.)

Programming / Re: ODBC VX-Rexx/DBExpert
« on: November 13, 2020, 06:38:12 pm »
I don't have ODBCADM.EXE in os2\apps\bin, however the one I use is \dbexpert\odbcadm.exe and it works ok.
Think the problem is with the odbc.dll so it would be nice to find out what SQL commands it supports, and/or find out what's blocking
VX-Rexx from using all the functions.

You mentioned that your odbcadm.exe does nothing. Doesn't it even bring up the dialog window where you can define databases etc.?

Programming / Re: ODBC VX-Rexx/DBExpert
« on: November 13, 2020, 03:47:04 pm »
Had a look at RexxSQL but it seems that it needs an ODBC driver for connecting to the dBase files and I only have the drivers and manager
that were supplied with DBExpert. Suspect that these drivers are somehow modified to fully work with DBE only.

Does anyone know where I can obtain fully working ODBC drivers ?

Programming / ODBC VX-Rexx/DBExpert
« on: November 12, 2020, 01:32:42 pm »
Does anyone have experience using the dBase IV/ODBC driver that is bundled with DBExpert under VX-Rexx?
Simple queries work fine from VX-Rexx, but when I try SQL commands like 'INNER JOIN' and 'AS' I get various errors.
Even if I create the SQL in DBExpert, where it runs perfectly, using exactly the same sql-query in VX-Rexx results in errors.

Programming / VX-Rexx container - get values
« on: October 08, 2020, 07:39:37 pm »

I have a VX-Rexx project with a container filled with values from a query named "QRY_AVR".
The container has 4 columns and 4 records:

|   1|2004|  10|35490|
|   1|2004|  12|  732|
|   1|2004|  50|-8150|
|   1|2004|  99|-7320|

The code below returns the sum of column "DDDD" (20752):

sum = 0

ok = VRMethod( "QRY_AVR", "MoveFirst" )
do while( ok = 1 )
    call VRMethod "QRY_AVR", "RowData", "data."
    str = ""
    sum = sum + data.4
    do i = 1 to data.0
    str = str data.i
        ok = VRMethod( "QRY_AVR", "MoveNext" ) 

However, sometimes I need to get a specific value from the container.
Let's say I need the value in "DDDD" which corresponds to to the value "12" in "CCCC",
anyone knows how to do that?

(I can get the needed values using several queries, but prefer some rexx-code to do the job.)

Pages: 1 2 [3] 4 5 ... 14