Dear All,
I need to create an xml file with column value from Database table in the file name for example 001_test.xml,002_test.xml where 001 and 002 are fetching from table field name FID.
Looking farward for the suggestion how can i proceed for this.
Generate an xml file with column value in DB
Moderators: chulett, rschirm, roy
Search around...there are some threads as recently as yesterday that talk about getting "row values" at run time into a filename that is written.....you'll find that the Folder Stage in a Server Job or the Sequential Stage in a 9.1 EE Job are two of the known ways to do this......not sure if either will meet your requirement, but those will be the techniques to search for.
Ultimately you would craft your xml and send the content down an output link using a single large column (something like "myXMLcontent" with longvarchar and a long length.....and if you are using the xmlOutput Stage, put a single "/" slash in the Description.
Use passthru to have FID also passed on the output link (same column on the input link and the output link).
Get that working so that you have the desired FID value and column on the same output link with your constructed XML.
...then send those two columns to one of the techniques that you test above.
Ernie
Ultimately you would craft your xml and send the content down an output link using a single large column (something like "myXMLcontent" with longvarchar and a long length.....and if you are using the xmlOutput Stage, put a single "/" slash in the Description.
Use passthru to have FID also passed on the output link (same column on the input link and the output link).
Get that working so that you have the desired FID value and column on the same output link with your constructed XML.
...then send those two columns to one of the techniques that you test above.
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>