DSXchange

Best thing is to check for Numeric data on those columns before doing aggregation.
(If Num(columnname) then columnname else 0).
Try this .May be it work.

Yes ..Its been created in the name 'pilresidmatlovmap'

Previously my design, created the hash file via UniVerse stage and also accessed the hash file via Universe stage.For this we needed some permisions to run the job. So,next we tried to change the design as the one specified as above which is running in some other environment. May be i am not clear a...

But my hash file which i created is pilresidmatlovmap

Sorry for that!! The column names are column1,column2,column3,column4 resp/- First 3 columns are primary key field The design is we are generating the hash file in 1 job and in another job using UniVerse stage we are invoking the same hash file. I am able to read the data but not able to run the job...

This is my TableDefinition <a href="http://s290.photobucket.com/albums/ll265/ushasangayan_photo/?action=view&current=TableDict.jpg" target="_blank"><img src="http://i290.photobucket.com/albums/ll265/ushasangayan_photo/TableDict.jpg" border="0" alt="Ph...

Can you please guide me how to post an image?
Its in my local PC

DSD.BCIOpenRef call to SQLPrepare failed. Statement was:SELECT column1,column2,column3,column4 FROM "abc" WHERE column1 = :1 AND ((column2 = 0 AND column3 =0) OR ( column3 <= :2 AND column2 > :3)) SQLSTATE=S1000, DBMS.CODE=950088 [DataStage][SQL Client][UNIVERSE]DataStage/SQL: syntax error...

Can any one help to resolve this error? SQLSTATE=S1000, DBMS.CODE=950088 [DataStage][SQL Client][UNIVERSE]DataStage/SQL: syntax error. Unexpected verb. Token was "SELECT". Scanned command was SELECT | This job worked fine previously and i am trying to run after re-indexing Datastage!![size...