Search found 320 matches

by mydsworld
Wed Mar 19, 2008 6:28 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Invalid chracter from codepage UTF-8 to Unicode
Replies: 2
Views: 3431

Invalid chracter from codepage UTF-8 to Unicode

While doing a string conversion in transformer, I am getting the following error :

main_program: Invalid character(s) ([xF8]) found converting string (code point(s): COL_ID[x00][xF8]|[x8C][x08][xE0]~) from codepage UTF-8 to Unicode, substituting.

Please help.
by mydsworld
Fri Mar 07, 2008 3:47 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DataStage with WBI
Replies: 6
Views: 1469

DataStage with WBI

Yes,by WBI I meant, WebSphere Business Integrator, can DataStage read/write data from it.

Thanks
by mydsworld
Fri Mar 07, 2008 11:43 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DataStage with WBI
Replies: 6
Views: 1469

DataStage with WBI

Is there any way to read/write data from WBI using DataStage.

Thanks
by mydsworld
Tue Mar 04, 2008 9:32 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Loading SAP data through DataStage
Replies: 15
Views: 12004

Loading SAP data

By 'loading SAP data', I meant loading data from legacy to SAP system using DataStage.
by mydsworld
Mon Mar 03, 2008 9:56 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Loading SAP data through DataStage
Replies: 15
Views: 12004

Different Loading option of SAP data through DataStage

I am looking for SAP data loading and not SAS data.

Basically looking for which SAP plugin (in DataStage) to use in which case (less data volume/huge data volume and othere relevant consideration).
by mydsworld
Sun Mar 02, 2008 3:42 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Loading SAP data through DataStage
Replies: 15
Views: 12004

Loading SAP data through DataStage

Please let me know the methods (datastage plug-ins) for loading SAP data keeping in the mind :

1. Huge volume of data
2. Less volume of data.

Please let me know which SAP plug-in is to be used in which case.

Thanks.
by mydsworld
Sat Mar 01, 2008 12:14 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Writting parallel routine
Replies: 2
Views: 1526

Writting parallel routine

Please let me know the following regarding writting a parallel routines :

1. Where to write the code (in C/C++) of routine (which directory of the server)

2.compilation details (like compiler required etc)

3.how to invoke that routine from the DS designer (as parallel routine)

Thanks in advance.
by mydsworld
Wed Feb 27, 2008 3:48 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error with DSGetStageLinks
Replies: 5
Views: 1893

Error with DSGetStageLinks

The function DSGetStageInfo works fine, but that gives me list of input & output links together.I want them separate.
by mydsworld
Wed Feb 27, 2008 3:29 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error with DSGetStageLinks
Replies: 5
Views: 1893

Error with DSGetStageLinks

I am trying to capture the links (input) associated with a stage thrugh DS BASIC. When I write : x = DSGetStageLinks(<Job Name>,<Stage Name>,1) I get the following error. Please help. ',' unexpected, Was expecting: '!', ')', '=', "AND", "OR", "LT", "LE", "...
by mydsworld
Wed Feb 27, 2008 11:17 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Datastage job auditing
Replies: 4
Views: 1814

Datastage job auditing

Hi,
I am trying to build up a job that will generate auditing information (like start date,rowcount etc) of other jobs (using jobname as parameter).Whats the best way to do that in DS8.
Thanks
by mydsworld
Wed Feb 27, 2008 8:54 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Generating Job auditing information
Replies: 4
Views: 1590

Generating Job auditing information

Hi,
I am trying to build up a job that will generate auditing information (like start date,rowcount etc) of other jobs (using jobname as parameter).Whats the best way to do that in DS8. Thanks
by mydsworld
Fri Dec 14, 2007 12:37 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Comparison of database stages
Replies: 1
Views: 951

Comparison of database stages

Please let me know the difference between the database stages (like Oracle Enterprise/DB2 Enterprise etc) and plug-in stages (like DB2 API,Oracle OCI etc).Which one will be helpful under which circumstances.
by mydsworld
Tue Dec 11, 2007 2:18 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Problem with Accented characters in Lookup
Replies: 0
Views: 609

Problem with Accented characters in Lookup

Can anyone please let me know how we deal with accented characters in DataStage. I am reading a .csv file (containing accented characters) in Sequential File stage with NLS_Map set to 'ISO-8859-1' and individual columns having the extended 'Unicode' property.When I view the data I can see those acce...
by mydsworld
Mon Dec 10, 2007 5:45 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Installation requirement for DataStage 8
Replies: 3
Views: 1387

Installation requirement for DataStage 8

What is the min RAM size required for installing an IIS client. I heard it is 2 GB. Please clarrify.
by mydsworld
Sat Dec 08, 2007 8:11 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Working with accented characters
Replies: 0
Views: 817

Working with accented characters

Can anyone please let me know how we deal with accented characters in DataStage. I am reading a .csv file (containing accented characters) in Sequential File stage with NLS_CODE set to UTF-8 and individual columns not having the extended 'Unicode' property.When I view the data I can see those accent...