Get error when trying execute db2 command from AIX .sh file

sunshiner · #1 (**permalink**) 02-06-12, 22:47

Dear frieds,

I have a problem when I was trying execute db2 command from .sh file.
I use AIX as my system.
and i wanna try to export the data into .csv file.
when I executed the .sh file, I got this:

Quote:

Database Connection Information

Database server = DB2/AIX64 9.1.7
SQL authorization ID = DB2INST1
Local database alias = RMSALIAS

DB20000I The SQL command completed successfully.
SQL3022N An SQL error "-104" occurred while processing the SELECT string in
the Action String parameter.

SQL0104N An unexpected token "ftp" was found following "SELECT conf ".
Expected tokens may include: "FROM". SQLSTATE=42601

and here is my .sh file :

Quote:

db2 connect to RMSALIAS user xxx using xxx
db2 UPDATE CREDIT.CSV_FLAG CF SET CF.FLAG = 1
db2 export to /home/db2inst1/DWH/ftp/CREDIT_ASSESSMENT.csv of del modified by coldel'|' SELECT * FROM CREDIT.V_CREDIT_ASSESSMENT

could you help me?

Thanks

stiruvee · #2 (**permalink**) 02-06-12, 23:21

Use double quotes around export command

db2 "export to /home/db2inst1/DWH/ftp/CREDIT_ASSESSMENT.csv of del modified by coldel'|' SELECT * FROM CREDIT.V_CREDIT_ASSESSMENT "

.....Satya

sunshiner · #3 (**permalink**) 02-06-12, 23:24

Quote:

Originally Posted by stiruvee

Use double quotes around export command

db2 "export to /home/db2inst1/DWH/ftp/CREDIT_ASSESSMENT.csv of del modified by coldel'|' SELECT * FROM CREDIT.V_CREDIT_ASSESSMENT "

.....Satya

Thanks for your help, I will try this

Internet Services

Web Development

Digital Marketing

Consumer Tech