Search found 8 matches
- 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...
- 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...
- 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...
- 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
Thanks in advance for your help
- 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...
- 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 ...
- Fri Jul 20, 2007 3:29 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
- 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...