Search found 8 matches

by ankesh
Mon Oct 25, 2010 11:09 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Multiple Rows into one single row, comma seperated.
Replies: 9
Views: 8329

Use of stage variables

HI, Sort and Partition the data on first column, use stage variables to store second column. Concat the values of second column into the stage variable for repeatition of first column. (You might want to use a couple of stage variables to get the result). You will get below result- 4 158 4 158,156 4...
by ankesh
Mon Aug 23, 2010 12:34 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Transformer Compilation error
Replies: 6
Views: 5573

I am getting the same error.Please share the solution.


Regards
Ankesh
by ankesh
Mon Aug 16, 2010 5:13 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Basic Transformer in Datastage 8.1 Parallel job
Replies: 7
Views: 7550

Totally agree with you Chulette. Even I want to do it the right way...but I've to give them output from whatever time and resources I am provided.
by ankesh
Fri Aug 13, 2010 5:23 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Basic Transformer in Datastage 8.1 Parallel job
Replies: 7
Views: 7550

Hi Chulett, We have lots of basic routines in the existing projects and the timelines are very short, hence we decided to use same routines in parallel jobs as well.
by ankesh
Fri Aug 13, 2010 5:22 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Basic Transformer in Datastage 8.1 Parallel job
Replies: 7
Views: 7550

Thanks ArndW, It worked. Saved a lot of efforts. :)
by ankesh
Fri Aug 06, 2010 5:02 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Basic Transformer in Datastage 8.1 Parallel job
Replies: 7
Views: 7550

Basic Transformer in Datastage 8.1 Parallel job

HI, Ours is a Datastage 7.5 Server to Datastage 8.1 Parallel migration project. I need to use the basic routines called in Basic Transformers in Parallel job. But I am not able to pull Basic Transformer stage into Parallel Job. (Can't select the basic stage in palette when a Parallel job is open) Is...
by ankesh
Mon Jul 14, 2008 2:42 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Teradata_Enterprise_44,0: Operator terminated abnormally: re
Replies: 3
Views: 1850

Teradata_Enterprise_44,0: Operator terminated abnormally: re

Hi, I am running this job with below stages. ODBC Ent ------->Copy------->Teradata Ent. The target stage is having a closed command with one Insert and one Update statement. I am getting below error due to which the job is getting aborted: Teradata_Enterprise_44,0: Operator terminated abnormally: re...
by ankesh
Wed May 16, 2007 3:10 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Exporting and inporting a DS job.
Replies: 1
Views: 948

Exporting and inporting a DS job.

HI,

I am new to DS.
I need ro know, how to export and then import a job from and to different servers?

Regards