/*****************************************************************/ /* Script Name : -script name- */ /* Creator : -your name- */ /* Created Date: -date- */ /* Changed Date: -date- */ /* Description : LOAD INTO OPERATOR (LOAD OPR 4 Instances) */ /* SELECT * FROM OPERATOR (EXPORT OPR 4 Instances) */ /*****************************************************************/ DEFINE JOB TWBWBT DESCRIPTION 'web based training lab for TWB' ( DEFINE OPERATOR LOADOP() DESCRIPTION 'Terabuilder load operator' TYPE consumer INPUT SCHEMA * EXTERNAL NAME 'libldop.so' ALLOW PARALLEL MULTIPHASE MSGCATALOG 'pcommon.cat' ATTRIBUTES ( VARCHAR PauseAcq = 'N', INTEGER ErrorLimit = 1, INTEGER BufferSize = 64, INTEGER TenacityHours = 1, INTEGER TenacitySleep = 4, INTEGER MaxSessions = 12, INTEGER MinSessions = 1, VARCHAR PrivateLogName = 'twb151jaj.log', VARCHAR TargetTable = 'accounts', VARCHAR TdpId = 'lst5100', VARCHAR UserName = 'twb151', VARCHAR UserPassword = 'twb151', VARCHAR AccountID, VARCHAR ErrorTable1, VARCHAR ErrorTable2, VARCHAR LogTable = 'paradiserun1', VARCHAR CharacterSet = 'ASCII', VARCHAR WorkingDatabase = 'twb151' ); DEFINE SCHEMA accounts_schema DESCRIPTION 'accounts load from sys1 to sys2' ( ACCOUNT_NUMBER INTEGER , NUMBER INTEGER, STREET CHAR(25), CITY CHAR(20) , STATE CHAR(2) , ZIP_CODE INTEGER, BALANCE_FORWARD DECIMAL(10,2), BALANCURRENT DECIMAL(10,2) ); DEFINE OPERATOR export_sys1_accounts() DESCRIPTION 'export from sys1 accounts' TYPE producer OUTPUT SCHEMA accounts_schema EXTERNAL NAME 'libexpop.so' ALLOW PARALLEL MULTIPHASE MSGCATALOG 'pcommon.cat' ATTRIBUTES ( VARCHAR PrivateLogName = 'twb151jaj.log', INTEGER Blocksize = 64260, INTEGER TenacityHours = 1, INTEGER TenacitySleep = 1, INTEGER MaxSessions, INTEGER MinSessions = 1, VARCHAR TdpId = 'lst5100', VARCHAR DateForm = 'ANSIDATE', VARCHAR UserName = 'twb151', VARCHAR UserPassword = 'twb151', VARCHAR AccountID, VARCHAR CharacterSet = 'ASCII', INTEGER Outlimit, VARCHAR WorkingDatabase = 'paradise', VARCHAR SelectStmt='SELECT * from accounts;' ); LOAD INTO OPERATOR ( LOADOP [1]) SELECT * FROM OPERATOR ( export_sys1_accounts [1] ) ; );