Search found 182 matches

by srimitta
Sat May 07, 2011 7:54 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: IDoc loading
Replies: 0
Views: 1805

IDoc loading

Before mapping all segments I am trying to test run with Control Segement (EDI_DC40) using SAP IDoc load stage, job is failing with below error. IDoc exception: CIdoc constructor: Release length too long [/color] Searched this forum and also googled but didn't find any clue, would someone please hel...
by srimitta
Wed Dec 15, 2010 12:49 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Capture column names
Replies: 1
Views: 1782

Capture column names

Hi All,

While comparing two datasets along with identifying which row is changed how to Capture column names when a value changes in that particular column or columns.

This first time I have come-acrossed this kind of requirement, does any one have any idea on how to do this.

Thanks
srimitta
by srimitta
Wed Mar 24, 2010 3:37 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error loading data into SAP using IDoc stage from DataStage
Replies: 4
Views: 6092

I would take that error to your SAP 'DBA' or whomever administers that application / database / system. See what they think might be going on
It's failing even before going to SAP
by srimitta
Wed Mar 24, 2010 10:59 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error loading data into SAP using IDoc stage from DataStage
Replies: 4
Views: 6092

Error loading data into SAP using IDoc stage from DataStage

Hi All, While testing with one record DataStage using IDoc stage is successfully able to post in SAP, but when we try loading full volume we are getting below error. I was able to find few IDoc loading issues in DSXchange but they are not helping me, any idea what I a missing. Error Message: IDocs_C...
by srimitta
Tue Aug 04, 2009 2:30 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to install SAP PACK R/3 Client and Server
Replies: 7
Views: 4910

To install client version on developer's machines, you need to copy librfc32.dll to C:\WINDOWS\system32 or librfc32.dll will be copied when you install SAP GUI on developers machines.
by srimitta
Mon May 11, 2009 3:33 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Concatenation of multiple row string values to one column
Replies: 4
Views: 3286

Concatenation of multiple row string values to one column

Hi All, My source data looks like this in DB2: COLA COLB MIS-1 4 off Strips of clamp rubber MIS-1 1 off roller bearing MIS-2 1 off Heater rod MIS-2 2 off 16mm dia x 299 ground shafts How can I concatinate COLB for all repeated COLA values. COLA COLB MIS-1 4 off Strips of clamp rubber 1 off roller be...
by srimitta
Thu Mar 05, 2009 7:25 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Invalid character
Replies: 6
Views: 7238

Invalid character

Hi, While extracting data from SAP using ABAP stage, job is aboting with below errors. I Couldn't find similar issues on this forum, anybody have any idea on how to deal with this kind of errors. ABAP,0: Invalid character(s) ([xDE00]) found converting Unicode string (code point(s): [x0013][x6CFC][x2...
by srimitta
Fri Jan 30, 2009 10:24 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DataStage Repository Interface
Replies: 3
Views: 7556

Thanks Ray for the response, As per your advise I quried these tables couldn't interpret results, any help!. >SELECT * FROM UV.ACCOUNT; Account... UID GID Owner name...... NT pathname............. Permissions uv 0 0 C:\IBM\InformationServer \Server\DSEngine DS 0 0 C:\IBM\InformationServer \Server\DS...
by srimitta
Fri Jan 30, 2009 5:48 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DataStage Repository Interface
Replies: 3
Views: 7556

DataStage Repository Interface

Hi All, I was sucessfully able to install IISv8.1 on Windows, while testing Parallel Tranformer Stage I killed a testing job couple of times. After rebooting machine I tried to open DataStage client components but started throwing below errors. I know that killing testing job have corrupted DS repos...
by srimitta
Wed Jan 28, 2009 3:53 pm
Forum: Information Analyzer (formerly ProfileStage)
Topic: Error creating DS job
Replies: 2
Views: 5040

Thanks Ray,

We were able to reolve issue.

Under IA Home -> Analysis Settings -> Analysis Engine -> DataStage Credential

we removed User ID / Passwrod.

Information Analyzer gets default DataStage credentials.
by srimitta
Tue Jan 27, 2009 12:46 pm
Forum: Information Analyzer (formerly ProfileStage)
Topic: Error creating DS job
Replies: 2
Views: 5040

Error creating DS job

Hi Guys,

Column Analysis fails with "Error creating DS job".

Any have idea about this error.

Thanks
SriMitta
by srimitta
Tue Dec 02, 2008 10:14 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: capture records that exceed the limit
Replies: 12
Views: 5528

output link: - Tranform Stage Constraint logic student <= limit (Students <= limit, Based on the department ---> capture in output link) department students limit 1 10 10 1 9 10 2 10 10 3 10 10 Reject Link: Tranform Stage Constraint logic student > limit (students > limit, Based on the department --...
by srimitta
Thu Nov 20, 2008 3:29 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Flat File
Replies: 6
Views: 3319

What do you mean by
  • one line at the top and one line at the bottom to the data file
header and trailer records?.
by srimitta
Thu Nov 20, 2008 9:06 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Problem with the DRS stage
Replies: 1
Views: 2062

Try a simple job (DRSStage ---> Sequential File) and see how that goes, still if you have same issue then think about DRSStage or if your simple jobs runs fine then think about your job design, what are the satges you have after DRSStage.