The system defined default value for a date column in DB2/iSeries is always "current date". How can we change that to '01/01/0001' (*LOVAL) ?
When I insert a record via RPGLE, the date fields always default to *LOVAL.
Whereas, when I insert a record using SQL (or an ETL Tool like Informatica) it picks current date as the default value for the date field.
Please note - Date field is defined as "NOT NULL WITH DEFAULT"
I don't want to edit the DDS for each date field and manually override the default value. (using option DFT)
Is there a way to override the default value for an entire DB Schema?
Any ideas would be greatly appreciated.
When I insert a record via RPGLE, the date fields always default to *LOVAL.
Whereas, when I insert a record using SQL (or an ETL Tool like Informatica) it picks current date as the default value for the date field.
Please note - Date field is defined as "NOT NULL WITH DEFAULT"
I don't want to edit the DDS for each date field and manually override the default value. (using option DFT)
Is there a way to override the default value for an entire DB Schema?
Any ideas would be greatly appreciated.
Comment