DSXchange

Try

./dsjob - Arguments ...


Thats how u execute that from bin ...

Thanks,
Ajith

There is an environment variable to specify this APT_MAX_DELIMITED_READ_SIZE By default, when reading, DataStage will read ahead 500 bytes to get the next delimiter. If it is not found, DataStage looks ahead 4*500=2000 (1500 more) bytes, and so on (4X) up to 100,000 bytes. This variable controls the...

Thank you Ray,

I decided to add one more filter stage to sort this out.

Senthil,

As you said, I feel it is improper to use reject link, I dint even check this option out. Thank you too.


Thanks,
Ajith

I want to know how to get only the unmatched rows in a particular look up. Is it possible to do this with look up stage alone. I was trying to achieve this by specifying the look up condition. But It does not allow me to use reference link columns. I cannot change the link ordering as that is disabl...

You cannot Use Null validation functions along with Null handling functions ...

Try to do the null handling without using the null handling functions by equating to '' . I think that will sort that out..

Hope that helps ..
Ajith

I am getting the error too

Hi Ajith, Here you are performing lookup and taking the field DESC from reference is it right ? If your lookup fails, it have to give Null in the filed DESC. Here my question is what is the nullability of filed DESC ( NO/YES). If it is NO, datastage will set ' ' for the DESC filed and check If it i...

How can Filter stage can diffrentiate, if the space is from the source or that been padded by previous stage? Or you check for the presence of space in the first char of the DESC. Filter stage does not differentiate ... It just looks for Characters other than the padchar at the end of the string an...

Post the error from the Log files mentioned in the Datastage error, as Ray mentioned ...

This case you can check for the space for the full length of the DESC field. Or you can trim and check for ''. No, That is exactly my point, I just have to compare with one space ... The filter automatically trims ( Ignores ) rest of the spaces ... Is this a bug with the filter stage??? ... I want ...

DESC is Varchar from Database and I pad it with spaces ... Anyway, I want to filter it when there is no match for the key, ie in case of lookup failure ... I was using Is Null Desc ... But that does not work ... Since The null value is getting padded by spaces after the lookup ... Hope my point is c...

kumar_s wrote:Check if APT_PAD_STRING is ' '. Try to change it to 0x0 (Null). May be a case where empty space might be considered as pad chars. Try if that works.

Cannot afford to do that as The files I am writing into are fixed width files padded with spaces at the end ....

Hi, My job flow is like this Oracle stage | | Modify Stage | | Seq ---- Filter1 --- Look Up----- Flter 2 ------ | | Upd File All my Seq file are fixed width with all fields of Char Datatype .. In the modify stage I am changing the datatyes to Char .... The look up fail condition is Continue and I ne...

Hi when I executed netstat -a|grep dsrpc,soe processes got listed with status as CLOSE_WAIT,FIN_WAIT_2.Does this indicate that the client connections to the server is closed and the port needs to be released? How can we find out the time taken for the port to be released? In my case,the status is C...

Hi Ajith Thanks for your inputs. Actually my source is Sybase and the datatype for teh columns are smallint and decimal can you helo me what is the length i need to spacify in the metadata information. Thanks, girish Smallint is 16 bit int so the maximum value is +32 767 if it is signed .. So u can...