Database extract in csv format in scripting
Hi Experts,
I am generating database extract report. Usually user provides me query that have to extract output to .csv and zip and send to user using scheudled job.But I have difficulty in getting output into .csv. When I open file outptu is scrambled or sometimes getting message
~
~
"INC000013844217_2013071618.csv" Line too long
server details;SunOS asidikir001c01 5.10 Generic_127127-11 sun4u sparc SUNW,Sun-Fire-V490
Db details:10.2.0.4.0
I attached SQL query & shell script to do this job. I appreciate if anyone have knowledge on this and helps me out.
I am generating database extract report. Usually user provides me query that have to extract output to .csv and zip and send to user using scheudled job.But I have difficulty in getting output into .csv. When I open file outptu is scrambled or sometimes getting message
~
~
"INC000013844217_2013071618.csv" Line too long
server details;SunOS asidikir001c01 5.10 Generic_127127-11 sun4u sparc SUNW,Sun-Fire-V490
Db details:10.2.0.4.0
I attached SQL query & shell script to do this job. I appreciate if anyone have knowledge on this and helps me out.
0