When I am testing query subject in framework manager i got following error.
RQP-DEF-0177 An error occurred while performing operation 'sqlOpenResult' status='-28'.
UDA-SQL-0114 The cursor supplied to the operation "sqlOpenResult" is inactive.
UDA-SOR-0005 Unable to write the file.
I tried that but it's not working..I have created joins in database view..when I am testing the table in database view it's pulling the data..but I am facing problem in intermediate view..because in intermediate view that table having joins with multiple tables.
example:
I have master table as some x..this x table joins with 10 other tables.
x.id=a.id
x.id=b.id
x.id=c.id
When I am including the table a with x then it pulling the data.when I am including b table along with A table to x then its showing this error.
and apart from that I have large volume of data in the tables approximately 4o crore records.
It looks like you need more temp disk space:
http://www-01.ibm.com/support/docview.wss?uid=swg21506970