Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 24 Jan 2003 @ 19:59:38 GMT


     
  <Prev Next>   <<First <Prev Next> Last>>  


Subj:   Re: How setup a e-mail notification from mload on failure of job
 
From:   John Adams

From: Sajid Chida

  The right way to do this is through the APIs, but what I do is build the routines, then pipe them into the Teradata utilities.  


  can u please explan little bit clear about this... "build routines and pipe them into teradata" means?  


Sure:

$sql = &create_sql($param_list);
open(MLOAD, "|/usr/bin/mload");
print MLOAD $sql;
close(MLOAD);


  You might also look into Dean Arnolds DBD::Teradata module-- I've not used it, but hear good things.  


  what is this?  


He's on the list, so I'll let him speak for himself. If you aren't using DBI/DBD, I suggest you look into it. (I use DBI and DBD::ODBC extensively from my PC). For support, the dbi-users mailing list at www.perl.org is very, very, very fine.


Thanks,

John A
see me fulminate at www.jzip.org



     
  <Prev Next>   <<First <Prev Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016