sybase 代理表例子

最新推荐文章于 2017-08-15 13:22:17 发布

zhenzhenzhe

最新推荐文章于 2017-08-15 13:22:17 发布

阅读量545

点赞数

分类专栏： sybase

sybase 专栏收录该内容

1 篇文章

订阅专栏

本文探讨了从Sybase ASE向Sybase IQ迁移数据时遇到的问题，特别是关于如何简化不同服务器名称在插入位置脚本中的管理。作者询问是否可以在插入表名的位置调用一个函数来实现运行时只需提供服务器名和数据库名。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

I need to load tables from Sybase ASE to Sybase IQ via insert location. Everything is working fine except that it is getting hard to manage different names of server in the insert location script.

For eg:

i am using

insert table1
location 'ase_servername.database_name'
{select...}
go

if i need to change the source from 'ase_servername.database_name' to say
'ase_servername1.database_name1'..i am having to change every single file..

Is there a way to calla function in the
insert tablename
location 'function'
so that i just give the sername and database name only once at runtime.

Any comments/help appreciated.