Hi guys, can you help me with a basic structure for a TPT EXPORT operator job?
I have good examples on LOAD operator but I'm not sure what to change ar what's needed.
This would be a load operator generic structure:
DEFINE JOB JOB_NAME
DEFINE OPERATOR LOAD_OPERATOR
INTEGER MaxSessions = 20,
DEFINE SCHEMA SCHEMA_NAME
DEFINE OPERATOR READ_OPERATOR
TYPE DATACONNECTOR PRODUCER
STEP Load_Records (
'INSERT INTO TABLE_NAME (
TdpId =ID (?)
SELECT * FROM OPERATOR
So, how would the export one be?
thanks in advance,
Our documentation describes the Export operator, the mandatory attributes and the optional ones.
Our User Guide has examples of Export operator job scripts as well.
We also ship sample scripts with the product. Just look in the "samples" directory under the TPT root install directory.
What type of scenario are you looking for?
What version of TPT are you using?
hi feinholz, yes I've been looking both the tpt user guide and the tpt reference manual, didn't find full examples.
I was hoping for a minimal or standard query-to-file structure, I can't tell from the load one how to change it. At the moment I'm trying to adapt the load one.
That samples dir could be it, I'm going to check-
I'm looking at these paths but no tpl file samples to be found,
I don't know if the location changed, but the sample directory is usually found at /opt/teradata/client/xx.xx/tbuild/samples/userguid
Btw, TTU 13.10 is a very outdated and no longer supported release.
I got another good example from here: