DSXchange

There is an option in datastage administrator to enable/disable auto purge feature. Diasble the auto purge option in DS administartor itself to get rid off this problem. Thats all you need to do.

The problem has been resolved by disabling auto-purge feature in DS director. I raised a ticket for this problem with IBM and IBM suggested to disable auto-purge feature. Now my sequencer with multiple instane jobs inside it, is running fine on DS version 8.0 :D

I am running a sequence job in Datastage version 8.0 but getting the below error: job_seq..JobControl (DSWaitForJob): Job bftp_vistacrep.Inv_Id_1 has finished, status = 99 (Not running) job_seq..JobControl (@Inv_Id_1): Job bftp_vistacrep.Inv_Id_1 did not finish OK, status = 'Not running' My sequence...

Hi, I am using a shell script to ftp a flat file from first machine to second machine. Then I am using the ftpped flat file from second machine through sequential stage to load data into database table by creating a parallel job. My query is that if the ftp shell script encounteres any error during ...

Yes it supports. Use server jobs for this.

PeterPol wrote:Hello,

Does Datstage 8.0 supports the use of Sybase ASE stored procedures?

Peter

can you please guide me where can i get the APT_DISABLE_COMBINATION? And how can i set it true?

ray.wurlod wrote:There must be more information available. Run the job with APT_DISABLE_COMBINATION set to True. ...

Errors from the director are as follows APT_CombinedOperatorController,2: [DataDirect][ODBC lib] Program type out of range APT_CombinedOperatorController,1: [DataDirect][ODBC lib] Program type out of range APT_CombinedOperatorController,3: [DataDirect][ODBC lib] Program type out of range APT_Combine...

What do you meant by disable com... I dont have more information related to this as this was a production error. Can you let me know whether this error is something related to the job or is it comming from datasabe side, due to some configuration issues. Our jobs picks flatfile and then uses ODBC st...

When we run our job we are getting below Fatal errors, but the job is not getting aborted and no data missing is hapenning. Can some one give me clues about why this fatal errors are coming up? How can i stop this? 199\2007-04-05 18:13:24\3\\3\APT_CombinedOperatorController,2: [DataDirect][ODBC SQL ...

I am executing a stored procedure using ODBC stage and i am writing the the output to a file using sequential file stage. In between ODBC stage and sequential file stage i have transformer stage. My job runs daily. If suppose my stored procedure returned 5 rows for todays run then that data gets wri...

We have source as sequential file. Followed by seqential file stage we have transformer stage and then we have ODBC stage (say A) followed by one more ODBC stage (say B). Between stage A and B we have reject link. Records which gets rejected due to primary key constraint or duplicacy gets automatica...

Can you please explain it bit more clearly. I am not getting your explanation ..

So Sorry for the trouble

But in the sequential file stage the type for this field is kept as unknown. How can i solve this problem. The date in the file need to be loaded to TERADATA table. Please give me some ideas

in the sequential file stage we have kept the type unknown for the incomming date. In teradata table the type is Timestamp with length 22. We are getting below error . Teradata_Enterprise_1,0: At field "Effective_Date": Default value not valid for type "timestamp"; text: default=...

I have date comming in flat file. My target is Teradata.In terada the type of the date is timestamp. How to convert the date comming in flat file to timestamp type in the transformer stage.