Read complex structured (segment) type table

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
spuli
Participant
Posts: 40
Joined: Thu Apr 09, 2015 12:13 pm

Read complex structured (segment) type table

Post 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.
Thanks,
Sai
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post 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...
-craig

"You can never have too many knives" -- Logan Nine Fingers
spuli
Participant
Posts: 40
Joined: Thu Apr 09, 2015 12:13 pm

Post 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
Thanks,
Sai
qt_ky
Premium Member
Premium Member
Posts: 2895
Joined: Wed Aug 03, 2011 6:16 am
Location: USA

Post by qt_ky »

Have you tried using the Oracle Connector stage with a user-defined SQL select statement?
Choose a job you love, and you will never have to work a day in your life. - Confucius
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Oh... so we're talking about user-defined datatypes? The previous suggestion should work fine, I would think.

Let us know! :D
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply