DSXchange

Thank you for the suggestions . I see this message in logfile "(total CPU: 0.03)" for the stages. Can we take this as a CPU time in seconds. May be we will check for "total CPU:" and get the values. SEQL_Err_Bin_Master,0: Operator completed. status: APT_StatusOk elapsed: 1.40 use...

Hi: We are calling the server routine in Parallel Job as AfterJob Routine. I want to capture the CPU usage of the datastage job in statistics table. We wrote a routine StageCPUsec = DSGetStageInfo(DSJ.ME,StageName, DSJ.STAGECPU) Stagename is passed through looping logic. But the output i get is 0.0 ...

Got an answer from another post , with a search string GetEnvironment.


Thanks,
Nandha

Hi: I have a Environment Variable defined in Administrator - DS_IWH_SCHEMA and value assigned I included that in the Job Properties - $DS_IWH_SCHEMA with $PROJDEF I am able to use this in the Oracle EE stage to specify the schema for connectivity #$DS_IWH_SCHEMA#. But when i place it in the transfor...

Hi: I am performing Delete & UPSERT in the Data stage parallel Job. In the joblog I can see the events for Inserts & Updates . But Delete is not showing theough 23 records got Deleted. Any help. ORCL_Tgt_Usr_Whs_Security,0: Records inserted: 3,157 Records used for update: 0 Records rejected:...

Hi: I imported the metadata from DB2 tables in mainframe using the Plug IN DSDB2. I have a date field defined as LAST_MAINT_DATE DATE, in DB2. Metadata also shows as LAST_MAINT_DATE DATE, 10 When I view data , I am seeing values as "10767 (1997-06-23)" . If I change the SQL Type to Char , ...