Home Page for the TeradataForum

Archives of the TeradataForum

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

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

Subj:   Re: C Preprocessor2 Alternatives
From:   Eric J. Kohut

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,

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

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023