Search found 18 matches
- Fri Oct 04, 2013 2:34 pm
- Forum: General
- Topic: Better logging for specified metrics
- Replies: 3
- Views: 1684
Better logging for specified metrics
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...
- Mon Jun 24, 2013 3:34 pm
- Forum: General
- Topic: Sequence job
- Replies: 7
- Views: 3033
Sequence job
How to print the data in a file in the email body using datastage sequence stages ?
- Fri Mar 15, 2013 9:11 am
- Forum: General
- Topic: Function in Basic Language
- Replies: 3
- Views: 2032
Function in Basic Language
Is there function in datastage basic language which is used to make the job wait for 10 minutes and then run
- Wed Apr 04, 2012 8:29 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Datastage func Converting From UTC to Estern Standard Time
- Replies: 2
- Views: 5629
Datastage func Converting From UTC to Estern Standard Time
Is There a Datastage Function in 8.5 to Convert Timestamp from UTC to EST Can Anyone Please Help.
- Wed Nov 16, 2011 2:24 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Seconds from timestamp
- Replies: 3
- Views: 3685
Re: Seconds from timestamp
Sorry i got the answer.
Datastage is right and db2 is wrong.
Datastage is giving the correct result.
Datastage is right and db2 is wrong.
Datastage is giving the correct result.
- Wed Nov 16, 2011 1:11 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Seconds from timestamp
- Replies: 3
- Views: 3685
Seconds from timestamp
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...
- Sun Nov 13, 2011 7:27 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Creating a key using database sequence in the transformer
- Replies: 3
- Views: 2322
Creating a key using database sequence in the transformer
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?
Can any one help me how to achieve this?
- Mon Aug 29, 2011 9:20 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Sequence is aborting due to following error
- Replies: 1
- Views: 2569
Sequence is aborting due to following error
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...
- Thu Jul 28, 2011 9:53 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Parsing Names
- Replies: 7
- Views: 4204
- Wed Jul 27, 2011 3:43 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Parsing Names
- Replies: 7
- Views: 4204
Parsing Names
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...
- Tue May 31, 2011 11:40 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: writing from oracle view to a oracle table?
- Replies: 2
- Views: 2662
writing from oracle view to a oracle table?
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...
- Mon Apr 11, 2011 9:50 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: REMOVING SPECIAL CHARACTERS FROM A STRING
- Replies: 2
- Views: 4617
REMOVING SPECIAL CHARACTERS FROM A STRING
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
EXAMPLE --- (732) 556-6677
RESULT --- 7325566677
CAN ANY ONE SUGGEST ME HOW TO DO IT AND PLEASE GIVE ME THE SYNTAX
- Thu Mar 03, 2011 8:33 am
- Forum: General
- Topic: Difference Between data stage 8.1 and 8.5
- Replies: 1
- Views: 4919
Difference Between data stage 8.1 and 8.5
would you please specify the difference between 8.1 and 8.5 which is the new version of datastage in the market.
- Mon Feb 28, 2011 3:18 pm
- Forum: General
- Topic: metadata server
- Replies: 4
- Views: 3205
- Mon Feb 28, 2011 3:11 pm
- Forum: General
- Topic: metadata server
- Replies: 4
- Views: 3205
metadata server
what is metadata server in datastage ?