Yes, but why didn't you just try?
but also check the manuals
Yes, I tried before I posted.. actuall issue was there was some junk value in between where condition.
I have tried to use where cluase, but i am getting syntax error due to the quotes present in the IN LIST. Is there any way to solve it. May be using some escape character to escape the quotes inside the IN LIST. Thanks in advance.
/*** Export Operator Definition ***/
DEFINE OPERATOR EXPORT_OPERATOR
DESCRIPTION 'TERADATA PARALLEL TRANSPORTER EXPORT OPERATOR'
VARCHAR PrivateLogName = 'exportoper_privatelog',
INTEGER MaxSessions = 8,
VARCHAR TdpId = 'XXXXX',
VARCHAR UserName = 'XXXXXX',
VARCHAR UserPassword = 'XXXXXX',
VARCHAR SelectStmt = 'SELECT BATCH_PK,
BATCH_STATUS from PLT_IWH_BASE.BATCH where BATCH_ID IN ('000362464WH', '20550K01A');'