TechQA.

No authorized routine named "GETVARIABLE" of type "FUNCTION" having compatible arguments was found

1.4k views Asked by At

I migrated a schema of DB2 v9.1.700.855 to SQL Server 2012 using the tool "SSMA (Microsoft SQL server migration Assistant) for DB2", I can establish a connection, but it shows an error :"Error occurred while collecting data". I checked the log file and it shows the below message

No authorized routine named "GETVARIABLE" of type "FUNCTION" having compatible arguments was found.

How can I resolve this error?

sql-server-2012 db2 migration db2-luw sql-server-2012-datatools
Original Q&A
1

There are 1 answers

4
Laughing Vergil On BEST ANSWER

IBM DB2 Session variables have no direct equivalent in SQL Server. You will have to look up the GETVARIABLE command, see what information is being retrieved, and find the SQL Server equivalent (if any).

Related Questions in SQL-SERVER-2012

Related Questions in DB2

Related Questions in MIGRATION

Related Questions in DB2-LUW

Related Questions in SQL-SERVER-2012-DATATOOLS

Popular Questions

Popular Tags

javascript python java c# php android html jquery c++ css ios sql mysql r reactjs node.js arrays c asp.net json python-3.x ruby-on-rails .net sql-server swift django angular objective-c pandas excel

Trending Questions