Re: HELP!!! complex Sql command using text file

From: Paul Scotchford <paul.scotchford_at_uq.net.au>
Date: 1999/04/01
Message-ID: <3702ACA6.8F78C0D0_at_uq.net.au>#1/1


Well Chris, it depends on your product, but if it was Oracle RDB then a quick solution would be ...

  1. RMU/LOAD the text file of account nbrs to a temp table in your db or a dummy db
  2. Write an SQL clause that crosses the accounts table with your temp table

You could write this in a DCL script too (assuming you're a VMS site)

cheers

Paul Received on Thu Apr 01 1999 - 00:00:00 CEST

Original text of this message