I would like to pick all of your brains for a bit on this topic. It is generally known that if you have a Nullable column, and you need to convert it to Non-Nullable, you need to address what to do for those records with NULL values.
The one method I am aware of is using the Transform stage, and the following routine:
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
That would work for Server, but using the PX Transform stage? I am probably missing something big here if I am able to create a function that can be used by that stage.
-T.J.
Developer of DataStage Parallel Engine (Orchestrate).
The Sequental File Stage (Import/Export Operator) allows NULL values to be replaced with a VALUE. (using the Column Property -> Nullable -> Null Field Value).
The Sequental File Stage (Import/Export Operator) allows NULL values to be replaced with a VALUE. (using the Column Property -> Nullable -> Null Field Value).
Somehow it doesn't work for me. I'm trying to process a delimited sequential file but I keep getting errors from the import phase that says something like -the null-value field must be the same size as the field (a specific one)- !
Then I went to the column definitions and went column by column and changed the default nullable property ! My god I have 390 columns
Isn't there any other way
I would like to pick all of your brains for a bit on this topic. It is generally known that if you have a Nullable column, and you need to convert it to Non-Nullable, you need to address what to do for those records with NULL values.
The one method I am aware of is using the Transform stage, and the following routine: