Changing the DATABASE OPEN in PDL

[Deskin, Bob]

I'm going to take you at your word and assume you have little PDL
experience. Forgive me if I've gone too far. You can't simply change an
existing value. What you need to do is change the PDL source file and
recompile the dictionary. If you want to test your statement, get into PDL,
create a new dictionary by entering CREATE DICT <name> NOT PRELOADED.
Substitute a dictionary name for <name>. Once the dictionary is created,
enter your statement. Assuming you don't get any errors, enter LOAD. That's
it. You probably want to save the statement so you don't have to re-enter
it. You can now go into QUIZ, QDESIGN, or QTP and reference a table in that
database. Actually you should check in QUIZ to ensure you can get access
using your parameters. If it works, go ahead and change the PDL source and
recompile. Hope this helps.

Bob Deskin              
Senior Product Advisor, Application Development Tools, Cognos Inc.
bob.deskin@cognos.com (613) 738-1338 ext 4205 FAX: (613) 228-3149
3755 Riverside Drive P.O. Box 9707 Stn. T, Ottawa ON K1G 4K9 CANADA


-----Original Message-----
From: Rich `Lego-Man' Jesse - 7633 [mailto:RJESSE@QTIWORLD.COM]
Sent: Thursday, March 18, 1999 6:01 PM
To: powerh-l@lists.swau.edu
Subject: Changing the DATABASE OPEN in PDL


Hi,

I need to change the OPEN portion of the DATABASE statement in our
dictionary
(7.33D3 on HP/UX 10.20).

I *know* there's got to be an easy answer for this, but for the life of me I
can't find it in the PDL manual.

I tried this simple DATABASE statement:

    DATABASE RDBMS TYPE ORACLE OPEN ORACLE@TNS:MYSID USERID "MYUSER"
PASSWORD
    "MYPASS" OWNER MYOWNER

...but was met with the dreaded:

    ^^^
    *E* Expected : APPLICATION ASC CANCEL CREATE DATABASE DESCRIPTION
ELEMENT
    EXIT FILE LOAD PERMIT QUIT REVISE SAVE SET SHOW SYSTEM TRANSACTION USAGE
    USE HELP <eol>

Huh?  I thought I specified one of those?  And I'm not sure why I only got a
"^^^" error indicator instead of a "^^^^^^^^" for the word "DATBASE".  As if
it
isn't painfully aware, I'm not a regular PDL user.  The dictionaries I've
been
using up until now have been setup for me.  :)

TIA,
Rich Jesse
Programmer/Analyst (/DBA/SysAdmin/etc.)
rjesse@qtiworld.com
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
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
powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
This list is closed, thus to post to the list, you must be a subscriber.