Changing the DATABASE OPEN in PDL

[Rich `Lego-Man' Jesse - 7633]

Bob Deskin kindly replied to my post:

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

A-ha!  It needs to be recreated to make the change!  That would be the main
item that I wasn't able to glean from the books.

I did a GENERATE from QSHOW (see, I really did RTFM), edited the resulting
source file, and USEd it back in PDL as you outlined above.  Worked great,
although next time I'll hopefully remember to NOLIST the 2MB source...  ;)

Thanks also to those that pointed out the "ORACLE@user@tns/password" syntax.  I
used environment variables here so that I won't need to recompile the
dictionary again should the DATABASE OPEN need to change.

THANKS!!!  :)

Rich Jesse                              Programmer/Analyst
rjesse@qtiworld.com                     Quad/Tech International, Sussex, WI USA
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
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.