There is *NO* CTE functionality in U2 at all as far as I'm aware. However, I think it would be a worthwhile addition if it could be implemented both for Retrieve (mvquery) and U2 SQL. CTEs are now supported in the major SQL DBs...
Stuart Boydell -----Original Message----- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of phil walker Sent: Friday, 9 April 2010 10:36 To: U2 Users List Subject: Re: [U2] Common Table Expressions Precisely, I am pretty sure U2 Sql does not support ALL the capabilities of a MS Sql CTE... But I would be interested in being shown otherwise.... > -----Original Message----- > From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- > boun...@listserver.u2ug.org] On Behalf Of Boydell, Stuart > Sent: Friday, 9 April 2010 12:31 p.m. > To: U2 Users List > Subject: Re: [U2] Common Table Expressions > > One scenario off the top of my head would be to allow recursive > selects. This would be similar to a qselect, where you select a list of > MVs from a record, but would also allow you to include the parent id > and any child ids and grandchild ids, etc as a result of the CTE > select. > > Eg. A master customer AC has child accounts which may also have child > ACs - you would use a CTE to select the customer and return the parent > and list of children and grandchildren etc in a single optimised > select. > > To do this in U2 now probably requires a recursive basic program. > > Stuart Boydell > > > -----Original Message----- > From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- > boun...@listserver.u2ug.org] On Behalf Of phil walker > Sent: Friday, 9 April 2010 06:30 > To: U2 Users List > Subject: Re: [U2] Common Table Expressions > > Hi Symeon, > > I have been trying to think how you would use CTE (or equivalents) in > u2 > SQL. Are you willing to enlighten us? > > Regards > > Phil > > > -----Original Message----- > > From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- > > boun...@listserver.u2ug.org] On Behalf Of Symeon Breen > > Sent: Thursday, 8 April 2010 8:16 p.m. > > To: 'U2 Users List' > > Subject: Re: [U2] Common Table Expressions > > > > It could certainly work in u2 SQL - not sure how you would do this in > > English (MVQuery or whatever) tho > > > > -----Original Message----- > > From: u2-users-boun...@listserver.u2ug.org > > [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Boydell, > > Stuart > > Sent: 08 April 2010 06:55 > > To: U2 Users List > > Subject: [U2] Common Table Expressions > > > > Just working on a SQL project which uses lots of CTEs (Common Table > > Expressions) for in-memory caching of table data. > > Really useful things in terms of speed and not having to create > > temporary > > tables for manipulating data. Wondering if anyone has thought about > if > > or > > how they might work in U2... > > Just a thought for better and better (which is down at the moment.) > > Cheers, > > Stuart Boydell > > > > > > > > _______________________________________________ > > U2-Users mailing list > > U2-Users@listserver.u2ug.org > > http://listserver.u2ug.org/mailman/listinfo/u2-users > > > > _______________________________________________ > > U2-Users mailing list > > U2-Users@listserver.u2ug.org > > http://listserver.u2ug.org/mailman/listinfo/u2-users > > > > _______________________________________________ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > > _______________________________________________ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
