Search found 222 matches

by rsunny
Tue Mar 26, 2013 8:52 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: SAP BW extract stage issue
Replies: 3
Views: 2509

Hi Ray,

The records that are extracting is 0 records. None of the records are extracting and even if there are records its extraction with lesser time limit rather than using the time limit as 7200 secs
by rsunny
Tue Mar 26, 2013 3:55 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: SAP BW extract stage issue
Replies: 3
Views: 2509

SAP BW extract stage issue

Hi All, I have a parallell job which extracts the data from SAP BW extract stage and loads into flat file. I have used the process chain, connection and source system and also the open Hub Destination name. It did ran fine in Dev and QA after updating the BW in the extract stage. It didnt ran in Pre...
by rsunny
Mon Aug 20, 2012 1:09 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Couldn't able to read xml file
Replies: 8
Views: 5793

Any idea of what would be the issue?
by rsunny
Sun Aug 19, 2012 8:27 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Couldn't able to read xml file
Replies: 8
Views: 5793

Hi Ernie,

I have used xml metadata importer and defined in the columns and the xpath is also defined in the description for each column but still couldn't able to read the xml file.

I have done searches but couldn't able to find the solution.

Any help is really appreciated
by rsunny
Sun Aug 19, 2012 1:26 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Couldn't able to read xml file
Replies: 8
Views: 5793

Is there any other alternative solution to read the xml files besides using with External Source or Sequential file stage?
by rsunny
Sat Aug 18, 2012 12:02 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Couldn't able to read xml file
Replies: 8
Views: 5793

Any help for the above issue is really appreciated
by rsunny
Fri Aug 17, 2012 1:40 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Couldn't able to read xml file
Replies: 8
Views: 5793

Hi , I have included the namespace declaration in xml input stage xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/" xmlns:wsdl="http://schemas.xmlsoap.org/wsdl/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:defns="urn:books" xmlns:xsd=&q...
by rsunny
Fri Aug 17, 2012 8:02 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Couldn't able to read xml file
Replies: 8
Views: 5793

Couldn't able to read xml file

Hi , I am trying to read xml file and load it into text file . I used External Source->xml input->transformer->sequential file In External Source , i Have specified Source Method as Specific Program Source program as ls /abc/ghe/books.xml Record Type as implicit Record delimiter as none In Xml input...
by rsunny
Thu Jul 05, 2012 6:34 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Bad NLS map name
Replies: 7
Views: 5578

I tried setting the transform type to be Target and no output link but still get the error and the job is Aborting
by rsunny
Mon Jul 02, 2012 8:58 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Bad NLS map name
Replies: 7
Views: 5578

Hi Craig, I was not in a hurry but just want to make sure my thread doesn't become old. If my thread is Old , i dont think so i will get the response. I have used a 'transform' procedure without source and a target and it worked fine but the Database that i used is Teradata. But when i am trying for...
by rsunny
Mon Jul 02, 2012 6:40 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Bad NLS map name
Replies: 7
Views: 5578

Hi,

Could anyone please suggest me what would be the solution for the above error?
by rsunny
Sun Jul 01, 2012 2:49 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Bad NLS map name
Replies: 7
Views: 5578

Re: Bad NLS map name

Any Help is really appreciated
by rsunny
Sun Jul 01, 2012 11:48 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Bad NLS map name
Replies: 7
Views: 5578

Bad NLS map name

Hi , I am trying to execute a Oracle stored procedure and used a stored procedure stage . Procedure Type is Transform and have 7 parameters and the values are hardcoded in Parameters tab under Parametr maker/literal. I am getting the below error when i run the Stored procedure stage. The stored proc...
by rsunny
Thu Jun 21, 2012 11:24 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Numeric value issue
Replies: 8
Views: 3830

Hi,

Can you please provide me the solution as i need to use the datatype as Varchar . If i use the datatype as Integer it works but i nmeed to use the datatype as Varchar . And if i use Varchar i am not able to generate the number
by rsunny
Tue Jun 19, 2012 8:48 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Numeric value issue
Replies: 8
Views: 3830

yes my value will be 'abc_uniqueseqnumber