DSXchange

In Oracle and DataStage the datatype is the same Source field (Oracle) is: Varchar2(50) Nullable (source value=NULL) Target field (Oracle) is: DATE Nullable in DataStage (Transformer) the source column is VarChar 50 Nullable and the target column is Timestamp 38 Nullable There're no fatal errors but...

I checked the documentation before using it and I understood what you said but did not work. I will try again but the problem is not this. The problem is what I wrote in the post. The same code works fine if the source is a flat file but does not work (WARNING dropping records) if the source is a Or...

Therefore, the syntax would be

IsValid("timestamp", <field>)?

Prasson_ibm put the costraint because I have a reject link

does anyone know the solution?

I tested it on other jobs and it works perfectly

Hi, I've a big problem for me. I've a job: Ora Ent ---> TX ---> Ora Ent The problem is on trasformer and is as follows: APT_CombinedOperatorController,2: Field '<field>' from input dataset '0' is NULL. Record dropped. It's a warning. the constraint is: IsNull(<field>) Or Trim(<field>) = ""...

My DS version is 8.1

I don't know the syntax of IsValid() to check a timestamp

I've, in a file...

NAME;YYYYMMDDHH24MISS;LOCATION

I need to check if timestamp field is a valid timestamp

tks

Yes, but I find only "isValid()" function.

There're not other functions like IsValidDate or IsValidTimestamp.

I need to check if a string is a timestamp

thank you

I'm sorry,
I cannot see "premium content".

thank you anyway.

Hi to everyone,
is there a way to check if an input is a date in a transformer stage?

tks

are being discarded and I want to process them as nulls.

it's not valid for all types (timestamp,decimal, etc...)

to all types of field?

how do I handle null fields when I read a flat file?
When I read, discard the records.

thank you in advance