I would like to create a TPT Variable File which first exports a SQL in Text and den another SQL in VARTEXT to a CSV File. It doesn't seem to support two ReportModeOn Variables?!
If you need different settings for the two SELECTs, you will have to define two steps and use OpenMode='WriteAppend' for the Data Connector in the second step.
Thanks Fred! I had this already, but in order to save some overhead I tried to put it in one attribute file.
So now I tried to do this with two -v Attribute files , but it took only the second one... I use Version15.10.
At the Job level, a variable name can only have one value.
You'll have to override attributes at the step level, if you want different values in different steps.
Thx Fred, but then I would have to pack all the attributes and select statements into the -f file and the two -v Job Definition would still not work!? I'd just like to get this a more readable and servicable process!
The -v file is job-level, but you can makeup your own variable names and refer to those in the script. For example, instead of a single SelectorSelectStmt value, define SelectStmt1 and SelectStmt2. Then use those in your script
DEFINE JOB Example ( STEP Step1 ( APPLY TO OPERATOR ($DATACONNECTOR_CONSUMER() ) SELECT * FROM OPERATOR ($SELECTOR() ATTR ( SelectStmt=@SelectStmt1 ) ); ); /* End Step1 */ STEP Step2 ( APPLY TO OPERATOR ($DATACONNECTOR_CONSUMER() ATTR ( OpenMode='WriteAppend' ) ) SELECT * FROM OPERATOR ($SELECTOR() ATTR ( SelectStmt=@SelectStmt2 ) ); ); /* End Step2 */ ); /* End Job */