OS2 World.Com Forum

Subject  :  I'm looking for a fullscreen VIO database program. :-)
Author  :  rsteiner rsteiner@visi.com
Date  :  22 Nov, 2006 on 00:05
Something similar to Information Palace for DOS:

http://underworld.fortunecity.com/defender/855/

with a nice intuitive facility for laying out data entry/display screens and perform record searches and sorting.

Information Palace actually does what I want, mostly, but it's not a native program. I've also played with PCFile 7 (don't like the UI) and FoxPro 2.6 for DOS (nice program but has a learning curve I frankly don't have the time for right now).

Any ideas?

I seem to remember Alpha 4 having a native OS/2 version at one point. Is there any way to obtain a copy? Would it do what I want?


-Rich Steiner (rsteiner@visi.com)
The Theorem Theorem: If If, Then Then.

Subject  :  Re:I'm looking for a fullscreen VIO database program. :-)
Author  :  Tomas
Date  :  22 Nov, 2006 on 18:01
What about DBExpert?
Have a look here: http://www.sundialsystems.com/dbexpert/index.html
So long..

Thomas


Subject  :  Re:I'm looking for a fullscreen VIO database program. :-)
Author  :  Terry tgindy@yahoo.com
Date  :  22 Nov, 2006 on 19:41
If you have Lotus SmartSuite's Approach you could be overlooking a gem that can be used stand-alone, or; as a front-end to ODBC databases as well as pull in dBase IV and ASCII data.

June 2006 V.O.I.C.E. Newsletter recently finished a multi-part series about creating databases with Lotus Approach at http://www.os2voice.org/VNL/past_issues/VNL0606H/feature_5.html

At the bottom of the article are links to the prior article installments, and; zip file of the article series' databases. You could make needed adjustments to these templates.

If you eventually want to tie Lotus Approach into ODBC & SQL databases you could refer to Douglas Clark's superb (make that absolutely superb) 12-part "ODBC on OS/2" series from 2001-2002 in OS/2 eZine.


Subject  :  Re:I'm looking for a fullscreen VIO database program. :-)
Author  :  rsteiner rsteiner@visi.com
Date  :  22 Nov, 2006 on 20:21

Tomas (22 Nov, 2006 18:01):
What about DBExpert?
Hmmm. Even though DBExpert uses a GUI (not what I want), it does look like a very nice tool for building databases. That might be acceptable if I can use them in a fullscreen VIO session.

I may play with this one. Thanks for the pointer!
-Rich Steiner (rsteiner@visi.com)
The Theorem Theorem: If If, Then Then.

Subject  :  Re:I'm looking for a fullscreen VIO database program. :-)
Author  :  rsteiner rsteiner@visi.com
Date  :  22 Nov, 2006 on 20:24

Terry (22 Nov, 2006 19:41):
If you have Lotus SmartSuite's Approach you could be overlooking a gem that can be used stand-alone, or; as a front-end to ODBC databases as well as pull in dBase IV and ASCII data.
Yes, I have a Lotus SmartSuite license attached to my eCS 1.1 Application Pack, but I was more interested in WordPro and 123 when I last installed SS. I didn't think of Approach -- again, it's a GUI application (and I really do prefer text), but Approach is a program I should take a look at since I actually own a legit copy.

Thanks!

---
-Rich Steiner (rsteiner@visi.com)
The Theorem Theorem: If If, Then Then.

Subject  :  Re:I'm looking for a fullscreen VIO database program. :-)
Author  :  Dave
Date  :  23 Nov, 2006 on 15:16

rsteiner (22 Nov, 2006 00:05):

I seem to remember Alpha 4 having a native OS/2 version at one point. Is there any way to obtain a copy? Would it do what I want?

I've been a Alpha 4 user since their first product Electric Desk.

I'm actively using the OS/2 version and would be happy to answer questions, etc. .


Subject  :  Re:I'm looking for a fullscreen VIO database program. :-)
Author  :  magog
Date  :  25 Nov, 2006 on 02:35
You can also use Java to create VIO applications and with JDBC drivers you can also use several different databases (MySQL, PostgreSQL,...).
It's very easy to create a VIO program with Java.

---
Regards,
Juergen Ulbts (Germany)

*** Java Movie Database - http://www.jmdb.de/ ***
*** New version available (2006-11-17) ***
*** Website has been updated ***


Subject  :  Re:I'm looking for a fullscreen VIO database program. :-)
Author  :  rsteiner rsteiner@visi.com
Date  :  25 Nov, 2006 on 06:05

Dave (23 Nov, 2006 15:16):
I'm actively using the OS/2 version and would be happy to answer questions, etc. .

What's the interface like? Is it text-based or graphical? If it's text-based, would you be willing to take a few screen shots?

I don't know much about it, as you can see, but I remember some folks being quite high on the program several years ago so I've always been curious.

---
-Rich Steiner (rsteiner@visi.com)
OS/2 and Linux user in Mableton, GA USA
The Theorem Theorem: If If, Then Then.

Subject  :  Re:I'm looking for a fullscreen VIO database program. :-)
Author  :  Dave
Date  :  25 Nov, 2006 on 20:24

rsteiner (25 Nov, 2006 06:05):

Dave (23 Nov, 2006 15:16):
I'm actively using the OS/2 version and would be happy to answer questions, etc. .

What's the interface like? Is it text-based or graphical? If it's text-based, would you be willing to take a few screen shots?

I don't know much about it, as you can see, but I remember some folks being quite high on the program several years ago so I've always been curious.

