Schema files - default date

Sreenivasulu · Post by **Sreenivasulu** » Fri Jun 12, 2009 9:41 am

Hi All,

For date columns how do we define the default value. This would be applicable when the column is empty

I tried the default dataype for date used in datastage. It then asks to put the datatype for the column. If i give the column's datatype it asks to u se the datastage default format.

Regards
Sreeni

ddevdutt · Post by **ddevdutt** » Fri Jun 12, 2009 9:52 am

Can you be a little more specific, like what stage are you talking about? Can you also explain what is it that you are trying to do?

Sreenivasulu wrote:Hi All,

For date columns how do we define the default value. This would be applicable when the column is empty

I tried the default dataype for date used in datastage. It then asks to put the datatype for the column. If i give the column's datatype it asks to u se the datastage default format.

Regards
Sreeni

crouse · Post by **crouse** » Fri Jun 12, 2009 12:17 pm

My experience with dates on input is to define them as VARCHAR 10, then analyze and default them in a transformer.
Else, you run into issues of format, defaults, nulls, null lengths, null values... not worth it trying to define it in the schema.

-Craig

Sreenivasulu · Post by **Sreenivasulu** » Sat Jun 13, 2009 7:52 am

Hi,

Thanks for your response

I understand that we can use varchar. This solution is not applicable here since i use a single job to load 100 files using different schema files with different date formats.

Regards
Sreeni

crouse · Post by **crouse** » Sat Jun 13, 2009 8:24 am

Good luck.

So, do you have a solution to share?

Sreenivasulu · Post by **Sreenivasulu** » Sun Jun 14, 2009 5:18 am

No Not yet. But i think i am doing wrong somewhere. It should be possible.

Regards
Sreeni

crouse wrote:Good luck.

So, do you have a solution to share?

Sreenivasulu · Post by **Sreenivasulu** » Sun Jun 28, 2009 7:17 am

How to implement default date in a schema file

Any ideas ?

Regards
Sreeni

crouse · Post by **crouse** » Sun Jun 28, 2009 8:19 am

Define as varchar and check within a transformer or custom routine. You could have had that coded by now.

chulett · Post by **chulett** » Sun Jun 28, 2009 4:18 pm

What is your target? If it's a database, define your 'default' there.

ray.wurlod · Post by **ray.wurlod** » Sun Jun 28, 2009 4:35 pm

Schema files can only provide constants as defaults. It is not possible to provide "current date" as a default. It is, of course, possible to provide "1967-12-31" as a default date, since "1967-12-31" is a constant.

Sreenivasulu · Post by **Sreenivasulu** » Mon Jun 29, 2009 3:34 am

Thanks for your inputs.

I will try to fix it by having a default date as a 'value' instead of trying 'current date'

Thanks
Sreeni

DSXchange

Schema files - default date

Schema files - default date

Re: Schema files - default date