DSXchange

Whatever values are fetched from the right table can be made to be nullable.. So when these columns are transferred to the output link of the join and the join fails, you will have null values in these fileds. In case you do not have any column to be fetched from right table you can add a hardcoded ...

use the StringToDecimal(...) function

You can check the log... It does a simple delete.... for truncate and load use the db2 load stage in case you have very huge data volume and you want a replace load...

It is just a problem in my PC. When I try to login from another PC, things work fine.

I do have the administrative privileges in my machine... Once the issue propped up I tried uninstalling, removing the folders as mentioned in the datastage documents, etc and reinstalling. But still getting the same issue.

Hi Go to properties tab, you will find two options as before job and after job subroutine. Use ExecSh or ExecShSilent as per your requirements (the second one is appropriate if you are using userid/passwords as parameters to the script). If you want to execute it before your job starts use the befor...

For the given field perhaps you have skipped mentioning the precision and scale fields.... You need to provide a precision and scale values as you have for decimal fields in database

Hi Thanks for responding.. This is a new installation. Everything was working fine initially. Then perhaps some other application was installed in the machine and removed later. During the process some system file might have been removed. But not able to figure out the exact cause.

Hi

Can anyone kindly let me know, what is the method of deleting a given lookup file set? As we use Dataset Management utility to remove datasets, is there any similar tool for removing lookup file sets?

Thanks
Arnab Dey

Let me add to it.... I am able to get the login prompt, where after entering the domain name, userid and password, Projects are properly listed.

Hi While logging into the DS client I am having an issue as follows. [b]Datastage designer has encountered a problem and needs to close. We are sorry for the inconvenience. Please tell Microsoft about this problem..... ...... Send Error Report Don't send[/b] Seems to be a widows level problem. Versi...

Hi
Probably you are correct. You need to set dsenv. Please ensure that you have set the following environment variables ORACLE_HOME, ORAHOME, ORACLE_SID, ORASID, LD_LIBRARY_PATH/LIBPATH properly first. Also review the database credentials you provide.
Thanks

Hi
You first need to have atleast Visual Studio 2003, you also need to set the compiler and linker options correctly. cxx is an exe file and its path C:\Program Files\MKS Toolkit\mksnt is found in the path variable (in environment variable of windows).
Thanks

Hi

Check whether you have set up the .odbc.ini (in Engine folder) and uvodbc.config file (in the Projects folder). The uvodbc file should mention the data source names and the .odbc.ini file should contain connectivity details like ip address, database driver etc

Thanks

Can anyone please reply me what are the exact settings of these environment variables in Windows 2003 Server (and if possible in Windows XP)?

Thanks