DSXchange

Which section ?

I can only find teradata enterprise stage in Parallel Job Developer's guide

What document is for Teradata load stage in parallel job ? I haven' found it. However I check my job and find there is an option drop table ..... It is actually for drop table and re-create the table. Just set it to YES and DS will drop the table and re-create it even if the drop table statement wil...

I try to load some data to Teradata by Teradata load stage and meanwhile create a table.( table doesn't exist before the job ). I always get error from teradata log, say that the table xxxx doesn't exist. Do we have a option in Teradata load stage that it will create the table first, then load data ...

We have a few nodes in APT_Config file.

How can I make sure each node can access the library ??

Thanks a lot !

That can be a problem. but I run a server job over this node, with the same stage, same configuration. And It finished successfully. Can I assume the library is accessable since server job use the same libarary ? And I try to use Teradata Enterprise stage since it is better based on a few posts here...

I use a Tera Data API stage to extract data from Teradata to a sequencial file based on user-defined SQL statement, I can view data in Teradata API stage, and the result is fine. the job is Teradata stage --> Sequencial file Stage. After I compiled it, and run it, always get error. Teradata_API_6,0:...

If yes, how to ?

thanks

I need to use ODBC stage in Datastage.

As I knew, I need to set up the connection in Datastage server first of all, then I am able to use it.

But my Datastage server is on Linux, is here a Linux Version ODBC ? or How can I configure a ODBC connection to MS SQL Server in Linux server ?

Thanks

I got a problem in loading data back to Oracle today. And the job works fine previously. It is interesting that sometimes the job abort on 30%, sometimes abort on 90%. and the error log is like Oracle_Enterprise_103,3: The system(sqlldr UserName/Password@conn CONTROL=ora.4756.444240.3.ctl LOG=ora.47...

I have a big datastage job, it has a lot of category, sub-category, and son.

Somebody gave me a job name and ask me have a look.

I just couldn't locate it, somebody tell me how to search it ??

Thanks

ray.wurlod wrote:If you have QualityStage, you have the installation media from which you can install the QualityStage plug-in for DataStage, and the qsrtmngr component that needs to be installed on the DataStage serv ...

Thanks a lot ! I will try tomorrow.

I have no idea about it.

But I have seen that somebody write a job routine to call Quality Stage job. Is it the only way to do it ?

Somebody can give me some hints about the syntax ?

Thanks

Finally, I was told our group don't have the right to unlock jobs.

I got a problem to unlock a job. when I go to director, and clean up resource file. Then show all process, I can find a few processes under my ID. then I try to logout them, but failed, they are still there. And If I click the process, and show locks by process. I found a few locks as well. then i t...

It is a stupid mistake I made in my job, and I figure it out finally, but loose reputation. Actually I revised somebody else's job. And trim works fine, after trim works, I actually put a char(10) source to char(5) target. and finally still get probably the first 5 bytes spaces. I always suspect tri...