Not picking last table

praburaj · Post by **praburaj** » Mon Feb 13, 2012 1:39 am

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.

kandyshandy · Post by **kandyshandy** » Mon Feb 13, 2012 2:01 am

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?

praburaj · Post by **praburaj** » Mon Feb 13, 2012 2:07 am

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.

kandyshandy · Post by **kandyshandy** » Mon Feb 13, 2012 2:55 am

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

praburaj · Post by **praburaj** » Mon Feb 13, 2012 5:34 am

I fixed my problem. Thanks to everyone :D

pandeesh · Post by **pandeesh** » Mon Feb 13, 2012 6:16 am

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

Thanks