name some of the Routines to be used in PX jobs

sreedharmsc · Post by **sreedharmsc** » Wed Aug 13, 2008 2:23 am

name and give code of some of the Routines to be used in PX jobs commonly in any project . Example : date validation.

ArndW · Post by **ArndW** » Wed Aug 13, 2008 3:04 am

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.

sreedharmsc · Post by **sreedharmsc** » Wed Aug 13, 2008 3:10 am

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

LavanyaRamesh007 · Post by **LavanyaRamesh007** » Wed Aug 13, 2008 3:30 am

For performance stats- > APT_DUMP_SCORE
To Collect the Audit Stats of the JOB -> $APT_RECORD_COUNTS

ArndW · Post by **ArndW** » Wed Aug 13, 2008 4:16 am

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.

ray.wurlod · Post by **ray.wurlod** » Wed Aug 13, 2008 4:33 am

IsValid() will do for (5) and (6).

When's the interview?