DSXchange

SUM(AMT) is basically summing AMT. So it is a derived function. It is not a new field. It is performing summation on the existing field AMT. So how can SUM(AMT) differ in metadata?

I am not able to view premium content

I have faced similar problem- but when using the Aggregator Stage to do a summing. For the new aggregated column (which contains the aggregated value), the same warning was thrown, eventhough it was defined as Nullable NO.When I changed this to nullable YES, this warning disappeared. I then include...

I am using SUM(AMT) in the DB2 stage itself. The metadata is AMT(9,2) non nullable.. the query goes like this

SELECT SUM(AMT) AS AMT FROM <TABLENAME>

Ya. I tried that. Created a new job as told by you. When I tried giving SUM(AMT)..Same warnings...When I removed the SUM and gave just AMT, the warnings disappeared.. But in the original job I need the SUM..

AMT is non nullable in DB2 source table. I did a describe for it

I have checked, rechecked and cross checked. Still the warning is intact

Thanks for all your replies. The last one has premium content, I am unable to read it I am not a premium member One other piece of information - Actually I am carrying forward SUM(AMT) to the flat file. AMT is decimal(9,2).

I have done as described by you, the field is non nullable

I checked the metadata. The column is non nullable in it.

I am getting the following warnings. In the job I am trying to extract data from DB2 stage to flat file. The field "AMT" is non nullable in source table as well as in target flat file 1)When checking operator: When binding output interface field "AMT" to field "AMT": Im...

What are Hash files? What is a look up

The problem was indeed in the .rhosts file in my home directory. There were some missing host entries in that file, which I rectified. Now it is working fine.

I am getting the following error while trying to view data or run job using DB2 stage: ##I TFCN 000001 00:18:37(000) <main_program> Ascential DataStage(tm) Enterprise Edition 7.5.1A Copyright (c) 2004, 1997-2004 Ascential Software Corporation. All Rights Reserved ##I TOSH 000002 00:18:37(001) <main_...