Search found 83 matches

by Saama
Tue Jan 02, 2007 4:52 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: regarding subroutine DSSENDMAIL
Replies: 8
Views: 2158

hi gurus, when i see, iam getting error message. ERROR WHILE EXECUTING COMMAND. C:\ASCENTIAL\DATASTAGE\PROJECT NAME SMTP MAIL NETWORK ERROR 10053. TRY TO ADJUST DSSEND MAIL_TEMPLATE.TXT. cant i mail to yahoo or gmail.when i want to send to yahoo or gmail account, what will be name of SMTP MAIL SERVE...
by Saama
Tue Jan 02, 2007 2:33 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: regarding subroutine DSSENDMAIL
Replies: 8
Views: 2158

Hi Gurus, As gurus suggestion iam going for a sequence and linking it to notification activity. my design is job activity1---->jobactivity2----->notificationactivity parameters declared in jobactivities. triggers tab-> conditional ok for both jobs. in notification activity- SMTP MAIL SERVER NAME: MA...
by Saama
Wed Dec 27, 2006 10:24 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: regarding subroutine DSSENDMAIL
Replies: 8
Views: 2158

regarding subroutine DSSENDMAIL

hi, i want to send email when the job is success. iam using after jobsubroutine DSSENDMAIL. i have also tried to use jobactivity and notification activity inorder to send email. whats the difference in approach, will the both give the same result. in the notification activity how to know my SMTP MAI...
by Saama
Thu Dec 21, 2006 6:17 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: regarding command line utility
Replies: 30
Views: 7343

Hi Gurus,
thanks very much.
i could generate the detail report.
but abt that query SORT.ITEMS DS_JOBOBJECTS;
o/p is

001 NRO
002 TRX
005 DSLINK
just curious why does it skip to 005.why doesn't it display 003,004.
plz help me understand the logic behind.

ONCE AGAIN THANKS GURUS;
cheers;
saama
by Saama
Thu Dec 21, 2006 6:06 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: regarding command line utility
Replies: 30
Views: 7343

hI GURUS, thanks very much. I have given command from operating system. dsjob -report ADMINISTRATOR ddd sss detail. this is the command which i used. ADMINSTRATOR- user name ddd- project name sss- job name. iam getting error status code=-9999 DS_JE_DS_JOB ERROR. plz help me with synatax and second q...
by Saama
Thu Dec 21, 2006 5:42 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: regarding command line utility
Replies: 30
Views: 7343

hi,
i went to administrator and from the command prompt gave this command dsjob -report <ddd> <sss> DETAIL.
where ddd is project name, sss is the jobname.
iam getting error saying that dsjob doesnot exists in your VOC.
plz help me.

cheers;
saama
by Saama
Thu Dec 21, 2006 5:36 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: regarding command line utility
Replies: 30
Views: 7343

hi, sorry i have incomplete details dsjob -report [scott] <ddd> <sss|jobid> [basic] here ddd is project name sss is the jobname userid-iam logging as admin, shall i use this id. iam not using job id and project id, instead of that iam using iam using project name and jobname. iam getting error-DSJOB...
by Saama
Thu Dec 21, 2006 5:11 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: regarding command line utility
Replies: 30
Views: 7343

hi Gurus, thanks very much, i got 2 doubts. dsjob -report [scott] <ddd> <sss|jobid> [report type>] report type = BASIC | DETAIL | XML. iam getting error dsjob doesnot exit in your voc. 2nd doubt: when i used SORT.ITEM DS_JOBOBJECTS; i was able to view what all the stages i used, metadata. it is very...
by Saama
Thu Dec 21, 2006 3:24 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: regarding command line utility
Replies: 30
Views: 7343

Hi,
i have given command LIST DS_JOBOBJECTS.
how to find my object id.
there are many object id, plz help me how to find my object id.

cheers;
saama
by Saama
Thu Dec 21, 2006 3:17 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: regarding command line utility
Replies: 30
Views: 7343

Hi, thanks guru. i just wanted to view transformation used in the jobs from the command line utility, the metadata, the source table and target table used. can we find these details of my job from command line utility. my team lead wants to know that. once again thanks. my design is odbc---->transfo...
by Saama
Thu Dec 21, 2006 3:03 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: regarding command line utility
Replies: 30
Views: 7343

Hi gurus, Thanks very much. i have used command line utility SELECT * FROM DS_JOBS WHERE NAME='JOBNAME' i also used another command, which i searched in the forum. when i use SORT.ITEM DS_JOBOBJJECTS. it displays record numbers. how to identify my job when i use SORT command. plz help me in identify...
by Saama
Thu Dec 21, 2006 1:05 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: regarding command line utility
Replies: 30
Views: 7343

regarding command line utility

hi gurus, my job design is odbc---->transformer---->odbc after compiling and running the job its stored in the repository.i use command line utility from administrator. i have search for commands. i have used LIST.DICT DS_JOBS, its displaying a list. but my job name is saa, will this command display...
by Saama
Thu Dec 21, 2006 12:00 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: regarding exporting the jobs created in designer
Replies: 12
Views: 4271

hi Gurus,
thanks very much.
my doubt is resolved.
once again thanks.

cheers;
saama
by Saama
Wed Dec 20, 2006 6:20 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: regarding exporting the jobs created in designer
Replies: 12
Views: 4271

hi, Thanks a lot. my doubt is when i click on available tables, i just can select only one table how to select 2 tables, like if i performed join transformation in a particular job, that means i need to select 2 tables, one of my friend is telling me that there is no need of selecting 2 tables, the ...
by Saama
Wed Dec 20, 2006 2:33 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: regarding exporting the jobs created in designer
Replies: 12
Views: 4271

hi, my company has registered, i said my comapny to register, they did so. My offshore team wants to analyze the design what i created. i want to export the design, what components i used, what routines used, which all stages used in developing job. In order to do i went to manager, select the proje...