RE: [sqr-users] RE: Date Validation

["Alexander, Steve" <Steven.Alexander@sanjoseca.gov>]

Krishna, it was unclear whether you said there were 6 dates in each line of
the input file or there were six characters in each date and one date one
each line of the input file.  Also, are the dates within a limited range of
time?  If the dates are six characters (no century) then there are only
36525 valid values repeated over and over for millions of dates.

Unfortuneately, SQR has no built-in date validation function, but there may
be programming tricks that are simpler than the code I sent you.  What can
you tell us about the dates?  How are they formatted and is there any
restriction to the values?



-----Original Message-----
From: James Womeldorf [mailto:jwomeldo@fastenal.com]
Sent: Friday, June 18, 2004 8:31 AM
To: 'This list is for discussion about the SQR database reporting
languagef rom Hyperion Solutions.'
Subject: RE: [sqr-users] RE: Date Validation 


Hi Krishna,
If there are a relatively small number of actual dates represented in the
file (lots of duplicates) perhaps you could store validated dates in a
string which delimits them with some odd character that you would NEVER find
in the date field.  Then, as a first test use INSTR() to see if a date is in
the validated list.  If not there, then check using Oracle.  It should cut
the number of database calls drastically.  
The only thing you would have to watch is that the validation string length
did not exceed the maximum string length for SQR (32767).  If the string
length would be exceed then just avoid adding any more dates to it.
Jim Womeldorf



-----Original Message-----
From: Krishna [mailto:knookula@yahoo.com]
Sent: Friday, June 18, 2004 9:33 AM
To: sqr-users@sqrug.org
Subject: [sqr-users] RE: Date Validation 


Well, currently I am validating all the dates from the input file by sending
the dates one at a time to Oracle and checking them whether the dates are
valid. If the the date is invalid then I am trapping the invalid date from
the ON-ERROR procedure. 
   I am trying to see if there are any other better method of date
validations in SQR. Number of records in my input file like I said earlier
is 2-3 million. The way I am currently achieving the task is by sending a
request to Oracle six times one for each date, since I have to write an
error log specifying which date is invalid in the input file for every
record read from the input file. 

                
---------------------------------
Do you Yahoo!?
Yahoo! Mail Address AutoComplete - You start. We finish.

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users