DSXchange

Hi, I have ajob design as below: DB2 stage------>copy stage------->DB2 stage In Source DB2 stage I'm writing query as "SELECT Rtrim(CHAR(BIGINT(INTERNET_ORDER_NBR))) AS INTERNET_ORDER_NBR from #$prsnt_SchemaName#CS_ORDER_FACT where ORDER_KEY IS NULL" to get INTERNET_ORDER_NBR(decimal(9,0))...

What you get and what you expect are equivalent. Decimal representation in DataStage includes leading and trailing non-significant zeroes and placeholder to prove that precision and scale are being m ... no when I queried the DB2 table using IBM data studio 2.2,I'm getting the result displayed as 0...

Hi, I'm facing problem in converting Decimal(9,0) to Varchar(20).My design is as below: DB2 stage------->Modify stage------>DB2 stage In modify stage I have specified as INTERNET_ORDER_NBR=string_from_decimal (INTERNET_ORDER_NBR) I'm getting output as 049351929. 049342258. But the required output is...

Did you try to Insert/Update data using any database access tool? If yes, was that successful? Just to make sure you are not making any mistakes with schema/table/column names. Yes I'm using IBM Data Studio2.2 to access,insert and updating table,it was successful in doing that operation with this t...

The schema does not contain the field ORDER_KEY mentioned in your SQL. Perhaps you need to qualify the table name with the correct schema name. ... Yes below my Insert and Update statements given: INSERT INTO CDW.CS_ORDER_FACT (INTERNET_ORDER_NBR, ORDER_KEY) VALUES (ORCHESTRATE.INTERNET_ORDER_NBR, ...

Hi I am trying to update data from a Dataset to a DB2/UDB stage . It is having Internet_order_nbr(decimal(9,0) key column) and Orderkey(integer(10)) and doing upsert by giving Autogenerated mode as "upsert".After specifying the properties for the DB2 stage. It's giving an error "The s...

Yes,Thanks for your timely response and now i'm getting the exact required output.

INTERNET_ORDER_NBR:decimal(9,0)