DSXchange

First off, if this is going to an Aggregator then you don't want nulls as they will make the end result null. So this instead, I would think: Vsr_no = if IsNull(source.SR_NUMBER) then 0 else 1 I'm a little fuzzy on exactly what 'distinct' information you are looking for. Are you trying to ge...

How are you planning on compiling anything without the source being available? As you noted in your first post, that doesn't really make any sense.

Because "they" decided they should be treated the same.

First place to check:

$DSHOME/include/dsapi.h

I'm honestly not sure how you tell the different between "Aborted" and "Aborted/Restartable".

I would think the short answer is 'no' and that that burden lies squarely on the shoulders of the web service.

rajendharreddy wrote:Can I reset the value from the job sequence?

Sure. A custom routine with DSExecute and "UV" springs to mind.

As Ray notes, the short answer is 'yes' but you'd need to post specific questions to get specific answers.

Double-check your data types in each database. SQL Server doesn't have a 'varchar2' as far as I know and the error implies that your Oracle target column is a LONG not a VARCHAR2.

There's nothing you can do to not read the column names in an effort to 'improve performance'. Something, be it a O/S function or something internal to DataStage will need to read everything and filter out just the bits you need. Inside DataStage, seems to me you can use the Field() function to spli...

Suggest you search the forums for ORPHCallActivePluginInitialize and see if any of those posts help first.

If a comma and a semi-colon didn't work, try a single space.

With 'test'.


Returns true if the file exists and is greater than zero bytes in size, otherwise it returns false. Reverse the check with the bang:


Returns true if the file doesn't exist or exists and is zero bytes in size.

Rather than awk the entire file, a simple conditional expression could be used to check the file. For example:

So, feel free to not ignore the last paragraph in my reply.

Sorry, misread what was going on here. Please feel free to ignore.