DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
spuli
Participant



Joined: 09 Apr 2015
Posts: 40

Points: 302

Post Posted: Thu Oct 12, 2017 12:58 pm Reply with quote    Back to top    

DataStage® Release: 11x
Job Type: Parallel
OS: Unix
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

Premium Poster


since January 2006

Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group

Joined: 12 Nov 2002
Posts: 42273
Location: Denver, CO
Points: 217068

Post Posted: Thu Oct 12, 2017 1:09 pm Reply with quote    Back to top    

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

Watch out where the huskies go and don't you eat that yellow snow
Rate this response:  
spuli
Participant



Joined: 09 Apr 2015
Posts: 40

Points: 302

Post Posted: Thu Oct 12, 2017 1:24 pm Reply with quote    Back to top    

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
Rate this response:  
qt_ky



Group memberships:
Premium Members

Joined: 03 Aug 2011
Posts: 2665
Location: USA
Points: 19822

Post Posted: Thu Oct 12, 2017 3:00 pm Reply with quote    Back to top    

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
Rate this response:  
chulett

Premium Poster


since January 2006

Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group

Joined: 12 Nov 2002
Posts: 42273
Location: Denver, CO
Points: 217068

Post Posted: Thu Oct 12, 2017 3:26 pm Reply with quote    Back to top    

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

Let us know! Very Happy

_________________
-craig

Watch out where the huskies go and don't you eat that yellow snow
Rate this response:  
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours