Search found 42189 matches

by chulett
Fri Jul 15, 2011 7:54 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Newbie question regarding a debugger
Replies: 12
Views: 4693

The Server product has always had an interactive debugger, thought the same would make it into the PX side of the house eventually but for whatever reason it hasn't happened yet. :(
by chulett
Fri Jul 15, 2011 7:48 am
Forum: General
Topic: Finding the projects,jobs,logs in unix
Replies: 13
Views: 3717

Code: Select all

find / -d Projects -print
by chulett
Thu Jul 14, 2011 10:58 pm
Forum: General
Topic: Finding the projects,jobs,logs in unix
Replies: 13
Views: 3717

They could technically be anywhere, but by default the main Projects directory is at the same level as the DSEngine directory. So... cd $DSHOME/../Projects Will typically get you in. Once there you'll find a directory per project, inside that (amongst other things) are folders - one "set" ...
by chulett
Thu Jul 14, 2011 10:18 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: dummy stage
Replies: 2
Views: 936

Copy stage.

Note, however, that Peek will not "fill up your log" - it will capture only the sample you specify (by default 10 rows per node). :wink:
by chulett
Thu Jul 14, 2011 10:14 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: sqlloader and management of blank or empty fields
Replies: 1
Views: 883

$APT_ORACLE_PRESERVE_BLANKS = True
by chulett
Thu Jul 14, 2011 1:04 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: warning: Data that exceeds the maximum display length
Replies: 2
Views: 1056

That is a hard limit built into the viewer.
by chulett
Thu Jul 14, 2011 1:02 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: CPU its Cores and Nodes
Replies: 6
Views: 2172

There is no relationship between CPUs or "cores" to nodes.
by chulett
Thu Jul 14, 2011 12:59 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: incoming .csv file with embedded line breaks
Replies: 5
Views: 3403

In a Server job you can scroll the Sequential File stage over and make use of the "Contains Terminator" property for that column.
by chulett
Thu Jul 14, 2011 9:07 am
Forum: General
Topic: Error calling ....(DSOpenJob) Cannot open job
Replies: 3
Views: 2101

Are there any other errors logged when it happens? Most times a job is "not runnable" because it is already running. It could also mean not compiled or it was aborted and you didn't enable the "reset if required" option.
by chulett
Thu Jul 14, 2011 9:04 am
Forum: General
Topic: For Unix installation- windows client project
Replies: 2
Views: 1579

No to both questions.
by chulett
Thu Jul 14, 2011 7:28 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: from Date to Julian day
Replies: 3
Views: 2501

Yah, it is (unfortunately) a quite common confusion.
by chulett
Thu Jul 14, 2011 6:51 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: from Date to Julian day
Replies: 3
Views: 2501

What exact output do you want? Anything like MMDDD or DDD is not a julian date, hence the issue you are having. Look at the DateToString() function, I believe that a mask of DDD will get you the ordinal day number.
by chulett
Thu Jul 14, 2011 6:31 am
Forum: General
Topic: Cant access VSAM files via Classic Federation
Replies: 1
Views: 1368

I really have no idea about Classic Federation but am curious - what exactly have you used in the External Source stage?
by chulett
Wed Jul 13, 2011 9:09 pm
Forum: General
Topic: Mapping job - Track dependencies
Replies: 4
Views: 2223

Not sure what to tell you, the link in the first post works just fine for me - I click on it and the download starts. Perhaps try a different browser?
by chulett
Wed Jul 13, 2011 1:45 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Hash file causing issue with special characters
Replies: 0
Views: 2229

That's the rub, you need to find something that won't occur naturally in your data. Perhaps something like a pipe or an up-caret? | ^