Nesting ODI Substitution Methods. Part II.
Get our e-books Discover the Oracle Data Integrator 11g Repository Data Model and Oracle Data Integrator Snippets and Recipes
Today we look at how we can escape quotes when nesting ODI substitution method calls at different levels of the multi pass parser.
As an example we will store the columns of the C$_ datastore and the columns of a target datastore in a two dimensional java array.
|
1 2 3 4 5 6 7 8 |
<? String[][] ColList = {<%=snpRef.getColList("{", "u0022[EXPRESSION]u0022", ",", "}","INS")%>,<%=snpRef.getColList("{", "u0022[COL_NAME]u0022", ",", "}", "INS")%>}; for (int i = 0; i < ColList.length; i++) { for (int j = 0; j < ColList[i].length; j++) { out.println(ColList[i][j]); } } ?> |
As you can see, we are nesting a call to the ODI substitution API inside aparse block. Normally in Java we escape a quote with “. In ODI this would throw an error. What we do instead is to use the Unicode representation of the quote character: u0022
If you want to master scripting in ODI get the following books.
Java BeanShell
Scripting in Java: Languages, Frameworks, and Patterns
Jython
The Definitive Guide to Jython: Python for the Java Platform.
Jython Essentials (O’Reilly Scripting)
Uli Bethke
Uli has been rocking the data world since 2001. As the CEO of Sonra, the data liberation company, he’s on a mission to set data free. A self-proclaimed data evangelist, Uli doesn’t just talk the talk—he writes the books, leads the communities, and takes the stage as a conference speaker. Uli is a co-founder of DAMA Ireland, helping build a thriving community of data enthusiasts, and a proud Snowflake Data Superhero, leading the charge as the chapter lead of the Snowflake User Group Ireland. Whether sharing insights, empowering others, or championing the coolest data tools, Uli makes data fun. Growing up in Germany and making Ireland his home, Uli brings a global perspective to everything he does. On the academic side, he holds degrees in political science from Freie Universität Berlin, Albert Ludwigs Universität Freiburg, and the University of Ulster, Coleraine, adding a unique interdisciplinary flair to his work.
