Search found 40 matches
- Thu Oct 12, 2017 1:24 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Read complex structured (segment) type table
- Replies: 4
- Views: 2760
Sorry about that. Database is oracle 11g. Columns are like below with user defined structure. LP2300_ID NUMBER CONSTRAINT HAP_NN_CLPP_2300A#LI NOT NULL, LP2000B_ID NUMBER, LP2000C_ID NUMBER, FILE_ID NUMBER CONSTRAINT HAP_NN_CLPP_2300A#FI NOT NULL, CLM_CLAIM CLM_SEGMENT_TYPE, DTP_ADMISSION DTP_SEGMEN...
- Thu Oct 12, 2017 12:58 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Read complex structured (segment) type table
- Replies: 4
- Views: 2760
Read complex structured (segment) type table
Hi All,
I have a requirement to read the data from segment structured tables.
I am using Datastage 11.3 version. Please suggest me to read the data in this table from DdataStage.
Thanks in advance.
I have a requirement to read the data from segment structured tables.
I am using Datastage 11.3 version. Please suggest me to read the data in this table from DdataStage.
Thanks in advance.
- Thu Jul 14, 2016 10:05 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Remove duplicates after concatenation
- Replies: 10
- Views: 6404
- Thu Jul 14, 2016 7:35 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Remove duplicates after concatenation
- Replies: 10
- Views: 6404
- Thu Jul 14, 2016 7:31 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Remove duplicates after concatenation
- Replies: 10
- Views: 6404
Hi JRodriguez, Thanks for posting your idea. I thought of this approach before. There is a difficulty in this. I have to retain the rank of the columns. Lets say col3 value is already in col1, I have to move col4 to col3 only if it is not a duplicate of existing columns. Please let me know if there ...
- Wed Jul 13, 2016 11:34 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Remove duplicates after concatenation
- Replies: 10
- Views: 6404
Remove duplicates after concatenation
Hi All, I have got a requirement to eliminate the duplicates after concatenating a set of columns. Col1 value: 123 Col2 value: 234 Col3 value: 123 Col4 value: 222 Col5 value: 222 After concatenating with pipe I should get the value 123|234|222|| I have the below logic to achieve this result: Appendi...
- Wed Mar 30, 2016 1:42 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: External string too long
- Replies: 7
- Views: 14325
- Wed Mar 30, 2016 12:19 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: External string too long
- Replies: 7
- Views: 14325
- Wed Mar 30, 2016 11:56 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: External string too long
- Replies: 7
- Views: 14325
External string too long
Hi All, I am trying to load a file with 700 fields into a table. I used sequential file stage to read the file. I am getting the below warning message. "Input_Stage,0: External string too long. Imported only 1 out of 2 external characters. Ignoring last 1 characters up to delimiter." How d...
- Fri Jan 29, 2016 2:23 pm
- Forum: IBM QualityStage
- Topic: Need to verify US address with zipcode
- Replies: 7
- Views: 6925
Need to verify US address with zipcode
Hi All, I have some data in a dimension table which contains address fields like Address lin1, address line 2, state, city, zip code and zip code extension. All the addresses are US based addresses. I have to validate all these addresses and identify which are invalid. Is there any webservice to val...
- Thu Jan 28, 2016 4:15 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Could not open transformer in 11.3
- Replies: 5
- Views: 4770
- Thu Jan 28, 2016 4:14 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Could not open transformer in 11.3
- Replies: 5
- Views: 4770
- Tue Jan 26, 2016 2:16 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Could not open transformer in 11.3
- Replies: 5
- Views: 4770
Could not open transformer in 11.3
Hi All, Datastage 11.3 client is installed on Windows 7 enterprise edition desktop. It is a 32-bit OS. I am trying to open transformer inside a job and it is not showing up :( I am trying to open director client. It is throwing the below error. Run-time error '339': Component 'MSCOMCTL.OCX' or one o...
- Thu Jan 21, 2016 9:54 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: how to find ODPP libraries to add to LIBPATH in 11.3
- Replies: 2
- Views: 4393
how to find ODPP libraries to add to LIBPATH in 11.3
I am trying to configure Data Masking stage in parallel job. when i execute the job, getting below error: Failed to load ODPP library. In case of ODPP version 9.1, add the path to ODPP libraries to system path. In case of ODPP version 1, make sure that ODPP libraries exist under <Information_Server_...
- Fri Jan 15, 2016 1:38 pm
- Forum: General
- Topic: execute sh displaying password
- Replies: 5
- Views: 4018