Archives of the TeradataForum

Message Posted: Wed, 28 Nov 2001 @ 19:46:35 GMT

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

Hi,

I think there are two subjects coming up here, scheduling and accessing Teradata.

Scheduling: with Win2k the AT command is probably still there, but it is gradually being replaced with the Windows Task Scheduler - I think you'll find it's a native part of W2K. Earlier versions of Windows needed IE4.0 or higher to get it installed. Check in Windows Explorer for a system folder called "Scheduled Tasks". That will contain a shortcur called "Add Scheduled Task". With this you can run a program at different times, every 'n' minutes etc etc. I've found it very reliable (assuming of course that Windows stays up !).

Accessing Teradata: whether you use cli or odbc is almost one of programming style. Yes, ODBC skils are more abundant, cli can occasionally give you more functionality (but only occasionally). I've seen some customer sites with appalling performance problems retrieving data using odbc, same query 'runs like a steam train' when using cli - to my mind that has to be a network issue ! However, if your query does all-Teradata work (for instance an Insert/Select) then network performance shouldn't be an issue.

Cheers,

Dave

Ward Analytics Ltd: Information in motion (www.ward-analytics.com)

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