I am spooling the output of the select statement into the destination file. It's working fine, but, I get the header in the file as well, where it echos the select statement. We don't need it, because we need to load this file to another database. Please advise, jil is as followed
insert_job: EADTEST_SQL job_type: SQL
notification_msg: "A non-critical job has failed. Please review at an appropriate time"
sql_command: "SELECT DISTINCT Substr(a.accountnumber,1,10)|| ',' || RTRIM(SUBSTR(c.CIRCUITID,1,6)) || ',' || ',' || ',' || ',' || ',' || ',' || ',' || ',' || ',' || ',' || ',' || ',' || ',' || ',' || ',' || ',' || ',' || ',' || ',' || ',' || ',' || ',' || ',' || ',' || ',' || decode (e.PHASEDESIGNATION,7,'ABC',4,'A',2,'B',1,'C',6,'AB',5,'AC',3,'BC','000') || ',' || ',' || ',' || ','|| ',' || ','|| ','|| case when c.DISTTRANSOBJECTID is null then 'UP_' else 'XFR_' end || nvl(c.DISTTRANSOBJECTID,b.usagepointobjectid) FROM ace.customeraccount a"
Check the agent settings - and if that doesn't work -
Write a second job to remove unnecessary data
Sent from my iPhone - don't faint!
sed -e '1,4d' <account_import_gis.csv
But, we got to get this into enhancement to allow SQL file execution.
I have to be open and honest , right now. I have noticed a trend: you ask a question and someone answers; which leads you to a solution. That solution, which you were actually lead to by another, you post and mark helpful.
On one hand, did you make a change and test it, from what i have seen yes. However, it was due to the initial feed back from those in the thread. Please reflect on this in a positive light.