TPT Export with multiple SQL using different ReportModeOn settings

Tools & Utilities
Highlighted
Teradata Employee

TPT Export with multiple SQL using different ReportModeOn settings

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?!

5 REPLIES
Teradata Employee

Re: TPT Export with multiple SQL using different ReportModeOn settings

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.

Teradata Employee

Re: TPT Export with multiple SQL using different ReportModeOn settings

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.

Teradata Employee

Re: TPT Export with multiple SQL using different ReportModeOn settings

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.

Teradata Employee

Re: TPT Export with multiple SQL using different ReportModeOn settings

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!

 

Teradata Employee

Re: TPT Export with multiple SQL using different ReportModeOn settings

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 */