DSXchange

Hi !

I want to choose Replace Existing rows Update I see in View SQL the SQL generated with clause where in delete statement .
But how I can define the Where clause ?

I cant edit the SQL generated

I need help ! During insertion of rows to target I get errors . Primary key violation , datatype mismatch ... . I want to catch these error's rows and put to another table and may be create some metadata with DBMS code error. How to do these ? For example, I see that 1000 rows are go into final odbc...

Yes . Only two values

Hi !

I want to split one source table to two tables according to column and specific value of this column . Suppose , if the column value is 1 load it to Target 1 and if 2 load to target 2.

If The Link Partitioner will help me ?

My hash file contains four fields with two keys. If I link my primary table to hash file there multiple rows are returned . In these rows i need to check third field of hash file and depend on it enter the fourh value from hash file to target table. How I can do it ? If hash file appropriate for thi...

How I can to enter Name of ODBC connection into JOB PARAMETR ?

Help me , please !

Can I use in ODBC stage JOB PARAMETR that contain name of ODBC Connection in WINDOWS System DSN ?

I connect to Link Collector Three Input Links from Three Transformers
and get error during compilation :

"Link Collector doesnt support in-process active-to-active inputs or outputs..."

What does it mean ! And From What I can link multiple Links To Link Collector ?

Hi !

I want to do Custom Trigger in Job Activity That Terminates the sequence if There are were Failed OR Warning

How I can to combine this . What @JobStatus For these two cases ?

Hi !

I want to get data from three different ODBC stages throuth transformers and to collect them all to ODBC target stage. In three transformers I need to get same metadata from target ODBC stage and Use Link Collector.

Will it work ?

Hi !

I want to ask people that have used RowMerger or RowSpliter
Where there are help you?

I want to get that '2000/01/01' is greater (later) then '1999/01/01'

I want ot compare to dates 1999/01/02 and 2000/01/02 and the answer that i get is wrong

Hi , I pass to MS SERVER smalldate time in format yyyy-mm-dd but i get error : [DataStage][SQL Client][ODBC][Microsoft][ODBC SQL Server Driver][SQL Server]The conversion of char data type to smalldatetime data type resulted in an out-of-range smalldatetime value. yyyy-mm-dd is the format for SQL.SMA...

Hi !

I need to know how to convert data defined by DS as binary to varchar and smalldate time of MS SQL Server