Convert Rows to Columns with Comma Delimiter
Posted: Wed Mar 24, 2021 3:09 pm
Hi Team,
I am working on of the migration project and the table counts are validated once DB2 tables are loaded to Cloud platform.
The integration tool expects the counts of each table in a row format with a comma delimiter.
The above Query results are as mentioned below
Could you please help me to get this result in below mentioned format.
120,130,140
Thanks in advance !
I am working on of the migration project and the table counts are validated once DB2 tables are loaded to Cloud platform.
The integration tool expects the counts of each table in a row format with a comma delimiter.
SELECT COUNT(*) FROM SCHEMA_NAME.TABLE1
UNION ALL
SELECT COUNT(*) FROM SCHEMA_NAME.TABLE2
UNION ALL
SELECT COUNT(*) FROM SCHEMA_NAME.TABLE3
UNION ALL
SELECT COUNT(*) FROM SCHEMA_NAME.TABLE2
UNION ALL
SELECT COUNT(*) FROM SCHEMA_NAME.TABLE3
The above Query results are as mentioned below
120
130
140
130
140
Could you please help me to get this result in below mentioned format.
120,130,140
Thanks in advance !