Search found 3329 matches

Go to advanced search

by Sainath.Srinivasan
Thu Feb 12, 2009 3:49 am
Forum: General
Topic: Dynamically (re)setting job parameters at run time
Replies: 9
Views: 19732

Select list of required dates from the table and store in a parameter.

Use the result in an "IN" clause of second query.
by Sainath.Srinivasan
Wed Feb 11, 2009 7:30 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: sqlcode - 1480
Replies: 7
Views: 5684

What is your table name and column name?
by Sainath.Srinivasan
Wed Feb 11, 2009 6:02 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Null handling
Replies: 11
Views: 4905

Give the derivation on target column rather than stage variable
by Sainath.Srinivasan
Tue Feb 10, 2009 7:09 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How many jobs we can run at one shot
Replies: 5
Views: 1057

...also how big is your job..!!
by Sainath.Srinivasan
Tue Feb 10, 2009 7:06 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Grouping the records of DS_AUDIT
Replies: 15
Views: 5584

Both DTM and REASON are multi-valued. You see a flattened view.
by Sainath.Srinivasan
Tue Feb 10, 2009 4:37 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Config file
Replies: 6
Views: 2012

What were you answers?
by Sainath.Srinivasan
Mon Feb 09, 2009 10:00 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Regarding best option to load to oracle database
Replies: 2
Views: 1062

Not enough info.

It is like asking "how fast can a person with two legs run?"

Try it with a sample and tune variables.
by Sainath.Srinivasan
Mon Feb 09, 2009 9:55 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: result rows are not showing up-total mismatch
Replies: 18
Views: 4875

Are there any logs? Did you try to find the missing rows?
by Sainath.Srinivasan
Mon Feb 09, 2009 7:24 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Missing value for the parameter "DSJobInvocationId"
Replies: 5
Views: 2849

You have not enabled the multi-instance property but using its value.
by Sainath.Srinivasan
Mon Feb 09, 2009 7:24 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Missing value for the parameter "DSJobInvocationId"
Replies: 5
Views: 2849

You have not enabled the multi-instance property but using its value.
by Sainath.Srinivasan
Fri Feb 06, 2009 10:51 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Extract row wise data
Replies: 3
Views: 1181

Set first record is column-name to be true
by Sainath.Srinivasan
Fri Feb 06, 2009 10:15 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Too many open files
Replies: 2
Views: 2174

Maybe you hit your ulimit.

Try breaking the job into smaller units.
by Sainath.Srinivasan
Fri Feb 06, 2009 8:12 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Email Notification
Replies: 10
Views: 4182

DQuotes missing after "Body" in line sendmail.
by Sainath.Srinivasan
Fri Feb 06, 2009 8:09 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: can we compare two CSV files in datastage?
Replies: 6
Views: 3736

No. I am asking you on how you want to compare.
by Sainath.Srinivasan
Fri Feb 06, 2009 7:35 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: can we compare two CSV files in datastage?
Replies: 6
Views: 3736

Define 'compare'.

- Row by row
- Size
- by Key
- any other method

Go to advanced search