RE: [sqr-users] RE: Date Validation

[James Womeldorf <jwomeldo@fastenal.com>]

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