Archives of the TeradataForum
Message Posted: Thu, 22 Jun 2000 @ 15:00:59 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|