Search found 5168 matches

by kumar_s
Mon Jan 22, 2007 5:17 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Simulating restartability
Replies: 13
Views: 3167

Or modify the Script in ExecuteCommand or a script in Afterjob to intake a paremter and create a warning based on the parameter value say if the value is greater thatn 2. You can produce warning by executing some wrong script or referring to a wrong file name or path. The input parameter can be you ...
by kumar_s
Mon Jan 22, 2007 5:07 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Problem with data types
Replies: 17
Views: 3666

Why a varchar to char conversion needed? Why you need Basic Transformer for this purpose? Why can you directly use PX job to read and write it into Dataset? What are the issue you faced when you had header? Have you tried First line as column Name option to get rid of Header? Why cant StringToDate /...
by kumar_s
Mon Jan 22, 2007 4:58 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: I wnat storred porocedures in oracle....
Replies: 16
Views: 4074

So funny to see such messages in this technical forum like this.

Moderator pls Delete the posts of Doloane.
by kumar_s
Mon Jan 22, 2007 4:54 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Regarding exporting datamodel
Replies: 53
Views: 13005

Hi Vijay,

Here, what are you referring to as schema?
by kumar_s
Mon Jan 22, 2007 4:53 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Lookup using </> in parallel jobs
Replies: 9
Views: 2121

No Range lookup available in the version as such. But you can make some work around. If the sources are database, you can do the lookup in Database level. Else you can approach as DSGuru2B suggested, by loading into table. There are several other ways as well. But you need to explain you job design ...
by kumar_s
Mon Jan 22, 2007 4:46 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Issue retrieving number of rows processed
Replies: 18
Views: 4417

Craig - Should there be some other reason why the OP is getting the error even after inserting the Transformer? Will it be a different error after inserting transformer?

ds_team - As suggested by Craig, insert the transformer in you design irrespective of anything.
by kumar_s
Sun Jan 21, 2007 10:02 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Output file full
Replies: 2
Views: 987

Do a search on 'output file full' and Exact match. Check for disck space usage of target directory and temp directory as well.
by kumar_s
Sun Jan 21, 2007 9:59 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Job access by other and cant unlock
Replies: 24
Views: 4496

The whole window shows, what job been used by which PID (Users). Once the lock is cleared, there wont be any entry there.
by kumar_s
Sun Jan 21, 2007 9:44 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Job access by other and cant unlock
Replies: 24
Views: 4496

Now I see the reason of couple of your previous post. Missed that prominent word. I should be Locked rather than Unlocked.
by kumar_s
Sun Jan 21, 2007 9:34 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Oracle Connection Dead
Replies: 12
Views: 7727

If you double click any log event, does the user id shows as dsadm?
Have you tried after the server restart?
Try restricing the number rows for testing purpose.
by kumar_s
Sun Jan 21, 2007 9:26 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Job access by other and cant unlock
Replies: 24
Views: 4496

Narasimha - LIST.READU brings user id as well. Wont it?
by kumar_s
Sun Jan 21, 2007 9:23 pm
Forum: General
Topic: CR/LF for the new generation
Replies: 45
Views: 19163

Hello all: How do we find if there is any CR & LF in the data? How do we preserve CR & LF? Are there any functions in DS that allow you to do that? You copy book should take care of that. But once you load into tables, you wont require the Line termination yet. As these characters are used ...
by kumar_s
Sun Jan 21, 2007 9:16 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Aggregator, Restricting count for individual group
Replies: 23
Views: 4062

Sort the data, use KeyChange column for the counter. Use transformer (or Filter stage) contraint to avoid KeyChange < 100, and following by an aggregator stage.