[Info-vax] SQLite port for OpenVMS (Re: Is there currently a functioning link for hobbyist licenses?)

[seasoned_geek]

On Friday, March 13, 2015 at 6:16:54 PM UTC-5, Jan-Erik Soderholm wrote:
> David Froble skrev den 2015-03-13 19:32:
> > Bill Gunshannon wrote:
> >
> >
> > The ony database I have used is MicroSoft's SQL-2000.  With that, I built
> > stored procedures, that were stored in the database.  I then invoked the
> > procedures from Visual Basic, passing parameters as required, and depending
> > on the operation, got back record sets, or the procedure made changes int
> > he database.
> >
> 
> Yep, stored procedures (and functions) are suported by most DBs today.
> 
> 
> > Now, I have the impression that other database products don't work in the
> > same manner.
> 
> In what "manner"? All databases let you manage your database and data!
> 
> >
> > I'd like to learn about other database products.  While I may complain
> > about C code examples as "documentation", I confess that I think the
> > easiest way I could start with another database product would be to see
> > some examples.  Go figure ....
> 

I believe "same manner" means the fact there is no standard SQL. Oh yes, there is a standard which is published, but it might as well be printed on Charmin.

Take something simply like "displaying all tables in the database". On RDB and a few other database engines it is SHOW TABLES.  On Oracle you have to SELECT some_column FROM USER_something_or_other; then SELECT some_column FROM SYSTEM_something_or_other; Under SQLite3 and a few other command shells it is .tables but under PostGreSQL it is \d

Now take something as basic as data integrity. Under SQLite you can declare a field INTEGER and stuff the text of "Mary Had a Little Lamb" in the column. It doesn't care. Some engines will issue a warning if you try to stuff a float, double, or other non-integer type into an INTEGER column, others will simply truncate without telling you.

Now let's take something as simple as character data. Some people will do that trendy thing of declaring character columns VarChar. When you have RDB using SQLMOD for a COBOL program where the value is expected to be PIC X(15) a 3 character value gets space padded for you. Some other databases using EXEC statements will leave a NULL in the 4th byte because they think everyone will always use C.

SHAMELESS PLUG ALERT:

If the unfortunate soul that has been forced to use legacy Microsoft products wants to learn how to use modern and robust OpenVMS they should seriously look into a copy of this:

http://theminimumyouneedtoknow.com/app_book.html

It is laid out so if you know one of the languages you can learn how to use it on OpenVMS with RDB, MySQL, and RMS files, then quickly come up to speed on the other languages because the same application keeps getting implemented over and over.