DSXchange

That's neither a short nor simple subject. Why not track down whomever wrote that one of yours and have them tutor you?

if its doing update and insert mean it will take more time to process, Oracle bulk load doesnt support this. It does, to some extent, with a conventional (DIRECT=FALSE) load. But you're correct about the performance over the duration of the load. Any of those 'combo' Update Actions are a crutch, IM...

The DRS stage set to 'Oracle' is functionally equivalent to the OCI stage, so there's no gain from switching. And it doesn't take the place of a bulk loader any more than OCI does.

I've used the Sybase stage (singular) and, since it requires the Sybase OC to work, I made the assumption it couldn't somehow be finageled into also working for SQL Server. Could be wrong. [shrug] I didn't pick up on your use of the plural, so didn't take any other stages into consideration and will...

As Ray noted, DataStage ships with a Data Direct wire driver for SQL Server which is what I used when I needed to interface with that source. Sure, that's still ODBC and you still need to do all the normal configuring like you would for any other ODBC source, but it's a 'source specific' driver and ...

After a bit of hacking, I've deduced that TO_DATE must be an internal DataStage function that converts the string to the proper format for the target database. TO_DATE isn't a SQL Server function, although I've used it before on Oracle projects. No, TO_DATE() is not anything internal to DataStage, ...

Kryt0n wrote:Could the Sybase stages be configured to access SQL Server?

No.

Mike wrote:Which means that even though you're using the DRS stage, you are probably still talking to SQL Server through an ODBC interface.

That depends entirely on the 'Database type' setting, it supports both ODBC and MSSQL Server. The OP hasn't specified which they are using.

"When field1 is a duplicate the data in field2 should have the same value" - as what, the first key value found?

What would be your expected output for this input:

001 AAA
001 AAA
001 AAA
001 BBB
001 BBB
002 BBB
002 CCC
002 CCC
002 AAA

Confusing. Do you only want the records that are not duplicated within the file?

uegodawa wrote:First it will remove comma subsequently remove all alphabetic characters.

Reread the requirements - trailing alpha characters only. Apparently up to three max. As Ray noted, we really need a more complete specification.

No, we've been discussing the way to reset a job. However, that's what your job control should be doing before it runs the job as the job can't do it to itself.

Yes.

Of course. Why would you need to reset a running job? This is something one job would do for another, not for itself.

Ah, yes, that post. Seems like you'll need to set some kind of indicator, something you can check on later, to see if any jobs had problems and the Sequence itself should be aborted as a result. And then check on that 'indicator' after job and if found or set, issue the abort there. Perhaps that's a...