Search found 36 matches
- Sat Aug 22, 2020 9:22 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Datastage on Azure
- Replies: 2
- Views: 12866
Datastage on Azure
Hi, We are planning to host DataStage on Azure cloud as part of data centre exit strategy. Please provide the steps involved in doing that. Below are some of the queries on the same. > Currently we are using DS11.5 ,Do we need to upgrade to 11.7 in order to do that? >Can we install DS server on Wind...
- Tue Jun 27, 2017 7:00 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: XML Hierarchical stage
- Replies: 5
- Views: 4746
- Mon Jun 19, 2017 8:33 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: XML Hierarchical stage
- Replies: 5
- Views: 4746
- Fri Jun 16, 2017 8:13 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: XML Hierarchical stage
- Replies: 5
- Views: 4746
XML Hierarchical stage
Error when changed the target path from ABC to ABC_DE. Checked in Google and couldn't see any solution for this particular issue. main_program: Fatal Error: ErrorDuringDocumentCreation cause = 'java.util.InvalidPropertiesFormatException: org.xml.sax.SAXParseException: The reference to entity "U...
- Mon Dec 05, 2016 10:37 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: sending hierarchical data through web service via soap rqst
- Replies: 7
- Views: 6280
- Mon Dec 05, 2016 2:00 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: sending hierarchical data through web service via soap rqst
- Replies: 7
- Views: 6280
- Mon Dec 05, 2016 1:58 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: sending hierarchical data through web service via soap rqst
- Replies: 7
- Views: 6280
HI Ernie, I am trying to use XML stage to create the XML with hierarchy and this XML will be fed to web service stage as an input. Once we create the XML we can use XML output stage to send data to web service in a single column(lets say SOAP_OUTPUT) but I am not how much data a single column can ho...
- Sat Dec 03, 2016 11:55 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: sending hierarchical data through web service via soap rqst
- Replies: 7
- Views: 6280
sending hierarchical data through web service via soap rqst
Sending hierarchical data through web service via soap request in datastage. To read a relational data from database and convert that into hierarchical data and need to send it downstream as a single or multiple hits. For Ex: Hierarchy in the downstream is Header rowcount totalcredit totaldebit deta...
- Tue Oct 04, 2016 10:20 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Datastage calling peoplesoft web service
- Replies: 3
- Views: 2401
Hi Ernie, It is a single call from ETL to peoplesoft . and Peoplesoft would be one row as a response. but in that row as I said there would be inbuilt peoplesoft fields(such as PSCAMA fields ) but one field(comments column) contains the actual XML. When I trying to make this field as an input column...
- Mon Oct 03, 2016 12:33 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Datastage calling peoplesoft web service
- Replies: 3
- Views: 2401
Datastage calling peoplesoft web service
Hi, We are invoking peoplesoft web service from datastage and the output is in one field in the form of an XML. Lets say for exmple the output of peoplesoft web service is like this >col11 col2 col3 col4 XML is there in col3 and i am trying to make this as a key column to propogate and create an XML...
- Sat Apr 23, 2016 5:10 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Rejection handling in web service transformation stage
- Replies: 1
- Views: 2295
Rejection handling in web service transformation stage
Hi, Need info on rejection handling when using web service transformation stage. Two scenarios would be there >When the web services are down- In this case what is the config setup i have to do >when there's no output for the input ETL provided- i did check rejects in the stage tab but still when th...
- Fri Dec 11, 2015 9:49 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Timestamp issue when using Pivot Stage
- Replies: 10
- Views: 5405
My Date Validation Logic is like this
Code: Select all
If INDATE <> "" Then
If IsValid('Date', INDATE[1,4] : "-" : INDATE[5,2] : "-" : INDATE[7,2]) = 1 Then
StringToDate(INDATE,"%yyyy%mm%dd")
Else SetNull()
Else SetNull()
- Thu Dec 10, 2015 12:24 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Timestamp issue when using Pivot Stage
- Replies: 10
- Views: 5405
- Thu Dec 10, 2015 9:09 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Timestamp issue when using Pivot Stage
- Replies: 10
- Views: 5405
- Thu Dec 10, 2015 7:24 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Timestamp issue when using Pivot Stage
- Replies: 10
- Views: 5405
Re: Timestamp issue when using Pivot Stage
When I checked in google I came across one solution where we need to update some patch because there is an issue with Pivot Stage in handling TimeStamp.