Search found 406 matches

by JRodriguez
Thu Apr 16, 2009 11:42 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: dsjob command not working
Replies: 7
Views: 6382

Re: dsjob command not working

datastagenewbie,

It worked OK for me

$ dsjob -run project_name job_name

Status code = 0

The command should be executed from below folder C:\IBM\InformationServer\Server\DSEngine\bin ( Default install folder )

Looks like a typo in your project name/ job name
by JRodriguez
Wed Apr 15, 2009 9:05 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Negative Number representation needs to be modified
Replies: 11
Views: 5569

Re: Negative Number representation needs to be modified

Hi, Try this


Oconv("123456-", "MC/N") : Oconv("123456-", "MCN")
by JRodriguez
Tue Apr 07, 2009 9:23 am
Forum: IBM QualityStage
Topic: Reference Match Error
Replies: 5
Views: 4476

vasubabu,

Take a look at the Input Link Ordering, just make sure that each link is really pointing to what you want
by JRodriguez
Thu Apr 02, 2009 3:11 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: confusion and request for help setup Windows UNIX datastage
Replies: 9
Views: 8126

Nowdays - IIS 8.xx - the licenses are for all supported OS .... IBM allows you to download the software for any supported OS. The xml license file is the same for all
by JRodriguez
Thu Feb 26, 2009 10:49 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: QualityStage standardize stage error
Replies: 6
Views: 2489

Bobyon,

If you ran a "provision all" to this new rule and another person can run the job fine then take a look a permisions

You wrote:

"I had created a ruleset called USADDR2. I found the directory but another person can run this job fine"
by JRodriguez
Wed Feb 25, 2009 4:36 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Did anyone installed ver 8.1 in SUSE Linux
Replies: 7
Views: 2555

Mike,

Unfortunately Linux SuSe is my current employer's standard :(
by JRodriguez
Wed Feb 25, 2009 3:10 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Very slow log refresh under director
Replies: 8
Views: 13429

Re: Very slow log refresh under director

RodBarnes, How about clearing the log? If you have a lot of logs then it will become more and more slower. In the Administrator you can set auto-clear log option by number of days or number of previous runs Also if you have 8.1 you can set the log to be stored in files - the old way- instead of havi...
by JRodriguez
Wed Feb 25, 2009 2:50 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Did anyone installed ver 8.1 in SUSE Linux
Replies: 7
Views: 2555

Aruna,

We are using IIS 8.1 on Windows and plan to migrate to Linux SuSe, would you mind describing the issues that you had during development phase with 8.0.1?

I know that in 8.1 IBM fix a lot of issues but still I would like to be aware of them .....


Thanks,
by JRodriguez
Wed Feb 11, 2009 10:57 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: ETLStats: Why is ReportDbDriver followed by a Sequencer?
Replies: 8
Views: 4444

Chulett,

:shock: Looks like the behaviour is not like that anymore, I tested it with 8.1 and the sequence restarted from the last activity
by JRodriguez
Mon Feb 09, 2009 11:26 am
Forum: General
Topic: Parameters in Sequence
Replies: 4
Views: 1473

samsuf2002, If you add a new parameter to a parameter set the change will be effective immediately everywhere you use the parameter set Be aware that the assignment of the new parameter to any parameter used in a job is not automatically... all parameters in the parameter set will be available to an...
by JRodriguez
Fri Feb 06, 2009 9:41 am
Forum: IBM QualityStage
Topic: how to make a SOA services with deduplication
Replies: 17
Views: 8446

ascen, It's a bit different ...... "Drive the Reference Input by using a lookup that is based on some of your blocking factors." mean that instead of having a static reference data set feeding the match reference stage, you would like to generate the reference data dynamically using a look...
by JRodriguez
Thu Feb 05, 2009 12:57 pm
Forum: IBM QualityStage
Topic: how to make a SOA services with deduplication
Replies: 17
Views: 8446

Ascen, A couple of tips: - Use a single node config file - If you designed this job as "always on" (WISD Input and WISDOuput stages present) the WISD Input must be the driving stream for the job, just make sure that all input streams are driving by the WISD Input stage - look for Eostic 's...
by JRodriguez
Thu Feb 05, 2009 9:35 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Remove Duplicates
Replies: 11
Views: 5110

Hi Archi,

Before sorting the data add an extra column where you want to have the date formatted as YYYYMMDD and use it as your sort variable, use the stage variables to remove the duplicates.


It will work fine for on entire data.
by JRodriguez
Wed Feb 04, 2009 10:01 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: parsing address informaiton
Replies: 5
Views: 2534

Re: parsing address informaiton

Tom, If all your records follows same standard my suggestion is to parse them using a combination of Oconv, Len and substrim [] functions as follow ( You want to use stage variables for best performance ) Using your example MilwaukeeWI54621 ZipCode = OCONV(InputField,"MCN") This will extra...
by JRodriguez
Wed Feb 04, 2009 5:12 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Need shell script to start job based on remote trigger file
Replies: 7
Views: 4373

Re: Shell Script to kick DS job

sryarraguntla,

Take a look at the Wait For File activity in the sequence palette. This activity address what you are looking for and more .... unless you wanted it done specifically by a shell script