DSXchange

chulett wrote:You can't trim spaces from a char. Why not simply check for = 'IN ' instead? ...

i need this field to make joins, so should trim it.

For example:

A field 'ID' is Varchar(10) and having a value "abc", if this field is directly mapped to "IP_ID" char(10) in a transformer, would it append 7 spaces to "IP_ID".

Hi, I am trying to read a sequential file having 10 columns all defined as varchar. A transformer stage follows the sequential file where i am converting some varchar to char. There is a field 'GMAB' of length 3 having value 'IN ' for all the records. In the transformer stage i am using TrimLeadingT...

hi, basically the sort stage sorts the data within the partitions. at the o/p of the sort stage the data is sorted within the partitions and when writing to dataset the data from all partitions gets collected, thereby if u look at the entire set of data the sorting looks as if it is lost. To avoid t...

Hi Guys, I am using a DB2 stage to write to a table and the Default String Length property is set to 32 bytes. what would be the length of varchar field being written into the table, would it be 32 for all entries or would it be the length of the data being written? For example if i am writing 'sam'...

Hi,

I need to know from where i can download the following guides for PX 7.5.1.

Parallel job developer guide
advanced Parallel job developer guide
director guide
server job developer guide
manager guide
administrator guide