Search found 91 matches
- Wed Jul 10, 2013 5:16 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: HELP!!! - Field is NULL Record dropped
- Replies: 14
- Views: 12083
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...
- Wed Jul 10, 2013 3:33 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: HELP!!! - Field is NULL Record dropped
- Replies: 14
- Views: 12083
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...
- Wed Jul 10, 2013 9:32 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: HELP!!! - Field is NULL Record dropped
- Replies: 14
- Views: 12083
- Wed Jul 10, 2013 9:27 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: HELP!!! - Field is NULL Record dropped
- Replies: 14
- Views: 12083
- Wed Jul 10, 2013 9:25 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: HELP!!! - Field is NULL Record dropped
- Replies: 14
- Views: 12083
- Wed Jul 10, 2013 8:01 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: HELP!!! - Field is NULL Record dropped
- Replies: 14
- Views: 12083
- Wed Jul 10, 2013 7:19 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: HELP!!! - Field is NULL Record dropped
- Replies: 14
- Views: 12083
HELP!!! - Field is NULL Record dropped
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>) = ""...
- Sat Jul 06, 2013 4:49 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Fatal Error: Invalid time
- Replies: 10
- Views: 5161
- Thu Jul 04, 2013 9:19 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Fatal Error: Invalid time
- Replies: 10
- Views: 5161
- Wed Jul 03, 2013 4:34 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Fatal Error: Invalid time
- Replies: 10
- Views: 5161
- Mon Jul 01, 2013 5:52 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Fatal Error: Invalid time
- Replies: 10
- Views: 5161
Fatal Error: Invalid time
Hi to everyone,
is there a way to check if an input is a date in a transformer stage?
tks
is there a way to check if an input is a date in a transformer stage?
tks
- Thu Jun 27, 2013 3:21 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Null handling flat file
- Replies: 9
- Views: 5928
- Wed Jun 26, 2013 9:53 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Null handling flat file
- Replies: 9
- Views: 5928
- Wed Jun 26, 2013 9:14 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Null handling flat file
- Replies: 9
- Views: 5928
- Wed Jun 26, 2013 8:03 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Null handling flat file
- Replies: 9
- Views: 5928
Null handling flat file
how do I handle null fields when I read a flat file?
When I read, discard the records.
thank you in advance
When I read, discard the records.
thank you in advance