Create SQL String Template framework and dialog for use in new view construction and SQL editing ------------------------------------------------------------------------------------------------ Key: TEIIDDES-1223 URL: https://issues.jboss.org/browse/TEIIDDES-1223 Project: Teiid Designer Issue Type: Sub-task Components: Transformations Affects Versions: 7.6 Reporter: Barry LaFond Assignee: Mark Drilling Fix For: 7.7 Attachments: Prototype SQL String Template dialog.bmml, Prototype SQL String Template dialog.bmml, Prototype SQL String Template dialog.png 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 ========================

Create SQL String Template framework and dialog for use in new view construction and SQL editing ------------------------------------------------------------------------------------------------ Key: TEIIDDES-1223 URL: https://issues.jboss.org/browse/TEIIDDES-1223 Project: Teiid Designer Issue Type: Sub-task Components: Transformations Affects Versions: 7.6 Reporter: Barry LaFond Assignee: Mark Drilling Fix For: 7.7 Attachments: Prototype SQL String Template dialog.bmml, Prototype SQL String Template dialog.bmml, Prototype SQL String Template dialog.png, SQLTemplateDialog.png 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 ========================

Create SQL String Template framework and dialog for use in new view construction and SQL editing ------------------------------------------------------------------------------------------------ Key: TEIIDDES-1223 URL: https://issues.jboss.org/browse/TEIIDDES-1223 Project: Teiid Designer Issue Type: Sub-task Components: Transformations Affects Versions: 7.6 Reporter: Barry LaFond Assignee: Mark Drilling Fix For: 7.7 Attachments: Prototype SQL String Template dialog.bmml, Prototype SQL String Template dialog.bmml, Prototype SQL String Template dialog.png, SQLTemplateDialog.png 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 ========================

Create SQL String Template framework and dialog for use in new view construction and SQL editing ------------------------------------------------------------------------------------------------ Key: TEIIDDES-1223 URL: https://issues.jboss.org/browse/TEIIDDES-1223 Project: Teiid Designer Issue Type: Sub-task Components: Transformations Affects Versions: 7.6 Reporter: Barry LaFond Assignee: Mark Drilling Fix For: 7.7 Attachments: Prototype SQL String Template dialog.bmml, Prototype SQL String Template dialog.bmml, Prototype SQL String Template dialog.png, SQLTemplateDialog.png 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 ========================