Search found 15 matches

by thupallireddy
Fri Nov 07, 2014 10:46 am
Forum: General
Topic: Read a sequential file. Metadata not known at design time
Replies: 4
Views: 14358

Vishal -- Did u get the solution for the above requirement?
by thupallireddy
Fri Aug 22, 2014 7:54 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: XML file created with no proper ordering open and close tags
Replies: 8
Views: 4869

It Appears for every product in xml. Please let me know whether any fix pack needs to upgrade for the same. Currently im using 8.5 with fixpack2. Because it is working fine for 1000 products and if it is 3000, then issue is arising for each chunk. chunk contains product_id, desc, locale etc., Random...
by thupallireddy
Mon Aug 18, 2014 1:10 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Oracle connector Update statement
Replies: 6
Views: 11813

This is the error we get when update statement is using more than two columns in where condition and data is not matching for columns(used in where condition). I have overcome this error now and job is running fine.
by thupallireddy
Mon Aug 18, 2014 1:02 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Polish Character Issue in Datastage
Replies: 7
Views: 8183

Hi Kunal,

This issue is resolved. I have configured nls_lang value as same as oracle db in dsenv and it worked. :lol:
by thupallireddy
Mon Aug 11, 2014 1:44 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Oracle connector Update statement
Replies: 6
Views: 11813

hi

Did this issue get resolved? I am also facing same issue. Can anyone please suggest on this rowid error while updating.

Im getting same error as RETURNING COUNT(ROWID) INTO :19.

Thanks in advance,
Reddy.
by thupallireddy
Sat Aug 09, 2014 7:00 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Polish Character Issue in Datastage
Replies: 7
Views: 8183

HI Kartik,

Im also facing the same issue. Pls let me know how to overcome this?
by thupallireddy
Wed Jun 11, 2014 11:00 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: XML file created with no proper ordering open and close tags
Replies: 8
Views: 4869

Hi Ernie, Yes there is Descriuptions tag with list and description containing in it. For differnet locales teh information should be residing in description. It should be like below. <Descriptions> <Description locale="loc1"> ....</Description> <Description locale="loc2"> ....</D...
by thupallireddy
Wed Jun 11, 2014 10:58 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: XML file created with no proper ordering open and close tags
Replies: 8
Views: 4869

Hi Eric, There is a job producing XML based on XSD. It worked fine in test and preprod but in live it is giving problem for 5 or 6 items randomly. I checked wheteher there is any data issue. But no issues and tried to run the job couple of times and this mismatch of close tag is happening randomly. ...
by thupallireddy
Wed Jun 11, 2014 9:25 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: XML file created with no proper ordering open and close tags
Replies: 8
Views: 4869

Hi chulett, My requirement is like this. <Descriptions> <Description locale="loc"><li>Add a glamorous edge to your wardrobe with these F&F Limited Edition stiletto court shoes. These striking pointed toe courts have an animal print in a glossy patent finish and a brushed metal effect s...
by thupallireddy
Wed Jun 11, 2014 7:43 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: XML file created with no proper ordering open and close tags
Replies: 8
Views: 4869

XML file created with no proper ordering open and close tags

This is happening in live with more data in XML assembly editor stage in 8.5. the below thing happens in sequence. Job is not aborting and crating the xml file. out of 7000 products only 5 or 6 products are getting this error while validating against the XSD. Please suggest me how to overcome this. ...
by thupallireddy
Tue May 20, 2014 11:52 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Message bundle error in XML
Replies: 3
Views: 3387

It could be anything. Whenever I have received that, it's either because of an error I've made in the assembly that is causing a warning or a real error, or an issue with an xsd or document that the ... Hi Ernie, Iam not an premium member, Can u please tell me the exact error as i am not able to vi...
by thupallireddy
Mon May 19, 2014 1:30 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Message bundle error in XML
Replies: 3
Views: 3387

Message bundle error in XML

Hi All, While running a job which is having XML as output ( using XML assembly editor stage), im getting below error. XML_102,0: Message bundle error Can't find resource for bundle com.ibm.e2.Bundle_E2_engine_msgs, key en_GB Message bundle error Can't find resource for bundle com.ibm.e2.Bundle_E2_en...
by thupallireddy
Wed Apr 30, 2014 6:08 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Inserting UTF-8 characters into Oracle
Replies: 7
Views: 8920

Re: Inserting UTF-8 characters into Oracle

Try without modifying in admin, just pass a parameter in job as

NLS_LANG=AMERICAN_AMERICA.AL32UTF8

Even in jobproperties, NLS ---> projectdefault(UTF8) and default(off).

Im new to this forum not able to paste screenshot of the same what i have used.

:)
by thupallireddy
Wed Apr 30, 2014 6:00 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Inserting UTF-8 characters into Oracle
Replies: 7
Views: 8920

Re: Inserting UTF-8 characters into Oracle

Tony, I have also faced the same issue for trademark symbols as ? instead of TM. After entry in dsenv file, everything is working fine for me. I remember as i read in some forum recently as first we need to modify in server level(dsenv) to make into effect. May be Im wrong :o But it worked for me wi...
by thupallireddy
Wed Apr 30, 2014 1:48 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: suppressing duplicates in repetitive elements in xml using
Replies: 1
Views: 1389

suppressing duplicates in repetitive elements in xml using

o/p is </Product> <Product> <ExternalId>product123</ExternalId> <Name>Gola Active Women's Verde 2 Trainers</Name> <Description>The Verde 2 trainers from Gola </Description> <BrandExternalId>Gola</BrandExternalId> <CategoryExternalId>catg1</CategoryExternalId> <ProductPageUrls> <ProductPageUrl locale...