Hi,
Happy to attach some screen shots. Before I explain them, Alhpa4V6 runs as an OS/2 app. It is entirely text based. Its is an easy package with which to design DB apps, create input forms, perform global updates, and setup logical DB's and relationships. Most if not all the app work is pushbutton. There are numerous commands and functions available.

I run all my stuff in an OS/2 window, but full screen support works too.

My samples are somewhat generic in appearance. I take the default background color and default color for menu items. In my samples the bright white text is the DB data, the dull colors are the form data.

I've used Alpha4V6 for years and before that the DOS versions which ran in a DOS window. I avoided the Windows versions of Alpha4/Alpha5 because they became 'graphic' oriented. Alpha is still in business at www.alphasoftware.com

Hope this helps. If not, ask anything.


Subject  :  Re:I'm looking for a fullscreen VIO database program. :-)
Author  :  Dave
Date  :  25 Nov, 2006 on 20:29
Whoops
Didn't realize the 1 file limit on attachments.

Here is a zip file containing the Alpha4 screen shots.


Subject  :  Re:I'm looking for a fullscreen VIO database program. :-)
Author  :  rsteiner rsteiner@visi.com
Date  :  27 Nov, 2006 on 19:02

Dave (25 Nov, 2006 20:24):
Hi,
Happy to attach some screen shots.

It looks like a program I'd be interested in. I suspect they don't sell it anymore, but I'll ask about it just the same. Thanks for the info!

---
-Rich Steiner (rsteiner@visi.com)
OS/2 and Linux user in Mableton, GA USA
The Theorem Theorem: If If, Then Then.

Subject  :  Re:I'm looking for a fullscreen VIO database program. :-)
Author  :  El Vato
Date  :  28 Nov, 2006 on 16:43

rsteiner (22 Nov, 2006 00:05):

with a nice intuitive facility for laying out data entry/display screens and perform record searches and sorting.
[...]
Any ideas?

[...]
[quote]magog (25 Nov, 2006 02:35):
You can also use Java to create VIO applications and with JDBC drivers you can also use several different databases (MySQL, PostgreSQL,...).
It's very easy to create a VIO program with Java.


Or you could also use the open source Java Apache Derby --an implementation of which is provided by IBM (as a no cost download) and known as CloudScape:
http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0408cline/index.html#download

Although the implementation examples files are provided for Linux (*.ksh files) and WinXX (*.bat files), you can adapt them to execute under OS/2. If you Kow REXX, you can make your own implementations. Notwithstanding, since I run the EMX and Linux utilities (like the public domain Korn Shell for OS/2), I made the following changes.

Assuming an CloudScape installation directory on drive J:, a CLASSPATH, PATH, etc environment variables could be set in an OS/2 *.CMD file for the network server side (that could be running in your same machine), say /os2/mycloudscapeNet.cmd, as:

SET JAVA_HOME=F:\Java141
SET DERBY_INSTALL=J:\IBM\Cloudscape_10.1
SET CLASSPATH=%DERBY_INSTALL%\lib\derby.jar;%DERBY_INSTALL%\lib\derbytools.jar;%DERBY_INSTALL%\lib\derbynet.jar;
PATH=%DERBY_INSTALL%\frameworks\NetworkServer\bin;%PATH%

Whereas for the client side, you might write your OS/2 CMD file, say \os2\mycloudscapenetClient.cmd, as:

SET DERBY_INSTALL=J:\IBM\Cloudscape_10.1
SET CLASSPATH=%DERBY_INSTALL%\lib\derbyclient.jar;%DERBY_INSTALL%\lib\derbytools.jar;
PATH=%DERBY_INSTALL%\frameworks\NetworkServer\bin;%PATH%

Needless to say the JAVA_HOME environment is assumed to point to a drive F: (were my Golden Code Development Java resides).

The next step would be to rem out all the statements relating to CLASSPATH in the *ksh files in the direcory:

j:/ibm/cloudscape_10.1/frameworks/NetworkServer/bin/

...hence the statements to be REM'd by inserting a # at the very beginning would be like:

# "$DERBY_INSTALL"/frameworks/NetworkServer/bin/setNetworkServerCP.ksh

and

# "$DERBY_INSTALL"/frameworks/NetworkServer/bin/setNetworkClientCP.ksh

in each file where those ending *CP.ksh lines appear.

Note that although the open source Apache Derby does not come with an DB2 JDBC universal driver, IBM makes it available from:
http://www-128.ibm.com/developerworks/db2/downloads/jcc/

for those people not desiring to download CloudScape and opting for Apache Derby instead.

After the changes made above, we are ready to work. From the OS/2 EMX environment and using the port of OS/2's public domain Korn Shell instead of the OS/2 shell, I execute:

start /i mycloudscapeNet.cmd

...and I follow it with the command to enter my ksh environment again:

ksh

http://www.chingonazo.com/CloudScapeNet.JPG

and ONLY AFTER the network server is executing, then can the Client CMD be executed:

start /i mycloudscapenetClient

...and as before I reenter my ksh environment with:

ksh

http://www.chingonazo.com/CloudScapeNetClient.JPG

(Note that if the network server side of CloudScape is not executing, you will not be able to start the client side)

And the client is ready to accept your SQL statements to create a persistent data storage and manage it, for example.

For more info about the Java RDBM, you may want to buy and study the manual Apache Derby --Off to the Races.

Good Luck !


Powered by UltraBoard 2000 <www.ub2k.com>