Search found 4 matches

by yuga1234
Tue Jan 17, 2012 5:08 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ORA-00934: group function is not allowed here
Replies: 8
Views: 6196

No its just a temp job to test
i dint copy any metadata or stages from any other job
by yuga1234
Tue Jan 17, 2012 4:00 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ORA-00934: group function is not allowed here
Replies: 8
Views: 6196

individually insert and update is working fine

But When we use UPSERT its showing this error
by yuga1234
Tue Jan 17, 2012 2:09 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ORA-00934: group function is not allowed here
Replies: 8
Views: 6196

ORA-00934: group function is not allowed here

I am getting the same error as noted here when tried to UPSERT using oracle connector in datastage 8.5 the auto generated query : The connector generated the following RETURNING statement at runtime: UPDATE SIDBOR_ETL.tmp_1 SET C=:c,B=:b WHERE A=:a RETURNING COUNT(ROWID) INTO :3. The connector gener...