Loading

DB2 to SQL conversion

nitin singh

8y1.3k

I need to convert below DB2 query to SQL.

SUBSTR(xmlserialize(xmlagg(xmltext(CONCAT( ', ',DEL.COVERAGE_CODE))) as VARCHAR(1024)), 3) as COVERAGE_CODE

I am not able to get equivalents of xml related things in SQL. Any help would be appreciated

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Shahriar Nikkhah8y ago
oops forgot the ones from MS

https://docs.microsoft.com/en-us/sql/ssma/db2/sql-server-migration-assistant-for-db2-db2tosql
Shahriar Nikkhah8y ago
so many tools that does that but make sure you understand what you are getting
my point is at the end within SQL server check the
Tables , fields , PK, FK, NN , Index, etc....

Good luck

FYI

https://www.easyfrom.net/download/?gclid=CjwKCAjws6jVBRBZEiwAkIfZ2pgZNU4nPeErTVlzW7-IZdQWgCvqH0LHjqC4_V4YaetVn4TxtubtBBoCjuQQAvD_BwE