Search found 13 matches

by Pikty
Fri May 13, 2016 6:47 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Teradata Connector error
Replies: 8
Views: 9118

Hi I can not see Premium Messages unfortunately - Are you able to share please ?
by Pikty
Fri May 13, 2016 5:06 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Teradata Connector error
Replies: 8
Views: 9118

Hi there, I'm running under PX 8.7 and I'm facing the same error message: "Error loading connector library cctera.dll.The specified module could not be found". Could you help to fix this issue I can see this cctera.dll file in two places under this paths 1. "C:\IBM\InformationServer\S...
by Pikty
Fri Jan 04, 2013 7:17 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Create Pivot Horizontal table
Replies: 9
Views: 8159

Thanks guys. I'll move in that direction then
by Pikty
Thu Jan 03, 2013 9:51 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Create Pivot Horizontal table
Replies: 9
Views: 8159

Hi Prasoon,
These options are not available for 8.1 unfortunately.
I guess I'm stuck and have to use stage variables to make it work. :-(
by Pikty
Thu Jan 03, 2013 8:36 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Create Pivot Horizontal table
Replies: 9
Views: 8159

Sure, please have a look below In the Inputs tab: I have 2 columns: columnname ID (Key) MyNumbers In the Outputs tab columnname Derivation ID (Key) Value1 MyNumbers Value2 MyNumbers Value3 MyNumbers and here is the result Peek_429,0: persIdf:aaa Value1:47650 Value2:47650 Value3:47650 Peek_429,0: per...
by Pikty
Thu Jan 03, 2013 8:27 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Create Pivot Horizontal table
Replies: 9
Views: 8159

True... just looking for a working sample. to configure it properly

by the way I'm running on Datastage 8.1
I ran couple of tests and I'm not able to dispatch the result as expected... :-(
by Pikty
Thu Jan 03, 2013 8:05 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Create Pivot Horizontal table
Replies: 9
Views: 8159

Create Pivot Horizontal table

Hi there, I'd like to use a pivot table to convert a vertical table into a horizontal table Basically I'm receiving data as below: ID Name Value 1 aaa 123 1 aaa 456 1 aaa 789 2 bbb 963 2 bbb 852 3 ccc 111 4 ddd 444 4 ddd 555 ... and I would like to convert the data as below: ID Name Value1 Value2 Va...
by Pikty
Sat Dec 01, 2012 10:19 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: XML source File -> EXTRACT DATA
Replies: 1
Views: 1907

XML source File -> EXTRACT DATA

Hi Experts I need your help !!! Currently working on DS 8.1 installed on a Unix box (server) / client running on Windows In a parallele job I would like to load a XML file which uses the structure below: <?xml version="1.0" encoding="UTF-8"?> <dataroot xmlns:od="urn:schemas-...
by Pikty
Fri Nov 16, 2012 2:01 am
Forum: IBM<sup>®</sup> SOA Editions (Formerly RTI Services)
Topic: how pass param to Webservice
Replies: 2
Views: 5730

Re: how pass param to Webservice

All right - the solution of reading a xml file containing the soapRequest to consume the webservice is explained here below the list of stages I'm using: ExternalSource stage -> XML Input stage -> WSTransformer stage -> XML Input stage and a peed to check the result http://www-01.ibm.com/support/doc...
by Pikty
Thu Nov 15, 2012 9:33 am
Forum: IBM<sup>®</sup> SOA Editions (Formerly RTI Services)
Topic: how pass param to Webservice
Replies: 2
Views: 5730

how pass param to Webservice

Hi there, I'm facing a critical issue querying a Webservice. I'll try to describe as much as possible. I'm working on Datastage v8.1 Server on Unix & DB2 1st/ I tried to load a WSDL file used by other departments with the Web Service Meta Data Importer tool without success. When I tried that the...
by Pikty
Thu Nov 15, 2012 4:09 am
Forum: IBM<sup>®</sup> SOA Editions (Formerly RTI Services)
Topic: Failed to load webservice M'aider M'aider
Replies: 4
Views: 5222

All right I get ride of it by defining manually the Web Service Information (adding the Service name, operation name, port address...)
by Pikty
Tue Nov 13, 2012 8:18 am
Forum: IBM<sup>®</sup> SOA Editions (Formerly RTI Services)
Topic: Failed to load webservice M'aider M'aider
Replies: 4
Views: 5222

Hard to say..that is now a pretty old release, and there were definitely some improvements along the way that eased the ability to import certain WSDL. Do you have access to an 8.5 or an 8.7 to at le ... No way. This is the current version used by the company. ARchh I'm pretty sure there is a way t...
by Pikty
Tue Nov 13, 2012 7:12 am
Forum: IBM<sup>®</sup> SOA Editions (Formerly RTI Services)
Topic: Failed to load webservice M'aider M'aider
Replies: 4
Views: 5222

Failed to load webservice M'aider M'aider

Hi there, I'm using DS 8.1 Server (server on UNIX and client on Windows 7) and I currenty stuck on the import step of a webservice (certainly soap 1.2) as there are no webmethods returned when I load the wsdl file using the WebService Meta Data Importer (using the http://....?wsdl). When I save the ...