We have Stored Procedure which connects to AS400 system and retrieve or insert/update data in the AS400 files using linked server.
Right now we have hardcoded the linked server name, AS400 catalog name, library name and file name in SP. We are using SQL server management studio for the development.
We got to know that rather than hardcoding we can use variable reference for the changing variables as per the target environment using
Visual Studio 2008 Database Professional GDR 2.
Can anyone assist on this? We need to know how to use Visual Studio 2008 Database Professional GDR 2 for adding variable references and using them in stored procedures.
Thanks