Page 1 of 1

name some of the Routines to be used in PX jobs

Posted: Wed Aug 13, 2008 2:23 am
by sreedharmsc
name and give code of some of the Routines to be used in PX jobs commonly in any project . Example : date validation.

Posted: Wed Aug 13, 2008 3:04 am
by ArndW
sreedharmsc - Your query is so susupiciously like an interview question that you will most likely not get any responses. If you illustrate what you are looking for in more detail then someone will certainly answer.

name some of the Routines to be used in PX jobs

Posted: Wed Aug 13, 2008 3:10 am
by sreedharmsc
I am looking routines for the following
1.To collect the Status of the JOB after each Execution
2.To collect the Performance Statistics of the JOB after each Execution
3.To Collect the Audit Stats of the JOB (No of Records in Source, No of Records Inserted, No of Records Updated etc) after Each execution
4.Datastage Job Log Retrieval Component
5. Date Check Component
6.Numeric Check Component

Posted: Wed Aug 13, 2008 3:30 am
by LavanyaRamesh007
For performance stats- > APT_DUMP_SCORE
To Collect the Audit Stats of the JOB -> $APT_RECORD_COUNTS

Posted: Wed Aug 13, 2008 4:16 am
by ArndW
The routines commonly used for (1), (2), (3), (4) are:
DSAttachJob(), DSDetachJob(), DSGetJobInfo(), DSGetStageInfo(), DSGetLinkInfo().
I don't know what (5) and (6) mean, so cannot answer that.

Posted: Wed Aug 13, 2008 4:33 am
by ray.wurlod
IsValid() will do for (5) and (6).

When's the interview?