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 "fatal error/rdbms code 3996" error?

914

I have a few records just I want to store data in to targets cycling way how?

2122

What is ibm datastage flow designer?

881

what is the use of skid in reporting?

2126

What is the use of datastage director?

788

What are the some differences between 7.x and 8.x version of datastage?

995

Can you explain kafka connector?

1015

What is oci?

1074

Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.

1961

What is the difference between operational data stage (ods) and data warehouse?

947

What is the purpose of interprocessor stage in server jobs?

1948

What are stage variables?

871

Differentiate between data file and descriptor file?

802

What is the difference between server job and parallel jobs?

894

How do you run datastage job from the command line?

808