Search found 28 matches

by Vino_joe84
Wed Jun 04, 2008 6:02 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Aggregate columns based on the condition
Replies: 1
Views: 1280

Aggregate columns based on the condition

Hi, Help us to implement the logic. My Input records is in below. ID name Sal Dept Status 10 vin 1000 eee d 200 kiui 1000 cs e 300 AV 152 cs d 300 hfajs 600 cs e 400 afd 900 eee f 500 afd 800 cs f My output should be like this D_Status_Sal E_status_Sal F_Status_Sal eee_Dept_sal cs_Dept_sal 1152 1600...
by Vino_joe84
Thu May 22, 2008 11:44 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Capturing variables and parameters from unix script into DS
Replies: 1
Views: 1186

Capturing variables and parameters from unix script into DS

Hi, We have a requirement to capture the variables and parameters created in a unix script into my DS job. Is there any method by which i can retrieve the values of all the variables exported in my shell script. Iam using a shell script since lot of logic is involved and addtional perl scripts are u...
by Vino_joe84
Tue May 20, 2008 2:02 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Basic Transformer Stage
Replies: 11
Views: 6963

After going to the customize pallet option,

We are able to see only the transformer in the processing/ parallel folder.

We are not able to see the Basic transformer in the processing/ parallel folder.

Basic transformer is the separate PLUG-IN that needs to be bought or how do we install?
by Vino_joe84
Tue May 20, 2008 1:44 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Basic Transformer Stage
Replies: 11
Views: 6963

Please let us know my understanding is correct or not.

1) We will have two different transformer stage in PX 8.
2) Once we customize the pallet we will get both transformer and Basic transformer.
by Vino_joe84
Tue May 20, 2008 12:25 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Basic Transformer Stage
Replies: 11
Views: 6963

Please correct me if i am wrong.

1) We will have two different transformer stage in PX 8.
2) Once we customize the pallet we will get both transformer and Basic transformer.
by Vino_joe84
Tue May 20, 2008 12:24 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Basic Transformer Stage
Replies: 11
Views: 6963

Please correct me if i am wrong.

1) We will have two different transformer stage in PX 8.
2) Once we customize the pallet we will get both transformer and Basic transformer.
by Vino_joe84
Tue May 20, 2008 12:16 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Basic Transformer Stage
Replies: 11
Views: 6963

Basic Transformer Stage

Hi, There is only one transformer stage is avail in DS 8. But in document they have specified both transformer and Basic trasnformer stage is avail. How do we get both these stage? Do we have only one stage called transformer? Whether transformer can be changed to Basic transformer stage functionali...
by Vino_joe84
Mon May 19, 2008 9:30 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Row count generation
Replies: 13
Views: 5619

Row count generation

Hi,

We have a requirement in which we need to seperate the 10th record from a file and process it separately. Is there any way to filter the 10th record alone from a file using any stages by checking the rowcount . Any help is appreciated. Thanks
by Vino_joe84
Fri May 09, 2008 4:35 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Installation DS-8
Replies: 1
Views: 1140

Installation DS-8

Hi,

Is this possible for us to install the Data stage 8 version in Windows 2000.

Any restrictions is there in installing DS 8 in windows 2000.

Can you please help us out on this issue?
by Vino_joe84
Fri Apr 25, 2008 3:55 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Sequence number Generation
Replies: 2
Views: 1560

Sequence number Generation

Hi,

We need to create a number sequentially.
For ex. today my job ends with 1000 then tomorrow if i run the job it should start 1001.

How to achieve this in DS?

Do we have any stage to implement this?
by Vino_joe84
Fri Apr 25, 2008 3:47 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: To read EBCDIC format data present in flat files
Replies: 2
Views: 1253

To read EBCDIC format data present in flat files

Hi,
We have EBCDIC format flat files used in our project. Can anyone please suggest us any methodology to handle such file datas in DS. Any help would be appreciated.
by Vino_joe84
Fri Apr 25, 2008 3:05 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Additional features in DS 8x parallel
Replies: 3
Views: 1789

Is it possible for you to tell what are all the new stages has been added?
and what enhancement has been implemented?
by Vino_joe84
Fri Apr 25, 2008 2:20 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Additional features in DS 8x parallel
Replies: 3
Views: 1789

Additional features in DS 8x parallel

Hi,

We would like to know what are all the addional functionalities is used in DS 8x.

What is the difference in between 7.5.2 to 8.

If any one have document please share with us.

Thanks,
Vino
by Vino_joe84
Tue Apr 22, 2008 5:51 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Interpreting Record format
Replies: 12
Views: 4604

I have tried that approach. It shows the warning. Rows are not delimited.Contains long values.

Your help is appreciated.
by Vino_joe84
Tue Apr 22, 2008 2:09 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Interpreting Record format
Replies: 12
Views: 4604

Hi,

Our sequential file is .dat file and not .csv file.

ArindamBanerjee,

I have tried your approach. It shows the warning. Rows are not delimited.Contains long values.

Please let me know any other approaches to resolve this issue.