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
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 ...
- RMU/LOAD the text file of account nbrs to a temp table in your db or a dummy db
- 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