TD-25653: WITH Statement in TD 7.4.1

Missing or incomplete OpenText Gupta product features? Discuss it here!
a_sivababu
India
Posts: 505
Joined: 10 Mar 2017, 08:46
Location: Chennai,India

TD-25653: WITH Statement in TD 7.4.1

Post by a_sivababu » 24 Dec 2021, 03:26

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
Founder/Site Admin
Founder/Site Admin
Netherlands
Posts: 3384
Joined: 24 Feb 2017, 09:12
Location: Gouda, The Netherlands

Re: TD-25653: WITH Statement in TD 7.4.1

Post by Dave Rabelink » 24 Dec 2021, 09:21

If you get a TD enhancement number please report it back here.
Regards,
Dave Rabelink

Image
Articles and information on Team Developer Tips & Tricks Wiki
Download samples, documents and resources from TD Sample Vault
Videos on TDWiki YouTube Channel

a_sivababu
India
Posts: 505
Joined: 10 Mar 2017, 08:46
Location: Chennai,India

Re: TD-25653: WITH Statement in TD 7.4.1

Post by a_sivababu » 24 Dec 2021, 10:36

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
Founder/Site Admin
Founder/Site Admin
Netherlands
Posts: 3384
Joined: 24 Feb 2017, 09:12
Location: Gouda, The Netherlands

Re: TD-25653: WITH Statement in TD 7.4.1

Post by Dave Rabelink » 24 Dec 2021, 10:54

Thanks.

I have moved this topic to the "Enhancement suggestions" subforum.
Regards,
Dave Rabelink

Image
Articles and information on Team Developer Tips & Tricks Wiki
Download samples, documents and resources from TD Sample Vault
Videos on TDWiki YouTube Channel

Return to “Enhancement suggestions”

Who is online

Users browsing this forum: [Ccbot] and 0 guests