DSXchange

I have a requirement where the input data has records which share a parent child relation. I need to read them in DS. I would like to have a overview of above data tyoes for the same, The parallel job dev guide has a high level info only...I need something more detailed as to what are these data typ...

Please don't mind, but I need more info here..I agree I used a null handler and converted all nulls to spaces. But in target if I leave Nullability as Yes, how does it make a difference...Is it that, in DataStage if you use any null handling function for a given field, the nullability of that field ...

Just one more bit of info...sounds silly of me to give it out so late..but just came to know...The initial job which I described in my first post, the nullability of target was set to 'Yes' I mean to say in the output of the transformer where IsNull function was used..Does that make any change ? bec...

You can use an aggrgator stage here...Take a count of the key column..if count greater than 1 have it routed to a output via filter

ArndW wrote:The IsNull() function works in all scenarios. Did you check the nullability in the DESCRIBE of "colname" in both environments? It would seem to be a nullable field and this generating your error messa ...

Yes it is a nullable field in both environments. I checked using DESCRIBE table.

creatingfusion wrote:ues the function NullToEmpty in yours transformer dataset will treat blanks as null

Do you mean to say IsNull function does not work in all scenarios ? Why do u suggest NullToEmpty ?

ArndW wrote:"DDL" Data Definition Language. Do a "DESCRIBE <table>" in both environments and check the nullability in both environments for the column in question.

I did exactly the same thing desribed by you. The tables are identical in all respects.

The Oracle tables are identical in both environments. If that what you mean by DDL ? It has to be the data. Obviously UAT guys pass all types of data which may not be in Dev..What say ?

The job is in read only mode and I am wont be able to run it..I tried to replicate in Dev env but it ran fine...So I reckon it has something to do with the incoming data from Oracle. Something which is a null but is not being caught by IsNull and it is letting it pass through..and then it is failing...

At project level $APT_DISABLE_COMBINATION = False..It is something I dont have a control and cannot change since it is in UAT environment...In the Dev environment, I am not able to reproduce the above error...So not sure what I can do.But i remeber a long time back of some post somewhere which said ...

$APT_DISABLE_COMBINATION is set to True in job parameters. The transformer is throwing the error.

Is there any scenario where IsNull function fails to catch a null value ? My source is Oracle table. Version is Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production. DataStage Version is 8.1 The field in question is of datatype NVARCHAR2(75) in the database. It is a Nullable ...

It works perfectly fine. Thanks

I want the the output to be empty string. So can I use

outcolumn=handle_null(incolumn,"") ?

What is the syntax to be used within the Specification of Modify Stage if I need to convert a null value into empty string. In short I need the equivalent of NullToEmpty(Fieldname) which we usually use in transformer