SSMA for DB2 - unparsed SQL error

karthik poondisridhar 1 Reputation point
2022-09-30T13:36:35.867+00:00

Hi,

I am trying to convert a native DB2 stored procedure (Language SQL) to MS SQL. When I try to view the procedure in the UI it appears to be in EBCDIC format, when I convert it I get error 246522-ssma-db2-image1.jpg246478-ssma-db2-output1.jpg

Could you please let me know how to resolve this?

SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
494 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. CathyJi-MSFT 21,086 Reputation points Microsoft Vendor
    2022-10-03T08:24:10.553+00:00

    Hi @karthik poondisridhar ,

    Unparsed SQL" means that it didn't recognize the statement you tried to convert. May be some parameters are not supported in MS SQL server. The error message that you offered is too less for analysis. Suggest you choose the stored procedure one by one to check which one has this issue. Please also check the Parameters and Type Mapping tags on SSMA to find some related information for analysis. You may find which parameter is not recognized.

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