#1  
Old 20th January 2025, 08:39 PM
radvansky radvansky is offline
Member
 
Join Date: Jun 2012
Posts: 35
Default Run stored procedures under different alias

Hello,
I need some advice on the following problem.
I have a NexusDB server with many aliases. Each alias contains data of the same structure. One of the aliases is the main working one, the others are different years of stored data. In the main alias I have created stored procedures, functions, views. I would need some advice on how to call a stored procedure/function/view from the main alias, but with it being executed over the alias I specify. Currently, the same procedure/function/views are created in each alias, but to update them, this duplication is very undesirable.

Is there any way to resolve this?
Thank you for any advice.
Best regards
Martin
  #2  
Old 20th January 2025, 09:31 PM
radvansky radvansky is offline
Member
 
Join Date: Jun 2012
Posts: 35
Default RE: Run stored procedures under different alias

Hello

I just found that in the sql section of this newsgroup there is almost the same query with the answer NOT SUPPORTED.

However, I think it is beneficial to share stored procedures/functions/views
between different databases.
Thank you
Martin
  #3  
Old 21st January 2025, 05:08 AM
David Rose
 
Posts: n/a
Default Re: Run stored procedures under different alias

On 20/01/2025 10:31, radvansky wrote:
>
> However, I think it is beneficial to share stored
> procedures/functions/views
> between different databases.


Could you not write yourself a function in the main database that
replicates the procedures/functions/views to the other databases ?

David

  #4  
Old 21st January 2025, 10:38 AM
radvansky radvansky is offline
Member
 
Join Date: Jun 2012
Posts: 35
Default

Hi,
Yes, I can do it, but again, we have a lot of aliases. Each alias contains company accounting data for a single year. In the case of replication of sp/fnc/view, I still have a lot of redundant code. With some database upgrades, it will end in an uncluttered state.

Thanks for the answer
Martin


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Stored Procedures Tony Grant nexusdb.public.support 6 9th March 2020 04:08 PM
help for stored procedures Daniele nexusdb.public.support.sql 8 8th August 2006 07:49 PM
Help for stored procedures Daniele nexusdb.public.support 5 7th August 2006 04:44 AM
Re: Stored Procedures Martijn Tonies nexusdb.public.support.sql 1 16th September 2005 10:15 PM
Re: Stored Procedures Wolfgang nexusdb.public.support.sql 0 16th September 2005 06:39 PM


All times are GMT +11. The time now is 08:29 AM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.