DSXchange

Does anyone know what this error means? It does not tell me where in my job the error is occuring, so I cannot get it corrected. main_program: Fatal Error: Caught ORCHESTRATE exception in main program: APT_ParseError: Parsing parameters "" for schema type "decimal": Expected prec...

Yes, I am trying to get the date with the delimiters removed

I am trying to convert a date field to a decimal and am using the following: StringToDecimal(DateToString(DSLink218.SRVC_DT,"%yyyy-%mm-%dd"))

The results from this are all zero. Does anyone know why? Thanks.

joinDMMem: When checking operator: User inserted sort "joinDMMem.inMem_Sort" does not fulfill the sort requirements of the downstream operator "APT_JoinSubOperator in joinDMMem"

Yes, I did do multiple searches, but didn't find anything that seemed to apply. If you can point me to a post, I would appreciate that.

I am new to datastage, but have noticed that if I leave joins on auto partitioning, I often get invalid results. I was told that when I experience that, to change the partitioning to hash and sort the data. Why would I get different results from auto partitioning and opposed to hash partitioning? Th...

I have a join with two inputs. Both inputs are hash partitioned and sorted on one field (the field used in the join). I am getting the warning that the user inserted sort does not fulfill the requirements of the downstream operator APT_JoinSubOperator in JoinName . What does this warning mean? How d...

Yes, the source data comes from Oracle unbounded number fields. I used the orchestrator to import the metadata--but does that have an affect on the oracle stages? I was under the impression that you could paste a query into an Oracle stage without having imported the table definition.i I did search ...

Can someone explain to me why datastage seems to default all numbers to the decimal datatype? I am using Oracle tables, with columns all defined as number and all integers, but it seems as though datastage trys to make the integers into decimals. I get a lot of warnings about scale, when my numbers ...

I'm getting the warning "Floating point decimal is not fully supported; adjusting the scale" in a lot of my oracle stages. My oracle query is putting the data into integer columns. Why am I getting this warning and how do I correct it? Thanks.