RE: USE Statement
From: James Moosmann (james.moosmann_at_bankofamerica.com)
Date: 12/23/04
- Next message: Hardy Merrill: "Re: USE Statement"
- Previous message: Ron Wingfield: "USE Statement"
- Maybe in reply to: Ron Wingfield: "USE Statement"
- Next in thread: Hardy Merrill: "Re: USE Statement"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Thu, 23 Dec 2004 12:41:11 -0500 To: "'Ron Wingfield'" <rtwingfield@archaxis.net>, dbi-users@perl.org
That is not recommended.
You should instead use the fully qualified path.
ie.
Instead of:
use customerDb
select A.name, B.order
from info A, orders B
where A.id = B.customerId
...
do this:
select A.name, B.order
from customerDb..info A,
customerDb..info B
where A.id = B.customerId
...
*** That being said.
If you pull out the use statement and execute it before you do the rest of
the query.
It will work also.. I do this by using a 'go' in the raw sql and then
splitting the
sql strings into an array and executing them in order.
-----Original Message-----
From: Ron Wingfield [mailto:rtwingfield@archaxis.net]
Sent: Thursday, December 23, 2004 12:40 PM
To: dbi-users@perl.org
Subject: USE Statement
I would like to the specify the USE argument dynamically as for example:
USE $database;
Apparently, the scalar is not recognized (compile error). Is it possible to
provide a dynamic insertion such that a user could specify via a run-time
parameter, which database the program is to use?
BTW, I'm a new forum user. Can someone please respond is this message
appears on the forum?
Thanks,
Ron W.
- Next message: Hardy Merrill: "Re: USE Statement"
- Previous message: Ron Wingfield: "USE Statement"
- Maybe in reply to: Ron Wingfield: "USE Statement"
- Next in thread: Hardy Merrill: "Re: USE Statement"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
