DSXchange

Hi All , Please find the below job design sqfile -> sort_stage -> remove_dup -> transformer -> sqfile And inside transformer i am using the following expression If (trim(link1.col1,' ','A')='msg1') then 'jb1' else if ((trim(link1.col1,' ','A')='msg2') or (trim(link1.col1,' ','A')='msg3')) then 'jb2'...

sorry ray that is wrong design,
this is correct design,

I am not reading from the dataset in the same job. another job will read the dataset in case of failure in first job.
my problem is dataset is not created(created at runtime but deleted if job got aborts). Is there any way to prevent dataset from deleting ,even if job aborts

In our job design another link from the copy stage is loading teradata tpump table. mq -> copy -> dataset | V column import -> transformer -> TPump stage As we are doing destructive read from mq, we plan to use the dataset as a backup in case of any failure. The actual problem is if the job aborts d...

Hi, The design of my job is MQ->Copy stage -> dataset In my job, datset is serving as a backup . The problem is the dataset created during job run is deleted if job got aborts( We can view the dataset in the given path while job running , but it is missing after it got aborts). Is there any way to c...

Hi All, When i try to ran a job through sequencer, the job got aborted showing the error 'job control process (pid xxx) has failed'. and the job has locked. when i try to compile it is showing the "cannot get exclusive access to executable file or job, job may be being monitored". the prev...

Hi All, When i try to ran a job through sequencer, the job got aborted showing the error 'job control process (pid xxx) has failed'. and the job has locked. when i try to compile it is showing the "cannot get exclusive access to executable file or job, job may be being monitored". the prev...

Hi All, When i try to load data from a teradata tabel to another teradata table using ODBC stage, the job aborts with following fatal error "APT_COMBINEdoperatorcontroller,1: [Data Direct][ODBC TERADATA CLIENT DRIVER][TERADATA]CLI2:REQOVFLOW{350};Request size excedds maximum" Note: the tar...

Hi All, I am running a job in sequencer. my requirement is that even if the job aborts, the job has to reset automatically when the sequencer restarts. eventhough i select the option 'Reset if required then run' in execution action in job activity stage, the sequencer is throwing the following error...

Hi, In the attached C Routine, how to pass the values from DS to a C structure which has 2 variables (length, bytes[66000]). #define SQL_TEXT Latin_Text #include "/ds/data/sqltypes_td.h" #include <string.h> #include <stdlib.h> struct VARBYTE_D { long length; BYTE bytes[66000]; }; void vbto...

hi boss if you had solved this issue, could you please share that information with me.

hi all, I am using column to import stage to convert binary to text. The problem is, there is some null values are in the middle of binary column. so when column import converts binary into text, it is truncating upto the last character before the null leaving remaining as blank space. so i am not g...

thanks george

hi ,
my requirement is to find the minimum value of timestamp column. when i use aggregrator, it is producing result in double so i am not getting the appropriate results. what stage i should use for this purpose

hi, My requirement is to get the current_timestamp with each record in teradata for that i am using the query "select <col1>,current_timestamp from <table>" inside the teradata enterperise stage. when i use view data, it is showing the data correctly. But when i try to run, it is showing t...