IF ISNULL(Column_Name.field) THEN default value ELSE (Column

How do u set a default value to a column if the column value
is NULL?

Question Posted / jayakumar

Answer Posted / jayakumar

IF ISNULL(Column_Name.field) THEN default value ELSE
(Column_Name.field)

Is This Answer Correct ?

4 Yes

4 No

Please Help Members By Posting Answers For Below Questions

what is the difference between == and eq in UNIX shell scripting?

1440

Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also

3136

What is ibm datastage?

924

how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.

3276

What are the benefits of datastage?

1191

Difference between sequential file and data set?

1146

What are the areas of application?

1102

What are the main features of datastage?

1216

What are the types of hashed files in data stage

1069

What all the types of jobs you developed?

1126

Define project in datastage?

1058

client know skid info?

2042

How do y read Sequential file from job control?

15826

How to RD using transformer?

1374

Define orabulk and bcp stages?

1080