Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 08 Nov 2002 @ 12:04:18 GMT

  <Prev Next>  
Next> Last>>  

Subj:   Using multiple external files in a bteq request
From:   Hayes, Jim M


I have to extract data from a table using input from two external files.

Is this doable via the .import command?

Input file one contains starting and ending dates in the form yyyymm. For whatever reason, the DBA who created the table did not make the datatype of the field I'm looking at a date, so I'm having to use between date x and date y instead of something like from date to date - 24 months.

The second input file will contain a list of 100 values we wish to extract data for. I'd prefer to build a temp table and join to it, but the politics of this particular environment seem to preclude that solution.



Jim Hayes,
Delta Airlines, Network Analysis

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