Computer Hope

Software => Computer programming => Topic started by: Erion on May 26, 2011, 01:43:20 AM

Title: Batch File
Post by: Erion on May 26, 2011, 01:43:20 AM

Hello,

I want to write a script that saves different Input Data from Database into one txt File.

I tried this way:
echo export to a.txt of del modified by nochardel coldel^; select from DB1>> %SqlFile%
echo export to b.txt of del modified by nochardel coldel^; select from db2>> %SqlFile%
copy a.txt+b.txt d.txt>> %SqlFile%
echo export to d.txt>> %SqlFile%
The porblem of this script is that a.txt and b.txt are not copied direct into d.txt but after a second RUN.

Can somebody tell me if there is one other way to reach my GOAL.
Import Rows from DB1 and DB2 and write them into a txt File

Thank you in advance,

Erion.