Search found 27 matches

by reddy.cba
Wed Mar 04, 2009 6:21 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: IIS 8.0 - Parallel jobs - runtime error
Replies: 8
Views: 5625

You ar enot authorised to run any jobs in the project.
by reddy.cba
Wed Mar 04, 2009 6:19 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: IIS 8.0 - Parallel jobs - runtime error
Replies: 8
Views: 5625

You ar enot authorised to run any jobs in the project.
by reddy.cba
Wed Apr 09, 2008 12:30 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to read an XML file in Parallel JOb?
Replies: 4
Views: 2898

Tried with the stages as described, Now i am getting this error message: " Error occurred in call to ORPHCallActivePluginInitialize()." and also a warning message : "No repetition element specified for link "DSLink7". Please make sure a column that contains the repetition pa...
by reddy.cba
Tue Apr 08, 2008 10:24 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to read an XML file in Parallel JOb?
Replies: 4
Views: 2898

How to read an XML file in Parallel JOb?

Hi All,
What stage or File would we use to read an XML file in a parallel job?
Thanks in advance for your Help?
Regards,
Vee Yes
by reddy.cba
Wed Feb 06, 2008 6:16 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Failure During Execution of Operator Logic
Replies: 29
Views: 20789

remove semicolon from the sql statement..it worked fine for me..
by reddy.cba
Sun Nov 18, 2007 7:38 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: HOw to identifyfor a particular job belongs to which sequenc
Replies: 2
Views: 1567

HOw to identifyfor a particular job belongs to which sequenc

Can you please help me on this on HOw to identifyfor a particular job belongs to which sequence in Enterprise edition?

Like i have a JOb X where it Belongs to Sequnece A, But is there any where i can find out about the JOb X in which sequence this Job X has been called.

Thanks In Advance...

vamshi
by reddy.cba
Wed Jul 18, 2007 4:43 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Multiload JOb Hangs at near completion of Records
Replies: 3
Views: 1627

FOund the problem...
Prmiamry Index was created on wrong column and as a result... The job took ages to finish....

After changing the primary index column..it worked...
If any of you face any problem like this..check DDL for the Target DB and also check for the Indexing....

Many thanks to all
Vamshi
by reddy.cba
Tue Jul 17, 2007 4:00 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Multiload JOb Hangs at near completion of Records
Replies: 3
Views: 1627

I havnt tried running it, But will try again... Just in case i need to add any parameters if i am reading data frm a big dataset and writing into teradata, ? Are there any parameters i need to add to run the job smoothly... The same job was running fine when i ran with less than 100 records... I ass...
by reddy.cba
Tue Jul 17, 2007 2:33 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Multiload JOb Hangs at near completion of Records
Replies: 3
Views: 1627

Multiload JOb Hangs at near completion of Records

HI All, I am running a Multiload JOb in D/S Parallel edition, Input File is a Huge dataset contaning more than 12 million records, and i am writing this to Teradata using Multiload option. After nearly writing 12 million records the job does not do anything... It still hangs up.. can any one tell me...
by reddy.cba
Tue Jun 26, 2007 6:58 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Change Capture to Get the Deleted Recods.
Replies: 2
Views: 1622

Thanks Ray,
I was able to get by making the following change:

Using Full Outer JOin
and changing the Drop Output for Column to false from Its Default Stage(True).
by reddy.cba
Tue Jun 26, 2007 6:16 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Change Capture to Get the Deleted Recods.
Replies: 2
Views: 1622

Change Capture to Get the Deleted Recods.

HI, I will try my best to explain the Logic i am trying to build... we have a two tables A & B I have to get the results output to a dataset for Delete records, Edit Recods and Insert Records: Table A has two fields A1 & A2 with the values U1, T1 & U2, T2 & U3 , T3 Table B has two fi...
by reddy.cba
Tue Jun 26, 2007 6:00 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Delta Processing using change capture
Replies: 4
Views: 2444

Typo again..
WHen Input is Vamshi mohan , output should be vamshimohan.
Thanks
Vee Yes,
by reddy.cba
Tue Jun 26, 2007 3:35 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Delta Processing using change capture
Replies: 4
Views: 2444

Delta Processing using change capture

Is there any Trim Function in R 7.5 enterprise edition to trim the Blank spaces in between two words. Like if souce is 'vamshi mohan' can i get it as vamshi mohan. Removing more than one spaces in between. In the document it states we can use trail R function but this function is not available in th...
by reddy.cba
Sat Jun 23, 2007 9:18 am
Forum: General
Topic: Video tutorials
Replies: 10
Views: 4617

Typo...
Thanks Ray