Search found 99 matches

by igorbmartins
Fri Jul 09, 2010 10:07 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Send mail
Replies: 2
Views: 1731

I changed the SMTP settings for an internal server 10.1.4.2. I can ping normally. It also informed a valid e-mail but to no avail.
by igorbmartins
Fri Jul 09, 2010 8:43 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Send mail
Replies: 2
Views: 1731

Send mail

Anybody could help me with the below error? I am trying send an e-mail. The DataStage server is windows. In other companies that I worked the server was UNIX and always worked. Teste_envia_email..JobControl (DSSendMail): Error when executing command: C:\IBM\InformationServer\Server\Projects\STAGING_...
by igorbmartins
Fri Jul 09, 2010 5:57 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: how to do funnel in server edition
Replies: 6
Views: 3163

Use the Link Collector stage.

Att, Igor Bastos Martins
by igorbmartins
Tue Jul 06, 2010 12:50 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Routine that finds the JOB name that called it.
Replies: 5
Views: 2404

Friends, the command indicated by the anbu was correct. My job gave error for other reasons.

Thanks all.
by igorbmartins
Tue Jul 06, 2010 12:24 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Routine that finds the JOB name that called it.
Replies: 5
Views: 2404

I tried to do this by following the codes above, but the job does not end. Neither can stop killing the job
by igorbmartins
Tue Jul 06, 2010 12:05 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: how can I force the stop of a job?
Replies: 5
Views: 3460

how can I force the stop of a job?

Friends how can I force the stop of a job? I click the STOP button in the DIRECTOR but the job is still running.
by igorbmartins
Tue Jul 06, 2010 11:30 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Routine that finds the JOB name that called it.
Replies: 5
Views: 2404

Routine that finds the JOB name that called it.

Good afternoon my friends.

I did a routine that is invoked by several JOBS. Is there any way to set the routine for it to discover the name of the JOB that called it.
Anyone know how to do this?

Thanks
by igorbmartins
Fri Jun 04, 2010 11:13 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Stage SAMPLE
Replies: 3
Views: 1558

No error message. And when I put 100% all the records go.
by igorbmartins
Fri Jun 04, 2010 10:48 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Stage SAMPLE
Replies: 3
Views: 1558

Stage SAMPLE

Good afternoon my friends, I have a doubt about the SAMPLE stage. My JOB is very simple, is only composed of three stages as following: Sequential_File - - -> SAMPLE - - - > Sequential_File The first Sequential_File contains 100 rows , in the SAMPLE I configured in the option PERCENT the value 50. S...
by igorbmartins
Thu May 06, 2010 8:54 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DSGetLogSummary
Replies: 3
Views: 2896

Thanks
by igorbmartins
Fri Apr 30, 2010 5:34 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DSGetLogSummary
Replies: 3
Views: 2896

DSGetLogSummary

Hi my friends. I need once your help. I need to read the log of a JOB and then write its output to a file. For this I use the command DSGetLogSummary. Sintaxe: DSGetLogSummary(vAttach, DSJ.LOGWARNING, vStartJob , vEndJob, 0) Problem is, the log of the Job I have the following line: 20\2010-04-12 13:...
by igorbmartins
Tue Dec 29, 2009 7:45 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to get all the dates in a range between two dates, minim
Replies: 2
Views: 1337

Friendes, I already got. I created a routine where I used the iconv function and oconv within a loop.
by igorbmartins
Tue Dec 29, 2009 7:09 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to get all the dates in a range between two dates, minim
Replies: 2
Views: 1337

How to get all the dates in a range between two dates, minim

Good morning my friends, I have a little doubt logic to creaate a process. I have a file with two columns: min_date;max_date 20091201;20091210 I would like to get all dates between them, for example: min_date 20091201 20091202 20091203 20091204 20091205 20091206 20091207 20091208 20091209 max_date 2...
by igorbmartins
Tue Dec 22, 2009 10:53 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: The JOB every hour brings me a different result
Replies: 5
Views: 3281

My server version is 7.5.1.A
I do this, I setting the Default output to 5,2.

I setting the partitioning hash in the transformer before of the aggregator.
by igorbmartins
Mon Dec 21, 2009 4:45 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: The JOB every hour brings me a different result
Replies: 5
Views: 3281

The JOB every hour brings me a different result

Friends, I am here again with other doubt with aggregator.
I have a column containing a value 1 to 30. I want to get the average value. The correct result is 15,50 but the JOB every hour brings me a different result as 15,49 or 15,50 or 15,51.

Anybody know explain me what is happing?