read_delimited()
Posted: Mon Jun 26, 2006 10:30 am
Hi Fellas,
I'm loading data from a oracle table to a sequential file(Job1).The job is running fine with no indication of errors or warnings in the log.I use this sequential file to load to another table(Job2).
Now the scenario is like this.
When I tried to view the data from the job 1, I get the following messages.
1. read_delimited() - invalid quotes
2. read_delimited() -required column missing
I'm not able to get rid of this.
When I run the Job 2, Sequential file (from Job1) into a table,the job is getting aborted with the following message.
read_delimited() - invalid quotes, row 204
So, Unless I fix the issue in job1,my job 2 cannot be go for a successful run.Please throw your opnions on this issue.
Regards,
VG.
I'm loading data from a oracle table to a sequential file(Job1).The job is running fine with no indication of errors or warnings in the log.I use this sequential file to load to another table(Job2).
Now the scenario is like this.
When I tried to view the data from the job 1, I get the following messages.
1. read_delimited() - invalid quotes
2. read_delimited() -required column missing
I'm not able to get rid of this.
When I run the Job 2, Sequential file (from Job1) into a table,the job is getting aborted with the following message.
read_delimited() - invalid quotes, row 204
So, Unless I fix the issue in job1,my job 2 cannot be go for a successful run.Please throw your opnions on this issue.
Regards,
VG.