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
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