-
Sub-task
-
Resolution: Done
-
Major
-
7.6
-
None
Could be beneficial to expose a standard library of SQL templates that Designer knows about and uses in our import and object creation wizards.
EXAMPLES include forms based on :
SELECT * FROM XXXX
SELECT a,b,c FROM t1, t2 WHERE t1.a = t2.b
======= Generated XML File Importer SQL ==========
SELECT
A.x AS x, A.y AS y
FROM
(EXEC MP.getTextFiles('myfile.xml')) AS f,
XMLTABLE('/topelement/secondelement' PASSING XMLPARSE(DOCUMENT f.file)
COLUMNS x string PATH '/x', y string PATH '/elem_a/elem_b')
AS A
========================
- is related to
-
TEIIDDES-1216 New View Table Wizard
-
- Closed
-
- relates to
-
TEIIDDES-1270 SQL Templates for Insert, Update, and Delete queries need to be modified to represent new syntax for Teiid 7.7
-
- Closed
-
-
TEIIDDES-987 Add ability to edit/generate Create Virtual Procedure SQL statements for RestEasy XML, File and Web Service Translator procedures
-
- Closed
-
