Changing the DATABASE OPEN in PDL

[Jones Allen (Van)]

Try:

  DATABASE RDBMS TYPE ORACLE OPEN ORACLE@MYUSER@TNSNAME/MYPASS OWNER MYOWNER

Also have a look at the lines preceeding the DATABASE statement to make sure
you haven't left an ampersand or something there.

-----Original Message-----
From: Rich `Lego-Man' Jesse - 7633 [mailto:RJESSE@QTIWORLD.COM]
Sent: March 18, 1999 3: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.