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.
Read complex structured (segment) type table
Moderators: chulett, rschirm, roy
Read complex structured (segment) type table
Thanks,
Sai
Sai
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
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
Sai