DSXchange

Hi ,

I would like to know is there any way we can get routine activity start time and end time in a job sequence.I am collecting job statics in a sequencer by using after routine in each job but i dont know how to get routine activity statistics.

Thanks

Can you please in which datastage stage i need to set the properties c you mentioned. where i nedd to jxl.jar package.

Thanks

importing stage means oracle table.I have already checked table metadata between prod and test databases and both are exactly same.
Can you please tell me any other things i need to check.

Thanks

a)There is no difference between the two enviroments.we checked with Datastage admin regarding this. b)After got this error we took the same file and processed in the test env and there is no difference in the data becusae it is the same file. we checked all the oracle table metadata between two env...

Hi, I am getting following warning in the transformer stage before loading into oracle table. xfm_tranformer,0:Field 'CLAIM_KEY' from input dataset '0' is NULL. Record dropped. I am using the following condition in the transformer. If NullToEmpty(inS1xfm.CLAIM_KEY)="" Then "" Els...

Can any one please tell me when we import table definitions from a table where all the metadata will be stored in datastage repository.what DS_ table contains all the imported table definitions.

Hi,

Can any one please tell me where can i found the documentaion for the following basic functions.

DSR.SUB.JOB.RESERVE
Call @SUBR(Key, Arg2)
Call DSD.Init(MyJobNo, Dummy2)
Key = DSR.SUB.JOB.COMPILE


Appreciate for your help

Hi vmcburney I added a copy stage to the oracle enterprise stage reject link and in the output columns of the copy stage added a column sqlstate and turned on runtime column propagation option.so I am able to compile the job and when i ran the job i am getting the following error when i try to write...

I am using this query to get warning limit for a job. SELECT @ID FMT '40L', EVAL "@RECORD<18>" WARNLIMIT FROM RT_STATUS751 WHERE EVAL "@RECORD<1>" = 'JOB'; Is there any way i can update the warning limit to 5.Can any one help me with query to update RT_STATUS table Thanks

Can you please explain me littile bit detail

I have an lookup file file like below. Not50,PLAN,HPHC 50,ANY,MEDICA I have the following input file. 100,PLAN 50,100 Here is the description. 100 means Not50 in the lookup file that means it matched and PLAN matched with PLAN then it should return HPHC. second row in the input file 50 matches with ...

Is there any way we can change the Projectwide (dsenv) defined ODCBINI value can be changed. In dsenv i have the following entry for ODBCINI. ODBCINI=/opt/dsadm/Ascential/DataStage/DSEngine/.odbc.ini I want to change that value to ODBCINI=/home/dstest/.odbc.ini I defined that value in my .profile an...

Hi,

Can any one please tell me how to access datastage Env variable value in basic routine.

Thanks

Hi,

Is there any way we can execute Basic routine in unix script.

Thanks

I created the following routine and i compiled it and it is successfully compile.But when i sued it in job activity custom conditon i am getting the follwoing error when i compiled that sequence. $INCLUDE DSINCLUDE JOBCONTROL.H JobHandle=DSAttachJob(JobName,DSJ.ERRFATAL) JobStatus=DSGetJobInfo(JobHa...