IsValid() problems with non-standard dates

[ray.wurlod]

Well, there's always a specific-to-purpose parallel routine that you could implement. What are the three possible formats? C should be fast enough to do range checks on the components.

(I am getting above 15000 rows/sec through a server job Transformer stage using that IsValid function, and more using a cut-down version just doing date validations. Rows are about 80 bytes in size, server is a fairly beefy Windows box. The job is selecting from Oracle and writing to a text file.)

[ArndW]

It would seem that there is ECase 118247 open on this issue and is states

(contray[sic] to the documentaion[sic]) that IsValid only accepts date format %yyyy-%mm-%dd

. I am pursuing this, as I don't think that is acceptable and will update this thread when it gets resolved one way or the other.

[soumya.mazumder]

Hi,

I have a similar problem with the isvalid function. My In.col = 20080101
I gave IsValid("date", StringToDate(DECTOSTRNGAC,"%yyyy-%mm-%dd")) in transformer. But this function is always returning 0 for any type of dates.

[soumya.mazumder]

Hi,

I have a similar problem with the isvalid function. My In.col = 20080101
I gave IsValid("date", StringToDate(DECTOSTRNGAC,"%yyyy-%mm-%dd")) in transformer. But this function is always returning 0 for any type of dates.

[soumya.mazumder]

Hi,

I have a similar problem with the isvalid function. My In.col = 20080101
I gave IsValid("date", StringToDate(DECTOSTRNGAC,"%yyyy-%mm-%dd")) in transformer. But this function is always returning 0 for any type of dates.

[trammohan]

Try this
IsValid("date", StringToDate(DECTOSTRNGAC,"%yyyy%mm%dd"))

[dspxlearn]

Hello ArndW,

By an chance, did you get to hear anything from IBM guys on this Ecase?

Code: Select all

It would seem that there is ECase 118247 open on this issue and is states