DSXchange

Need to validate
if the following formats are correct:


YYYYMMDD
Date:
if isValid ('DATE', StringToDate (StageVar, "% yyyy% mm% dd")) Then StageVar else 0

HHMMSS
Time

isvalid (HH: MM: SS)

Please confirm if it is correct

This topic seems to reply to your concerns

Regards,
eph

eph wrote:This topic seems to reply to your concerns

Regards,
eph

ok

but yet need to validate if the following formats are correct:

HHMMSS

isvalid (HH: MM: SS)

thanks

IsValid("time",timestring)

Where timestring is in the format HH:MM:DD (or the default format if different).

Regards,

will be appropriate if there are no delimiters.

For 8.1? Not FP1, at least

For 8.0.1 (at least according to the manual) and therefore, presumably, for 8.1.

Parallel Job Developer's Guide (8.0) wrote:result (int8) = IsValid(type (string) [, format (string)])

(page 601)

The 8.1 docs have the same entry (and so do the 7.5.1a docs), but I think it was a typo that never got corrected. It should be (IMHO) With type being one of the datatypes and string being the value being validated. At least that is what the transformer derivation validator allows.

When I run this derivation: I get this message and a result of 0: That's on two different 8.1 FP1 systems, one RedHat and one AIX.

c'est la vie

D'accord.

I tried the third option in 8.1 as well and it wouldn't pass validation.

jwiles wrote:I tried the third option in 8.1 as well and it wouldn't pass validation.

isvalid('DATE',StringToDate(Lnk_campo,"%yyyy%mm%dd"))

isvalid('TIME',StringToTime(Lnk_encabezado.CHDHTR_E,"%hh%nn%ss"))

Those work, but mainly because Date, Time and Timestamp datatypes return a string of asterisks '*' when the data is invalid. In a sense, the datatype is performing the validation for you.