DSXchange

Does what you're doing work? The only improvement I could suggest would be to use stage variables for clarity and to avoid multiple calculations of the same function. Maybe use Left() function to test for the sign, if the input column data type is string. The problem with the above is it will take ...

Hi, I have stage variable decimal(14,2) say: 666665555555.12 output needed: 5555555 Input: -666665555555.12 Output: -5555555 I would like to truncate any thing after decimal point and take right 7 digits before decimal. My destination column is Varchar 8. I am using the following: if col<0 then &quo...

The "VOC" is a hashed file, which can be treated as if it were a table. This contains not only the keywords used by the engine itself, but also pointers to all files used by all jobs; i.e. by creating a new job you will implicitly make several changes to the VOC; thus there is little to b...

Hi We see the VOC file for the project got changed. We want to login to the VOC file and see what got changed. As our project is locked and giving following error: ACCESS DENIED: Project Currently locked. The project is currently locked by the administrator. Try again later or see your administrator...

Decimal 16, 2 --> 16 is the total lengh. Out of which 2 is decimal. So 16 bytes for numbers to hold. One by for the '.' Sign byte in the front will be always allocated. It will be space if there is not '-' sign. Either one of below. 00000000000001.00 -00000000000001.00 Hence total 18. Thanks kumar ...

18 = 16 + 2( One char for dot and one char for sign ) decimal16,2) If +ve number then it is: 00000000000000.00 if -ve number then it is: -0000000000000.00 if negative sign is there then one zero will be less. So we should need varchar (16)+1 for decimal. =varchar(17) correct me if i am wrong.

Hi

I have a Decimal(16,2) field in Datastage odbc stage.
I want to convert this to varchar.

I am using decimaltostring conversion.

What shall be the exact length of Varchar to hold decimal(16,2)

Appreciate reply.

Hi, I am getting following warning in odbc stage: oratils: When checking operator: When binding output interface field "ITDY" to field "ITDY": Implicit conversion from source type "decimal[38,0]" to result type "decimal[38,10]": Possible range limitation. We i...

the output needs to be dfloat or decimal. in case output is dfloat remove preserve type, if decimal, use default to decimal property. Else use any one of these and use modify stage afterwards to convert it back to datatype you want. Thanks for the reply!! My input is varchar and also as varchar. It...

What about giving some more details. It just says that you have selected two properties in aggregator which are mutually exclusive and can't be used together. for an example, sum and preserve type. Yes, i have choosen Sum and Preserve type. Can i not use this two properties. if yes then what shall ...

I am getting following error:

Aggregator_111: When processing argument -reduceWhen processing sub-arguments: "
When processing argument -reduceWhen processing sub-arguments: Arguments are mutually exclusive: "


Help is appreciated to resolve this.

I use the dscmdexport.exe command wrapped in a batch script that is scheduled from Windows client (that contains DS client) to create the dsx file. It creates a single dsx file for a project and contains jobs, routines, table defintions, executables etc. Whenever I want to split them into individua...

ArndW wrote:If you go to your source stage, double-click on the number at the left of the column or right-mouse click and "edit row" and then see if that column might have a default value set.

I checked it doesn't have a default value set.

ray.wurlod wrote:Do these columns have default values defined at any point in the processing?

No this column doesnot have any default value.

Decimal data type is always converted to string (including in View Data) with leading and trailing non-significant zeroes. If you don't want them, you have to get rid of them, typically using a Trim() function. Thanks Ray Wurlod. But i still dont understand the following: When my source field is Nu...