Archives of the TeradataForum

Message Posted: Thu, 22 Jun 2000 @ 15:00:59 GMT

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

Well since I'm not sure of any alternatives to PP2.

Does the work have to be interactive or can it be applied using a batch utility? What does the program need to accomplish?

You can write an inmod to the TPUMP utility that sits on a message queue and waits for input and then TPUMP will load / update the data a row at a time but across many sessions and packaging many requests into a sessions statement. This can be very fast and efficient.

For Selects, you can either use BTEQ or Fast Export for batch selects or you can use BTEQ with a using clause and a macro to read data from a file or possibly message queue to execute the selects for you a row at a time. I use this approach often in prototyping or OLTP type transactions.

Good luck,

EJK
Eric J. Kohut
Senior Solutions Consultant - Teradata Solutions Group - Retail
NCR Corp.

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