Search found 5 matches

by caseyhoo
Tue Oct 07, 2014 8:57 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Netezza - What is datatype for select Sum(col) from table
Replies: 2
Views: 2918

Beside using Double for the "sum" column, below is the others changes that i did.

At "Netezza Connector" stage, I had change "Type mismatch action" to Keep.

ray.wurlod, billions thanks
by caseyhoo
Mon Oct 06, 2014 9:36 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Netezza - What is datatype for select Sum(col) from table
Replies: 2
Views: 2918

Netezza - What is datatype for select Sum(col) from table

Im using netezza connector. I try to sum a numeric NUMERIC column using below select statement. However, I always get "did not have a compatible data type. These columns will be dropped from the output link schema" message. select Sum(col) as ssum from table May I know what DS datatype I s...
by caseyhoo
Thu May 31, 2012 8:47 pm
Forum: IBM QualityStage
Topic: Unable to locate column keyChange in the input link with the
Replies: 1
Views: 3342

Unable to locate column keyChange in the input link with the

I got below fatal error when running my duplicate matching. Unduplicate_Match_177: Unable to locate column keyChange in the input link with the following schema: record ( qsMatchDataID: uint64; C_HOUSE_NUMBER: nullable ustring; ) My souce data just have 3 columns Source varchar not nullable Row BigI...
by caseyhoo
Tue Sep 15, 2009 2:29 am
Forum: IBM QualityStage
Topic: Can not open Administrator Client nor 1 of project
Replies: 3
Views: 3385

Re: Can not open Administrator Client nor 1 of project

thanx for warm welcome and prompt reply. FYI, at DesignerClient, I didnt facing problem connect to others project. --------------------- After the clue that you give me, " Search DSXchange for the particular error code". I found a thread similiar with what happen to us. http://www.dsxchang...
by caseyhoo
Tue Sep 15, 2009 12:52 am
Forum: IBM QualityStage
Topic: Can not open Administrator Client nor 1 of project
Replies: 3
Views: 3385

Can not open Administrator Client nor 1 of project

Currently, there is few projects. At Designer Client, when we try to access 1 of project, I got the below error. Beside that, we also get the same error when trying accessing Administrator Client "Failed to connect to DataStage server:Z2DQUAT1, project : Test (Invalid account name supplier (391...