Search found 3329 matches

by Sainath.Srinivasan
Fri Jul 29, 2005 4:35 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: User-Defined SQL behaves differently in 7.5.1A
Replies: 16
Views: 3702

What about running the SQL directly via SQL Plus or TOAD.
by Sainath.Srinivasan
Fri Jul 29, 2005 4:31 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Can we know the Constraint Name which was Violated
Replies: 4
Views: 968

Ora 1 is primary key violation.

You can link the message constraint with the table to obtain more information.
by Sainath.Srinivasan
Thu Jul 28, 2005 3:19 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: merge three files
Replies: 8
Views: 1999

Concatenate the 3 files and then sort.
by Sainath.Srinivasan
Thu Jul 28, 2005 9:43 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Cross language compatability of Datastage
Replies: 3
Views: 1414

You may need NLS.
by Sainath.Srinivasan
Thu Jul 28, 2005 9:39 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: merge three files
Replies: 8
Views: 1999

Your question has the answer. User Merge stage.
by Sainath.Srinivasan
Thu Jul 28, 2005 9:34 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: No output from ExecSH routine
Replies: 4
Views: 1741

This is a voluntary site. There is nothing called urgent. If you want your problem to resolved immediately, sign up for a 24x7 or premium with your support provider.

Did you try the command from your OS shell? What happens?
by Sainath.Srinivasan
Thu Jul 28, 2005 7:16 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Send email datastage 6
Replies: 2
Views: 682

Use blat or external mail utility that supports that functionality.
by Sainath.Srinivasan
Wed Jul 27, 2005 10:57 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: duplicate records in sequential file
Replies: 11
Views: 3873

How will you know which one of the duplicate is to be picked?

The soln will be to store the row number. Again this leads to more steps and using hash file for reference.
by Sainath.Srinivasan
Wed Jul 27, 2005 10:56 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Insert/Update on SQL SERVER Database
Replies: 11
Views: 1685

The user had 'insert or update rows' in a single link and not 2 different links. So that cannot be the reason for lock.
by Sainath.Srinivasan
Wed Jul 27, 2005 9:57 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: duplicate records in sequential file
Replies: 11
Views: 3873

You can do that to identify duplicate keys. But what about the data value associated with the key?
by Sainath.Srinivasan
Wed Jul 27, 2005 9:47 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Insert/Update on SQL SERVER Database
Replies: 11
Views: 1685

As ArndW has pointed out, you need to supply some examples for others to understand and answer.
by Sainath.Srinivasan
Wed Jul 27, 2005 9:45 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: duplicate records in sequential file
Replies: 11
Views: 3873

You can sort the rows before using stage variables.
by Sainath.Srinivasan
Wed Jul 27, 2005 9:05 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: changins parameters to sequence
Replies: 6
Views: 1072

As Ken suggested, getting Parameter Manager may solve your problem to include params list in multiple jobs.

Job Activity is the stage in job seq to invoke jobs.
by Sainath.Srinivasan
Wed Jul 27, 2005 9:03 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Insert/Update on SQL SERVER Database
Replies: 11
Views: 1685

Check whether some other person / application is modifying the table.
by Sainath.Srinivasan
Wed Jul 27, 2005 7:55 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Row Splitter Help !
Replies: 11
Views: 1570

In that case, I think you need stage variables and not row splitter.