TransferText

[Tony Wainwright]

Hi guys
I am using the TransferText command to export data to a text file, however
this didn't seem to work until I used the Export command on the File menu.
Reading the help file indicates that I need to specify a SpecificationName
as one of the arguments. It also indicates that if you use the Export
command a Specification file can be created.
My questions are:
1) What information is stored in the file in SpecificationName? and how is
it presented?
2) If I create one using the Export menu option, where is it stored?

Cheers guys
Tony

 

[Nikos Yannacopoulos]

Tony,

The information stored in Import/Export specifications pertains to field
names, types, sizes, start/end position etc. It is stored in two system
tables, MSysIMEXSpecs for the spec header data and MSysIMEXColumns for the
columns data.
These tables can be viewed if you select to make system objects visisble
(Tools > Options), but you cannot manually change the tables. The only way
to create / change / delete specs is through the import/export wizard.

HTH,
Nikos