Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Fast Export error

Status
Not open for further replies.

neemi

Programmer
May 14, 2002
519
GB
Hi I am trying to run my first fast export script however I keep getting an error and have no clue what this could be? I have simplified the sql just to try and get something working but still no joy.
The error I get is as below

UTY3401 End of file was reached with an unbalanced number of quotes being found


========================================================================
= =
= Processing Control Statements =
= =
========================================================================

0003 'DATABASE DXWV_PROD_CE_CAR_PLAY_PEN;
.BEGIN EXPORT .SESSIONS 5; /*specify export function */
/*number of sessions to be used */
/*contains the input data */
.EXPORT OUTFILE Y:\GrocExtractPL\TestExport.txt; /*identify the
destination */
/*file for
exported data */
SELECT
company_Code,
Supplier
FROM DXWV_PROD_CE_CAR_PLAY_PEN.GrocExtract
WHERE Year_Week_Number = 201033 AND Company_Code=10;
.END EXPORT; /*terminate the export */
/* operation */
.LOGOFF; /*disconnect from the DBS */
09:43 19/10/2010
09:47 19/10/2010
09:52 19/10/2010
**** 09:53:36 UTY3401 End of file was reached with an unbalanced number of quotes being found
in the text.



Help and advise to reslove this is much appreciated.
many thanks
Neemisha
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top