Hi,
I have been struggling to insert a Null value into one of the mandatory column(which allows Char data only) when no value is passed to it.
The problem area is :
I am trying to load data from a sequential file to the Sybase database. The last column in the row is mandatory but if no value is passed to it then a Null value must be stored in the database.
But if the file data contains Null as the column data then the '?' mark in the Insert statement is internally replaced with 'Null' i.e. a hardcoded string(enclosed in single quotes) which creates error.
I simply want to send the value as Null (without enclosing in single quote) which is acceptable in Sybase.
I have also tried replacing the '?' mark with Null as required but it didn't worked anyway.
How can I send the Sybase acceptable Null (without enclosed in single quotes) from my insert job?
Many Thanks in advance...
Null value handling
Moderators: chulett, rschirm, roy
Hi,
Placing a @NULL as the derivation of a column in a transformer stage should work, if the column is nullable by DB definition.
When you say a mandatory coulmn I assume the column is defined as not null in the DB which won't allow this kind of data, or rather lack of data in the column.
So if your column is defined as not null you must have a value inserted, hence you can choose to put the string 'NULL' if this is your need.
IHTH,
Placing a @NULL as the derivation of a column in a transformer stage should work, if the column is nullable by DB definition.
When you say a mandatory coulmn I assume the column is defined as not null in the DB which won't allow this kind of data, or rather lack of data in the column.
So if your column is defined as not null you must have a value inserted, hence you can choose to put the string 'NULL' if this is your need.
IHTH,
Roy R.
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Roy,roy wrote:Hi,
Placing a @NULL as the derivation of a column in a transformer stage should work, if the column is nullable by DB definition.
When you say a mandatory coulmn I assume the column is defined as not null in the DB which won't allow this kind of data, or rather lack of data in the column.
So if your column is defined as not null you must have a value inserted, hence you can choose to put the string 'NULL' if this is your need.
IHTH,
Thanks very much for timely help.
The mandatory column here does allow a Null value as per the table definition.
Well, using @NULL has resolved the issue at the moment but I need to look into this more later on.
