Schema files - default date
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 892
- Joined: Thu Oct 16, 2003 5:18 am
Schema files - default date
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
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
Re: Schema files - default date
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
DD
Success is right around the corner
Success is right around the corner
-
- Premium Member
- Posts: 892
- Joined: Thu Oct 16, 2003 5:18 am
-
- Premium Member
- Posts: 892
- Joined: Thu Oct 16, 2003 5:18 am
-
- Premium Member
- Posts: 892
- Joined: Thu Oct 16, 2003 5:18 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Premium Member
- Posts: 892
- Joined: Thu Oct 16, 2003 5:18 am