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.
Not picking last table
Moderators: chulett, rschirm, roy
Not picking last table
prabakaran.v
-
- Participant
- Posts: 597
- Joined: Fri Apr 29, 2005 6:19 am
- Location: Singapore
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.
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.
prabakaran.v
-
- Participant
- Posts: 597
- Joined: Fri Apr 29, 2005 6:19 am
- Location: Singapore