Hello every one:
I have a task to finish. I want to drop a teradata table and want to use datastage to finish this task.
My server is in unix and the brand is 7.5.2. Please tell me which datastage I should select and tell me more detail.
Many thanks!
Problem of Teradata task
Moderators: chulett, rschirm, roy
-
- Charter Member
- Posts: 560
- Joined: Wed Jul 13, 2005 5:36 am
- Location: Ohio
I have designed a job, and using Teradata Enterprise stage as source. In this stage I defined a SQL (Select * from (Select 'aa' AS AA) t1)to post data flow, and a SQL (DELETE FROM CBS_AGDMX)to delete the table. It can work when I union the two SQL sentences. But my final aim is droping the table. As I change the SQL(DELETE FROM CBS_AGDMX) as (Drop table CBS_AGDMX) it does not work. And I also try it on the teradata celint, which does not work. So my friends, can you give me a way?
-
- Charter Member
- Posts: 560
- Joined: Wed Jul 13, 2005 5:36 am
- Location: Ohio
You might try using the Teradata API stage instead of Teradata Enterprise, since the Teradata API stage doesn't use a utility slot and doesn't have the overhead of connecting multiple sessions at startup. Teradata Enterprise is overkill for what you want to do.
If you don't see the Teradata API stage in the default palette, you can still drag it from Stage Types->Parallel->Database->Teradata in the repository view. Specify your DROP TABLE statement in the Before or After SQL tab.
If you don't see the Teradata API stage in the default palette, you can still drag it from Stage Types->Parallel->Database->Teradata in the repository view. Specify your DROP TABLE statement in the Before or After SQL tab.