Search found 111 matches

by mahadev.v
Thu Sep 11, 2008 7:58 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: searching a value in input dataset
Replies: 5
Views: 2676

I guess range lookup might help you. i have never used it but you can do a range lookup in V8.
by mahadev.v
Wed Sep 10, 2008 12:58 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to avoid NULL Character in File.
Replies: 3
Views: 1250

You need to provide more information. Start by posting the exact error message and also search on that error message. And next time dont forget to ask a question.
by mahadev.v
Tue Sep 09, 2008 5:29 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Read sequentially
Replies: 3
Views: 1245

You should be more worried about partitioning. Because reading is sequential, but further down stream, it would be partitioned if you are running on multiple nodes.
by mahadev.v
Tue Sep 09, 2008 5:24 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Warning in the look up
Replies: 1
Views: 1263

This has been answered a lot of times here. Search on "When checking operator: Dropping component".
by mahadev.v
Tue Sep 02, 2008 1:16 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Remove duplicates using Transformer
Replies: 8
Views: 5873

You have a stage called remove duplicates to do this for you. Any specific reason for wanting to using transformer?
by mahadev.v
Mon Sep 01, 2008 3:45 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to Use Userdefine Environment Variables into the Dsjob c
Replies: 6
Views: 3446

Set these variable values to "$PROJDEF" in the job. Then you dont have to specify them in dsjob command. Every time the job is run the project level value of the variable is taken.
by mahadev.v
Fri Aug 29, 2008 5:44 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Run Time Error for PX Routine
Replies: 2
Views: 2527

search on the term "either the directory containing the library file
is not on the library search path". This has been answered here.
by mahadev.v
Wed Aug 13, 2008 12:49 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Replacing Mutlibyte characters to Single byte characters
Replies: 9
Views: 4586

i am looking for some thing which can be used in Parallel stage. Basic transformer will run on head node only. Even i thought that basic transformer runs in sequential mode when used in a parallel job. But the answer is no. It runs in parallel. I think it is considered as an over head cause it crea...
by mahadev.v
Tue Aug 12, 2008 5:46 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: expecting 1 segments, read 2 segments
Replies: 15
Views: 4802

Are you using the same configuration file? And Same partitioning on the input to the DataSet, for both the jobs?
by mahadev.v
Fri Aug 08, 2008 12:45 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: INTERVAL datatype handling in Datastage
Replies: 7
Views: 4198

An example of the data would have helped. I assume it would be a number. No of seconds, No of minutes, or hours or days. So an integer would do. Or maybe a decimal.
by mahadev.v
Tue Aug 05, 2008 3:51 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Datastage PX Warning: Import consumed only 27bytes of the re
Replies: 5
Views: 4893

Using a "tr" command in external source stage would help.
See if this post helps:

viewtopic.php?t=113640
by mahadev.v
Wed Jul 30, 2008 3:45 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Getting error compiling transformer in PX Job
Replies: 9
Views: 3121

##W TBLD 000000 10:39:20(015) <main_program> Error when checking composite operator: Output from subprocess: aCC: Not enough memory is available to finish the compilation. First few warnings are related to String to decimal, String to number conversions. i think these will have to be handled explic...
by mahadev.v
Fri Jul 25, 2008 4:10 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Oracle Enterprise stage
Replies: 2
Views: 1922

Code: Select all

"Access to sys.dba_extents is required but not available; please see your database administrator for select privileges"
Looks like you don't have select privileges.
by mahadev.v
Thu Jul 24, 2008 9:41 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DateToString format "dd-Mon-yyyy"
Replies: 4
Views: 14848

Firstly i doubt that month format mmm will work. Second the timestamp format is wrong. Third the syntax is wrong. If you are using the derivation in transformer, it will change the color to red indicating wrong derivation. And i doubt it would compile. The timestamp format will be something like '%d...
by mahadev.v
Thu Jul 24, 2008 5:06 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Partition Type while using Auto Partition
Replies: 1
Views: 1177

Use the variable "APT_DUMP_SCORE" and set it to true. Go through the score line by line and you will find out.