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

Answer Posted / suresh

in the column extended properties set the desired value if
it is null

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination

1627


AGGREGATOR default datatype

931


What are the repository tables in datastage?

819


What is job control?

621


What are the main features of datastage?

659






What are the different plug-ins stages used in your projects?

621


What are the types of views in datastage director?

1243


What are the differences between datastage and informatica?

568


What is "fatal error/rdbms code 3996" error?

663


Where do you see different stages in the designer?

628


how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)

521


What is the use of hoursfromtime() function in transformer stage in datastage?

580


What is the use of datastage director?

586


WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE

3263


what is ds administrator used for?

718