Search found 24 matches
- Mon Mar 08, 2010 9:07 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Multiple values in Local parameter...
- Replies: 1
- Views: 1552
Multiple values in Local parameter...
Hi Gurus, In my new reuirement, we need to add the extra local parameter value while running the sequence. Example: we have common job, in that job source query we have the logic as COLUMN='#LOCAL_PARAMETER#'.(LOCAL_PARAMETER is string type) while runtime we are passing #LOCAL_PARAMETER#="XXXX&...
- Sun Jul 12, 2009 8:20 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: issue with difference stage
- Replies: 1
- Views: 1412
issue with difference stage
hi Our requirement is first time we will get information from source we will insert all the data(for 1st time) from 2nd time onwards we need to identify the flags. whether the record is new record or existing record and if any record not coming from the source and existing in target we need to delet...
- Tue Jan 20, 2009 10:31 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: JobAuditReport..BeforeJob (DSAttachJob): Job control error (
- Replies: 8
- Views: 5280
- Tue Jan 20, 2009 9:12 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: JobAuditReport..BeforeJob (DSAttachJob): Job control error (
- Replies: 8
- Views: 5280
Is your multi-instance job running another job 'before job'? If so, is that other job MI as well? :? ... Yes, In my sequence we are calling the MI job 12 times , but flow is sequential (i.e one MI with some invocation id after this job completion , next MI with different invocation id like this we ...
- Tue Jan 20, 2009 8:29 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: JobAuditReport..BeforeJob (DSAttachJob): Job control error (
- Replies: 8
- Views: 5280
JobAuditReport..BeforeJob (DSAttachJob): Job control error (
Hi Guru's, we have the Multiple instance job, That job getting aborted and giving fatal error as follows: JobAuditReport..BeforeJob (DSAttachJob): Job control error (-12) (DSOpenJob) Cannot get shared access to executable file for job XXXX. what may be the possible reason for this? Thanks in advance...
- Wed Nov 19, 2008 10:26 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Restate logic...
- Replies: 1
- Views: 1496
Restate logic...
Hi, As a part one of the my requirement is, Currently we get getting data(source) and we are applying some transformation logic on that data, then put it in the sequential file(Target) with append mode. If we will get the wrong data from the soure, that data is also appending. we need some logic to ...
- Thu Oct 09, 2008 4:44 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Issue with date...
- Replies: 3
- Views: 2114
Issue with date...
Hi Guru's, we have a issue with DATE feild column, From source we are getting varchar feild, this varchar is mapping to DATE feild in target. Due to source is VARCHAR, we are getting CHARACTERS for this feild but target is date field. due to this reason job getting aborted. For source field the data...
- Fri Aug 22, 2008 6:45 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Date from File name...
- Replies: 1
- Views: 3143
Date from File name...
Hi,
we are replacing our old system(PROC) by datastage jobs.
In old system, for date field we are getting date from file name itself.
That file name format like this:A01yymmdd0.dat
In our data stage how we can handle this one?
Thanks in advance...
we are replacing our old system(PROC) by datastage jobs.
In old system, for date field we are getting date from file name itself.
That file name format like this:A01yymmdd0.dat
In our data stage how we can handle this one?
Thanks in advance...
- Thu Aug 21, 2008 6:21 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Integrate Web Service into dataStage Job
- Replies: 8
- Views: 3112
Jasti, I'm new to Datastage, I read in an article that we need to install the webservices pack for v7.5.1 and two Real time stages WS Client And transformer stage gets added. For ex i need to access the google search web service which uses SOAP api into our datastage job how should i go about. The s...
- Thu Aug 21, 2008 5:33 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Integrate Web Service into dataStage Job
- Replies: 8
- Views: 3112
Integrate Web Service into dataStage Job
Can anyone who has used the webservices in DS Version 7.5.1 help me in knowing how to integrate the webservice into the datastage job.
Thanks in advance.
Thanks in advance.
- Mon Jun 30, 2008 10:50 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Query taking much time...
- Replies: 5
- Views: 3238
- Sun Jun 29, 2008 11:39 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Query taking much time...
- Replies: 5
- Views: 3238
- Fri Jun 27, 2008 3:21 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Query taking much time...
- Replies: 5
- Views: 3238
Query taking much time...
Hi Gurus, My source database is Oracle and one of the source query executed in 1 min in TOAD(Database tool) and that same query i putted in source oracle stage (job level) then for the extraction of data is taking nearly 50 mins. I am getting what may be the problem for this, can any one provide the...
- Wed May 21, 2008 7:49 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Compilation error....
- Replies: 12
- Views: 5389
Compilation error....
Hi guru's, I am getting below error while compiling the job.please any one give any idea to solve this error and please tell me how to compile the parallel routine. Output from transformer compilation follows: ##I TFCN 000001 08:40:59(000) <main_program> Ascential DataStage(tm) Enterprise Edition 7....
- Sat Apr 26, 2008 7:37 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: I got an error while running a job
- Replies: 2
- Views: 1405