At 04:45 PM 11/4/2008, [EMAIL PROTECTED] wrote:
Hell list
I have a command file that was working correctly yesterday but today
when I run the same command file I get an error message "ERROR-
invalid cursor state (2645)"
Following is the command line that creates the error.
GATEWAY EXPORT XLSW bank_inv.xlsx +
SELECT
itemcs,locout,itmout,desout,venout,ivalot,balout,excost,orgcst4 FROM invp01 +
WHERE excost > 0 ORDER BY itemcs,locout,desout +
OPTION COL_NAMES ON +
|TAB_NAME Full_Inventory +
|STYLE ZEBRA +
|SHOW_PROGRESS ON +
|SPECIFICATION_FILE_NAME Bank_Inv.rgw
The table invp01 is an Non Rbase table accessed using a ODBC connection.
Ajay,
Make sure that the server table (InvP01) is actually STTACHed.
Without knowing all details, you may use the following technique
to achieve your goal:
-- Start here ...
SET ERROR MESSAGE 2038 OFF
DROP TABLE tInvP01
SET ERROR MESSAGE 2038 ON
PROJECT TEMPORARY tInvP01 FROM InvP01 USING ALL
GATEWAY EXPORT XLSW bank_inv.xlsx +
SELECT itemcs,locout,itmout,desout,venout,ivalot,balout,excost,orgcst4 +
FROM tInvp01 WHERE excost > 0 ORDER BY itemcs,locout,desout +
OPTION COL_NAMES ON +
|TAB_NAME Full_Inventory +
|STYLE ZEBRA +
|SHOW_PROGRESS ON +
|SPECIFICATION_FILE_NAME Bank_Inv.rgw
DROP TABLE tInvP01
RETURN
-- End here ...
Hope that helps!
Very Best R:egards,
Razzak.
