Search found 124 matches

by fmou
Tue Aug 09, 2011 11:13 am
Forum: General
Topic: DataStage parallel job tutorial files
Replies: 6
Views: 5117

by fmou
Tue Aug 09, 2011 11:10 am
Forum: General
Topic: DataStage parallel job tutorial files
Replies: 6
Views: 5117

DataStage parallel job tutorial files

Hi,

in "Parallel Job Tutorial" it says the tutorial files are from "the folder on the CD named \TutorialData\DataStage\parallel_tutorial "

which CD is this? Can I get the tutorial files from the web?

thanks
by fmou
Mon Aug 08, 2011 3:23 pm
Forum: General
Topic: Palette gone and can't be added
Replies: 3
Views: 2138

arunkumarmm wrote:I believe the pallet will be available only when you have a job open.
Silly me. Yep, problem solved.
by fmou
Mon Aug 08, 2011 9:36 am
Forum: General
Topic: Palette gone and can't be added
Replies: 3
Views: 2138

Palette gone and can't be added

Hi, This is a newly installed DS7. Somehow the Palette had a very limited list of groups: http://www.imgplace.com/img856/84/28p1.jpg See, now there is only one there! and the problem is that I can't even add them myself. I used customize, but - all Palette group that should show up are already at th...
by fmou
Mon Aug 08, 2011 9:29 am
Forum: General
Topic: Jobs Status Report
Replies: 30
Views: 14605

Now the real issue is finding whether the last run time falls on yesterday. For example, if the first three parts of date function in unix is : Mon Aug 08 , we need to check the Last Run time contains the string Sun Aug 07. If you don't have gnu date, search for a tool named mktime. If you have gnu...
by fmou
Mon Aug 08, 2011 9:12 am
Forum: General
Topic: Jobs Status Report
Replies: 30
Views: 14605

Start from this: . /opt/app/dstage/DataStage752/Ascential/DataStage/DSEngine/dsenv sfile=$(date "+status.%m.%d.%H.%M.txt") touch $sfile for job_name in `/opt/app/dstage/DataStage752/Ascential/DataStage/DSEngine/bin/dsjob -server servername -user unam -password pwd -ljobs PRJDEV` do if `/op...
by fmou
Fri Aug 05, 2011 4:49 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: catching previous row.
Replies: 6
Views: 2974

Where you say "Output is" do you actually mean "Output should be"?
yeah, i believe so.
by fmou
Fri Aug 05, 2011 4:42 pm
Forum: General
Topic: Restartability of User Variables
Replies: 4
Views: 2067

hmm.... not that obvious to me. I was having a hard time trying to decipher the following extremely simple case. Any help? Thanks * Tokens were replaced below as follows: * IdV1S1%%UserVar%%0 <= uv2.var3 * IdV1S1%%UserVar%%1 <= uv1.uv_var1 * IdV1S2%%UserVar%%3 <= uv1.uv_var2 * IdV1S0%%Result2%%4 <= ...
by fmou
Fri Aug 05, 2011 2:34 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Dump Score
Replies: 5
Views: 3316

I forgot to set $APT_DUMP_SCORE to True when I initialed my project (so none of the score are written into the job log). I've now set $APT_DUMP_SCORE to True for my project, will my previous built jobs now show the score? Do I need to re-compile?

Thanks
by fmou
Fri Aug 05, 2011 1:18 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DataStage variables
Replies: 4
Views: 6722

Viewing values of the User Variables and job parameters

[reusing the old thread to ask a related question]

How can I view/debug the actual value of the User Variables and job parameters?

Thanks
by fmou
Tue Aug 02, 2011 8:08 am
Forum: General
Topic: Need to pass a parameter across all jobs
Replies: 9
Views: 13281

Thanks zulfi,

User Variables Activity Properties . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6-36
by fmou
Sat Jul 30, 2011 10:28 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: converting date
Replies: 13
Views: 5867

chulett,

you didn't mention about null handling, can the DateToString() function take null parameter values?

thanks
by fmou
Sat Jul 30, 2011 10:24 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DataStage variables
Replies: 4
Views: 6722

DataStage variables

Hi, Am I right that in the transformer stage, all kinds of variables can be used in output columns derivations, including transformer's own stage variables, job parameters, and user variables from the job sequence? How about updating the variables? Only the transformer's own stage variables can be u...
by fmou
Sat Jul 30, 2011 9:53 am
Forum: General
Topic: Need to pass a parameter across all jobs
Replies: 9
Views: 13281

in the job sequence setup a "user variable" using the User Variable Activity stage first THe OP was on DataStage Release: 7x. Is such User Variable Activity stage available in DataStage 7? I searched trough the Parallel Job Developer's Guide, Version 7.5.1, but didn't find a match for &qu...
by fmou
Sat Jul 30, 2011 9:42 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ROW NUMBER for sequential file stage
Replies: 4
Views: 6260

You can generate the current row number if you are careful with any partitioning.
You are talking about not in the sequential file stage but in the following stage, eg, a transformer, right?