DSXchange

You can do this in datastage by doing a lookup on two tables using a lookup stage and then filtering the output of the lookup stage in transformer for null/blank records from the second table. This is like executing a below statement in SQL.. select A.* from Table A, Table B where A.ID = B.ID(+) and...

Using the filter option in Sequential file is simple. Here you go...

Under the options tab, choose the filter option and use the below command..

sed -e '1d' Your_full_file_path_including_name

Can anyone know or used the DML statements to update the readonly status on the routines in the Version 8.0. If yes, please shed some light on the DML statements.

I searched the entire documentation and found nothing useful.


I appreciate your help.

Thanks
Mike..

Hello All, I have created a routine and made it a readonly by exporting the routine and replacing the READONLY from "0" to "1" in DSX file. I imported that routine into another project and trying to change the READONLY status to Not Read Only by executing the below command in Adm...

Thank you all for the advice.. I was using this gigantic key as an input to the routine with other fields. I tried creating multiple fields and concatinating them in the routine. But still it did not work... I will keep trying.. In the mean time, anyone with better ideas.. please suggest. Thanks in ...

Hello, I am having a problem using the hash file in which the length of a column exceeds 1500 chars. In my job design, I am creating a record in a dynamic hash file (Type30) which is the concatenation of multiple fields and I am using this field to lookup on the file that I am getting from the Mainf...