Empty Date Type Variable
70 pts.
0
Q:
Empty Date Type Variable
 

What does a *ISO Date type variable contain if it is not populated?

It is not *Zero or *Null???

 

ASKED: Aug 12 2009  10:10 AM GMT
0
2435 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
Initialization depends on a number of factors but generally the date field is initialized to 0001-01-01
You could answer this easily/

D testdateiso s d datfmt(*iso)
C testdateiso dsply
C eval *inlr = *on
C return


____________________________________________________

It depends on where / how you dfefine it. Usually it defaults to *LOVAL or 0001-01-01. However, just adding a field to a file may result in an unpopulated field that will cause errors. (Depending on how the field is defined in DDS or SQL). Neither zeros not null is a valid date. If you have this in your database, you will get errors.

Graybeard52
Last Answered: Aug 12 2009  1:56 PM GMT by Graybeard52   2435 pts.
Latest Contributors: Philpl1jb   24610 pts.
0
0
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



0