DSXchange

Hi Ray

I have used the following

a) Used NullToValue
b)Used If/Else and ISNULL
c)NullToEmpty

3 Nullables (2 Varchars , 1 Date) . As for the date for null values a Non Nullable input date is assigned.

Arnd

I tried to break the job , fails again at the same transformer

Hi Folks

I have a Transformer stage , and input fields to the transformer is a Nullable Source. All transformations and Null handling is done in the transformer , still i end up getting a FATAL message saying source and target have differing Nullability

What is the possible cause ?

No still does not work Still

HI Folks

Tried both ! Still remains unresolved though .

NO Warnings / Errors in the log

Hi all, We are currently working in a project for a client in California, and in California PST ( Pacific Standard Time) is followed during winter and PDT(Pacific Daylight Time ) during summer. We will be running some jobs which will be transform data on Hourly basis.Our business logic is that our m...

Hello Ray

I am using DataSet-Management utility to read the dataset and the no:of records in each node.
There are no other stages in the Job , it is just a dump of the table we are taking for processing in the subsequent Jobs.
Job is compiled normally not in trace mode

Hi Folks

Facing a strange problem , extracting data from z/os - DB2 . Link counts show 10000 records and view data shows 10000 , actual dump into a dataset has only 100 records immaterial of data extracted !

The input needs to be hash-partitioned and sorted for Join . Same partition can be maintained after doing the same. Alternatively "Auto" partition does the same. APT_NO_SORT_INSERTION : DataStage automatically inserts sort components based on this , can be included in Job to prevent automa...

I am getting this compilation error "LinkCollector stage does not support active-to-active inputs or outputs"


Note:I have used two sequential files as input for the Linkcollector stage.
what would be the problem?
Help needed.

Hi Ray,

We are going to install SAO edition. But before that, we have no idea how this webservice works out.

Can you please put some light on specifoed questions mentioned in the first post.

It will be great helpful to us.

thanks

Hi

Immediate requirement is for exposing jobs to webservice.

But I need installable requiment list for both ways.

thanks.

Hi All, We have special requirment from our client. We need to build the jobs in datastage and need to expose it to webservice. The webservice will execute the job. 1. Can we expose more than one job as webservice ? 2. If more than one will be exposed then how can webservice will execute one after a...

Hi Ray

We have input as Comma delimited. Truncation is also ruled out due to other business requirement , now the way we are doing is read it as a String[3] to the xfm and use the Len functions to reject the record.

Hi Folks

I read numeric fields in input . The length of the field is 3 , if iam passing an Integer of length 4 , the record is not truncated . Is there an Env Variable that controls this behaviour. What is the workaround