Search found 8 matches

by fleurlisalu
Thu Sep 20, 2007 4:49 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: warning: "decimal[10,2]" to result type "int3
Replies: 1
Views: 1503

warning: "decimal[10,2]" to result type "int3

hello, i have many warnings when i do sum(X) as X, X is decimal(10,2): exemple: OCI_DTW_MVT_PHY_PAL: When checking operator: When binding output interface field "Q_PALETTE_RCP_NP" to field "Q_PALETTE_RCP_NP": Implicit conversion from source type "decimal[38,10]" to resu...
by fleurlisalu
Thu Aug 09, 2007 2:02 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: division
Replies: 6
Views: 3614

The latter two are just warnings - alerts, if you prefer. The first is coming from a composite operator - you need to prevent operator combination to determine which stage is actually generating it. ... i don't know if it's a warning but i can't compil my job and so I don't execute it, i don't know...
by fleurlisalu
Wed Aug 08, 2007 6:28 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: division
Replies: 6
Views: 3614

division

What is there desired output and what is the data type of the mapped column?? What is there desired output and what is the data type of the mapped column?? In output i would like a decimal(10,2) decimal(10,2)/integer = decimal(10,2) but it's bad the error is : ##W TFCP 000000 14:26:39(002) <transfo...
by fleurlisalu
Wed Aug 08, 2007 4:04 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: division
Replies: 6
Views: 3614

division

hi!! I would like that : decimal(10.2)/integer but I have errors at the compilation, I have to test AsFloat (A) /AsFloat (B) and DecimalToDFloat(A)/AsFloat (B) but that does not go, which must I do?
Thanks in advance for your help
by fleurlisalu
Fri Jul 27, 2007 9:52 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Sequential_File
Replies: 5
Views: 3562

Sequential_File

in ODS, the field is nullable, and when i load in a sequential file,i have a warning in director: Sequential_File_119: When checking operator: When validating export schema: At field "HORAIRE_CONTRAT": Exporting nullable field without null handling properties i can't modify the field, beca...
by fleurlisalu
Mon Jul 23, 2007 10:25 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: invalid length date
Replies: 2
Views: 1907

invalid length date

hello!, I have an erreur when I want load a table in the data warehouse it's : invalid length for DATE or NUMBER bind variable I tried to load the table without date and it's ok but when I put a date it's not ok , my type date is timestamp in my DBMS(ORACLE 10g) it's timestamp too. I don't know how ...
by fleurlisalu
Thu Jul 19, 2007 8:18 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: how can i know if there are a sundy between 2 dates?
Replies: 2
Views: 1278

how can i know if there are a sundy between 2 dates?

how can i know if there are a sundy between 2 dates? i have a condition for calculating a indicator, for exemple: date1=01/07/07 et date2=19/07/07, how can i know there are a sundy between date1 and date2? i have a table of "day" to know "what day is today?" how can i do it? my e...