For 4 digit year formats the separators are fixed!!!
The following formats are valid:
'YYYY-MM-DD' = ISO, JIS
'MM/DD/YYYY' = USA
'DD.MM.YYYY' = EUR
SET OPTION only reflects the attributes that can be set with STRSQL or
iSeries Navigator's Run an SQL Script.
... and just try to change the date separator for a four digit year format
in this environments.
A date separator can only be set for a 2 digit date format.
Mit freundlichen Grüßen / Best regards
Birgitta Hauser
"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"
-----Ursprüngliche Nachricht-----
Von: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] Im Auftrag von rob@xxxxxxxxx
Gesendet: Thursday, 29. July 2010 17:05
An: Midrange Systems Technical Discussion
Betreff: Re: SQL Newbie Question about Dates
-- The SET OPTION statement is only allowed in REXX, in a precompiled
program, or in SQL routines. In a precompiled program, it must be the
first
SQL statement in the program.
http://publib.boulder.ibm.com/infocenter/iseries/v7r1m0/topic/db2/rbafzsopti
on.htm
See if you can play with it to get this to work
set option datsep='/';
insert into qtemp/kirk values('1999/11/11');
But me, I'd start using the ISO standard '-' instead.
Rob Berendt
midrange.com
