DSXchange

Hi,

We have numerous prod jobs which makes the log full.

We have a scenario where we want to know which job has created the particular log.

Is there is any routine/ utility which can give the tell which log file is been created by which job.

Thanks in advance.....
Regards

Hi,


I've a scenario as below

EMP id

123
123
456
456
222
234

I need to o/p in the format

emp id key

123 1
123 2
456 1
456 2
222 1
234 1

The logic is to start the seq again from 1 when ever the emp id changes.

Thanks in advance.....
Regards

Hi, I've a very simple job, which updates the rows in Table. The only problem is the table has 206 columns and 1 million rows. I'm only updating 6-7 columns in table but the job performance is like it takes 10 hours to update. Can there be any suggestions to improve the performance of jobs from DS /...

Hi Craig, How to check the return status of routine in Nested condition stage. It do not give the option to do it. The scenario is If the routine returns the value 44 the run the job else do not run the job. Regards Simple enough with a Nested Condition stage. Have it check the return status and eit...

Hi, I need to start or abort the job based on the return value of the routine. Scenario I've a routine which I'm planning to call in sequencer thro' routine stage the routine returns the value 1 and 0 , I need to start the Datastage job if the value is 1 and do not start the job if value is 0. Regar...

Hi , The D stands for (-) and (+) or nothing stands for C. And length of the mainframe field is 14. Regards, Hi Shrey3a, I have encountered a similar case before. It looks like you have to encode your values using a particular logic. Find out if there is any logic to be applied inorder to get the 00...

Hi, I've a typical scenario , I need to do the below conversion to provide the file to mainframe group so that they can match the data from ascential generated file with mainframe file e.g. Value -212.00 should be converted to 0000000021200D The above looks like decimal to Hex conversion. I tried al...

Thans it worked with code and sending one mail for any no of rows


If @INROWNUM =1 then (DSSendMailTester('munish.sharma@anheuser-busch.com', 'munish.sharma@anheuser-busch.com', 'test', 'mail.anheuser-busch.com', "dstest")) else '0'

Thanks again for all help

where in transformar I use the condition in constraint link or stage variable....I'm struggling on it

Hi,
Is there is way we can identify in Ds that particular link rownum >1 and then send an email.

It may be in the same job or other job which checks the previous job link info for the same.

Rgds,
Munish

[quote="pnchowdary"]Hi Munish,

Well, I am confused now

Is your reject link writing to a sequential file or an Oracle table?[/quote]

Its writing the Oracle table.

Hi ,

But in my case the reject link feeds to oracle table so I need to check if the data is been passed thro' reject link then only do an email after the job is finished.

Rgds,
munish

Hi, I've below scenario : There is a reject link in my job populating the error file and I need to send an email to group of people after the job has finished/ aborted only when the data comes to reject link. for e.g. I extracted 1000 rows and 998 made to target and 2 is been sent to reject link tha...

Hi, I've a scenario in look up as stated below. Source link Crse_CD Col1 Col2 Col3 Col4 Col5 M10001 1 a c c b M20001 4 s d d d Look up Crse_cd M10001 M10001 M10001 M20002 M20002 I've to do a look up on Crse_cd column and divide my source in to no of occurence of Crse_cd in look up link i.e. M10001 c...

Hi ,

I tried looking for code/routine which can be executed from DS enviorment to fetch the value from oracle table but was not able to find.

Can anybody help on this..

Thanks in advance...

Regards

Sainath.Srinivasan wrote:Look for DSExecute.