DSXchange

lpad equivalent: rpad equivalent: where
<string_of_spaces> is at least <length_of_desired_result> bytes in size

Regards,

You can't loop data back around within a single job...DataStage will complain that you have a data cycle detected and will abort the job. If you are using IS 8.5 or above, you may be able to use transformer looping to accomplish this by placing all of the holidays into a single delimited string (thi...

Set the extended property of the Timestamp column to microseconds. The default does not include microseconds.

Regards,

Have you tried any of those options to see if they work for you?

Why do you believe that the rounding type caters to only 10,2 decimals? That's a rather limiting definition.

Regards,

COMP-3 is Packed Decimal. Setting Packed = Yes provides Packed Decimal/COMP-3. Column -> Decimal( 9 ,2) as I stated previously, NOT Decimal(7,2). In DataStage, length is the total number of digits (before and after the decimal point), and scale is how many of those appear after the decimal point. In...

COMP-2 is a double-precision floating point data type, not packed decimal.

In Sequential File stage, set the Decimal Type to Packed in the column attributes. Your decimal column should be a Decimal(9,2) in DataStage.

Regards,

I don't believe there are changes in the Data Masking Pack for IS 8.5, 8.7 and 9.1. You can examine the New Features and Release Notes for 9.1 (a link is available here ) to see if there are any changes or improvements listed. If you suspect a performance problem with the pack, I recommend that you ...

I assume that you're not going to answer the questions you have been asked? :? In each of your reference data streams, add a column containing an integer with the value 1 (for TRUE). A Column Generator or Transformer can do this. This column will be used as an indicator to show the result of a looku...

Thank you for the explanation...it does clear up the questions regarding the individual reference sets, but now leaves some more detailed requirements open: 1) Do you need to keep any records which don't match at all to Ref1 or Ref2? If yes, what is the output value for TXN_DT? Will it be nulled, or...

StringToDecimal(lkGeidAdded.OVERRIDE_BALANCE_UNITS,6) Why do you include ",6" in your StringToDecimal() function call? This optional second parameter of the function is a string which indicates the type of rounding to be performed during the conversion, as documented here . This may likel...

As this is a Windows environment, did you properly create a dll library containing your parallel routine, as is documented?

Regards,

Have you selected "File" or 'File Pattern" in source/read method options on the output link tab? Try both to see if there is any difference in results. I don't have access to a DS server right now (visiting a client) or I would look up what I've done in the past. Looks like they have ...

which seems to be more forparallelising the read in case of mulitple files by treating it as a FileSet That is its primary purpose, but a side effect of that is that you are returned the actual filenames. The pattern alone (without the env variable set) causes the operator to concatenate the matchi...

There is a Combinabilty Mode option under the Advanced tab, no need to force a copy stage in between.

Regards,

From a purely conversion-only point of view, I agree: no difference. It's largely a personal preference and habit in my case. Re making sure the input is in the correct formation: I push back for cleaner data where and when I can, but if I have to go through the effort in my job to format and valida...