DSXchange

Update... The suspicion around breaching the bigint threshold proved unfounded, the same issue was also seen with lower values in lower ranges. The conclusion reached with the vendor showed that the same behaviour also exists in 9.1 and the solution is to perform only AsInteger on the inbound field ...

Prasoon,

You can also use Peek to pull out specific columns/values to send to an output link, from which you can join it back to something else, for example, or do some other processing on. It's not restricted solely to being output to the job log.

Look at the IsValid function to validate the content against a specified datatype ahead of your load. It's a "type conversion" function class.

I'm slightly intrigued as to why there is a reference to decimal_from_ustring in there for a varchar - are you using extended metadata options? I wouldn't be surprised also if, under the covers, your transformation is going from a varchar to another datatype in an intermediate variable, before being...

For the handling part, unless I am misunderstanding something, it seems relatively simple. Does the required/expected number of columns not remain the same? If so, a count of the columns in the header can be checked. A failure to match can result in the process exiting as a failure, which you can ha...

I'm not sure you can exclusively handle this through Datastage alone, instead I'd look to check the file format through scripting and produce a relevant schema file to use on input to the initial Datastage job reading the source in. Look at schema files and partial schemas.

Cross referencing this issue as also existing in 8.1

viewtopic.php?t=150110

Use the debugger, breakpointing on a condition equating to the search on the data you're interested in, on the dataset output link

Hi all, To correlate that this issue also occurs in 7.5x, please also refer to http://www.dsxchange.com/viewtopic.php?t=107493 In our case we saw the same behaviour in 8.1. The incoming field is a Varchar (19) from a sequential file. A transformer performs the below derivation in an output link: AsI...

Hi all, Has anyone had any experiences of this product when using it as a plugin to IIS Datastage v8 please? I'm particulary interested in any experiences that can show a cross-comparison of the 'before and after', to include system usage footprint and elapsed time or any other relevant measures. Th...

Check for running processes on each node, using ps, grepping for string "phantom DSD.RUN"

I'd elaborate if you want an (accurate) answer... you mean which is set to run on which node, which is running on which node right now...? Something else?

We have one of these in our environment and have found that when trying to import the table definition it cannot be viewed, only tables and views can be found when using the plug in metadata definitions (DB2). The same appears to hold true in v7x and v8.1. As such, it means the user maintained MQTs ...

Thanks all, I'll look at capturing this information solely at o/s level instead as it isn't available in the Datastage environment.

Hi Mark, Did you try enabling the server trace option from the Administrator Client? And at unix server level also we can capture the log file I think, because we are doing it in our AIX server. Hi Tony, Which 'log file' are you referring to here please? Our o/s is also AIX. I haven't yet looked at...