DSXchange

Hi,
when i use the APT_RECORD_COUNTS environment variable it shows this operator "APT_CombinedOperatorController" consuming a lot of cpu.
Is it possible for me to know what this combined operator is doing???

hi,
i am reading decimal fields from sequential file, if the record contains invalid decimals the record is not getting dropped instead DS is reading the value as all 0's. Is this the default behaviour of DS or is there any setting that needs to be done to make datastage do this???

hi,

My job got aborted due to network issue i a need to recompile in order to re run it. I want to know why it is always necessary to recompile if a job aborts, is there any specific reason???

Hi, I have a column of length 3 of type char in a db2 table but the field contains only one aphabet. i am reading using db2 stage into a field defined as char(3) but surprisingly Datastage is not padding the spaces even if the APT_STRING_PADCHAR is set to 0x20. What is the reason behind this ? need ...

Hi, I have a column of type Char(3) in a db2 table, its having only one alphabet and rest spaces, i am triming the field in the db2 select querry and putting it in a field defined as char(3). i can see that there are no spaces appended to it by selecting view data option. The problem is that all the...

hi,
I have not specified any schema file in a job but specified the metadata in the columns tab and if i enable RCP will it carry the metadata to the following stage or only schema file should be used if i need RCP to be enabled?

Hi,

I have to make a join on 4 keys between 2 datasets. the keys are ACB,ACS,ACX,ACP. do i need to hash partition on all 4 keys or is it sufficient to make hash partition on 1 key.

hi,
I am planning to purchase premium membership but have one question in mind.
can i login from multiple pc's or will it allow only one ip address to log on?

In my project the default value for APT_STRING_PADCHAR is 0x0. i am mapping 'HUB' to a field char(5), now when i view the data at the target i dont see any characters padded to this value. can anyone explain what is this '0x0' and what happens when this is padded. In between i am using a transformer...

Hmmm... 13? New number here. Sure, leading spaces can be trimmed from a char field. It's the trailing ones being discussed as problematic here, the "padding" that is automatically done for the data type to its full size. Sorry if that wasn't clear. sory it was 3 not 13. one more doubt!! w...

All things are possible, but think about it. Out of the box the only values that may match to the char(1) are 1 character values in the char(3) field, is that what you need? Or are they a match if the first character is the same in both fields? You'd have to tell us what your match rules are. you a...

chulett wrote:And by "join" you mean in the database / sql sense rather than say, concatenation, yes? What are your rules for "joining" a char(1) with a char(3)? ...

isn't is possible to join char(1) field with char(3) field???

chulett wrote:Yes. ...

If i don't specify the length while reading the sequential file, even then would it do the same?

chulett wrote:Joining to another char field of the same size? If so, then no trim needed. If something else, then please explain. ...

I need to join this field with another field of length char(1)

narasimha wrote:Is it ok if you do not do the conversion from varchar to char? Then the TrimLeadingTrailing function would work.

The problem is that i need to convert it to char. so i am searching for a solution!!!