Page 1 of 1
Read complex structured (segment) type table
Posted: Thu Oct 12, 2017 12:58 pm
by spuli
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.
Posted: Thu Oct 12, 2017 1:09 pm
by chulett
I don't know about anyone else, but I for one would need a wee bit of detail around what a "segment structured table" might be / look like, what database we're talking about, etc etc...
Posted: Thu Oct 12, 2017 1:24 pm
by spuli
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_SEGMENT_TYPE,
DTP_DISCHARGE DTP_SEGMENT_TYPE,
DTP_REPRC_RECEIVED DTP_SEGMENT_TYPE,
CN1_CONTRACT CN1_SEGMENT_TYPE,
AMT_PATIENT_PAID AMT_SEGMENT_TYPE,
REF_SVC_AUTH_EXEMP_CD REF_SEGMENT_TYPE
Posted: Thu Oct 12, 2017 3:00 pm
by qt_ky
Have you tried using the Oracle Connector stage with a user-defined SQL select statement?
Posted: Thu Oct 12, 2017 3:26 pm
by chulett
Oh... so we're talking about user-defined datatypes? The previous suggestion should work fine, I would think.
Let us know! :D