I'm using a ODBC data source so no code required. The full log states: <?xml version="1.0" encoding="UTF-8" standalone="no" ?> <datafluxdocument class="architectjob" version="1.2"> <jobid id="56E2AD7D389585E9"/> <propset> <prop name="_DESCRIPTION"> <value dtype="String"></value> </prop> <prop name="_NOTES"> <value dtype="String"></value> </prop> <prop name="AutoLayoutRequired"/> <prop name="DefaultLayout"> <value dtype="String">LeftToRight</value> </prop> <prop name="GroupNodes"/> <prop name="name"> <value dtype="String">Test Data Job</value> </prop> <prop name="ShowGridLines"> <value dtype="String">True</value> </prop> <prop name="SnapToGrid"> <value dtype="String">False</value> </prop> <prop name="STICKYNOTES"/> <prop name="ZoomLevel"> <value dtype="String">26</value> </prop> </propset> <paramset> <param name="WFINPUTS" type="matrix"/> <param name="WFOUTPUTS" type="matrix"/> </paramset> <page> <propset> <prop name="serial_targets"/> </propset> <step id="SOURCE_ODBCSQL" iid="2" ver="1"> <propset> <prop name="color"/> <prop name="default_target"/> <prop name="description"> <value dtype="String">SQL Query 1</value> </prop> <prop name="descriptive_text"> <value dtype="String">Specifies an SQL query that selects data from one or more tables. The results table is used as an input in a data job</value> </prop> <prop name="node_position"> <value dtype="String">146.4</value> <value dtype="String">238.761875</value> </prop> <prop name="notes"> <value dtype="String"></value> </prop> <prop name="serial_target_position"/> </propset> <paramset> <param dtype="String" name="DSN" type="single">DSN=PSELIV01_USER;DFXTYPE=ODBC</param> <param dtype="Unknown" isnull="true" name="MAX_OUTPUT_ROWS" type="single"></param> <param dtype="String" name="SQL_STMT" type="single">SELECT GENDER FROM PERSON</param> <param name="SQL_PARAMETERS" type="matrix"/> <param dtype="Unknown" isnull="true" name="ROW_ESTIMATE" type="single"></param> <param dtype="Unknown" isnull="true" name="SQL_PROTOTYPE" type="single"></param> <param name="TYPE_OVERRIDES" type="matrix"/> <param dtype="Unknown" isnull="true" name="POOL_NAME" type="single"></param> </paramset> </step> </page> </datafluxdocument>
... View more
