SSMA - DB2 z/OS to MSSQL - DB22SS0532: Conversion of external functions or procedures is not supported

Question

I am trying out converting DB2 stored procedures (on Mainframe) to MSSQL (sql server 2019) using SSMA for DB2 v9.1 with no luck. I get the below error message. The SSMA documentation and GIT repo mentions the conversion of procedures and functions but not sure what I am missing here.

Analyzing metadata...
Converting procedure CAN001.ABC060XY ...
Errors: DB22SS0532: Conversion of external functions or procedures is not supported.
Conversion finished with 1 errors, 0 warnings, and 0 informational messages.

The settings are default by the way. Am I missing additional configuration, software or add on pack? Please let me know.

Answer 1

Conversion of external functions or procedures is not supported.

IBM DB2 support external functions/procedure written in programming languages like Cobol, C++, etc.
SQL Server don't support that and so that external functions can not be converted by SSMS. You have to implement that function on your own in an other way.

https://www.ibm.com/docs/en/db2-for-zos/12?topic=function-external-functions

Answer 2

Hi @karthik poondisridhar ,

Check the corresponding conversion result, it has mentioned, external procedures require manual update
Converting DB2 Schemas (DB2ToSQL)

You need to manually update the unsupported conversions to one of the supported types in SQL Server

-------------

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.