DEV Community

Query Filter
Query Filter

Posted on

queryout

$BCP "SELECT
col1,
col2,
col3,
col4,
col5,
col6,
col7,
col8,
col9,
col10,
col11,
col12,
col13,
col14,
col15,
col16,
col17,
col18,
col19,
REPLACE(REPLACE(OVERRIDERULESET, CHAR(13), ''), CHAR(10), '<>'),
col21,
col22,
col23,
col24,
col25
FROM ${DB_NAME}..${tableName}" \
queryout $CUR_DAT_FILE -c -t"${DELIMITER}" \
-S${SYBASE_SERVER_NAME} -U${SYBASE_DB_USER} -P${COMET_PSWD} -I${INTERFACE} \
-b 5000 -e $DATA_FILE_DIRECTORY/${tableName}_error.log

Top comments (0)