DSXchange

Yes, I would do so.
In my case the Oracle tables were not responding so went to the concerned dba.
In your case SIGPIPE is Signal and Unix Pipe. Your Unix Admin wud be helpful.

hi there, getting error below then job terminate , any idea whats wrong main_program: A SIGPIPE signal was received in APT_JobmonFilter::writeMessage caused by closing of the socket on port 13,400; turning off job monitoring for the rest of the job. This job is doing couple of lookups based upon ke...

The output reject link of your Oracle stage should have "sqlcode" as an integer column, is that correct? Are you writing straight to a sequential file or going through another stage? ... Yes, you are right, sqlcode is integer column. and yes I am writing straight to seq. file as below ODB...

ArndW wrote:that makes sense, the "sqlcode" is added in the reject link so that you can analyze the error cause. Which stage is giving this error? ...

Seq. file stage.

ArndW wrote:What are your column definitions and it would seem you are using user-defined SQL, so what do you have there? ...

Hi ArndW,

There are abt 20 columns. 18 are VARCHAR and 2 TIMESTAMP.
I am using Auto-generated SQL. When I add that rej. link a new column sqlcode is adding as you.

thanks

Hi all, from the target ODBC stage am using a seq. file to load the rejected records. settings made : ODBC output reject records - True Seq. file. file - /........./............/............./test.txt file update - overwrite Cleanup on failure - True Reject mode - continue When I ran this job. error...

kumar_s wrote:If your intention is to collect the records not equal to any of these 'u','i','d', have another condition in filter stage itself.
Else you can find one such scenario in vincents blog, use copy stage ...

Ashik,
Did u get the solution? even I am facing the same.

Help me

Thank You
Kumar

Did they not give you a file layout? Can you post that and a sample record or two, wrapped in tags? ...[/quote] No layout is given, I presume it to have the same layout as the destination table, which has around 15 columns. [code]468742 Craig Matt FT A Global Information Technology Corporate System...

Extensions can be fairly meaningless, where did the file come from? More than likely it's a sequential file and can be read with that stage, can you view it properly with vi? ... Mr.Chulett, It was ftped by different business and the location is given to me. S, I can view the data using vi. i used ...

oops

Hi all, I want to read data from a .dat file on my unix box and load into an oracle table. can you please tell me which stage can be used to read the .dat file. Seq. file / CFF /..... I gave a try with this design a Seq. File -------> Trfm -------> ODBC stage . But then I realised Seq. file may not ...