Search found 15603 matches

by ArndW
Mon Apr 28, 2008 10:49 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Universe Stage
Replies: 3
Views: 819

You posted with a PX product in the PX forum, which is I posted a question to which I already knew the answer (which is "No, PX has never had a UniVerse Stage").

V8 Server jobs - go to the Stages -> Server -> Database category to select the UniVerse stage.
by ArndW
Mon Apr 28, 2008 10:39 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Universe Stage
Replies: 3
Views: 819

Was there a UniVerse stage in PX 7.0?
by ArndW
Mon Apr 28, 2008 9:58 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Moving from Unix to Windows
Replies: 7
Views: 1559

Unix scripts will run under windows if you install a package such as "MKS Toolkit".
by ArndW
Mon Apr 28, 2008 9:53 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: NUll warning for date field.
Replies: 7
Views: 1865

could it be 1900/01/01 ?
by ArndW
Mon Apr 28, 2008 8:26 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: LOG file & datastage job viewing in aix
Replies: 12
Views: 18421

Log files are stored as hashed files and cannot be directly viewed. You can use the "dsjob -logsum" or "dsjob -logdetail" to output a job's log to stdoutput, which you can redirect to a file.
by ArndW
Mon Apr 28, 2008 8:14 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Active and Passive stages
Replies: 2
Views: 1522

I like thinking of passive stages as inputs and outputs (sources & targets of data); but the definitive list can be seen when browsing the stages as they are shown are "active", "passive" or "external"
by ArndW
Mon Apr 28, 2008 8:11 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Optimisation of job with hashed files
Replies: 8
Views: 1927

I just checked and it seems that DS no longer support distributed files - which might have been a similar option to add to what Ken has just posted.
by ArndW
Mon Apr 28, 2008 8:08 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Problem with Charachter handling in Dataset
Replies: 10
Views: 2475

No, nothing like that will have DS automatically convert an input Hex Value of 96 to '-'; this is not an NLS conversion. You can use the

Code: Select all

CONVERT(CHAR(150),'-',In.Column)
by ArndW
Mon Apr 28, 2008 8:02 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Is there a PX equivalent to the Char() and Seq() functions?
Replies: 7
Views: 1090

That at least is my first path. You can also ask IBM for the Orchestrate documentation which does a much better job at detailing functionality.
by ArndW
Mon Apr 28, 2008 7:42 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Is there a PX equivalent to the Char() and Seq() functions?
Replies: 7
Views: 1090

To make matters worse, much of what you will find on the modify stage in the standard docs is incorrect.
by ArndW
Mon Apr 28, 2008 7:14 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Is there a PX equivalent to the Char() and Seq() functions?
Replies: 7
Views: 1090

Joe - you haven't seen anything until you start trying to reconcile the Modify stage with it's documentation.
by ArndW
Mon Apr 28, 2008 6:58 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Problem with Charachter handling in Dataset
Replies: 10
Views: 2475

Try putting in a transform with the output of "CHAR(In.TimeStampStringColumn[16,1])" to see if it really is a "-"
by ArndW
Mon Apr 28, 2008 6:21 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Datasets
Replies: 6
Views: 1512

DSRajesh wrote:i heard that the daatsets are stored in swipia ..i dont know what is this swipia can any one help me pls
You must have heard incorrectly. "swipia" is not a DS term or directory. Check your APT_CONFIG file for actual data locations.
by ArndW
Mon Apr 28, 2008 6:19 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Datasets
Replies: 6
Views: 1512

DSRajesh wrote:...I would like to know how can i read the data in datasets other View data or dataset management using manager?...
The only other method is through the "orchadmin" command from the command line.
by ArndW
Mon Apr 28, 2008 6:18 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Is there a PX equivalent to the Char() and Seq() functions?
Replies: 7
Views: 1090

Yes, by great coincidence the PX functions are Char() and Seq() 8)