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...
5 results in 0.0018 seconds.
-
Override System Default Value - Date Column
-
Date format to char conversion in rpg
I have beeen receiving a date timestamp error in my rpgle at a statement:
result=%char(field:*iso)
where result is 10A and field is of D format type.
I have been pushing a iso type value eg: '2013-05-05' into field, yet the timestamp issue persists.
... -
Change source date of RPGLE
Is there any way by which one can change the iSeries system settings to accordingly manipulate source date change on Line of Code.
This has accidently happened with me that an unwanted section of code was unwantedly changed which has caused an obvious change in the dates along those LOCs.... -
How to retrieve system date from display file to rpg program
I have a display file that is defined as decimal date.I want it to fetch the system date and be used a variable in my rpg program.
I have defined a PF that has a date variable 6 length 0 decimal PACKED.I am aware that by using *DATE in display file we can fetch system date.But i want... -
*DATE returns wrong value when called by a .NET page
This is a weird situation we have having. We are using C# (dot net) to launch a program that prints some stuff to the spool. The problem is that the report uses *DATE to print the current date in the report, and the date always show 21/06/2008! (june 21 2008) We can only guess that the interop ...