InstantForum.NET v4.1.4Teradata Forumshttp://www.teradata.com/teradataforum/info@teradata.comSat, 21 Nov 2009 17:26:32 GMT20http://www.teradata.com/teradataforum/Topic15816-10-1.aspxAre you using the Wizard?Can you cut and paste and the script to a text file and run from the command line?One thing I see in your script is the use of Job Variables.I do not think the Wizard can handle job variables.If you want to email me outside of this forum list, we might be able to solve this faster.Wed, 01 Jul 2009 22:09:56 GMTSteve Feinholzhttp://www.teradata.com/teradataforum/Topic15816-10-1.aspxanyone? i know tpt isnt really a well known tool but any help would be much appreciatedThu, 18 Jun 2009 19:26:40 GMTazeem_syhttp://www.teradata.com/teradataforum/Topic15816-10-1.aspxHello,I am just getting familiarized with TPT and I was trying to load a table. I am using demo version 12. Everything seems to be fine with my script and everything else, but in job state it says: completed with unexpected status from tbuild (2)Can anyone assist me with this?Thanks,Azeem Syedbelow is the script:/* 1 */ /* 2 */ /* 3 */ DEFINE JOB Movie/* 4 */ DESCRIPTION 'Loading movie table'/* 5 */ (/* 6 */ DEFINE OPERATOR W_1_o_Movie/* 7 */ TYPE LOAD/* 8 */ SCHEMA */* 9 */ ATTRIBUTES/* 10 */ (/* 11 */ VARCHAR UserName, /* 12 */ VARCHAR UserPassword, /* 13 */ VARCHAR LogTable, /* 14 */ VARCHAR TargetTable, /* 15 */ INTEGER BufferSize, /* 16 */ INTEGER ErrorLimit, /* 17 */ INTEGER MaxSessions, /* 18 */ INTEGER MinSessions, /* 19 */ INTEGER TenacityHours, /* 20 */ INTEGER TenacitySleep, /* 21 */ VARCHAR AccountID, /* 22 */ VARCHAR DateForm, /* 23 */ VARCHAR ErrorTable1, /* 24 */ VARCHAR ErrorTable2, /* 25 */ VARCHAR NotifyExit, /* 26 */ VARCHAR NotifyExitIsDLL, /* 27 */ VARCHAR NotifyLevel, /* 28 */ VARCHAR NotifyMethod, /* 29 */ VARCHAR NotifyString, /* 30 */ VARCHAR PauseAcq, /* 31 */ VARCHAR PrivateLogName, /* 32 */ VARCHAR TdpId, /* 33 */ VARCHAR TraceLevel, /* 34 */ VARCHAR WorkingDatabase/* 35 */ );/* 36 */ /* 37 */ DEFINE SCHEMA W_0_s_Movie/* 38 */ (/* 39 */ MID INTEGER,/* 40 */ NAME_2 VARCHAR(100),/* 41 */ ACTOR VARCHAR(100),/* 42 */ GENERE VARCHAR(50),/* 43 */ RATING VARCHAR(20),/* 44 */ RELEASE_YEAR SMALLINT/* 45 */ );/* 46 */ /* 47 */ DEFINE OPERATOR W_0_o_Movie/* 48 */ TYPE EXPORT/* 49 */ SCHEMA W_0_s_Movie/* 50 */ ATTRIBUTES/* 51 */ (/* 52 */ VARCHAR UserName, /* 53 */ VARCHAR UserPassword, /* 54 */ VARCHAR SelectStmt, /* 55 */ INTEGER BlockSize, /* 56 */ INTEGER MaxSessions, /* 57 */ INTEGER MinSessions, /* 58 */ INTEGER TenacityHours, /* 59 */ INTEGER TenacitySleep, /* 60 */ INTEGER MaxDecimalDigits, /* 61 */ VARCHAR AccountID, /* 62 */ VARCHAR DateForm, /* 63 */ VARCHAR NotifyExit, /* 64 */ VARCHAR NotifyExitIsDLL, /* 65 */ VARCHAR NotifyLevel, /* 66 */ VARCHAR NotifyMethod, /* 67 */ VARCHAR NotifyString, /* 68 */ VARCHAR PrivateLogName, /* 69 */ VARCHAR TdpId, /* 70 */ VARCHAR TraceLevel, /* 71 */ VARCHAR WorkingDatabase/* 72 */ );/* 73 */ /* 74 */ APPLY/* 75 */ (/* 76 */ 'INSERT INTO VIDEO_OPERATION.movie_stg (MID,NAME,ACTOR,GENERE,RATING,RELEASE_YEAR) VALUES (:MID,:NAME_2,:ACTOR,:GENERE,:RATING,:RELEASE_YEAR);'/* 77 */ )/* 78 */ TO OPERATOR/* 79 */ (/* 80 */ W_1_o_Movie[1]/* 81 */ /* 82 */ ATTRIBUTES/* 83 */ (/* 84 */ UserName = 'tduser', /* 85 */ UserPassword = 'tduser', /* 86 */ LogTable = 'VIDEO_OPERATION.movie_stg_log', /* 87 */ TargetTable = 'VIDEO_OPERATION.movie_stg', /* 88 */ TdpId = 'localtd'/* 89 */ )/* 90 */ )/* 91 */ SELECT * FROM OPERATOR/* 92 */ (/* 93 */ W_0_o_Movie[1]/* 94 */ /* 95 */ ATTRIBUTES/* 96 */ (/* 97 */ UserName = @TeradataSourceUser, /* 98 */ UserPassword = @TeradataSourcePassword, /* 99 */ SelectStmt = 'SELECT MID,NAME,ACTOR,GENERE,RATING,RELEASE_YEAR FROM VIDEO_OPERATION.movie2;', /* 100 */ TdpId = 'localtd'/* 101 */ )/* 102 */ );/* 103 */ );Tue, 16 Jun 2009 15:19:09 GMTazeem_sy