DSXchange

Hi,
I have a job:

Oracle extraction - file sequential.

Some fields are nullable, and I want them null. But I have some discard, the message is the following:

Rss_Consistenza_file.Estraz,0: Field "FIELD1" is null but no null export handling is defined
Rss_Consistenza_file.Estraz,0: Export unsuccessful at record 3 (continuing) :
..........

Could anyone help me?

Thanks

look at the columns list in the sequential file and double click on the row number (left hand side), this brings you up another screen that allows you to set the -> Nullable -> Null Field Value.

This allows you to set the character string you are using to mean NULL that is written to file.

[quote="Eric"]look at the columns list in the sequential file and double click on the row number (left hand side), this brings you up another screen that allows you to set the -> Nullable -> Null Field Value.

This allows you to set the character string you are using to mean NULL that is written to file.[/quote]

I'd like to know if it is possible to leave the NULL value in the file without without being substituted by another string

Essentially the answer is NO.

NULL is a meaningless concept in a text file. If you want the internal database representation of null, you will find that this varies between databases, and would mean that your text file is probably a binary file (there's no guarantee that the internal representation of null doesn't contain 0x0D either, which would really foul you up).

If you want the null fields in your text file to contain zero-length strings (""), do nothing. This is the default for the Sequential File stage.

The problem is that the record with null values are doscarded and not written in my file. Why?

Because you have not specified null handling.

Just to note:
When you use a 'special character sting' to represent a NULL in a text file.

When you read that text file back into DataStage you can tell DataStage that the 'special character string' means a null, so when you load data back into a database you again have a NULL value (rather that your special string).

lory,

Use NVL function of Oracle in the select clause. It is best to handle null there.

Regards
~Amitava

Hi Amitava,

Using the NVL function in oracle will not resolve the warning. The record will not be discarded but the warning will still persist. The best way to handle this situation is using the Null handling feauture available in Field properties of sequential file stage as described by Eric and Ray.

Rich

Ok, as a newbee I have a question about this null handling. I was not doing anything on null handling and the job started to give a lot of null errors. So, after doing a search on the board here, I decided to try null field length = 0 approach.

This time I am getting as an error.

Dealing with these nulls is becoming pretty annoying at this point..