DSXchange

here is how you should use open/close command in oracle/odbc stages.

..

VMARK->ARDENT->ASCENTIAL->IBM

http://etl-tools.info/en/datastage.html

[quote="mingzhang"]Yes, but not necessary SORTED (since didn't "perform sort"). And my question is: does Join stage require inputs to be sorted? [quote="betterthanever"]in the second scenario hash partitnoning makes sure that the key values end up in the same partition....

do you have a sequential stage upstream/downstream???

in the second scenario hash partitnoning makes sure that the key values end up in the same partition...

as long as the same key values endup in the same partition for all the input/references you should be okay which would have happened in the 2 step you mentioned. the first step already would have inserted the sort operator when you set AUTO partinoning..which you should be able to see in the directo...

"repost"

it depends on the triggers we use fo the sequence...
using proper tiggers you should he able to hadle the aborts due to warnings.

bart12872,
we can handle single digit month and date as mentioned in the expessions ...

i agree that the expression you mentioned also works..

"repost"

[quote="efxuser"]My version is 7.5.1.A[/quote]

may be someone else with your version has to chime in ...

[quote="Sainath.Srinivasan"][code]StringToTimestamp(DSLink8.Eff_date:' 00:00:00',"%m/%d/%yyyy %hh:%nn:%ss") [/code]

Or simply to a StringToDate and use it as a date.[/quote]

the one sainath suggested also works. i tested it.

efxuser,

i dont know if something to do with the version youa re using, but tested on 8.0.1 version before i posted it.
and it works!!!!