DSXchange

kcshankar

Hi Minish,

For Audit purpose I need to know the jobs changed for todays date.

I'm running the command

use CLASS ='2' to get only the status of the jobs.

SELECT * FROM DS_AUDIT WHERE DTM > '2006-02-01 00:00:00' AND CLASS = '2'

regards
kcs

kcshankar

Hi somu_june, When the target columns metadata does not match with the source's(In your case source "int32" to target "string[max=18]")and no explicit conversion has been made you will get this warning message. DS does the number to string conversion and warns. Try by changing yo...

kcshankar

Hi Ravi,

Try this command to find Job Modification Date(s)
SELECT MODIFIER,DTM FROM UNNEST DS_AUDIT ON MODS WHERE CLASS ='2' AND INSTANCE = 'JobName';
Output:
Modifier-------modification Date
user-----------------Date

Regards
kcs

kcshankar

Hi Ravi,
Try this command,

Code: Select all

SELECT INSTANCE,CREATOR,DTC FROM DS_AUDIT WHERE CLASS ='2' AND INSTANCE = 'gmt1';

Output:
Instance Id.jobname
Created by...user
Created on...job cration date

regards
kcs

kcshankar

Hi loveojha2,
to know more, go thru the discussion between kumar and Ray in the following link...............
http://dsxchange.com/viewtopic.php?t=97 ... c4135269d9

regards
kcs

kcshankar

Hi Puli.reddy, I am curious to get by using @DATE I was using the following expression to get Oconv(@DATE,"DYM[4,2]") but it gives a blank value between year and month. try this to extract year and month values in the format "YYYYMM" from @DATE function Oconv(@DATE, "D YM&qu...

kcshankar

Hi Jayant,
Using checkpoint option you can make the sequence to restart on failure.

regards
kcs

kcshankar

Hi kumar,

I mean ranking for all or atleast top 50,Which can be shown in their personal profile.

regards
kcs

kcshankar

Hi Murali,

Search the forum for "String value to Date type unsuccessful ",You will get lot of posts related to your topic.

regards
kcs

kcshankar

Hi,
How about Ranking based on number of posts for all the participants.
1.ray.wurlod
2.chulett
3.ArndW
..
..
..

Regards
kcs

kcshankar

Hi Ray,ArndW,Kumar,Craig Thanks for giving valuable suggestions. I altered the routine and it is working fine now. *------------Routine to find active stages----------------* $IFNDEF JOBCONTROL.H $INCLUDE DSINCLUDE JOBCONTROL.H $ENDIF ActiveStages = DSGetJobInfo(DSJ.ME, DSJ.STAGELIST) ValidOpen = @F...

kcshankar

Hi Ray, For any job, no of Active stages in a job = Total no of process -1(Controller) correct me if Iam wrong. Only sometimes. If your design has two active stages directly linked (for instance two Transformer stages) they will be executed in one process. However, if you have inter-process row buff...

kcshankar

Hi venkat, There are two kinds of routine that you can write in DataStage,one is a Transform function, the other is a before/after subroutine. Both Transforms and Routines are re-usable components, which are stored in the DataStage Repository. Transform function routines are called for every row pro...

kcshankar

Hi sudhakar,
Here is an alternative.
Ereplace(in.Source," ",Char(10))

regards
kcs

kcshankar

Hi Kumar,Ray
Thanks for your replies

I execute this command in DS Administrator.
I didn't copy the result,i typed it.

Regards
kcs

Search found 89 matches