TD-25653: WITH Statement in TD 7.4.1

[a_sivababu]

Hi,
It seems WITH statement is not currently supported in TD. I have requested OpenText to support it as this is very important SQL statement in all RDBMS and it is drastically reduces the complex and multiple coding with single WITH statement. It also supports Tree recursive functions without depending on the native DB tree supporting functions or work around.

Thanks!
Siva A

[Dave Rabelink]

If you get a TD enhancement number please report it back here.

[a_sivababu]

Yes Dave.

TD-25653
TD 7.3 Win32 - Common Table Expression using WITH statement does not work in MS SQL Server

The KB article is KB17313742

Thanks!
Siva A

[Dave Rabelink]

Thanks.

I have moved this topic to the "Enhancement suggestions" subforum.

KB article:
https://support.opentext.com/csm?sys_kb ... 8e0ebb353a