January 11, 2012, 01:31 PM
ray_In_VancouverPassing Nulls to Sql Server
In My synonym I have
DEFINE MYDATE/MDYY MISSING ON=IF LENV( TRIMV('T', DLVY, 20, ' ', 1, 'A20V'), 'I8') NE 0 THEN
DATECVT(EDIT( TRIM('T', DLVY, 20, ' ', 1, 'A20'), '99$99$9999' ), 'A8MDYY', 'MDYY')
ELSE
'';
But when the flows run it inserts 1900-12-31 00:00:00 where ever a date was not given. I thought 'MISSING ON' passed Null to the targate sql
January 12, 2012, 06:09 AM
j.grossTry
ELSE MISSING;
in place of
ELSE '';
'' represents the date value that WebFocus displays as blank (and 12/31/1900 is reserved for that purpose); MISSING, the null value, is something else.
January 12, 2012, 10:06 AM
ClifInstead of ELSE '' use ELSE MISSING.
January 12, 2012, 04:10 PM
Dan SatchellIf ELSE MISSING doesn't solve the problem, you may need to SET DATEDISPLAY = OFF at the top of your program to prevent the base date from populating null dates.
January 13, 2012, 04:07 AM
MadasabearAlso include SET HOLDMISS = ON at the top of your code , this will ensure
that when you issue the ON TABLE HOLD AS something FORMAT SQLORA any missing/nulls
will not get populated with a default date.
January 13, 2012, 10:48 AM
ray_In_VancouverELSE MISSING Got it.
thanks everyone