A
Abhishek C
Guest
I'm getting ERROR [OpenEdge JDBC Driver][OpenEdge] Insufficient Memory. Memory allocation failed at 751 in Z:/vobs_sql/sql/src/rds/psr_bld1.cxx. Contact Progress Technical Support.
If I execute query to get Distinct count who's column size is varchar(264) for MonthQuota column.
Data And Query Image
Query which I have executed
Error: Error Image
working fine If I removed COUNT(distinct MonthQuota) Image of query without COUNT(distinct MonthQuota)
So, Is there any solution for getting Distinct count for varchar size more than 264.
Continue reading...
If I execute query to get Distinct count who's column size is varchar(264) for MonthQuota column.
Data And Query Image
Query which I have executed
SELECT MAX(MonthQuota) AS maxo, MIN(MonthQuota) AS mino, COUNT(*) AS notnullo, COUNT(distinct MonthQuota) AS distincto FROM PUB.Salesrep WHERE MonthQuota is NOT NULL;
Error: Error Image
working fine If I removed COUNT(distinct MonthQuota) Image of query without COUNT(distinct MonthQuota)
So, Is there any solution for getting Distinct count for varchar size more than 264.
Continue reading...