• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

Jde c api sql "having"

nkuebelbeck

VIP Member
Jde c api sql having clause

I can't seem to locate a way to include a HAVING sql command

trying to do something like this via C API

select sdshpn,count(distinct sddoco),sum(sditwt),avg(sdan8) from libary.f42119 left join library.F42019 on sddoco=shdoco where sdADDJ>=116001 and sdADDJ <=116366 and shptc='CWO' and sddcto='M1' group by sdSHPN HAVING count(distinct sddoco)>1;

Is this possible?
 
Last edited:

BOster

Legendary Poster
Yes a HAVING clause is possible. I did one just the other day. But only with a certain TR level (not sure which one). We are on 9.1.5.1. The API you are looking for is JDB_SetHaving and is documented in the JD_Edwards_EnterpriseOne_In-Memory_Tools_C_API_Reference document from Oracle.
 

nkuebelbeck

VIP Member
well i'm out of luck. went looking for JDB_SetHaving and nothing. Bummer, that would have really made this a lot easier. now i have to hack something together.

Thanks for the reply.
 
Top