Search found 39 matches

by aditya
Thu Apr 06, 2006 10:22 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Loading 50million records from Oracle9i to Oracle9i
Replies: 7
Views: 3667

Did you try using the IPC Stage?

-- Aditya.
by aditya
Wed Apr 05, 2006 12:07 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to create sequence number per ID?
Replies: 4
Views: 3026

Ask the DBA to create a sequence and use it in you query. You can also create one in the ERWIN data modeller and pass it over the script to the DBA.

Thanks
Aditya.
by aditya
Wed Mar 29, 2006 4:03 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Anybody ever recieve a 'Player Terminated' error? (REPOST)
Replies: 3
Views: 1647

Re: Anybody ever recieve a 'Player Terminated' error? (REPOS

Try stopping and re-starting the DS Server HTH Aditya. Nothing came up on Search here, so sorry if this has been discussed before. I'm running a Datastage job that connects with our Oracle database, and it's been Abending with the following 'Fatal Error' message: node_node1: Player 2 terminated unex...
by aditya
Thu Mar 23, 2006 11:04 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DS Sequences
Replies: 2
Views: 989

DS Sequences

All, I have had this question regarding sequences. When a job is selected in the job activity stage the location of the job might have moved from the previous run of the sequence. But DS seems to keep no track of the location ie the path into which the job might have moved and contiues to run good. ...
by aditya
Thu Sep 15, 2005 3:00 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Installing PeopleSoft PACK
Replies: 1
Views: 508

Installing PeopleSoft PACK

All, I have been trying to install DS Client followed by the PeopleSoft PACK on my machine which is running Windows XP Pro. The installation had been going on pretty smooth. The documentation required that once the Client and PACK were installed a DSN on the client had to created with the exact same...
by aditya
Mon Jul 18, 2005 9:18 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: load multiformat seq file
Replies: 12
Views: 7566

Thank you Ray.

- Aditya.
by aditya
Mon Jul 18, 2005 8:13 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: load multiformat seq file
Replies: 12
Views: 7566

Sri, One way of solving the problem is to replace the spaces using pipe delimiter '|' this can be achived using the replace() function and then having to manipulate using the functions such as ltrim() and rtrim() with the pipe delimiters specified to actually achieve the values into the different co...
by aditya
Wed Jul 06, 2005 8:59 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Invoking a UNIX Shell script in a stage
Replies: 3
Views: 850

Invoking a UNIX Shell script in a stage

Hi,

I have a shell script which I need to invoke in one of the stages as a before job subroutine. Could anyone help me out in how to specify it at the subroutine and also make it accept input parameters if the script has any.

Thanks
Aditya
by aditya
Wed Jun 29, 2005 11:42 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Loading only values of a particular attribute value
Replies: 4
Views: 1072

Loading only values of a particular attribute value

All, I have a job which works like this SequentialFile --> Transformer --> HashFile I have some attributes in the seq. file and I want to do a select on those attributes where attribute_value = 'XXXX'. I tried specifiying this condition as a constraint in the transformer where mention attribute_valu...