Solved

wisql - shift to different databases in a procedure

Posted on 2002-05-02
4
229 Views
Last Modified: 2008-02-01
Is there any alternate way to shift between different databases in a procedure. I know we can't use, use database in procedure. I want to pass data base name as parameter because my procedure in one database and I want to perform table information from other data base. These are systems tables which have same name through the databases.

thanks,

hmk.
0
Comment
Question by:hmk
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 5

Expert Comment

by:amitpagarwal
ID: 6986902
what version of sybase are you using .. if you are using 12 and above, u may use the concept of dynamic sql
0
 

Author Comment

by:hmk
ID: 6986964
11.9.2
0
 
LVL 5

Accepted Solution

by:
amitpagarwal earned 50 total points
ID: 6986969
in 11.9.2, dynamic sql is not possible

what you may do is to insert the stored proc in sybsystemprocs database and then execute it from any db u like on that same server.
0
 

Author Comment

by:hmk
ID: 6987023
11.9.2
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Facebook has became the #1 social media platform. People share many funny videos there, yet you don't know how to download them? Now you can download Videos from Facebook in just 3 simple steps.
This article was originally published on Monitis Blog, you can check it  here . If you have responsibility for software in production, I bet you’d like to know more about it. I don’t mean that you’d like an extra peek into the bowels of the sour…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

733 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question