Re: DEFINE SCHEMA target_schema FROM TABLE

I am a newbee but making great progress - I have everything working but I am trying to generalize my scripts thus the desire to use the dynamic schema operator. I have spent several hours now going through the TPT user and reference manuals, if there is a wex based training courtse that covers this please point me at it. Thank you, --Don

Re: DEFINE SCHEMA target_schema FROM TABLE

I am moving tables from netezza to teradata , they have the equivalent table definations. Since I have many to do, I'm trying to develop a script that could just take the table name.

I am testing the use of ODBC to move the data directly from one db to the other.

My thought was to use the DEFINE SCHEMA XXX FROM TABLE syntax so I won't need to code that part.

I have the script working by manually coding the scema directive and wish to remove that to make it generic.

On the NZ side I can create a view to output the data and timestamps columns formated correctly, although I wish that wasn't necessary. Apparently the data comes out formatted incorectly by default for loading timestamps and dates.

So I still am not able to get this working, the real operators all have an attributes section but the schema directive doesn't.

I tried this (below) as my best guess but it doesn't work, I obscured the tdpid below

ATTRIBUTES

(

VARCHAR TargetTdpId = @jobvar_tdpid,

VARCHAR TargetUserName = @jobvar_username,

VARCHAR TargetUserPassword = @jobvar_password,

VARCHAR SourceTdpId = @jobvar_tdpid,

VARCHAR SourceUserName = @jobvar_username,

VARCHAR SourceUserPassword = @jobvar_password,

VARCHAR TdpId = '10.xx.xxx.xxx',

VARCHAR UserName = @jobvar_username,

VARCHAR UserPassword = @jobvar_password

);

DEFINE SCHEMA target_schemaz FROM TABLE 'SONARTEST.EOD_USAGE';

So I don't see how to bind TdpId ,UserName and UserPassword to the schema directive.