DSXchange

Hi All,

I have a file which consists more than 16 table names. I need to call all the table one by one through start loop Activity. After that I need to do a insert and update for all the 16 tables. My job is running fine till my 15th table but I am not able to pick 16 table. All tables names are delimited by commas. I don't know why I am not able to pick the last table.

My file is like I mentioned below.


CC_AH00_PR,CC_AH01_PR,CC_AH02_AGENCYHIST_PR

Any help is really appreciated.

how you are selecting one by one? So you have only 1 record in that file? Do you have a new line character at the end of the record?

Thanks for your reply. I have done some changes in my code. Now, I am able to pick all my 16 tables. But still my job aborted.

I got message like this

SQL statement failed: SELECT UNQID, END_DT from M3DEV6_EDW. where END_DT<>to_date('9999-12-31 23:59:59', 'YYYY-MM-DD HH24:MI:SS').

It seems like trying to create one more table.

Any Idea on this.

praburaj wrote: SQL statement failed: SELECT UNQID, END_DT from M3DEV6_EDW. where END_DT<>to_date('9999-12-31 23:59:59', 'YYYY-MM-DD HH24:MI:SS').

I don't see a table name in your SQL

I fixed my problem. Thanks to everyone :D

So, can you please post the resolution to the topic?

Thanks