Help in executing the following db2 sql querry in unix

Shell Programming and Scripting
1

Hi All,
Please help me out in executing the following db2 querry in unix

db2 "select AP_RQ_ACQ_INST_ID || ',' || txn_classifier || ',' || AP_RS_RESP_CD || ',' || (count(*) AS COUNT1) || ',' || (SUM(AP_RQ_TXN_AMT) AS TOTAL_AMT) from TXN_RECORD where 
CREATE_TS > '2010-11-22 11:00:00.008645' 
and CREATE_TS < '2010-11-22 23:00:00.008645'
group by AP_RQ_ACQ_INST_ID,txn_classifier,AP_RS_RESP_CD with ur" > vin11.csv

Error:

SQL0104N An unexpected token "AS" was found following "|| ',' || (count(*)".
Expected tokens may include: "+". SQLSTATE=42601

Please let me know what needs to be done

Regards,
Duddu

2

try this. you can put on one line if you want - I broke it into multple lines to be easier to read.

db2 "export to vin11.csv of del 
select AP_RQ_ACQ_INST_ID, txn_classifier, AP_RS_RESP_CD,count(*) AS COUNT1,SUM(AP_RQ_TXN_AMT) AS TOTAL_AMT 
from TXN_RECORD 
where CREATE_TS > '2010-11-22 11:00:00.008645' 
and CREATE_TS < '2010-11-22 23:00:00.008645'
group by AP_RQ_ACQ_INST_ID,txn_classifier,AP_RS_RESP_CD 
with ur"