Search found 20 matches

by mjohnson62982
Thu Nov 02, 2017 12:07 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Filtering out a specific date
Replies: 7
Views: 3409

Sorry it is not quoted, and the field's datatype is date. Thanks.
by mjohnson62982
Thu Nov 02, 2017 10:40 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Filtering out a specific date
Replies: 7
Views: 3409

Here is the copied text of what I have in the Where Clause...

Code: Select all

Level_Status_Expiration_Date <> 1900-01-01
by mjohnson62982
Thu Nov 02, 2017 10:13 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Invalid conversion requested from a date to a int64
Replies: 3
Views: 3438

Resolved

I resolved this by putting the DateFromDaysSince() function in the Column Derivation field. Thanks for the help everyone.
by mjohnson62982
Thu Nov 02, 2017 10:03 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Filtering out a specific date
Replies: 7
Views: 3409

Filtering out a specific date

I am trying to filter out a specific expiration date. I am currently using a filter stage with a where clause: Level_Status_Expiration_Date <> '1900-01-01' I get the following error: Expiration_Date_Filter: Parse error: Expected 'is' statement ('is true', 'is false') or boolean operator (and, or) go...
by mjohnson62982
Wed Nov 01, 2017 12:36 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Invalid conversion requested from a date to a int64
Replies: 3
Views: 3438

Invalid conversion requested from a date to a int64

I am trying to convert a decimal field to a date using the DateFromDaysSince function. The constraint looks like this; DateFromDaysSince(CFPTA_Con.DSTRTA,'1900-01-01') I am getting the following error while compiling. Error in constraint expression for link DSLink4. Invalid conversion requested from...