Search found 68 matches

by dhiraj
Mon Mar 29, 2004 12:51 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Upper Case conversion
Replies: 5
Views: 2609

sorry ray,

i posted it to this forum by mistake.

btw i'm using windows.


thanks
dhiraj
by dhiraj
Mon Mar 29, 2004 12:45 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Upper Case Conversion
Replies: 2
Views: 1162

Upper Case Conversion

Hi, Is it possible to convert the entire input record read from a sequential file in to upper case. i am aware of the UpCase function, but if i use this i'll have to apply this funtion for each and every field. isn't there any generic way in which i can apply this to athe entire incoming record at o...
by dhiraj
Mon Mar 29, 2004 12:21 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Upper Case conversion
Replies: 5
Views: 2609

Upper Case conversion

Hi, Is it possible to convert the entire input record read from a sequential file in to upper case. i am aware of the UpCase function, but if i use this i'll have to apply this funtion for each and every field. isn't there any generic way in which i can apply this to athe entire incoming record at o...
by dhiraj
Tue Feb 24, 2004 1:20 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Accessing Hashed Files using UV stage.
Replies: 2
Views: 1051

Accessing Hashed Files using UV stage.

Hi, is there an performance improvement if we dump an odbc table in to a hash file and look up this hash file using an UV stage instead of looking up the odbc table directly. The reason why i am using an UV stage is that i have ' >' and '<' in look up conditions, and this can be achieved only throug...
by dhiraj
Thu Feb 19, 2004 11:38 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Help! Help! Help!
Replies: 7
Views: 2652

yes, this message is generated when i try saving my job.I don't have any problems while saving other jobs. I mentioned ODBC because the job works fine until i refer to a particular table ,say "a"using an odbc stage.when i refer to any other table(apart from table "a") using the O...
by dhiraj
Thu Feb 19, 2004 11:15 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Help! Help! Help!
Replies: 7
Views: 2652

Help! Help! Help!

Hi, I'm having a problem in saving my jobs. when ever i try to save a job which uses a particular table as input source(IN SQL SERVER 2000 USING ODBC STAGE) It gives me an error message which is given below. Error calling subroutine: DSR_RECORD (Action=2); check DataStage is set up correctly in proj...
by dhiraj
Fri Feb 06, 2004 6:43 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: can link collector stage be used with out Link partioner.
Replies: 5
Views: 2432

Just ignore the collector stage and link directly from your Transformers to the Sequenctial File. Just make sure that the settings inside the sequential file stage are the same for all three input links. And of course, change the 'Overwrite' setting to 'Append' I tried doing this but it gives me an...
by dhiraj
Fri Feb 06, 2004 5:04 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: can link collector stage be used with out Link partioner.
Replies: 5
Views: 2432

can link collector stage be used with out Link partioner.

Hi, actually i want to write the out put of 3 diffenrent transformer stages to the same sequential file.For this can i use the link collector stage to collect the output from these tranformers and write it to the sequential file.The output layout of the three transformers is the same. I tried doing ...