Pankaj Arora ([log in to unmask]) wrote:
: I am using PowerHouse 7.29.C3 with Allbase/SQL
: --------------------------------------------------------------------------
: While trying to delete records from a table (table has BLOB fields -
: defined as LONG BINARY in Allbase), the following message is received.
: - *E* Blob data cannot be written to the scratch file used in this request.
: ---------------------------------------------------------------------------
 
Well, it indicates that based on your code (which I cannot see) that
Qtp is using an intermediary file. Now, given that with 7.29 you
could use SQL DML you might be able to review how you have
structured your code and use a SQL statement to achieve your
needs thus bypassing the intermediary file requirements.
 
As an example, instead of saying Access A link to B.. Output B delete
Output A delete at A. You can issue statements like Delete from
B where b.col=A.col etc.
 
BTW, aside calling c.support for questions you'll also find a
non-Cognos maintained list serv. Drop a mail message of
subscribe powerh-l yourfullname here to [log in to unmask]
 
regards.
--
Nigel Campbell            Voice: (613) 738-1338 ext 3016   P.O. Box 9707,Stn.T
Business Intelligence       FAX: (613) 738-0002            3755 Riverside Dr.
Cognos Incorporated    Internet: [log in to unmask]         Ottawa ON K1G 4K9
                      URL: http://www.cognos.com           CANADA