DSXchange

DataStage 8.5 Looking for a way to enable logging of specific metrics for any given production DataStage job. This is in effort to monitor performance on reoccuring jobs as they come up with various concerns. Specifically, is there an automated notification to generate the below info for each run of...

How to print the data in a file in the email body using datastage sequence stages ?

Is there function in datastage basic language which is used to make the job wait for 10 minutes and then run

Is There a Datastage Function in 8.5 to Convert Timestamp from UTC to EST Can Anyone Please Help.

Sorry i got the answer.


Datastage is right and db2 is wrong.

Datastage is giving the correct result.

I need seconds from timestamp i am using the function SecondsSinceFromTimestamp(svCSOUTTSA, svCSINVTSA) but i am not getting the currect result. when the difference between the two is very high ie : 2011-07-01 15:27:00 --- 2011-08-23 17:41:00 ---- 4587240 i am getting 4500840 when i use the db2 func...

I need to use the database sequence to generate keys in a transformer stage and send it to target database stage DB2.

Can any one help me how to achieve this?

I am getting the following error message SQL*Loader-704: Internal error: ulconnect: OCIServerAttach [0] TrgCcdbUser,3: ORA-12520: TNS:listener could not find available handler for requested type of server My sequence has 12 jobs when i run the jobs separately the jobs are running fine. but when i ru...

Comma always appears after the last name.

I need to split this name into 3 fields even if there is no middle name Names Broyles,Keith T Hammond,Edward J Bullock,Monica Poston Jr.,Hugh O Result firstname lastname middlename Broyles Keith T Bullock Monica I am facing difficulty if the name does not have a middle name can any one please give m...

I am loading into a oracle table from a oracle view and i am getting the following wierd error. TrgCcdbStgAcctWkSalePassThru,3: The system(sqlldr CONTROL=ora.3317770.688603.3.ctl LOG=ora.3317770.688603.3.log BAD=ora.3317770.688603.3.log.bad SILENT=header PARFILE=ora.3317770.688603.3.par) failed; see...

I NEED TO REMOVE SPECIAL CHARACTERS FROM THE STRING

EXAMPLE --- (732) 556-6677

RESULT --- 7325566677

CAN ANY ONE SUGGEST ME HOW TO DO IT AND PLEASE GIVE ME THE SYNTAX

would you please specify the difference between 8.1 and 8.5 which is the new version of datastage in the market.

what does metadata repository contain?

what is metadata server in datastage ?