question

saurabh-2417 avatar image
0 Votes"
saurabh-2417 asked MartinJaffer-MSFT answered

Copy multiple Db2 for LUW tables in bulk by using Azure Data Factory in the Azure portal

Hi,

Has someone tried to copy multiple DB2(for LUW) tables in bulk by using Azure Data Factory in the Azure portal? The reference document only covers copy from SQL to SQL?

I am not sure if the same steps can be followed as is for a different source/target databases.
The queries for instance 'SELECT * FROM [@{item().TABLE_SCHEMA}].[@{item().TABLE_NAME}]" might be specific to SQL database. I think since Db2 has its own catalog tables, the queries/options might have to be customized.


Please share your experience/thoughts. It will be helpful if you can share any reference document for copying multiple DB2(for LUW) tables in bulk by using ADF.

azure-data-factory
· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@saurabh-2417 I haven't heard back from you. Are you still facing the issue?

0 Votes 0 ·

Hello @MartinJaffer-MSFT ,

Yes, the syntax should be quite similar. Do you have any reference code for copying Db2 tables in bulk ?
If not, I will experiment on my own.

Thanks for your follow up.

0 Votes 0 ·

No I do not have any examples off hand. Sadly I do not have a DB2 environment to test against, so I cannot do this for you.

The overall logic should be the same as for the bulk sql examples.
Good luck!

0 Votes 0 ·

1 Answer

MartinJaffer-MSFT avatar image
0 Votes"
MartinJaffer-MSFT answered

Hello @saurabh-2417 and welcome to Microsoft Q&A.

If DB2 language is different from SQL, then you would have to customize the query. The concepts used should stay the same, just the syntax and whatever peculiarities DB2 has need to be taken into account. Are you not familiar with DB2?

My cursory search suggests DB2 uses SQL syntax, which would mean not much, if any would need to be changed.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.