 |
 |
Archives of the TeradataForum
Message Posted: Fri, 24 Jan 2003 @ 19:59:38 GMT
| 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. | |
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
| |
