DSXchange

The Job Log we currently have is very limitted and only indicates if the job is successful or not. Is there any sample code to add to the script to give the following details A) i) Job Status ii) Number of Rows Written iii) Number of Rows Looked up B) how do I get the director log for a particular r...

I have a File to Capture rejected records....Is it Possible to get an alert everytime this File is written to...? If so how..thanks....(without using job sequence)

Thanks for the input..shall try and see if its successful

I got it working...Thanks A lot....I was trying it on a windows platform that's why it wasnt working..... The source is a Fixed width sequential file. The footer contains the number of records in the file excluding the header and the footer. I am required to : (1.)To verify if the number of actual r...

Hi, I am reading a fixed width sequential file with a header and footer....The footer gives the number of rows in the file. I would like the first step of the job to validate if the number of rows of data in the file match the number of rows in the footer...If it is correct I would like it to proces...

I tried Using the following command.....sed -e '$d' -e '1d'...The job gets aborted and this is the message :

Load_Test..TBL_TEST.Input: ds_seqopen() - Win32 error in CreateProcess() - The system cannot find the file specified.

The source is a Fixed width sequential file. The footer contains the number of records in the file excluding the header and the footer. I am required to : (1.)To verify if the number of actual records in the file, match the number of records stated in the footer. (2) To Remove the header and footer ...

Hello, I am loading 300k records from a sequential File to a DB2 Table.... This is done on my local machine......The rate of transfer is a pathetic 32 rows/sec. (i) Initially the table does not exist. (ii) The update Action : Update or Insert (iii) Array size = 1 ; Transaction Size = 100 Would appre...

What if there are lots of records in the target table....will it affect performance ? Wouldn't it better to have a separate job to clear the table like ray says....or before routine script ?? Anyone know of a script to clear the tables ? I am using a DB2 stage. Should I use like a DELETE or is there...

I am using a DB2 stage.

Should I use like a DELETE or is there anything else to clear multiple tables ?

Hello, I need to clear three tables before I execute my job. My Job currently does a clear and insert. Due to the dependancy on other tables i need to clear all three tables before I begin the job. Any suggestions on how I could accomplish this..? Should I do it by way of a script or is there any sh...

does that mean I am better off using my filtered DB2 stage as the lookup to do the same function ? Hashed file lookups do not support a BETWEEN type of lookup. You can use the SQL query on a hashed file (ODBC or UniVerse stages), but the performance is going to be abyssmal (full table scan for each ...

Is it possible to do a lookup on a hashfile to retrieve records between certain dates.....I am able to do what I want using a DB2 stage....but using a hashfile I cannot select the particular records I want......I used the account name option but it disables the selection when I use it as a lookup......

I do a look up on the target database before loading the data. I tried it with six records and my job worked....then when i tried it with 1500 records the job just froze.....and now i cant access the target table either...how do i correct it..... the lookup is done on a DB2 stage and the target is a...

I have a column A with value ( 8.0000) and Column B ( 21.4300)

When I multiply Column A and B My value should be 171.44 but the answer I get is 171.50. The target column is (15,2)

If I substitute the input link by the real values the result is ok but otherwise no..how do i fix it