Complex Flat Files

[etlbets]

I am brand new to Data Stage and I am trying read an EBCDIC file using complex flat file I am getting this error
Complex_Flat_File_375: At field "URF_CYL_TAX_DTAILS": At field "URF_CYL_TAX_DTAILS.URF_CYL_OTH_TAX_USA": Unrecognized type-specific format properties: {0, 0, 0} I was getting an error where it ask for a default value I added them and now I am stuck on this one. I also get this error
Complex_Flat_File_375_psubrec1: Error when checking operator: The supplied fieldname, URF_GCS_FACILITY_KEY, does not exist. On all the following fields... It list all on the input fields.

[ray.wurlod]

Prove it. Post the record schema associated with the CFF stage. You can find this in the generated OSH in the job properties dialog.

[goriparthi]

If you are from Mainframes take the cobol copy book (i mean the metadata) ftp it to your pc and save it with .cfd extension.

Then create a new table definition from cobol definitions and it automatically generates the table definitions for you.

Then do a ftp of your file with binary mode ,just read it with cff stage.
Path: ur file path
Data Format : EBCDIC
Record Style : Binary
and specify the record lentgh

This worked out for me see if this helps you anyway.

[etlbets]

I did send the file from the mainframe in the way you said I set it as fixed which it is and still the same problem. I could not find the schema but I found this. I do not know how to attach it so I hope this does not take up to much space Thank you for your help This is very frustrating we are not going to have classes on Datastage until after we go to parallel testing so we are learning as we go.

