|
Answer» Hello everyone,
I have 2 questions
1)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
2) Is there a possibility to save the .txt file directly in Unix Format.
echo export to d.txt>> %SqlFile%
Thank you in advance,
Erion.
|
