DSXchange

We have successfully used the WORKDB variable in our Teradata Enterprise stages. Now we are starting to use the new Teradata Connector stage in DataStage 8.1 (Fix Pack 1) but I do not see where we can specify WORKDB.

Does anyone know where we can specify WORKDB in the Teradata Connector stage?

I was looking at the Teradata Enterprise stage and the product documentation trying to find more about the Terasync table and how Fastload is invoked so we can write error-checking routines after loads. In the Teradata Multiload stage I can define the names of the error tables. Because I know the ta...

Update: I found I can do what I want to do in the Before stage because I have the ability to stop the load job with a non-zero return code if a specified condition is met. That takes care of most of my problem. I still have to shell out to our Teradata load server to invoke BTEQ when I want to just ...

We use 7.5.1A as well. We had to add these as User Defined variables, even though they are referenced in the Ascential documentation. Once you add them, though, they work as advertised. To add them to the available variable list go to the Job Properties button and select the Parameters tab. Click on...

Thanks Ray! I tried the Stored Procedure stage on your suggestion but Teradata is not a supported platform. If it worked with Teradata it would be just what I need. I am playing around with the Before and After commands but mostly to satisfy my curiosity. For my scenario I am pretty sure I can't rel...

I am a rather inexperienced user of DS 7.5.1A PX, and also an experienced Teradata DBA. I am wondering if there exists a stage for Teradata that allows SQL to be run via ODBC that requires no inputs or outputs. We are trying to integrate DS into our production environment and our standards require s...

If this is still an issue, it likely means that the Teradata user id identified in the Teradata stage does not have the ability to create and administer data in the TeraSync table, or that the database it is trying to create the TeraSync table in does not have any perm or enough perm space to contai...