DSXchange

where can i find the .odbc.ini file in client windows machine , this is hidden file and my system is in that mode.

You don't find in the client machine since it is used only by your server not by the client. It is used to store the ODBC connection available to the server.

Did you try to use DATE.TAG transform function.

Where can I find some logs of ds server running? I would like to get info such: new client connection, is that connection was succesful/not, how many clients are connected?
Is that possible?
And how to connect to ds server on unix to run DS.TOOLS app?

How this is related to your topic posted

First line in the routine, is that COMMON statement. Its already there. Atleast I can't see that in the code you have posted :evil: May be I need spectacles :cry: When I am testing, its not returning the right values. How do you know that? What output you are expecting, and what is it giving? Can y...

Reason and Status are common variables. I called this routine, in one of the transformer stage.

Then you need to use the common command prior to their use, I can't find that within your code

The error suggests that it is trying to take in a numeric data type column (specified within the datastage), change it to timestamp and see how it works.

Even if a database is not involved, this data can be loaded into a temp table and then a user defined sql can be written on it.

I agree with DSGuru, but instead of going for the database way, you can get it done through the Universe Stage (instead of your Hashed File) and do a range lookup there.

This post will help you

viewtopic.php?t=101453

Please read my earlier post again, I asked you to use derivation of Curr_Row to concate of the AccCode and DeptCode. i.e.
Set Curr_Row to AccCode : DeptCode

You don't write a query in transformer. Its the place where you do the transformation. Take two stage variables Prev_Row Curr_Row Set Curr_Row to Col1 : Col2 Constraint for the Target Link Curr_Row<>Prev_Row Constraint for the Error Link Curr_Row=Prev_Row Then set Prev_Row=Curr_Row It should give yo...

How are you sorting the data?

You can use the sort stage for the puppose, it won't remove the duplicates.

No need to go for aggregator stage.

Sort the data first (based on the two columns).

Then check the duplicates through the stage variables if found pass it to the error table link else to the target link.

can any body tell me ,what is difference between patitioning key and sorting key...

Where, which stage?

chulett wrote:You don't need to 'convert' anything. Simply declare the datatype for the Oracle DATE field as Timestamp on both source and target, let the stages generate the sql and you'll be fine.

That answers everything. Doesn't that?
Did you try what chulett suggested?
What result you got?

You can do it using
the sorted data and checking for duplicates using the stage variables within the transformer.