Search found 133 matches

by rajeev_prabhuat
Wed Dec 01, 2004 4:37 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Job Sequencer
Replies: 10
Views: 4764

Hi, Thank you Vincent McBurney. Can you help me in wiriting an simple routine in Parallel, using a if else condition. My requirment is as follows, i want to check time and if the time is less than 3 i want o get value "PROD", else "DEV". Please help me because i am not expert in ...
by rajeev_prabhuat
Wed Dec 01, 2004 4:33 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Parallel job routines
Replies: 3
Views: 2487

Parallel job routines

Hi,

I have not yet written a DS routines, can you help me in writing and runing a routine in Parallel jobs.

Regards,
Rajeev Prabhu
by rajeev_prabhuat
Wed Dec 01, 2004 12:39 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: query regarding reject files using merge stage
Replies: 4
Views: 1984

Re: query regarding reject files using merge stage

Hi Chiranjeevi, You cannot add or delete the columne if you tick the reject check box int he constaraint. Rather you create another constraing and populate the rejected rows without checking the reject option and add needed columns that you want. Regards, Rajeev Prabhu hi all, i am trying to use two...
by rajeev_prabhuat
Wed Dec 01, 2004 12:34 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Log files of a Datastage Job
Replies: 21
Views: 34378

Hi, Ray, but how can we acess this table in Universe, can we acess witht he same userid and password or is there any other way. Can i get the start and end time of the job from the log, from the column TIMESTAMP, as specified below, if so that will be good. Regards, Rajeev Prabhu Hashed file is a me...
by rajeev_prabhuat
Wed Dec 01, 2004 12:21 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Job Sequencer
Replies: 10
Views: 4764

Hi, Thanks you very much i hope this works out. What i understood is like this, we maintain two different sequencer which has parameters for diferent DSN am i right. I have another doubt, i want to run the job automatically once i schedule it, because i am running the job during mid night, it should...
by rajeev_prabhuat
Tue Nov 30, 2004 10:51 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Log files of a Datastage Job
Replies: 21
Views: 34378

H, Ray as you told we have table for log for each job, can we take this data from the table and populate into our oracle table to monitor our job. My requirment is something like this, we have 42 jobs and all the jobs are one to one mapping, we want to store the job name, its start time, end time, s...
by rajeev_prabhuat
Tue Nov 30, 2004 10:24 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Exceptions in Job
Replies: 1
Views: 1247

Exceptions in Job

Hi,

What all are the exceptions that we can except while we have a source to target population one to one mapping. Like column mismatch, trying to insert null values to the table... are there any other type of exceptions that we can come across while developing jobs in DS.

Regards,
Rajeev Prabhu
by rajeev_prabhuat
Tue Nov 30, 2004 10:15 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Job Sequencer
Replies: 10
Views: 4764

Hi, Thank you. Can give me a logic to get the parameters for two different DSN by using the same sequence, i was thinking to write a routine, but till now i have not written any so can you help me wiriting the same. Regards, Rajeev Prabhu If production and backup instances are identical in every way...
by rajeev_prabhuat
Tue Nov 30, 2004 9:42 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Job Sequencer
Replies: 10
Views: 4764

Hi Kim, My requirment is like this, i want to schedule the same set of jobs at two different set of times and based on the two different databases, one is from production and if it fails we creat a indicator file saying the connection to production failed and second time i want to connect to backup ...
by rajeev_prabhuat
Tue Nov 30, 2004 6:25 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Job Sequencer Input/Output
Replies: 2
Views: 1482

Job Sequencer Input/Output

Hi,

Can we have multiple inputs and outputs from a Sequencer. If so how can we do it.

Regards,
Rajeev Prabhu
by rajeev_prabhuat
Tue Nov 30, 2004 6:23 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Job Sequencer
Replies: 10
Views: 4764

Job Sequencer

Hi,

Can we have a sequencer inside existing sequencer in DS 7.x

Regards,
Rajeev Prabhu
by rajeev_prabhuat
Mon Nov 29, 2004 10:50 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Configuration Files
Replies: 4
Views: 2565

Hi Chandru,

Thank you.

Regards,
Rajeev Prabhu
afssekar wrote:Hi Rajeev,


thats is not a problem. any no if configure file you can create. only problem is during runtime u need to select which one is correct version.
by rajeev_prabhuat
Mon Nov 29, 2004 10:09 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Port Identification
Replies: 7
Views: 3295

Hi Kenneth/Ray, Thanks you. As Ray has told that, is it that we can not compile them in UNIx Version, if so how do we do it. Regards, Rajeev Prabhu Hi, Thanks you Ray & Kenith. Ray i don't have the acess to Developer net, so i am not able to go through the details. If possible can you explain it...
by rajeev_prabhuat
Mon Nov 29, 2004 9:46 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ORACLE Enterprise Stage
Replies: 6
Views: 2989

Hi Chulett, Thank you. That was really great. Regards, Rajeev Prabhu Check for a Transaction Size option in the stage, that sets the number of rows to commit at any one time. At least on the server side. :? You may also want to look for some $APT configuration parameters to set, I seem to remember r...
by rajeev_prabhuat
Mon Nov 29, 2004 9:41 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Port Identification
Replies: 7
Views: 3295

Hi, Thanks you Ray & Kenith. Ray i don't have the acess to Developer net, so i am not able to go through the details. If possible can you explain it. Regards, Rajeev Prabhu There's not a great deal of value installing a 7.1 server on a Windows machine (as you state in your text, though your head...