derived table in XIR2 - Informix

building semantic layer
1

Tying to create three field in a drrive table in xir2 designer.
But getting informix odbc error with DBD exception .
Is it a syntax error in sql or database error?
The data source of this universe is informix dynamic server 2000.
Please anyone asssist.

Thanks!!!

SELECT DISTINCT
  Table__14.mkos_household_key,
  Table__10.mkcl_item_key,
  Min(Table__10.mkcl_sale_date) AS Min_Date
FROM
  'informix'.mkcl_cus_ord_line  Table__10,
  'informix'.mk_order_summary  Table__14
WHERE
  ( Table__10.mkcl_cus_order_key=Table__14.mkos_cus_order_key  )
  AND  (
  Table__10.mkcl_item_key  =  5819
  )

Group BY

Table__14.mkos_household_key,
  Table__10.mkcl_item_key

[Moderator Edit: Added code formatting - Andreas]

BOWorker (BOB member since 2007-11-17)

2

I think you may not be able to create derived tables in certain release levels of informix…version 11 does it

I created views based on the proposed derived table SQL

jemstar :ireland: (BOB member since 2006-03-30)