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>>