DSXchange

It will be useful if we have the feature of search/replace facility in the Designer. Things like replacing same transformation for multiple fields will be of great useful. Also replacing column names ....

Will make developers lazy.....


Thanks
Rasi

It Would be nice to have ...copying rows from the grid and pasting to other application. Currently we can copy single row but if we can copy multiple row it would be nice.

Thanks

Rasi

Hi Arun,

This could be becos of the limit of files opened. Change the T30FILE configuration parameter in the uvconfig file.

Best of luck

Rasi

I had worked with DB2 before and never had this sort for problem while reading null values. Try to create a simple job and read the null value and insert into your staging table. Check the data type in both source and target table and make sure there isn't any transform happing to that column inside...

Round robin is the default algorithm. For more infomation check the manual servjdev.pdf (Page 13-3)

Thanks
Rasi

Split your type 2 data into two streams one for existing update and another one for new inserts. Send this as Sequential File and in the next job use the file to update the existing records first and then use the separate job to insert new records you will never have this problem.

Thanks
Rasi

Check this with another client machine. If it is the same problem revert back to your original version which it was running before and re-install Datastage Client on it.

Cheers

Rasi

Yes without the wildcards the folder stage will pick up all the files from the path. Also make sure you have some mechanism which clears off the files or moved to different path after the job is finished. This will make sure you are not getting back date files for the current running jobs. Good luck...

The limit is definitely not 64 rows. One of my job had splitted 130 rows as output. So I can say that the limit is not 64 but for higher number > 130 it may apply.

Thanks
Rasi

Hi

As Vincent said put the values in a reference table and then use it as hash file as lookup. This makes life easy and less maintenance for the developers in future.

Thanks
Rasi

Hi Kumar,

Check the metadata of the XML which you imported. Try re-importing and changing the definitions. Improperly imported metadata can cause weird results.

Thanks
Rasi

Sorry this is not the right place to post yours opportunity. There is a separate discussion forum called Looking for Talent post it there.

Siva

Check out for DSSendmail in the manual. You need to code to call this function to send email when job fails.

Cheers
Siva

If the table is hardcoded then the best way is to export to dsx file and search for the table name to get the jobs used for that particular table.

Siva

Yes Ray

you are correct. Any info would be helpful


Regards
Rasi