Search found 23 matches

by manojmathai
Tue Aug 30, 2005 11:49 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Emailing the results
Replies: 14
Views: 4557

Hi Can you just try a test batch using the following command and see if mail facility is working or not varToAddressee = "yourname@mailserver.com" code=DSSendMail("From:Test\nTo:" : varToAddressee: "\nSubject:Test \nBody: Test Success!") Pls add your mail id for variabl...
by manojmathai
Thu Aug 25, 2005 12:53 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Cannot Copy Stage from One Job to other
Replies: 6
Views: 1670

Hi When I select one stage in a job and do the right click, the pop up menu does appear, Copy menu item is enabled also. I can click the copy sub menu item. After that when I right click in an open area, the popup appears with paste disabled. I am able to do a copy and paste operation with other app...
by manojmathai
Wed Aug 24, 2005 11:52 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Cannot Copy Stage from One Job to other
Replies: 6
Views: 1670

Hi

Both are in same connection only.
I want to know if there is any client settings that need to be done for this.

Thanks in Advance
Manoj
by manojmathai
Wed Aug 24, 2005 9:00 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Cannot Copy Stage from One Job to other
Replies: 6
Views: 1670

Cannot Copy Stage from One Job to other

Hi

I cant copy stage from one job to other job using CTRL+C , CTRL+V.
In my collegue's PC its possible.

Any idea why ?

Thanks in Advance

Manoj
by manojmathai
Wed Aug 24, 2005 7:53 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: writing quote (") to a file in a routine
Replies: 6
Views: 3445

Hi

You can use char(34) to put double quotes while creating a file from the routine.

For eg : Char(34) : "Tom" : Char(34) will give the out file as "Tom"

Regards
Manoj
by manojmathai
Tue Aug 23, 2005 5:21 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Finding the value that repeats the maximum in a file
Replies: 2
Views: 851

Finding the value that repeats the maximum in a file

Hi I have an input file that contains fields ProcessingMonth, Customer Name ,Place ... I have to assign the Actual Processing Month as the most repeated Processing Month in the input file For Eg. Source ------- Proc Mth,Name,Place ------------------------------- 200405,aaaa,abc 200406,bbbb,xyz 20040...
by manojmathai
Fri Aug 19, 2005 3:13 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to add data to same seq file from more than one jobs
Replies: 8
Views: 3122

Hi For the second job, the input will be the file that contains cols ITEM3 and ITEM4 . This job will lookup the hash file to add the colums ITEM1 and ITEM2 which is generated in the first job. The output from this transform will be a written to a new file that contains four fields which are ITEM1,IT...
by manojmathai
Thu Aug 18, 2005 6:35 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to add data to same seq file from more than one jobs
Replies: 8
Views: 3122

I hope the number of rows generated in the first job and second job are same. In the first job,have an extra field with name as index which has a row number. Write it into a hash file with this as the key. In the second job, do a lookup for this row number and write into the output file. Do the look...