Search found 87 matches

by Das
Thu Nov 16, 2006 12:36 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Pass valus to UNIX script fromDS control job
Replies: 9
Views: 2396

Pass valus to UNIX script fromDS control job

How can i pass some values from a datastage control job to a UNIX script-

Script is used to send mail-i have to pass msg body to the script.


please provide the syntax-in ds side and unix side
by Das
Thu Nov 16, 2006 12:32 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: pass parameter to DSSendmail Subroutine
Replies: 8
Views: 2768

Hi

i want to run the routine from the controll job by passing some values as arguments .is it possible
by Das
Wed Nov 15, 2006 11:09 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: pass parameter to DSSendmail Subroutine
Replies: 8
Views: 2768

call DSSendMailTester from control job

ray.wurlod wrote:The code is already provided, in a routine called DSSendMailTester (under Routines\Built-In\Utilities in your Repository). ...
Thanks

Can i directly call this DSSendMailTester routine from a control job
in datastage 6,
by Das
Wed Nov 15, 2006 6:32 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Pass status to a unix script
Replies: 1
Views: 640

Pass status to a unix script

Hi

I have to to sent a mail to a particular is when a ds job get aborted with its status

Can i pass the status to dssendmail routine-please provide the syntax

Can call a unix script-
by Das
Wed Nov 15, 2006 4:23 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: pass parameter to DSSendmail Subroutine
Replies: 8
Views: 2768

pass parameter to DSSendmail Subroutine

Hi

How can i pass parameter (from ,to,subject,body) to DSSendmail Subroutine
Any body can give the code

Thanks in advance
by Das
Sun Nov 05, 2006 10:48 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: job takes very long time to run
Replies: 3
Views: 1592

job takes very long time to run

Hi all,

I have a problem with one job like it take too much time to run for some collection of data,and runs normally for others

Actually it is a c sql script which is called by a datastage job.

Could you explain the possibilities.
by Das
Tue Oct 31, 2006 3:55 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Performance issues with C sql
Replies: 3
Views: 705

Hi, Actually it is putting warnigs and errors into a text file(say warn.txt) Each time any error or warning occurs the main pgm will call a c procedure wich will opens the warn.txt and write the log. Can u suggest any alternative soluton or some modifications to do the same with out impact the perfo...
by Das
Tue Oct 31, 2006 1:21 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Performance issues with C sql
Replies: 3
Views: 705

Performance issues with C sql

Hi , I am using C sripts for lading datato DW which is called by a DS cotrol job. In the C sql sripts we are writing lot of warning message in to log file.Each time some particular condition occurs. 1---- Will it impact the performance of the job.? 2----or please suggest an alternative solution Thanks
by Das
Wed Oct 25, 2006 4:37 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Problem related to job abort and exit
Replies: 8
Views: 2411

Hi I have 10 files of the same type.If any problem with the one of the file the whole job will get aborted..Actually i want to continue with other records which have no problems....so i used DSLogWarn and continue with other files.. If the execes of the warning message may create any probs ..what wi...
by Das
Wed Oct 25, 2006 4:18 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Problem related to job abort and exit
Replies: 8
Views: 2411

Thanks...

Please suggest a solution to the above problem with out using DSLogWarn function
by Das
Wed Oct 25, 2006 2:28 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Problem related to job abort and exit
Replies: 8
Views: 2411

Thanks

If I increase the warning level from 50 to 100or 1000 ..is it effect the performance or any other parameters related to that particular job.

Please replay....
by Das
Tue Oct 24, 2006 10:22 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Problem related to job abort and exit
Replies: 8
Views: 2411

Problem related to job abort and exit

Hi Friends, I have a problem as follows .Please help. I have a job and in transformer stage i am calling a USER DEFINED routine , if a particular condition occurs then call DSLogWarn i think i will abort the job and need a reset to run the job again. so.. How can i avoid the job abort and performs a...