Toad World® Forums



Receiving SQL0412N When executing TPC-H against an DB2 DWE 9.4 AIX/64.


Do you know what transaction received the error?
What was the scale factor?
Was the user load one?



Hi Tracey,

here is the log error:

Benchmark Factory Agent
Version: 5.5.1
Build: 416
Copyright © Quest Software 2008

CLI Error (42823,FFFFFE64) - [IBM][CLI Driver][DB2/AIX64] SQL0412N Multiple columns are returned from a subquery that is allowed only one column. SQLSTATE=42823

This error ocurred while loading a table.

I’ve contacted the quest support and they are working on a solution.