record
(
URF_GCS_RECORD_TYPE:string[3];
URF_GCS_SYSTEM_ID:string[3] {redefines='URF_GCS_RECORD_TYPE'};
URF_GCS_RECORD_SUB_TYPE:string[3];
URF_GCS_ACCOUNT_NUMBER:string[8];
ORIGINALLY_3_CHAR_FILLER:subrec (
URF_GCS_CYCLE:string[2];
FILLER_2:string[1];
);
URF_GCS_REVENUE_OWNER:string[3];
URF_GCS_REV_OWNER_IND:string[1];
URF_GCS_INVOICE_OWNER:string[3];
URF_GCS_CONTROL_ACCOUNT:string[8];
URF_GCS_PRODUCT_CODE:string[1];
FILLER_3:string[2];
URF_GCS_ACCESS_IND:string[1];
URF_GCS_IFD:string[1];
URF_GCS_ACCOUNT_NAME:string[30];
URF_GCS_BILLING_ADDR_LINE_1:string[30];
URF_GCS_BILLING_ADDR_LINE_2:string[30];
URF_GCS_BILLING_CITY:string[28];
URF_GCS_BILLING_STATE:string[2];
URF_GCS_BILLING_ZIP_CODE:string[9];
URF_GCS_BILLING_CONTACT_NAME:string[30];
URF_GCS_BILLING_CONTACT_PHONE:string[15];
URF_GCS_BILLTYPE_FLAG:string[1];
URF_GCS_PREFIX_FLAG:string[1];
URF_GCS_COUNTRY_CODE:string[4];
URF_GCS_INVOICE_NUMBER:string[10];
URF_GCS_MKTS_SALES_SSN:string[9];
URF_GCS_MCII_SALES_CODE:string[4];
URF_GCS_DIVISION:string[2];
URF_GCS_DESCRIPTION:string[30];
URF_GCS_CURRENCY_DESC:string[28];
URF_GCS_TELCO_DESC:string[35];
FILLER_4:string[1];
URF_GCS_CATEGORY_CODE:string[16];
URF_GCS_SERVICE_CLASS_DESC:string[35];
URF_GCS_SERVICE_TYPE_DESC:string[35];
URF_GCS_SERVICE_TERM1:string[60];
URF_GCS_SERVICE_TERM2:string[60];
URF_GCS_SERVICE_TERM3:string[60];
URF_GCS_MKTS_CITY_CODE:string[4];
URF_GCS_ACQUISITION_SEGMENT:string[1];
URF_GCS_REVENUE_SEGMENT:string[1];
URF_GCS_NASP_ID:string[10];
URF_GCS_CUSTOMER_SEGMENT:string[1];
URF_GCS_DEPT_DESCRIPTION:string[35];
FILLER_5:string[3];
URF_GCS_AMT_USA:decimal[11,2] {zoned};
URF_GCS_REDUCTION_AMT_USA:decimal[7,2] {zoned};
URF_GCS_REDUCTION_IND:string[1];
URF_GCS_MTR_LOCAL_LD_IND:string[1];
URF_GCS_ORIG_TERM_IND:string[1];
FILLER_6:string[8];
URF_STN_INFO:subrec (
URF_GCS_CORP_ID:string[8];
URF_STN_CORP_ID:string[8] {redefines='URF_GCS_CORP_ID'};
URF_GCS_BILL_DATE:string[8];
)
URF_GCS_INVOICE_DATE:string[8];
URF_GCS_PERIOD_DATE:string[8];
URF_GCS_INCEPTION_DATE:string[8];
URF_GCS_CANCEL_DATE:string[8];
URF_GCS_COUNTRY_NAME:string[35];
URF_GCS_FED_ID:string[10];
URF_GCS_ISD_LABEL:string[50];
URF_GCS_CHRG_INFO:subrec (
URF_GCS_NODE_NUM:string[8];
URF_GCS_TYPE:string[2];
URF_GCS_SUBTYPE:string[4];
URF_GCS_GROUP_SVC_METH:string[3];
)
FILLER_7:string[7];
URF_GCS_CHRG_EFF_DATE:string[8];
URF_GCS_CHRG_END_DATE:string[8];
URF_GCS_FNE_BAN_NO:string[8];
URF_GCS_CONFERENCE_ID:string[9];
FILLER_8:string[21];
URF_GCS_DISCT_PERCENT:decimal[11,2] {zoned};
FILLER_9:string[22];
URF_GCS_AMT_FGN:decimal[11,2] {zoned};
FILLER_10:string[41];
URF_GCS_STATE_ABBREV:string[4];
URF_GCS_GTLINK_II_CODE:string[4];
URF_GCS_GTLINK_II_ORG_GEO_CODE:string[9];
URF_GCS_GTUXCODR_ZIP:string[9];
FILLER_11:string[22];
URF_GCS_INVOICE_TOTAL:decimal[11,2] {zoned};
URF_GCS_TAXES:subrec (
URF_GCS_FEDERAL_TAX:decimal[11,2] {zoned};
URF_GCS_STATE_TAX:decimal[11,2] {zoned};
URF_GCS_ULTS_TAX:decimal[11,2] {zoned};
URF_GCS_DEAF_TAX:decimal[11,2] {zoned};
URF_GCS_911_SURCHARGE:decimal[11,2] {zoned};
URF_GCS_GROSS_RECEIPT_TAX:decimal[11,2] {zoned};
URF_GCS_UTILITY_TAX:decimal[11,2] {zoned};
);
URF_GCS_FEDERAL_RATE:decimal[5,3] {zoned};
URF_GCS_STATE_RATE:decimal[5,3] {zoned};
URF_GCS_ULTS_RATE:decimal[5,3] {zoned};
URF_GCS_DEAF_RATE:decimal[5,3] {zoned};
URF_GCS_911_RATE:decimal[5,3] {zoned};
URF_GCS_GROSS_RECEIPT_RATE:decimal[5,3] {zoned};
URF_GCS_UTILITY_RATE:decimal[5,3] {zoned};
URF_GCS_PRO_FROM_DATE:string[8];
URF_GCS_PRO_TO_DATE:string[8];
URF_GCS_PRORATA_CODE:string[1];
URF_GCS_PAYER_IND:string[1];
URF_GCS_FGN_DECIMAL:string[1];
FILLER_12:string[1];
URF_GCS_SVCREF_NUMBER:subrec (
URF_GCS_SVCREF_CODE:string[4];
URF_GCS_SVCREF_NO:string[16];
);
URF_GCS_CURRENCY_CODE:string[5];
URF_GCS_DEPT_CODE:string[4];
URF_GCS_CHARGE_KEY:string[25];
URF_GCS_CIRCUIT_KEY:string[25] {redefines='URF_GCS_CHARGE_KEY'};
URF_GCS_FACILITY_KEY:subrec {redefines='URF_GCS_CHARGE_KEY'} (
URF_GCS_FAC_SEQUENCE:subrec (
URF_GCS_FAC_SEQ:string[4];
URF_GCS_SUB_SEQ:string[2];
);
FILLER_13:string[19];
);
URF_GCS_EQUIP_KEY:subrec {redefines='URF_GCS_CHARGE_KEY'} (
URF_GCS_EQUIP_NO:string[7];
URF_GCS_EQUIP_SEQ:string[5];
FILLER_14:string[13];
);
URF_GCS_SETL_KEY:subrec {redefines='URF_GCS_CHARGE_KEY'} (
URF_GCS_SETL_SVC_MTH:decimal[4,0] {, default=0,zoned};
URF_GCS_SETL_CHARGE_PREFIX:string[1];
URF_GCS_SETL_CURR_CODE:string[5];
URF_GCS_SETL_SEQ_NUM:decimal[5,0] {, default=0,zoned};
FILLER_15:string[10];
);
URF_GCS_CHARGE_SEQ:string[5];
URF_GCS_COMMON_SREF:subrec (
URF_GCS_SREF_INPP_NO:string[5];
URF_GCS_SREF_PLSO:string[8];
URF_GCS_SREF_ORDER_NO:string[20];
URF_GCS_SREF_DEPT:string[20];
URF_GCS_SCAN_NO:string[20];
URF_GCS_SREF_SERV_TYPE:string[4];
URF_GCS_SREF_SERV_CLASS:string[4];
FILLER_16:string[60];
URF_GCS_SREF_ROUND_DIF:decimal[9,2] {zoned};
);
URF_GCS_COMMON_ACCT:subrec {redefines='URF_GCS_COMMON_SREF'} (
FILLER_17:string[141];
URF_GCS_ACCT_ROUND_DIF:decimal[9,2] {zoned};
);
URF_CYL_USAGE_DETAILS:subrec {redefines='URF_GCS_COMMON_SREF'} (
URF_CYL_CU_FREEPHONE_ID:string[15];
URF_CYL_CU_ISAC_ZONE:string[1];
URF_CYL_CU_ORIG_CITY_CD:decimal[5,0] {, default=0,packed};
URF_CYL_CU_TERM_CITY_CD:decimal[5,0] {, default=0,packed};
URF_CYL_CU_NUMBER_CALLED_FROM:string[16];
URF_CYL_CU_NUMBER_DIALED:string[16];
URF_CYL_CU_NUMBER_CALLED:string[16];
URF_CYL_CU_ORIG_COUNTRY_CODE:string[3];
URF_CYL_CU_TERM_COUNTRY_CODE:string[3];
URF_CYL_CU_CALL_DATE:string[8];
URF_CYL_CU_GMT_TIME:string[6];
URF_CYL_CU_LOC_TIME:string[6];
URF_CYL_CU_DURATION:decimal[7,1] {default=0.0,packed};
URF_CYL_CU_CALL_TYPE:string[1];
URF_CYL_CU_DATA:string[1];
URF_CYL_CU_NCR:string[1];
URF_CYL_CU_TERM:string[2];
URF_CYL_CU_CONF_ACCESS:string[2];
URF_CYL_CU_CONF_LEADER_ID:string[9];
URF_CYL_CU_ACCOUNTING_CODE:string[8];
URF_CYL_CU_CALLING_STATION:string[15];
URF_CYL_CU_CON_FOR_IND:string[1];
URF_CYL_CU_BAND_NBR:string[2];
URF_CYL_CU_ORIG_SUBZONE:string[2];
URF_CYL_CU_TERM_SUBZONE:string[2];
URF_CYL_CU_ISAC_CARRIER:string[2];
FILLER_18:string[2];
);
URF_CYL_NMT_DETAILS:subrec {redefines='URF_GCS_COMMON_SREF'} (
FILLER_19:string[7];
URF_CYL_NMT_BILL_DATE:string[8];
URF_CYL_NMT_FILLER1:string[20];
URF_CYL_NMT_CHRG_CODE:string[8];
URF_CYL_NMT_FILLER:string[107];
);
URF_CYL_CIRC_DETAILS:subrec {redefines='URF_GCS_COMMON_SREF'} (
URF_CYL_CIRC_DATE_INFO:subrec (
URF_CYL_CIRC_INCEPT_DATE:string[8];
URF_CYL_CIRC_EFF_DATE:string[8];
URF_CYL_CIRC_LAST_BILL_DATE:string[8];
URF_CYL_CIRC_CANCELLED_DATE:string[8];
);
URF_CYL_CIRC_PAYER_IND:string[1];
URF_CYL_CIRC_CYCLE:string[1];
URF_CYL_CIRC_CYCLE_MONTH:string[2];
URF_CYL_CIRC_IFD:string[1];
URF_CYL_CIRC_FILLER:string[16];
URF_CYL_CIRC_GL:string[1];
URF_CYL_CIRC_CUST_REF:string[15];
URF_CYL_CIRC_LOCATION:string[15];
URF_CYL_CIRC_STATE_ABBR:string[2];
URF_CYL_CIRC_ZIP:string[9];
URF_CYL_CIRC_GEO_CODE:string[9];
URF_CYL_CIRC_BILLABLE_IND:string[1];
URF_CYL_CIRC_VAT_CODE:string[1];
URF_CYL_CIRC_STRF:string[4];
URF_CYL_CIRC_STFQ:string[1];
FILLER_20:string[39];
);
URF_CYL_SPEC_DETAILS:subrec {redefines='URF_GCS_COMMON_SREF'} (
URF_CYL_SPEC_DATE_INFO:subrec (
URF_CYL_SPEC_INCEPT_DATE:string[8];
URF_CYL_SPEC_EFF_DATE:string[8];
URF_CYL_SPEC_LAST_BILL_DATE:string[8];
URF_CYL_SPEC_CANCELLED_DATE:string[8];
);
URF_CYL_SPEC_PAYER_IND:string[1];
URF_CYL_SPEC_CYCLE:string[1];
URF_CYL_SPEC_CYCLE_MONTH:string[2];
URF_CYL_SPEC_IFD:string[1];
URF_CYL_SPEC_FILLER:string[16];
URF_CYL_SPEC_GL:string[1];
URF_CYL_SPEC_CUST_REF:string[15];
URF_CYL_SPEC_LOCATION:string[15];
URF_CYL_SPEC_STATE_ABBR:string[2];
URF_CYL_SPEC_ZIP:string[9];
URF_CYL_SPEC_GEO_CODE:string[9];
URF_CYL_SPEC_BILLABLE_IND:string[1];
URF_CYL_SPEC_PREFIX:string[1];
URF_CYL_SPEC_VAT_CODE:string[1];
URF_CYL_SPEC_STRF:string[4];
URF_CYL_SPEC_STFQ:string[1];
FILLER_21:string[38];
);
URF_CYL_TAX_DTAILS:subrec {redefines='URF_GCS_COMMON_SREF'} (
URF_CYL_FED_TAX_USA:decimal[11,2] {default=0.00,packed};
URF_CYL_CTRY_TAX_USA:decimal[11,2] {default=0.00,packed};
URF_CYL_ST_TAX_USA:decimal[11,2] {default=0.00,packed};
URF_CYL_CITY_TAX_USA:decimal[11,2] {default=0.00,packed};
URF_CYL_OTH_TAX_USA:decimal[11,2] {default=0.00, , 0, 00, 0, ,packed};
URF_CYL_FED_TAX_FGN:decimal[13,2] {default=0.00,packed};
URF_CYL_CTRY_TAX_FGN:decimal[13,2] {default=0.00,packed};
URF_CYL_ST_TAX_FGN:decimal[13,2] {default=0.00,packed};
URF_CYL_CITY_TAX_FGN:decimal[13,2] {default=0.00,packed};
URF_CYL_OTH_TAX_FGN:decimal[13,2] {default=0.00,packed};
URF_CYL_VAT_USA:decimal[11,2] {default=0.00,packed};
FILLER_22:string[79];
);
URF_GCS_COMMON_FAC:subrec {redefines='URF_GCS_COMMON_SREF'} (
URF_GCS_FAC_TARIFF:subrec (
URF_GCS_FAC_SRV_TYPE:string[4];
URF_GCS_FAC_RATE_CODE:string[4];
URF_GCS_FAC_ORIG_CTRY:string[4];
URF_GCS_FAC_ORIG_CITY:string[4];
URF_GCS_FACC_DEST_CTRY:string[4];
URF_GCS_FAC_DEST_CITY:string[4];
);
URF_GCS_FAC_SALES_ID:string[9];
URF_GCS_FAC_SALES_CITY:string[6];
URF_GCS_FAC_CCITT_NO:string[25];
URF_GCS_FAC_INET_ACCESS_AMTS:subrec (
URF_GCS_FAC_INET_AMT1_USA:decimal[9,2] {zoned};
URF_GCS_FAC_INET_AMT1_FGN:decimal[12,2] {zoned};
URF_GCS_FAC_INET_AMT2_USA:decimal[9,2] {zoned};
URF_GCS_FAC_INET_AMT2_FGN:decimal[12,2] {zoned};
URF_GCS_FAC_INET_AMT3_USA:decimal[9,2] {zoned};
URF_GCS_FAC_INET_AMT3_FGN:decimal[12,2] {zoned};
);
FILLER_23:string[23];
);
URF_GCS_COMMON_CIRC:subrec {redefines='URF_GCS_COMMON_SREF'} (
URF_GCS_CIRC_GROUP:subrec (
URF_GCS_CIRC_TYPE:string[1];
URF_GCS_CIRC_TELCO:string[3];
URF_GCS_CIRC_COST:string[4];
URF_GCS_CIRC_TARF_CODE:string[2];
);
URF_GCS_CIRC_COND:string[6];
URF_GCS_CIRC_CHAN_DESIGN:string[14];
FILLER_24:string[120];
);
URF_GCS_COMMON_EQUIP:subrec {redefines='URF_GCS_COMMON_SREF'} (
URF_GCS_EQUIP_QTY:decimal[4,0] {zoned};
FILLER_25:string[146];
);
URF_GCS_COMMON_PRO:subrec {redefines='URF_GCS_COMMON_SREF'} (
URF_GCS_PRO_PREFIX:string[1];
URF_GCS_PRO_NEW_AMT_USA:decimal[9,2] {zoned};
URF_GCS_PRO_NEW_AMT_FGN:decimal[9,2] {zoned};
URF_GCS_PRO_OLD_AMT_USA:decimal[9,2] {zoned};
URF_GCS_PRO_OLD_AMT_FGN:decimal[9,2] {zoned};
FILLER_26:string[113];
);
URF_GCS_COMMON_SPEC:subrec {redefines='URF_GCS_COMMON_SREF'} (
URF_GCS_SPEC_PREFIX:string[1];
FILLER_27:string[149];
);
URF_GCS_COMMON_SPTX:subrec {redefines='URF_GCS_COMMON_SREF'} (
URF_GCS_SPTX_PREFIX:string[1];
URF_GCS_SPTX_VAT:decimal[6,4] {zoned};
URF_GCS_SPTX_TAX_TYPE:string[1];
FILLER_28:string[142];
);
URF_GCS_COMMON_CDR:subrec {redefines='URF_GCS_COMMON_SREF'} (
URF_GCS_CDR_LOC:string[3];
URF_GCS_CDR_BRACKET:string[2];
URF_GCS_CDR_CALLS:decimal[11,0] {zoned};
URF_GCS_CDR_MINUTES:decimal[11,1] {zoned};
URF_GCS_CDR_RATE:decimal[10,6] {zoned};
FILLER_29:string[8];
FILLER_30:string[105];
);
URF_GCS_COMMEB_SPEC:subrec {redefines='URF_GCS_COMMON_SREF'} (
FILLER_31:string[1];
URF_MEB_SPEC_QUANTITY:decimal[13,3] {zoned};
URF_MEB_SPEC_RATE:decimal[11,5] {zoned};
URF_MEB_SPEC_UNIT_MEAS:string[2];
FILLER_32:string[123];
);
URF_GCS_COMMEB_SPTX:subrec {redefines='URF_GCS_COMMON_SREF'} (
FILLER_33:string[1];
URF_MEB_SPTX_VAT:decimal[6,4] {zoned};
URF_MEB_SPTX_TAX_TYPE:string[1];
URF_MEB_SPTX_QUANTITY:decimal[13,3] {zoned};
URF_MEB_SPTX_RATE:decimal[11,5] {zoned};
URF_MEB_SPTX_UNIT_MEAS:string[2];
FILLER_34:string[116];
);
URF_GCS_COMMEB_PRO:subrec {redefines='URF_GCS_COMMON_SREF'} (
FILLER_35:string[1];
URF_MEB_PRO_NEW_AMT_USA:decimal[9,2] {zoned};
URF_MEB_PRO_NEW_AMT_FGN:decimal[9,2] {zoned};
URF_MEB_PRO_OLD_AMT_USA:decimal[9,2] {zoned};
URF_MEB_PRO_OLD_AMT_FGN:decimal[9,2] {zoned};
URF_MEB_PRO_QUANTITY:decimal[13,3] {zoned};
URF_MEB_PRO_RATE:decimal[11,5] {zoned};
URF_MEB_PRO_UNIT_MEAS:string[2];
URF_MEB_PRO_USAGE_PROD:string[8];
FILLER_36:string[79];
);
URF_GCS_COMMEB_BAT_DTL:subrec {redefines='URF_GCS_COMMON_SREF'} (
URF_MEB_DTL_INV_CATG_CODE:string[2];
URF_MEB_DTL_PROD_SHORT_NAME:string[15];
URF_MEB_DTL_QUANTITY:decimal[13,3] {zoned};
URF_MEB_DTL_RATE:decimal[11,5] {zoned};
URF_MEB_DTL_UNIT_MEAS:string[2];
URF_MEB_DTL_FOOT_NOTE:string[1];
FILLER_37:string[106];
);
URF_GCS_COMMEB_BAT_TAX:subrec {redefines='URF_GCS_COMMON_SREF'} (
URF_MEB_TAX_FROM_LOC:string[20];
URF_MEB_TAX_TAXABLE_AMT:decimal[11,2] {zoned};
URF_MEB_TAX_QUANTITY:decimal[13,3] {zoned};
URF_MEB_TAX_AMOUNT[5]:decimal[11,2] {zoned};
FILLER_38:string[51];
);
URF_GCS_SETL_DETAILS:subrec {redefines='URF_GCS_COMMON_SREF'} (
URF_GCS_SETL_PART_KEY:subrec (
URF_GCS_SETL_SVC_MTH_2:decimal[4,0] {zoned};
URF_GCS_SETL_CHARGE_PREFIX_2:string[1];
URF_GCS_SETL_CURR_CODE_2:string[5];
URF_GCS_SETL_SEQ_NUM_2:decimal[5,0] {zoned};
);
URF_GCS_SETL_GAIN_LOSS:decimal[9,2] {zoned};
URF_GCS_ORIG_TYPE:string[2];
URF_GCS_ORIG_SUBTYPE:string[4];
URF_GCS_ORIG_CHARGE_KEY:subrec (
URF_GCS_ORIG_TAX_TYPE:string[2];
URF_GCS_ORIG_CURR_KEY:string[5];
URF_GCS_ORIG_SECONDARY:subrec (
URF_GCS_ORIG_CDR_RATE:decimal[13,6] {zoned};
FILLER_39:string[5];
);
);
URF_GCS_ORIG_CHARGE_SEQ_NO:string[5];
URF_GCS_SETL_CHRG_MONTH:string[4];
URF_GCS_SETL_ORIG_BIL_DATE:string[8];
URF_GCS_ORIG_AMT_USA:decimal[9,2] {zoned};
URF_GCS_ORIG_AMT_FGN:decimal[13,2] {zoned};
URF_GCS_ORIG_RATE:decimal[14,8] {zoned};
URF_GCS_SETL_RATE:decimal[14,8] {zoned};
FILLER_40:string[28];
);
URF_STN_USAGE_DTAILS:subrec {redefines='URF_GCS_COMMON_SREF'} (
URF_STN_CALL_NUMBER:string[15];
URF_STN_ACCOUNT_CODE:string[8];
URF_STN_CALL_DATE:subrec (
URF_STN_CALL_CENTURY:string[2];
URF_STN_CALL_YYMMDD:string[6];
);
URF_STN_LOCAL_CONNECT_TIME:subrec (
URF_STN_CONNECT_HOUR:string[2];
URF_STN_CONNECT_MIN:string[2];
URF_STN_CONNECT_SECS:string[2];
);
URF_STN_CALL_TYPE:string[1];
URF_STN_AMT_FGN_PRE_DISC:decimal[13,2] {zoned};
URF_STN_DISC_AMT:decimal[9,2] {zoned};
URF_STN_DURATION_TIME:subrec (
URF_STN_DURATION_HR:decimal[2,0] {zoned};
URF_STN_DURATION_MIN:decimal[2,0] {zoned};
URF_STN_DURATION_SECS:decimal[2,0] {zoned};
URF_STN_DURATION_TENTHS:decimal[1,0] {zoned};
);
URF_STN_FROM_LOCATION:subrec (
URF_STN_FROM_CITY_NAME:string[10];
URF_STN_FROM_STATE_CODE:string[2];
);
URF_STN_TERM_LOCATION:subrec (
URF_STN_TERM_CITY_NAME:string[10];
URF_STN_TERM_STATE_CODE:string[2];
);
URF_STN_NUMBER_DIALED:string[15];
URF_STN_TO_CNTRY:string[6];
URF_STN_PROVINCE:string[2];
URF_STN_NUMBER_CALLED:string[15];
URF_STN_RATE_PERIOD_IND:string[1];
URF_STN_VCN_CALL_TYPE_IND:string[1];
URF_STN_ORGNG_VCN_POINTIND:string[2];
URF_STN_TERMG_VCN_POINTIND:string[2];
URF_STN_EMR_DTO_IND:string[1];
FILLER_41:string[14];
);
URF_STN_MISC_DETAILS:subrec {redefines='URF_GCS_COMMON_SREF'} (
URF_STN_MISC_START_DATE:string[8];
URF_STN_MISC_STOP_DATE:string[8];
URF_STN_MISC_QUANTITY:decimal[7,0] {zoned};
URF_STN_MISC_CHRGE_AMT:decimal[15,2] {zoned};
URF_STN_REG_CHRGE_IND:string[1];
URF_STN_CUST_CAMS_ID:decimal[9,0] {zoned};
URF_STN_SUNIT_ID:decimal[5,0] {zoned};
URF_STN_MSC_SETTL_CODE_IND:string[1];
FILLER_42:string[96];
);
URF_STN_SPEC_DETAILS:subrec {redefines='URF_GCS_COMMON_SREF'} (
URF_STN_SPEC_PSN:string[15];
URF_STN_SPEC_USAGE:string[8];
URF_STN_SPEC_QUANTITY:decimal[13,3] {zoned};
URF_STN_SPEC_UNIT:string[2];
URF_STN_SPEC_RATE:decimal[11,5] {zoned};
URF_STN_SPEC_FNOTE:string[1];
FILLER_43:string[100];
);
URF_STN_SPTX_DETAILS:subrec {redefines='URF_GCS_COMMON_SREF'} (
URF_STN_SPTX_VAT:decimal[6,4] {zoned};
URF_STN_SPTX_TAX_TYPE:string[1];
URF_STN_SPTX_PSN:string[15];
URF_STN_SPTX_USAGE:string[8];
URF_STN_SPTX_QUANTITY:decimal[13,3] {zoned};
URF_STN_SPTX_UNIT:string[2];
URF_STN_SPTX_RATE:decimal[11,5] {zoned};
URF_STN_SPTX_FNOTE:string[1];
URF_STN_SPTX_TAX_CODE:string[8];
FILLER_44:string[85];
);
URF_STN_PRO_DETAILS:subrec {redefines='URF_GCS_COMMON_SREF'} (
URF_STN_PRO_NEW_AMOUNT_USA:decimal[9,2] {zoned};
URF_STN_PRO_NEW_AMOUNT_FGN:decimal[13,2] {zoned};
URF_STN_PRO_OLD_AMOUNT_USA:decimal[9,2] {zoned};
URF_STN_PRO_OLD_AMOUNT_FGN:decimal[13,2] {zoned};
URF_STN_PRO_VAT:decimal[6,4] {zoned};
URF_STN_PRO_PSN:string[15];
URF_STN_PRO_USAGE:string[8];
URF_STN_PRO_QUANTITY:decimal[13,3] {zoned};
URF_STN_PRO_UNIT:string[2];
URF_STN_PRO_RATE:decimal[11,5] {zoned};
URF_STN_PRO_FNOTE:string[1];
FILLER_45:string[50];
);
URF_IFR_DETAILS:subrec {redefines='URF_GCS_COMMON_SREF'} (
URF_MEGA_CHG_CODE:decimal[4,0] {zoned};
URF_IFR_SVC_ID:string[8];
URF_IFR_CHG_BEG_DATE:string[10];
URF_IFR_CHG_END_DATE:string[10];
URF_IFR_PVC_ID:decimal[15,0] {packed};
URF_IFR_ORIG_PVC_COUNTRY:string[3];
URF_IFR_TERM_PVC_COUNTRY:string[3];
URF_IFR_BILLING_PERIOD:string[8];
URF_IFR_ACCESS_CLASS:string[1];
URF_IFR_PARTNER_ID:string[10];
URF_IFR_SERVICE_TYPE:string[4];
URF_IFR_METRO:string[1];
URF_IFR_PIP_COS:string[1];
URF_IFR_PQ_SPEED:decimal[10,1] {packed};
FILLER_46:string[73];
);
URF_FNE_DETAILS:subrec {redefines='URF_GCS_COMMON_SREF'} (
URF_FNE_CHRG_CODE:string[6];
URF_FNE_CHRG_TYPE:string[1];
URF_FNE_CIRCUIT_TYPE:string[8];
URF_FNE_ADJ_IND:string[1];
URF_FNE_ADJ_DESC:string[14];
URF_FNE_PVC_SPEED:string[7];
URF_FNE_PORT_SPEED:string[8];
URF_FNE_BILL_METHOD:string[1];
URF_FNE_CONT_TERM:string[3];
URF_FNE_CONT_END_DATE:string[8];
URF_FNE_PUR_ORDER_NO:string[25];
URF_FNE_IXC_MILEAGE:string[6];
URF_FNE_SALES_PERSON:string[6];
URF_FNE_LOCA_NPA_NXX:string[6];
URF_FNE_LOCZ_NPA_NXX:string[6];
URF_FNE_LOCA_CITY:string[15];
URF_FNE_LOCA_CNTY_CD:string[3];
URF_FNE_LOCZ_CITY:string[15];
URF_FNE_LOCZ_CNTY_CD:string[3];
URF_FNE_PROMO_CD:string[8];
);
URF_GCS_SALES_REP_DIV_ID:string[2];
URF_GCS_SERVICE_SSN:string[9];
URF_GCS_SERVICE_CITY_CODE:string[4];
URF_GCS_SERVICE_REP_DIV_ID:string[2];
URF_GCS_SALES_CITY_CODE:string[4];
FILLER_47:string[1];
URF_GCS_ACQUISITION_CHANNEL:string[1];
URF_GCS_MEB_ORIG_INVNBR:string[10];
URF_GCS_CAT_CODE:subrec (
URF_GCS_CAT_PRIM:string[4];
URF_GCS_CAT_SUB:string[4];
URF_GCS_CAT_CTRY:string[4];
URF_GCS_CAT_CITY:string[4];
URF_GCS_CAT_DEPT:string[4];
);
FILLER_48:string[1];
URF_GCS_REV_LOCATION:string[3];
FILLER_49:string[51];
)

[ray.wurlod]

The first error message relates to the default value for the decimal type - technically 0.00 ("all zeroes") is not permitted. There is an environment variable - whose name I don't recall at the moment - to allow "all zeroes".

The second error is mysterious - the field does exist in the schema, though it is of type subrec (which is OK). That one requires more thought. Maybe there's a glitch in parsing a subrecord that contains a subrecord - which is theoretically allowable.

[etlbets]

I tried something different I uncompressed the file on the mainframe and sent it to data stage as ASCII but I get this error
Complex_Flat_File_375,0: Short read encountered on import; this most likely indicates one of the following possibilities:
1) the import schema you specified is incorrect
2) invalid data (the schema is correct, but there is an error in the data).
Complex_Flat_File_375,0: Expected 185 bytes, got 159.
Complex_Flat_File_375,0: Import error at record 30477.

I think it is reading past the last record there are 30314 records in the file is there a way to stop the read at the end of file?

[ray.wurlod]

Look for line terminators in the data.