DSXchange

What load method are you using and are these VarChar2 columns? ... Using an Upsert mode with a user defined update only. i have a insert statement instead of update. all columns are varchar2. with in the oracle stage, in the insert statement if i use trim(orchestrate.column), i dont see these chara...

What load method are you using and are these VarChar2 columns? ... Using an Upsert mode with a user defined update only. i have a insert statement instead of update. all columns are varchar2. with in the oracle stage, in the insert statement if i use trim(orchestrate.column), i dont see these chara...

ArndW wrote:APT_STRING_PAD_CHAR ...

its a single space. when its a varchar, how does this matter?

Hi, I have a datastage job in which the source and target are defined as varchar,but while inserting into the database where the column is defined as 50, i see ^z (ascii 32) being inserted into the table. if input is say "abc" in the database i see abc padded with ^z till 50 bytes. it app...

Hi, I have a datastage job in which the source and target are defined as varchar,but while inserting into the database where the column is defined as 50, i see ^z (ascii 32) being inserted into the table. if input is say "abc" in the database i see abc padded with ^z till 50 bytes. it appe...

Hi,

if we are using a oracle enterprise stage with load option, where is the control file created and where do the logs go to?

Hi

What is the best way to handle multi byte character datasets in datastage. We have NLS mapped to UTF-8. Will this handle all the cases. we are facing issues in oracle enterprise stage because of this.

kumar_s wrote:Dsxchange helps you. And so you got to help Dsxchange by paying Membership fee. ...

A regular insert worked fine with the same data,but the load fails

kumar_s wrote:Dsxchange helps you. And so you got to help Dsxchange by paying Membership fee. ...

thanks, i tried taking the membership for 50$, there was some error when i actually tried to pay, after that the fee was hiked.

anyway the datatype is varchar

There is a ecase 92389 already open for this. "If a partial mutibyte character is at end of string, U_TRUNCATED_CHAR_FOUND error and string is nulled. Customer requires replacement character and a ... Hmm i cant see it. Since its already a case error and not the knowledge of a premium member,c...

kumar_s wrote:But the metedata of the target table could be different from the Metedata specified Datastage. ...

I verified that,they are the same.

Check for the input data, if you have any string, whose length is more than the specified metadata. ... When the dataset reads the data, will it not read according to the metadata length? if i specify a column as 50, though the input is 100, its supposed to read only 50..so why do you think its a i...

Hi,

I am using a Oracle Enterprise Edition Stage with Load/Append option and my jobs are aborting with this specific message

U_TRUNCATED_CHAR_FOUND encountered

My default NLS map is UTF-8

How to fix this error?

Here goes my five cents: I think the logic for partitioning data in a stage (or link to be more precise) is required when you have to match data between links (join/merge/lookup etc) or to compare rows within a stage (aggregator, R-Dup etc). This will help improve accuracy and performace, as you ca...

Here goes my five cents: I think the logic for partitioning data in a stage (or link to be more precise) is required when you have to match data between links (join/merge/lookup etc) or to compare rows within a stage (aggregator, R-Dup etc). This will help improve accuracy and performace, as you ca...