DSXchange

Thanks for the quick reply Subversion is a open source version control system . We are checking in the dsx files after exporting from datastage manager ... We want to know is there any subversion(SVN) plugin available for datastage client so that we can directly compare the versions and check in the...

Hi,
We are using the datastage server edition 7.5.1.A .
Is there any Subversion plungin available for the datastge client 7.5.1.A to check in the dsx files into subversion repository?

Hi All, I am using KeyMgtGetNextValue transform inside transformer for generating sequence number . I am passing 100 as the initial value for SequenceName KeyMgtGetNextValue(%SequenceName%). My job aborted with following error . DataStage Job 1063 Phantom 29104 "SDKSequences" is already in...

I have two configurations: node1: { node "node1" { fastname "tnet368" pools "" resource disk "/prop/loc/tnbilfor/dtstnbilfor/work/node01/disk00/" {pools ""} resource scratchdisk "/prop/loc/tnbilfor/dtstnbilfor/work/node01/scratch00/" {pool...

Hi , Thanks for your reply but I am not able to understand the property's help Directory for Data and Command Files The directory in which the data file (INPDATA.DAT), command file (CMD.CLP), and batch files (ULOAD.BAT) are generated. If these files already exist, they are overwritten. If you specif...

Hi , I am loading data from a sequential file to DB2 database . I am using DB2/UDB stage for loading data . In the properties of the DB2/UDB stage I need to give the value for directory for data and command files. Please let me know what value I have to give for this parameter. If I run the job with...

Hi , There may be any foreign key constraints in the database where you are loading . So check the datastage director to get more information and also check the schema for foreign key issues. Hi all. I m running a job.which load data to Teradata table. But in my DS job is show 40 rows transfer ,i op...

Hi ,

Try writting server routine. May be it will help you.

Hi , Check the data type and data in the database by querying directly in the database for those two columns, View the data through some editor you will get some idea. Thanks Thiru I have 55 columns in the file and only 2 columns have the problem. i.e., they are getting rejected. how can i set the d...

Hi, I guess unix signal is kiling your job .So talk to your unix admin and resolve the problem. Thanks Thiru Hi, We are having a Set of Jobs which run on GRID in Production daily one or the other job aborts with the following message "main_program: Unexpected termination by Unix signal 10(SIGBU...

Thanks a lot

Thanka a lot

Hi , I want to use CSV as input and I have to insert data into DB2. But I have to use some of the fields in CSV to generate the XML . Then XML has to go into DB2 in one field .Some of the fields from CSV has to go to the database as direct inserts. I am able to generate XML . But I am not able to co...