If IsNull(link_name.column_name) then 'default

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

Question Posted / danny archer

7 Answers
35745 Views
HP, I also Faced
E-Mail Answers

Answer Posted / danny archer

If IsNull(link_name.column_name) then 'default_value' else
link_name.column_name

Is This Answer Correct ?

19 Yes

4 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?

2375

What are the types of hashed files in data stage

1108

Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC

1416

What is the use of datastage director?

1017

Define Merge?

1320

Define meta stage?

1205

What is oci?

1302

What is the purpose of pivot stage and types of containers in datastage

1041

What is the purpose of pivot stage?

1168

How to reverse the string using SQL?

1533

Triggers,VIEW,Procedures

1221

What are the different types of lookups in datastage?

1054

1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do

2085

What are the types of views in datastage director?

1775

How to reverse the string using unix?

3510