Search found 281 matches

by snassimr
Wed Aug 31, 2005 2:52 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Count warnings and stop job
Replies: 13
Views: 4412

What is batch Job by you . Routine code that do DSRUNJOB ?
by snassimr
Wed Aug 31, 2005 12:48 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Count warnings and stop job
Replies: 13
Views: 4412

Where I can do it in job sequence . I want to run Jobs not with routine or something.

Can I use routine activity to set limit for warning befor Job Activity Stage

?

Can I do it inside Job Activity ?

My question is About DSSetJobLimit and DSGetLinkInfo .
by snassimr
Tue Aug 30, 2005 9:49 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Monitoring %CP
Replies: 3
Views: 1071

Monitoring %CP

Hi !

In Monitoring Window of Director I can See %CPU .

What the value is shown after the job finished ? Max value of cpu usage,average,minimum during the job's run ?
by snassimr
Tue Aug 30, 2005 1:52 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Distinct Count With Aggregator
Replies: 2
Views: 1060

Distinct Count With Aggregator

Hi ! I need perfom the followwing task : Column1 Column2 Column3 1 1 3 1 1 3 2 3 4 2 3 4 2 3 4 I need to get : 1 1 1 2 3 1 the last number is the number of disctinct values of column 3 group byed according column 1 and column 2. Can I do it with aggregator ???
by snassimr
Tue Aug 30, 2005 1:41 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Count warnings and stop job
Replies: 13
Views: 4412

As how I can count warning mesages in log ? And write it for postponed decision.
by snassimr
Mon Aug 29, 2005 7:41 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Count warnings and stop job
Replies: 13
Views: 4412

Count warnings and stop job

I want to run job in sequence and if the job creates number of warning over the definit number of errors ( I want to define the number per each job) not to go on with it sequence and abort

How to do this ?
by snassimr
Mon Aug 29, 2005 3:04 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: ODBC Database error extracting
Replies: 2
Views: 1002

ODBC Database error extracting

Hi !

Does anybody succeed to extract the text of database error message
from all message . Only the message not all text are returned with LASERR

All BASIC string function dont work properly
by snassimr
Mon Aug 29, 2005 1:32 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Sort Stage Problem
Replies: 5
Views: 1134

I tried to do the same thing with seq file. After all rows entered to Sort stage ( all 100000) the Job was ended immidiatly . It seems tahat Sort actually transfer rows but dont show it and rows count stay 0 from Aggregator With order by I get 2500 rows per sec . I want more because I have very larg...
by snassimr
Mon Aug 29, 2005 12:58 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Sort Stage Problem
Replies: 5
Views: 1134

Sort Stage Problem

Hi !

I use Sort Stage and After it Aggregator .

Why Sort dont transfer rows to Aggregator despite of I defined Sort order in Aggregator ?

How I can to do the It wont work serially : Sort and after it Aggregator
by snassimr
Sun Aug 28, 2005 8:58 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Microsoft Exchange Server and Notification Activity
Replies: 1
Views: 1152

Microsoft Exchange Server and Notification Activity

Hi !

Ii I need to send e-mail throuth Microsoft Exchenge server if I need to change dssendmail_template.txt with Microsoft Exchenge server and not smtp server ?
by snassimr
Thu Aug 25, 2005 3:22 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error DBMS.CODE
Replies: 5
Views: 1587

Thank you ray . I find it in one of forums.
by snassimr
Wed Aug 24, 2005 10:39 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error DBMS.CODE
Replies: 5
Views: 1587

Yes , Sure!

I aware thet it isnt pure DS question , But I havent succeed to fin it . I finde numbers and I need description of the codes.
by snassimr
Wed Aug 24, 2005 10:37 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Wrong Routine value returned
Replies: 9
Views: 1998

Sorry I mistake in my formulation

In roitine test the value is 20010101 but in log of job 20030101

My SDTToDateNumeric('2001-01-01') return 20010101

Any other ideas
by snassimr
Wed Aug 24, 2005 10:30 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error DBMS.CODE
Replies: 5
Views: 1587

Error DBMS.CODE

Does anybode can hrlp me find list of DBMS.CODE errors of Microsoft ODBC SQL SErver driver ?

THanks
by snassimr
Wed Aug 24, 2005 10:16 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Wrong Routine value returned
Replies: 9
Views: 1998

Wrong Routine value returned

Hi ! I invoke routine from Job Sequence and pass value to job. When I test routine it return right value. But when I see in Director Job Parametr the value is returned wrong TempDateN=(SDTToDateNumeric('2001-01-01') ) TodayDateN=(SDTToDateNumeric('2003-01-01') ) IF TempDateN<TodayDateN THEN Ans=Temp...