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.
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.