Search found 3 matches
- Tue Oct 29, 2013 2:50 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Reading CLOB Column in DS 8.7
- Replies: 1
- Views: 1847
Reading CLOB Column in DS 8.7
Hi I am trying to read CLOB columns in DataStage 8.7. Here is the case Extract Query, working fine in oracle SELECT PLACEMENT_ID, DBMS_XMLGEN.CONVERT ( RTRIM ( XMLAGG (XMLELEMENT (e, TARGETED_ID || CHR (13))).EXTRACT ('//text()').getclobval (), ','), 1) INCLUDE_SITE_SECTION_IDS, DBMS_XMLGEN.CONVERT ...
- Mon Nov 19, 2012 11:42 am
- Forum: General
- Topic: Change the string to specific date format in User variable
- Replies: 4
- Views: 2066
Change the string to specific date format in User variable
We need to change the string to specific date format in User Variable Activity. One option would using OCONV function Input string coming in as 20120731 Expected Output : 31-AUG-2012 Can you please let me know what format do I need use in the function Oconv(Inputvalue, format) What are other options...
- Fri Sep 16, 2011 1:53 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Regarding Connecting to iseries data from Datastage
- Replies: 3
- Views: 6178
Regarding Connecting to iseries data from Datastage
Hi Experts, I do have question regarding connecting to iseries data from Datastage V8.5 The client company has purchased DB2 Connect for iseries processor. I have Infosphere information server installed on Aix 6.1 Do I have to install DB2 connect server as well as client on Aix 6.1 and also what I h...