Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Morning all,
Can I specify the table name in the import script? I'm thinking particularly when I am concatenating from two sources eg:
select * from SourceA
concatenate
select * from SourceB
and I want to see the table as CombinedTable.
Any ideas?
Thanks,
Tony
The concatenated file will inherit the name of the first file, thus your script may read:
CombinedFile:
select * from SourceA;
concatenate (CombinedFile) select * from SourceB;
It is not necessary in this example to specify, to which file the "B" should be added, but it makes script a bit clearer and prevents error, if you shuffle the code around.
HTH
Peter
The concatenated file will inherit the name of the first file, thus your script may read:
CombinedFile:
select * from SourceA;
concatenate (CombinedFile) select * from SourceB;
It is not necessary in this example to specify, to which file the "B" should be added, but it makes script a bit clearer and prevents error, if you shuffle the code around.
HTH
Peter
Cracking! Thanks v much Peter,
Tony