DSXchange

Its DataStage Designer version 7.5

I can't find Stored Procedure stage in DataStage 7.5 Server Edition, but it meant for ODBC Stage, then Yes I tried this. Following is things I have tried: 1. Imported Stored Procedure from Database with two input parameters and one output parameter. 2. In a server job, added one Oracle stage where I...

Hi, I have a stored procedure which takes two dates as input, calculates the no. of working days (by excluding weekends and holidays) and returns the number as the output. This stored procedure is available in Oracle database. Now, could you anybody please guide me in calling the stored procedure fr...

I have 4 jobs and one job sequence which runs these 4 jobs. Now, my requirement is to jun the job sequnce repeatedly (looping, like once the job sequence completes running 4 jobs, the sequencer has to be kicked off immediately and run the 4 jobs again) until some time is reach. Say I start the Job S...

Actually I used semi-colon and a space in between and it worked for me. Thanks

Thanks Maveric, it was very helpful

Hi,

Could anybody please tell me how to find out how many records are coming in and how many records are going out from a stage (or from a link).

Thanks in Advance.
KVN

devidotcom,

Please could you eloborate on what is to be done?

Thanks

Hi, I want to send a notification mail on the sucessful run of a job, so I had a global parameter defined for it and configured a mail to send a notification. In the parameter, i have supplied two email addresses separated by comma (also tried with ; ) but its not working for me. Can anybody please ...

problem is not with rejecting them. but i am missing something, while reading the source files, the new line character also comes along the data and I am unable to strip it off.

[quote="ArndW"]Unless your fixed-width file has record delimiters (i.e. <cr><lf>) you cannot read it if some records have different lengths. So, does your file have line/record delimiters?[/quote]

New line character can be considered as end-of-record.

[color=blue] Hi, I have fixed width flat file with only one column of size 618 char. I have no problems in reading the correct record, but there can be invalid records with either less or more than 618 char length. I want to identify these bad records and route them to a different file. Could you su...

In the first statement svCurr is used which is not defined till now and is done in the next statement. I was under the impression that it is defined so Datastage throws error.

Thanks for the help, its working.

I will explain my exact requirement: I have one key in the source which will be in sequence like 1,2,3, etc. When I pull the data to DW, I need to ensure the sequence is not missed out. So first thing I have to find out, what is the max value of the key avaibale in target. Then I read the data and e...

Appreciate your prompt reply. I have tried that, but it didn't seem to be working out for me. Say I have 10 records like follows: Col1 1 2 3 4 6 In the above, the sequence is missing after the value 4. Here I need to increment the value of SV1 by 1 if it is continous, other it should not. I tried do...