DSXchange

Connector is not available until version 8.x.

The solution is for you to take a class in Logic 101.

You need AND operators between <> comparisons. Think about it.
Or you could put OR between = comparisons and surround the whole lot with a Not() function.

DS_JOBOBJECTS perchance, as per my previous post?

You have the year and the ordinal number of the day in the year. You can extract these components with arithmetic operations/functions. Divide by 1000 to get the year, take the remainder (Mod() function) to get the day. Then you can use date conversion functions to generate a Date from those compone...

Yes you do.

It's in the Stage Types branch of the Repository. They deliberately do not put it in the Palette, to discourage its use.

If you're in an MPP or grid environment, there are several restrictions on the use of BASIC Transformer stage.

Premium membership will let you see the previous post in its entirety, as well as conferring a number of other benefits. All revenue from premium memberships is devoted to defraying the hosting and bandwidth costs incurred by DSXchange. By signing up you are not only benefitting yourself, you are a...

AMERICAN alone is not a valid value for NLS_LANG, but you'll find that out soon enough once you've set it. In the Administrator client open the project properties for your project and, on the General tab, click the button captioned Environment. This will open the environment variables tree. Select t...

Are your data really stored in the Oracle table using UTF-8 encoding? If so, you need to investigate where these characters are to be found and what they mean. It appears that there's an issue when converting them from UTF-8 into the Unicode used within DataStage. What value do you have NLS_LANG env...

1st Case Option 1 Do the whole move within Oracle. Don't worry about using DataStage. 1st Case Option 2 Oracle ---> SeqFile then use sqlldr with customized ctl file (tuned buffer sizes, etc) to load into Oracle. Obviously this only works if bulk loader is applicable (no bitmap indexes, load mode is ...

Please read this topic or, at the very least, its subject line. There is no such thing as a Peak stage. There is, as others have noted, a Peek stage. This has the function of capturing a sample of rows, either to log entries or to a file. A reject link is a link, so that's the main difference. Many ...

A running DataStage job is just another client application as far as DB2 is concerned. You do not need to set up ODBC unless you are planning to access DB2 using ODBC protocol - for example via the ODBC Enterprise stage. You do need, irrespective of how you will be connecting to DB2 from DataStage, ...

Sorta looks that way. What does your official support provider have to say?

Have you checked whether this is a deficiency in the ODBC driver itself? Can you retrieve results with the DS_CONNECT facility that comes with DataStage? Can you use the test utility under branded_odbc? Can you use some completely different client software - maybe even one of your own C programs wri...

You can use my solution above or Craig's using the Left() function or substring.