DSXchange

If you can not point it the way i told u , try what DS Guru is saying. Its a veru effective method. You will get exact length , but again it will not be easy.

You can also try somethign liek Maximum Len so that u know whats the max len of a column in the file.

The simplest way to do this will be to replace ur Target "table" with yet another flat file (smae strucutre as ur target table as of now) and check the data which gets populated in the file. Its a hectic process but u will need to go on doing this and may be narrowing down the data process...

Thanks !!

Got it... I did not know ODBC was also there...

Its ORACLE..

chulett wrote:No. Sorry, but the MCM *is* your only answer here - other than having two PCs that is. What is your issue with it?

I have never come across this . but will like to know what is MCM...?

I agree ! U can have transformer without any input link but u will need to put a constraint in it and that you can do only through a stage variable and the reason is simple - there is no input :D

ray.wurlod wrote: Are you using ODBC as the connection type in your Dynamic RDBMS stage?

Ray Can you please explain this because I am Not sure what you mean by this?

Are you saying tht the lookup can have A1 , A2 and A3 at the same time? or a single value? If it has all the values then what should be assigned to the output? If only one is present in the lookup then here is the way u can handle it -- Create the Hashed file with two columns - One column Substring...

Are you saying tht the lookup can have A1 , A2 and A3 at the same time? or a single value? If it has all the values then what should be assigned to the output? If only one is present in the lookup then here is the way u can handle it -- Create the Hashed file with two columns - One column Substring(...

DSguru2B wrote:What is the length of the entire record with your desc column set to 666?

768 with the descr column defined as 666...

chulett wrote:666? The devil you say!

Well the devil jut worked fine for me...

Also Just an FYI - The maximum limit of the Descrlong in the DRS stage for which this job works is "666" , if the length is greater than this then the job aborts.

May be its true with other jobs as well.

Yeppeeeeee... I do not know the reason why this can be an issue ! But the last column in the DRS stage was delared as Varchar (2000). I changed it to Char 255 (Tested it with Var char 255 as well) and now the job just works fine. I changed it back to Varchar 2000 , and the job aborts again with the ...

1. Generated the SQL statements (Insert) and ran them in SQL Plus. The SQL runs fine. With no discconection issue.

2. Replaced the DRS stage with an Oracle OCI stage , the job works fine.

Now the question is why DRS stage is not working fine with this one?

There are no EOT or EOF , Yes I am workign with the DBA to point this one out for me. Will update this once I get soem info.