Search found 81 matches

by Abhijeet1980
Sat Sep 01, 2007 2:45 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Numeric (P, S)
Replies: 14
Views: 6686

I'm gathering similar evidences from my friends as well.

This seems to be a bug or else the changes in uvconfig have not been reflected properly.

Till then lets wait......
by Abhijeet1980
Thu Aug 30, 2007 11:41 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Numeric (P, S)
Replies: 14
Views: 6686

You got it very right.

While trying to read even from a sequential file a number and writing to another sequential file, the same thing happens.

I shall escalate this to the support and see what they have to say on the same.
by Abhijeet1980
Thu Aug 30, 2007 10:22 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Numeric (P, S)
Replies: 14
Views: 6686

Thankx friend very much for the suggestion. EXACTNUMERIC was set to 38 immediately after the installation as suggested by my friends. Is there any limitation which is causing the problem. FYI. smat -d shows EXACTNUMERIC as 38. Still the problem persists. DS 7.5 in installed on Win XP. I have searche...
by Abhijeet1980
Thu Aug 30, 2007 3:15 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Numeric (P, S)
Replies: 14
Views: 6686

Re: Numeric (P, S)

This must be bcos of some limitation. IS it so ?
by Abhijeet1980
Tue Aug 28, 2007 4:30 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Numeric (P, S)
Replies: 14
Views: 6686

Re: Numeric (P, S)

Need to send this numeric field for aggregation (Sum). Cannot use other data types like char fields.
by Abhijeet1980
Mon Aug 27, 2007 10:34 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Numeric (P, S)
Replies: 14
Views: 6686

Numeric (P, S)

Hi, I've a monetary field defined as Numeric (30, 6). Data contained in table while readin by DS gets truncated to 14/15th digits. <table> <tr> <td>File Value <td>Read/Written Value <tr> <td>==================== <td>==================== <tr><td>2345678910111213.999999 <td>2345678910111210 <tr><td>23...
by Abhijeet1980
Mon Aug 27, 2007 3:04 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Unable to load subroutine on host (30105
Replies: 19
Views: 16125

Re: Unable to load subroutine on host (30105

Hi Nitin, If you can come up with more details. Rgds, Abhijit Gaikwad Hi, In our developement server there are three projects, we are able to loging on 2 projects but while loggging on 3rd one we are getting following error. "Error calling subroutine: DSR_PROJECT (Action=1); check DataStage is ...
by Abhijeet1980
Mon Aug 27, 2007 3:02 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Unable to load subroutine on host (30105
Replies: 19
Views: 16125

Re: Unable to load subroutine on host (30105

Hi Nitin, If you can come up with more details. Rgds, Abhijit Gaikwad Hi, In our developement server there are three projects, we are able to loging on 2 projects but while loggging on 3rd one we are getting following error. "Error calling subroutine: DSR_PROJECT (Action=1); check DataStage is ...
by Abhijeet1980
Wed Aug 22, 2007 3:01 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: specifying parameter SET via dsjob?
Replies: 7
Views: 6073

Hello Everybody, What if the no of parameters are more ...Say about 20 - 25 odd. Bcos of the limitation from the OS end (UNIX/Solaris in our case), there has to be some other alternative for the same. :( I've been suggested by our colleagues that we do go for the Routine which would read a text file...
by Abhijeet1980
Tue Jan 02, 2007 7:53 am
Forum: General
Topic: How to Acquire Last Run Date of a job (using dssh)
Replies: 6
Views: 4726

Well you might need something of this sort. I used Shell Programming in order to find out the Job Paramters passed. Hope this might be of any help to you. uvsh "SELECT FULL.TEXT FMT '100T' FROM RT_LOG$JOB_NO WHERE FULL.TEXT LIKE 'Starting%' AND TIMESTAMP = (SELECT MAX(TIMESTAMP) FROM RT_LOG$JOB...
by Abhijeet1980
Tue Jan 02, 2007 6:50 am
Forum: General
Topic: Differences between Join, Merge and Lookup Stages.
Replies: 12
Views: 7463

Thanx very much for sharing wonderful information with me.

The comparision was really wonderful.

Regards
Abhijit
by Abhijeet1980
Tue Dec 26, 2006 7:32 am
Forum: General
Topic: book about datastage and datawarehousing project
Replies: 6
Views: 3824

So far no one has ever tried. It is desperately needed.
by Abhijeet1980
Tue Dec 26, 2006 7:29 am
Forum: General
Topic: Differences between Join, Merge and Lookup Stages.
Replies: 12
Views: 7463

Differences between Join, Merge and Lookup Stages.

Dear All,

Can anyone outline the differences between Join, Merge and Lookup Stages ?

I've read a few forum messages regarding Join, Merge and Lookup, but have found no satisfactory answers.

Senior members: Pls do respond....
by Abhijeet1980
Mon Nov 27, 2006 3:25 am
Forum: General
Topic: Type II Dimension Implementation Using DS 7.1
Replies: 6
Views: 4417

Firstly CRC check will have to be taken care of by a custom function. As per my knowledge CDC part is not the part of the server edition and have to be taken separately. Secondly how will i generate equential no's required or the surrogate key needed to implement the type II. Chulett : Can you pls e...
by Abhijeet1980
Sat Nov 25, 2006 8:55 am
Forum: General
Topic: JOIN TWO SEQUENTIAL FILE
Replies: 8
Views: 6894

Are Merge ad Join stages the same ?