DSXchange

U can capture the reject rows without warning by writing the rejected row through an interprocess stage into a sequential file. When u specify reject row and try to capture the rejected rows into a seq file then it generates a warning. Capture the rejected rows into a IP stage and then into a seq fi...

Thanks for the suggestions.

Hi, I have a job which extracts data from a oracle database using odbc stage and splits data into 7 files based on the @OUTROWNUM. The files are split as 40 million, 40 million, 30 million, 20 million, 20 million, 20 million and so on.... I checked it after it ran and the third file is empty. I chec...

hi, I have a job which extracts data from one table to another table in Oracle database. There are 3 columns in the table which has a number in milliseconds. The number represents number of milliseconds from jan1 1970. So if a record was created on jan1 1970 at 12:00 am then the value in those colum...

Hi all, I am using the DB2 bulk loader stage to load data into DB2. It works fine with the sequential file load method, but fails with the NamedPipe load method. Error message: [quote]STANDARDIZED_DB2_LOAD..DB2_UDB_Load_27: Invalid pointer to stage user data mkfifo error creating named pipe[/quote] ...

The problem is solved. My user-defined sql query and my table definitions were not in sync. I changed that and its working fine now.

Thanks.

Hi, I am getting this error in one of my jobs, that was working fine till now. It doesnt give me too much info. Error message: Warning: XXX..Transformer_62: %s Fatal: XXX..Transformer_62: |-100| Any help would be great, I tried copying the job, renaming the stages and replacing the stages with new o...

Thanks Ray. It worked fine.

Hi, I have a job which retrieves data from a Oracle database and writes into a flat file. Then I have to ftp that file and go back to the database and delete the rows which have been extracted. I have to delete the rows from the table by selecting the maximum time stamp from the flat file and delete...

Hi all, I am trying to do a fast export from Teradata using Datastage. I was able to do a fastexport from a single table, but when I tried to do a fast export from two tables using a user-defined sql join query it bombed. I was wondering if we can do a fast export from multiple tables using a single...

Hi sainath, I am actually trying to delete that job, bcos i have a copy of it. The job does not exist in the director. But when i click on the category(datastage director) under which this job was there it throws me a message saying configuration file missing for that jobname. In the datastage desig...

hi, I had a problem opening one of my jobs in datastage. I cleared the status file, cleaned up resources and also killed the process in unix. But didnt work. Then i went ahead and deleted the rt_config, rt_status, rt_bp and rt_log files, but didnt work. Now my admin said he can restart the server an...

Hello all, I am getting this error when I try to use the Teradata mload stage. Its been working fine till now and no changes have been made to the job. Teradata_Multiload_2: Unable to start MultiLoad process : MultiLoad failed: Check MultiLoad report /tmp/**** This is wat the report says: **** 08:24...

Hi all, I have a master sequence job which calls many sequences within it. Each one of the sequence job updates 4 tables in the database. My problem is how to stop my sequence if i get 0 rows and trigger the next sequence. If i get 0 rows then it should not update any tables and go to the next seque...

Hi, I am getting this error when I use the XML input stage. My test data has only 3 rows. "DataStage Job 539 Phantom 2531 Program "DSD.StageRun": Line 301, Square root of a negative number. DataStage Phantom Finished" What is this phantom and where would the logs be?? Any suggest...