Login Register Actian.com  

Actian Community Blogs

Vectorwise Blog entries related to Vectorwise

Checking the Existence of Database Assets

Posted 2015-11-19 at 09:04 AM by rhann
Updated 2015-11-19 at 11:59 AM by rhann (Forgot to show the \macro command)

The Ingres tm terminal monitor—better known as sql—has a macro facility that provides, among other things, conditional execution.

The following example checks to see if the myproc procedure exists and if it does (tuplecount—that is, row count—is greater than 0), it skips everything between the \branch and the next-step label (\mark):
SELECT distinct procedure_name
FROM iiprocedures
WHERE procedure_name = 'myproc'
AND procedure_owner = dbmsinfo('username');
rhann's Avatar
Ingres Community
Posted in Ingres, Vectorwise
Views 1764 Comments 0 rhann is offline Edit Tags

More on ER Diagrams for Ingres Databases

Posted 2013-12-15 at 06:31 AM by rhann
Updated 2014-03-26 at 01:47 PM by rhann (Fixed broken image link)

As I mentioned in my previous post, SchemaSpy doesn't work as well as I'd like. I spent a couple days trying to fix it up and to get it to cooperate better with Ingres but I ran into multiple problems.

It became clear that the quickest way to get correct ER diagrams at run time was going to be to roll my own.

Happily, if the foreign key constraints are declared, I can generate something pretty decent with not much effort (500 lines of heavily commented C):
rhann's Avatar
Ingres Community
Posted in Ingres, Vectorwise
Views 2307 Comments 4 rhann is offline Edit Tags

ER Diagrams

Posted 2013-12-04 at 07:01 AM by rhann
Updated 2014-03-26 at 02:08 PM by rhann

As I am sure you all know, I am very easy going and relaxed in all matters to do with databases. So it will probably be a shock when I tell you I loathe and detest ER diagrams.

I think they are misconceived and misleading. I think they are a throwback to the days of network databases. I think they are a kind of technological comfort blanket for those who don't quite "get" relational databases. I think they encourage people to think not just "inside the box"...
rhann's Avatar
Ingres Community
Posted in Ingres, Vectorwise
Views 7664 Comments 0 rhann is offline Edit Tags

How to create links to topics on docs.actian.com

Posted 2013-08-19 at 08:12 AM by howle01 (Lee Howard)

This article explains the proper way to create topic links that you can include in email, case comments, KB documents, readmes, and other forms of communication.

The new docs.actian.com site displays topics on the fly from the latest publication of XML files. The site uses filtering to narrow the display and searching of topics to selected versions and releases.

To create a link, you must first set your filtering options for the site, meaning you must choose a product...
Attached Images
File Type: jpg doc_link.jpg (23.6 KB, 859 views)
howle01's Avatar
Junior Member
Views 2199 Comments 3 howle01 is offline Edit Tags

Accessing Ingres Data from Windows PowerShell

Posted 2013-08-14 at 06:49 AM by rhann

I'll admit that I am old-time Unix bigot (and various other kinds of bigot before that), and I never took to Windows for hosting enterprise systems of any kind. One of my better arguments against Windows was its childish native scripting capability. However even that argument has been invalid since PowerShell was introduced about six years ago.

PowerShell is actually pretty nice to work with and even if its syntax is a little Rococo it's not much worse than say the Korn shell, and...
rhann's Avatar
Ingres Community
Views 2808 Comments 3 rhann is offline Edit Tags
© 2011 Actian Corporation. All Rights Reserved