Search found 72 matches

by svga
Fri Apr 17, 2009 7:26 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Number of I/P & O/P connection per transformer
Replies: 7
Views: 1787

I have 35 inputs (lookups) & 35 output links.Will I have more impact on performance?
by svga
Fri Apr 17, 2009 5:36 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Number of I/P & O/P connection per transformer
Replies: 7
Views: 1787

Number of I/P & O/P connection per transformer

Hi,

Are there any limitation to the number of input and output connections and stage variables per transformer stage?
by svga
Fri Apr 03, 2009 3:46 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Extended Ascii &#9488;
Replies: 4
Views: 1237

Hi,

The NLS is not enabled..Do you have any ideas to achive this character?
by svga
Thu Apr 02, 2009 3:55 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Extended Ascii &#9488;
Replies: 4
Views: 1237

Extended Ascii &#9488;

Hi,

Please help me to procduce the special character ┐ in Datastage. Do we have any ascii equivalent value?

Thanks.
by svga
Tue Mar 24, 2009 4:30 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Number of jobs in Datastage
Replies: 6
Views: 4087

Hi,

Thanks for your answers.The above query gives the count of both jobs and sequences.Please help me to get the count of jobs alone.
by svga
Tue Mar 24, 2009 3:50 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Number of jobs in Datastage
Replies: 6
Views: 4087

Number of jobs in Datastage

Hi,

Can anyone tell me the Command used to count the number of jobs in Datastage.
by svga
Tue Mar 03, 2009 8:22 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Folder stage
Replies: 1
Views: 794

Folder stage

Hi,

When do we need to use folder stage?
by svga
Fri Oct 17, 2008 6:47 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: insertion into SQL Server table
Replies: 1
Views: 728

insertion into SQL Server table

Hi, I am inserting records into SQL server table using ODBC stage.All the records from the source getting inserted even though if there is some data problem with source. Eq :If the source column value length exceeds the target column length ,some char from source valuegetting truncated and loaded in...
by svga
Mon Oct 13, 2008 1:03 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Datatype conversion
Replies: 1
Views: 1099

Datatype conversion

Hi, I have problem in converting char string to datetime datatype.The macro Datetimestamp is being passed as a user status to the next job where i am deleting the record from SQL table if the Extrctdte(One of the column in the table) is equal to Datetimestamp.Here i am getting an error as "Synt...
by svga
Fri Oct 10, 2008 7:55 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: COMP field handling
Replies: 7
Views: 1564

hi,

Can any one help this out..
by svga
Fri Oct 10, 2008 4:59 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: COMP field handling
Replies: 7
Views: 1564

COMP field handling

Hi,

My requirement is to convert a number into COMP field.I am using routine ConvertToDataTypePicComp to convert into COMP field.Can any one help me to do this. I used below format to convert

ConvertToDataTypePicComp(038,2). but i am getting an error unable to convert
'%1' into number.
by svga
Fri Oct 03, 2008 6:46 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Key in sequential file
Replies: 4
Views: 1531

Thanks....
by svga
Fri Oct 03, 2008 6:46 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Key in sequential file
Replies: 4
Views: 1531

Thanks....
by svga
Fri Oct 03, 2008 6:39 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Key in sequential file
Replies: 4
Views: 1531

Key in sequential file

Hi,

What is the use of key in the sequential file?
by svga
Wed Sep 17, 2008 6:16 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Mail Notification
Replies: 4
Views: 1085

Chulett,

Can i call routine from mail body?