CONNX ODBC example

[Whittall, Conrad]

Hi Blue,

You don't actually need (and, in fact, can't use) FILE statements in PDL to
describe anything that is being accessed via an ODBC driver. The ODBC driver
obviously makes whatever is being accessed look like a relational database,
and so this is how PDL expects you to declare it...as a DATABASE rather than
as a FILE.

To access any ODBC data source your PDL DATABASE statement should look
something like this:

     DATABASE rms_database TYPE ODBC OPEN "rms_files"

Where the OPEN string, "rms_files" in this example, is an ODBC DSN (Data
Source Name) that you have defined through the ODBC Administrator.

Once you have compiled the dictionary containing this DATABASE statement you
can access your RMS files in PowerHouse by qualifying the FILE or ACCESS
statements with the "IN database" clause. For example, in QDESIGN you might
have:

     FILE employees IN rms_database  PRIMARY

If you prefer not to have to use the "IN database" qualifier, you can add
the SUBDICT=SEARCH command line option to whatever component you start, for
example:

     QDESIGN SUBDICT=SEARCH

This causes PowerHouse to automatically search all the "relational"
databases in the dictionary for the "FILE" you have named. In case you have
multiple databases in your data dictionary the search order will be the
order in which the DATABASE statements appear in the source PDL.

Don't forget that since PowerHouse now sees these RMS files as a relational
table you can also use the CURSOR statement in place of the FILE statement
in order to use SQL substitution, as well as using declared cursors and
embedded SQL to manipulate the data in your RMS files...off-loading a lot of
the work to the server end of the ODBC software, rather than pulling the
data to the PC, having PowerHouse process it, and then sending it back to
the server.

Sorry, but I have no any information on the HiT/400 ODBC driver.

Hope this helps.

Best regards,
Conrad

Conrad Whittall
Marketing Manager, Application Development Tools, Cognos Incorporated
3755 Riverside Drive, Ottawa, Ontario, K1G 4K9, Canada

Developer productivity never goes out of style!

For details of the Cognos PowerHouse family of high-productivity
development tools for Web, Windows and terminal-based business
applications just look here, http://www.cognos.com/powerhouse.


-----Original Message-----
From: Edis, Bob [mailto:bob.edis@fleetpride.com]
Sent: Wednesday 3 January 2001 12:58
To: 'powerh-l@list.swau.edu'
Subject: CONNX ODBC example


G'day all

Can someone show me an example of a file statement using the CONNX ODBC
driver in a PDL file please?  I have several RMS source systems that have
CONNX CDD files set up for them and appropriate ODBC connections as well.
The source systems are on OpenVMS machines of course but I am running
PowerHouse on a Windows NT 4.0 machine.

Also, has anyone used the HiT/400 ODBC driver with PowerHouse to connect to
a DB/400 system?

Regards,

Blue
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
This list is closed, thus to post to the list, you must be a subscriber.
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
This list is closed, thus to post to the list, you must be a subscriber.