XML Input stage
Moderators: chulett, rschirm, roy
I just wanted to ensure you saw his entire response. The way I read it, the 'writing to a file' part was just to ensure the XML in the CLOB was well formed. Once that was confirmed, switch back to sourcing directly from the table but use the "content" option rather than the URL to read the data into the stage. Plus what he noted about delimiters and quotes.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
Yes....debugging techniques, everyone! Take things one step at a time!
Don't try to put everything together at once --- and that goes for whatever you are building, not just xml, rdbms, and clobs.
Ernie
Don't try to put everything together at once --- and that goes for whatever you are building, not just xml, rdbms, and clobs.
Ernie
Ernie Ostic
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>