DSXchange

I want to use help in uvsh but get

Program "HELP": pc = 50A, Could not locate NLS map ?<.
Cannot Open "UV.SAVEDLISTS"

what's the problem?

And is there any document for the uvsh commands?

Thank you so much

A Lookup stage still performs a join - by default a left outer join, but this can be an inner join if the Lookup Failed rule is set to "Drop". Had I meant a Join stage the word would have had a capit ... For Lookup stage, it will load all the data to memory, therefore, if the data size is...

ray.wurlod wrote:Both inputs identically partitioned using a key-based partitioning algorithm (hash or modulus) on the key column(s) used for the join. ...

I am not changing the lookup to join. I have changed the input partition of a lookup stage from auto to round robin but the result is different....

Thank you, Ray

In fact, the result file is correct even there are many null handling... warning. But I am afraid the no. of warning will reach the limit set when the input data become more.

How about suppress the warning? Is there any method to tell the job ignore the warning?

Lookup stage has limitation on the data size it can handle. Someone told me that the problem can be solved by partition. Therefore, I have tried to change a lookup stage input to use hash / round robin partitioning. But I find that the result is not the same. Why? And how can I solve it? Thank you i...

Any other solutions? The file has more than 50 columns... I don't want to enter the space one by one

All fields in a "fixed-width" file are a fixed width, even when 'null'. So your null value for that CHAR(11) field will need to be 11 spaces or 11 somethings but it needs to be specified ... Do u mean I have to set all nullable fields with space up to its length to the null field value to...

chulett wrote:For a fixed-width file, you need to specify a null value that is the full size of the field it is associated with. Is that what you tried? ...

Sorry, I do not understand "specify a null value that is the full size of the field"...
Currently I have defined the field as Char(11), nullable.

My datastage job is to export the result to a fixed length file which contains nullable fields. I get 'When checking operator: When validating export schema: At field "AMOUNT_30_DAYS": Exporting nullable field without null handling properties"'. I have tried to set the null field valu...