Greetings, all.
I get this error message (TWICE, in a yes/no dialog box): "There is
insufficient disk space on either the Target Drive or the Temporary File
Drive. The operation may fail. Do you wish to continue".
when running the Gateway Export command below from the R>.
GATEWAY EXPORT QSV c:\database\catalog\bannerup\scrtxt2.qsv SELECT * +
FROM scrrare WHERE LIMIT = 10
The export does run, but the results include all 194 rows in the table.
Any rows after the LIMIT = 10 show up as all nulls.
"BIO","1114","199710",,1,"P_INCOMPL"
"BIO","1214","199920",,1,"P_INCOMPL"
"BIO","1214L","200110",,1,"P_INCOMPL"
"BIO","2102","200110",,1,"P_INCOMPL"
"BIO","2314","200020",,1,"P_INCOMPL"
"BIO","2604","200010",,1,"P_INCOMPL"
"BIO","3024","200020",,1,"P_INCOMPL"
"BIO","3104","199810",,1,"P_INCOMPL"
"BIO","3154","200020",,1,"P_INCOMPL"
"BIO","3204","200020",,1,"P_INCOMPL"
,,,,,
,,,,,
,,,,,
and so on for 194 lines, which is the number of rows I have in the table.
I have 3.7 GB plus space on the hard drive. The temporary directory is C:
\rbscrtch, it's not empty, but it doesn't have any *.$$$ files when the
command is run.
And it doesn't seem to matter what Null is (char(32), char(255), or -0-), I
always get the error dialog box TWICE before the command executes. It
also doesn't matter if I remove the LIMIT = 10 clause, I still get the
error dialog box.
Paul Patrick [EMAIL PROTECTED]
University of Central Oklahoma
Edmond, OK 73034
(405) 974-2336 fax (405) 341-4964
