Hi All,
When I try importing a table from DataStage Manager using Import\TableDefinition\ODBCTableDefinition I get the following error message for certain set of tables:
"Run-time error '6':
Overflow"
Though the import works perfectly fine with some tables. I am not able to figure out why for some tables it throws the above mentioned error message.
Does anyone have any idea why could this be?
Thanks in advance,
Sumit
Run-time error '6'
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 197
- Joined: Mon Feb 17, 2003 11:20 pm
- Location: India
These types of errors generally occur when a variable is assigned a value that is too large - i.e., long data to an int or an assignment to a property that exceeds the maximum value the property can accept.
The above is from the MSDN.
This used to happen in earlier versions of DataStage, but I had not heard of it in a while. If you think about what is happening then maybe you can identify something within this particular set of tables that might be causing the problem like number of columns, name of the column etc... - maybe the name of a column is too large - who knows. Could be anything.
If not and this issue continues then it seems to me that simply contacting support and sending them the ddl for these tables and allowing them to experience this problem would be in your best interest and likely would result in an answer or solution.
Regards,
The above is from the MSDN.
This used to happen in earlier versions of DataStage, but I had not heard of it in a while. If you think about what is happening then maybe you can identify something within this particular set of tables that might be causing the problem like number of columns, name of the column etc... - maybe the name of a column is too large - who knows. Could be anything.
If not and this issue continues then it seems to me that simply contacting support and sending them the ddl for these tables and allowing them to experience this problem would be in your best interest and likely would result in an answer or solution.
Regards,
Mike Hester
mhester@petra-ps.com
mhester@petra-ps.com
-
- Participant
- Posts: 197
- Joined: Mon Feb 17, 2003 11:20 pm
- Location: India
Thanks for the suggestion guys but the error seems to be something else.
No the error is not system specific. I tried it from two different systems. Its gives the same error in both.
I went through the ddl of the tables also and it looks ok. No column name is too large. Though the number of columns is high (close to 150) but I have imported tables which have 250 columns also.
Here is the ddl for the table I am trying to import:
Name Null? Type
----------------------------------------- -------- ----------------------------
BUSINESS_UNIT NOT NULL VARCHAR2(5)
VCHR_BLD_KEY_C1 NOT NULL VARCHAR2(25)
VCHR_BLD_KEY_C2 NOT NULL VARCHAR2(25)
VCHR_BLD_KEY_N1 NOT NULL NUMBER(10)
VCHR_BLD_KEY_N2 NOT NULL NUMBER(10)
VOUCHER_ID NOT NULL VARCHAR2(8)
VOUCHER_STYLE NOT NULL VARCHAR2(4)
INVOICE_ID NOT NULL VARCHAR2(30)
INVOICE_DT NOT NULL DATE
VENDOR_SETID NOT NULL VARCHAR2(5)
VENDOR_ID NOT NULL VARCHAR2(10)
VNDR_LOC NOT NULL VARCHAR2(10)
ADDRESS_SEQ_NUM NOT NULL NUMBER(38)
GRP_AP_ID NOT NULL VARCHAR2(10)
ORIGIN NOT NULL VARCHAR2(3)
OPRID NOT NULL VARCHAR2(30)
ACCOUNTING_DT DATE
POST_VOUCHER NOT NULL VARCHAR2(1)
DST_CNTRL_ID NOT NULL VARCHAR2(10)
VOUCHER_ID_RELATED NOT NULL VARCHAR2(8)
GROSS_AMT NOT NULL NUMBER(26,3)
DSCNT_AMT NOT NULL NUMBER(26,3)
TAX_EXEMPT NOT NULL VARCHAR2(1)
SALETX_AMT NOT NULL NUMBER(26,3)
FREIGHT_AMT NOT NULL NUMBER(26,3)
MISC_AMT NOT NULL NUMBER(26,3)
PYMNT_TERMS_CD NOT NULL VARCHAR2(5)
ENTERED_DT DATE
TXN_CURRENCY_CD NOT NULL VARCHAR2(3)
RT_TYPE NOT NULL VARCHAR2(5)
RATE_MULT NOT NULL NUMBER(15,8)
RATE_DIV NOT NULL NUMBER(15,8)
VAT_ENTRD_AMT NOT NULL NUMBER(26,3)
MATCH_ACTION NOT NULL VARCHAR2(1)
CUR_RT_SOURCE NOT NULL VARCHAR2(1)
DSCNT_AMT_FLG NOT NULL VARCHAR2(1)
DUE_DT_FLG NOT NULL VARCHAR2(1)
VCHR_APPRVL_FLG NOT NULL VARCHAR2(1)
BUSPROCNAME NOT NULL VARCHAR2(30)
APPR_RULE_SET NOT NULL VARCHAR2(30)
VAT_DCLRTN_POINT NOT NULL VARCHAR2(1)
VAT_CALC_TYPE NOT NULL VARCHAR2(1)
VAT_CALC_GROSS_NET NOT NULL VARCHAR2(1)
VAT_RECALC_FLG NOT NULL VARCHAR2(1)
VAT_CALC_FRGHT_FLG NOT NULL VARCHAR2(1)
VAT_TREATMENT_GRP NOT NULL VARCHAR2(4)
COUNTRY_SHIP_FROM NOT NULL VARCHAR2(3)
STATE_SHIP_FROM NOT NULL VARCHAR2(6)
COUNTRY_SHIP_TO NOT NULL VARCHAR2(3)
STATE_SHIP_TO NOT NULL VARCHAR2(6)
COUNTRY_VAT_BILLFR NOT NULL VARCHAR2(3)
COUNTRY_VAT_BILLTO NOT NULL VARCHAR2(3)
VAT_EXCPTN_CERTIF NOT NULL VARCHAR2(20)
VAT_ROUND_RULE NOT NULL VARCHAR2(1)
COUNTRY_LOC_SELLER NOT NULL VARCHAR2(3)
STATE_LOC_SELLER NOT NULL VARCHAR2(6)
COUNTRY_LOC_BUYER NOT NULL VARCHAR2(3)
STATE_LOC_BUYER NOT NULL VARCHAR2(6)
COUNTRY_VAT_SUPPLY NOT NULL VARCHAR2(3)
STATE_VAT_SUPPLY NOT NULL VARCHAR2(6)
COUNTRY_VAT_PERFRM NOT NULL VARCHAR2(3)
STATE_VAT_PERFRM NOT NULL VARCHAR2(6)
STATE_VAT_DEFAULT NOT NULL VARCHAR2(6)
PREPAID_REF NOT NULL VARCHAR2(10)
PREPAID_AUTO_APPLY NOT NULL VARCHAR2(1)
DESCR254_MIXED NOT NULL VARCHAR2(254)
EIN_FEDERAL NOT NULL VARCHAR2(9)
EIN_STATE_LOCAL NOT NULL VARCHAR2(20)
PROCESS_INSTANCE NOT NULL NUMBER(10)
IN_PROCESS_FLG NOT NULL VARCHAR2(1)
BUSINESS_UNIT_PO NOT NULL VARCHAR2(5)
PO_ID NOT NULL VARCHAR2(10)
PACKSLIP_NO NOT NULL VARCHAR2(22)
PAY_TRM_BSE_DT_OPT NOT NULL VARCHAR2(1)
VAT_CALC_MISC_FLG NOT NULL VARCHAR2(1)
IMAGE_REF_ID NOT NULL VARCHAR2(12)
IMAGE_DATE DATE
PAY_SCHEDULE_TYPE NOT NULL VARCHAR2(3)
TAX_GRP NOT NULL VARCHAR2(4)
TAX_PYMNT_TYPE NOT NULL VARCHAR2(5)
INSPECT_DT DATE
INV_RECPT_DT DATE
RECEIPT_DT DATE
BILL_OF_LADING NOT NULL VARCHAR2(30)
CARRIER_ID NOT NULL VARCHAR2(10)
DOC_TYPE NOT NULL VARCHAR2(8)
DSCNT_DUE_DT DATE
DSCNT_PRORATE_FLG NOT NULL VARCHAR2(1)
DUE_DT DATE
ECQUEUEINSTANCE NOT NULL NUMBER(38)
ECTRANSID NOT NULL VARCHAR2(15)
FRGHT_CHARGE_CODE NOT NULL VARCHAR2(10)
LC_ID NOT NULL VARCHAR2(12)
MISC_CHARGE_CODE NOT NULL VARCHAR2(10)
REMIT_ADDR_SEQ_NUM NOT NULL NUMBER(38)
SALETX_CHARGE_CODE NOT NULL VARCHAR2(10)
VCHR_BLD_CODE NOT NULL VARCHAR2(6)
BUSINESS_UNIT_AR NOT NULL VARCHAR2(5)
CUST_ID NOT NULL VARCHAR2(15)
ITEM NOT NULL VARCHAR2(30)
ITEM_LINE NOT NULL NUMBER(38)
VCHR_SRC NOT NULL VARCHAR2(4)
VAT_EXCPTN_TYPE NOT NULL VARCHAR2(1)
USER_VCHR_CHAR1 NOT NULL VARCHAR2(1)
USER_VCHR_CHAR2 NOT NULL VARCHAR2(1)
USER_VCHR_DEC NOT NULL NUMBER(26,3)
USER_VCHR_DATE DATE
USER_VCHR_NUM1 NOT NULL NUMBER(38)
USER_HDR_CHAR1 NOT NULL VARCHAR2(1)
Thanks and Regards,
Sumit
No the error is not system specific. I tried it from two different systems. Its gives the same error in both.
I went through the ddl of the tables also and it looks ok. No column name is too large. Though the number of columns is high (close to 150) but I have imported tables which have 250 columns also.
Here is the ddl for the table I am trying to import:
Name Null? Type
----------------------------------------- -------- ----------------------------
BUSINESS_UNIT NOT NULL VARCHAR2(5)
VCHR_BLD_KEY_C1 NOT NULL VARCHAR2(25)
VCHR_BLD_KEY_C2 NOT NULL VARCHAR2(25)
VCHR_BLD_KEY_N1 NOT NULL NUMBER(10)
VCHR_BLD_KEY_N2 NOT NULL NUMBER(10)
VOUCHER_ID NOT NULL VARCHAR2(8)
VOUCHER_STYLE NOT NULL VARCHAR2(4)
INVOICE_ID NOT NULL VARCHAR2(30)
INVOICE_DT NOT NULL DATE
VENDOR_SETID NOT NULL VARCHAR2(5)
VENDOR_ID NOT NULL VARCHAR2(10)
VNDR_LOC NOT NULL VARCHAR2(10)
ADDRESS_SEQ_NUM NOT NULL NUMBER(38)
GRP_AP_ID NOT NULL VARCHAR2(10)
ORIGIN NOT NULL VARCHAR2(3)
OPRID NOT NULL VARCHAR2(30)
ACCOUNTING_DT DATE
POST_VOUCHER NOT NULL VARCHAR2(1)
DST_CNTRL_ID NOT NULL VARCHAR2(10)
VOUCHER_ID_RELATED NOT NULL VARCHAR2(8)
GROSS_AMT NOT NULL NUMBER(26,3)
DSCNT_AMT NOT NULL NUMBER(26,3)
TAX_EXEMPT NOT NULL VARCHAR2(1)
SALETX_AMT NOT NULL NUMBER(26,3)
FREIGHT_AMT NOT NULL NUMBER(26,3)
MISC_AMT NOT NULL NUMBER(26,3)
PYMNT_TERMS_CD NOT NULL VARCHAR2(5)
ENTERED_DT DATE
TXN_CURRENCY_CD NOT NULL VARCHAR2(3)
RT_TYPE NOT NULL VARCHAR2(5)
RATE_MULT NOT NULL NUMBER(15,8)
RATE_DIV NOT NULL NUMBER(15,8)
VAT_ENTRD_AMT NOT NULL NUMBER(26,3)
MATCH_ACTION NOT NULL VARCHAR2(1)
CUR_RT_SOURCE NOT NULL VARCHAR2(1)
DSCNT_AMT_FLG NOT NULL VARCHAR2(1)
DUE_DT_FLG NOT NULL VARCHAR2(1)
VCHR_APPRVL_FLG NOT NULL VARCHAR2(1)
BUSPROCNAME NOT NULL VARCHAR2(30)
APPR_RULE_SET NOT NULL VARCHAR2(30)
VAT_DCLRTN_POINT NOT NULL VARCHAR2(1)
VAT_CALC_TYPE NOT NULL VARCHAR2(1)
VAT_CALC_GROSS_NET NOT NULL VARCHAR2(1)
VAT_RECALC_FLG NOT NULL VARCHAR2(1)
VAT_CALC_FRGHT_FLG NOT NULL VARCHAR2(1)
VAT_TREATMENT_GRP NOT NULL VARCHAR2(4)
COUNTRY_SHIP_FROM NOT NULL VARCHAR2(3)
STATE_SHIP_FROM NOT NULL VARCHAR2(6)
COUNTRY_SHIP_TO NOT NULL VARCHAR2(3)
STATE_SHIP_TO NOT NULL VARCHAR2(6)
COUNTRY_VAT_BILLFR NOT NULL VARCHAR2(3)
COUNTRY_VAT_BILLTO NOT NULL VARCHAR2(3)
VAT_EXCPTN_CERTIF NOT NULL VARCHAR2(20)
VAT_ROUND_RULE NOT NULL VARCHAR2(1)
COUNTRY_LOC_SELLER NOT NULL VARCHAR2(3)
STATE_LOC_SELLER NOT NULL VARCHAR2(6)
COUNTRY_LOC_BUYER NOT NULL VARCHAR2(3)
STATE_LOC_BUYER NOT NULL VARCHAR2(6)
COUNTRY_VAT_SUPPLY NOT NULL VARCHAR2(3)
STATE_VAT_SUPPLY NOT NULL VARCHAR2(6)
COUNTRY_VAT_PERFRM NOT NULL VARCHAR2(3)
STATE_VAT_PERFRM NOT NULL VARCHAR2(6)
STATE_VAT_DEFAULT NOT NULL VARCHAR2(6)
PREPAID_REF NOT NULL VARCHAR2(10)
PREPAID_AUTO_APPLY NOT NULL VARCHAR2(1)
DESCR254_MIXED NOT NULL VARCHAR2(254)
EIN_FEDERAL NOT NULL VARCHAR2(9)
EIN_STATE_LOCAL NOT NULL VARCHAR2(20)
PROCESS_INSTANCE NOT NULL NUMBER(10)
IN_PROCESS_FLG NOT NULL VARCHAR2(1)
BUSINESS_UNIT_PO NOT NULL VARCHAR2(5)
PO_ID NOT NULL VARCHAR2(10)
PACKSLIP_NO NOT NULL VARCHAR2(22)
PAY_TRM_BSE_DT_OPT NOT NULL VARCHAR2(1)
VAT_CALC_MISC_FLG NOT NULL VARCHAR2(1)
IMAGE_REF_ID NOT NULL VARCHAR2(12)
IMAGE_DATE DATE
PAY_SCHEDULE_TYPE NOT NULL VARCHAR2(3)
TAX_GRP NOT NULL VARCHAR2(4)
TAX_PYMNT_TYPE NOT NULL VARCHAR2(5)
INSPECT_DT DATE
INV_RECPT_DT DATE
RECEIPT_DT DATE
BILL_OF_LADING NOT NULL VARCHAR2(30)
CARRIER_ID NOT NULL VARCHAR2(10)
DOC_TYPE NOT NULL VARCHAR2(8)
DSCNT_DUE_DT DATE
DSCNT_PRORATE_FLG NOT NULL VARCHAR2(1)
DUE_DT DATE
ECQUEUEINSTANCE NOT NULL NUMBER(38)
ECTRANSID NOT NULL VARCHAR2(15)
FRGHT_CHARGE_CODE NOT NULL VARCHAR2(10)
LC_ID NOT NULL VARCHAR2(12)
MISC_CHARGE_CODE NOT NULL VARCHAR2(10)
REMIT_ADDR_SEQ_NUM NOT NULL NUMBER(38)
SALETX_CHARGE_CODE NOT NULL VARCHAR2(10)
VCHR_BLD_CODE NOT NULL VARCHAR2(6)
BUSINESS_UNIT_AR NOT NULL VARCHAR2(5)
CUST_ID NOT NULL VARCHAR2(15)
ITEM NOT NULL VARCHAR2(30)
ITEM_LINE NOT NULL NUMBER(38)
VCHR_SRC NOT NULL VARCHAR2(4)
VAT_EXCPTN_TYPE NOT NULL VARCHAR2(1)
USER_VCHR_CHAR1 NOT NULL VARCHAR2(1)
USER_VCHR_CHAR2 NOT NULL VARCHAR2(1)
USER_VCHR_DEC NOT NULL NUMBER(26,3)
USER_VCHR_DATE DATE
USER_VCHR_NUM1 NOT NULL NUMBER(38)
USER_HDR_CHAR1 NOT NULL VARCHAR2(1)
Thanks and Regards,
Sumit
-
- Participant
- Posts: 197
- Joined: Mon Feb 17, 2003 11:20 pm
- Location: India
Sorry the ddl didn't come properly. Here is the post again:
Thanks for the suggestion guys but the error seems to be something else.
No the error is not system specific. I tried it from two different systems. Its gives the same error in both.
I went through the ddl of the tables also and it looks ok. No column name is too large. Though the number of columns is high (close to 150) but I have imported tables which have 250 columns also.
Here is the ddl for the table I am trying to import:
Thanks and Regards,
Sumit
Thanks for the suggestion guys but the error seems to be something else.
No the error is not system specific. I tried it from two different systems. Its gives the same error in both.
I went through the ddl of the tables also and it looks ok. No column name is too large. Though the number of columns is high (close to 150) but I have imported tables which have 250 columns also.
Here is the ddl for the table I am trying to import:
Code: Select all
Name Null? Type
----------------------------------------- -------- ----------------------------
BUSINESS_UNIT NOT NULL VARCHAR2(5)
VCHR_BLD_KEY_C1 NOT NULL VARCHAR2(25)
VCHR_BLD_KEY_C2 NOT NULL VARCHAR2(25)
VCHR_BLD_KEY_N1 NOT NULL NUMBER(10)
VCHR_BLD_KEY_N2 NOT NULL NUMBER(10)
VOUCHER_ID NOT NULL VARCHAR2(8)
VOUCHER_STYLE NOT NULL VARCHAR2(4)
INVOICE_ID NOT NULL VARCHAR2(30)
INVOICE_DT NOT NULL DATE
VENDOR_SETID NOT NULL VARCHAR2(5)
VENDOR_ID NOT NULL VARCHAR2(10)
VNDR_LOC NOT NULL VARCHAR2(10)
ADDRESS_SEQ_NUM NOT NULL NUMBER(38)
GRP_AP_ID NOT NULL VARCHAR2(10)
ORIGIN NOT NULL VARCHAR2(3)
OPRID NOT NULL VARCHAR2(30)
ACCOUNTING_DT DATE
POST_VOUCHER NOT NULL VARCHAR2(1)
DST_CNTRL_ID NOT NULL VARCHAR2(10)
VOUCHER_ID_RELATED NOT NULL VARCHAR2(8)
GROSS_AMT NOT NULL NUMBER(26,3)
DSCNT_AMT NOT NULL NUMBER(26,3)
TAX_EXEMPT NOT NULL VARCHAR2(1)
SALETX_AMT NOT NULL NUMBER(26,3)
FREIGHT_AMT NOT NULL NUMBER(26,3)
MISC_AMT NOT NULL NUMBER(26,3)
PYMNT_TERMS_CD NOT NULL VARCHAR2(5)
ENTERED_DT DATE
TXN_CURRENCY_CD NOT NULL VARCHAR2(3)
RT_TYPE NOT NULL VARCHAR2(5)
RATE_MULT NOT NULL NUMBER(15,8)
RATE_DIV NOT NULL NUMBER(15,8)
VAT_ENTRD_AMT NOT NULL NUMBER(26,3)
MATCH_ACTION NOT NULL VARCHAR2(1)
CUR_RT_SOURCE NOT NULL VARCHAR2(1)
DSCNT_AMT_FLG NOT NULL VARCHAR2(1)
DUE_DT_FLG NOT NULL VARCHAR2(1)
VCHR_APPRVL_FLG NOT NULL VARCHAR2(1)
BUSPROCNAME NOT NULL VARCHAR2(30)
APPR_RULE_SET NOT NULL VARCHAR2(30)
VAT_DCLRTN_POINT NOT NULL VARCHAR2(1)
VAT_CALC_TYPE NOT NULL VARCHAR2(1)
VAT_CALC_GROSS_NET NOT NULL VARCHAR2(1)
VAT_RECALC_FLG NOT NULL VARCHAR2(1)
VAT_CALC_FRGHT_FLG NOT NULL VARCHAR2(1)
VAT_TREATMENT_GRP NOT NULL VARCHAR2(4)
COUNTRY_SHIP_FROM NOT NULL VARCHAR2(3)
STATE_SHIP_FROM NOT NULL VARCHAR2(6)
COUNTRY_SHIP_TO NOT NULL VARCHAR2(3)
STATE_SHIP_TO NOT NULL VARCHAR2(6)
COUNTRY_VAT_BILLFR NOT NULL VARCHAR2(3)
COUNTRY_VAT_BILLTO NOT NULL VARCHAR2(3)
VAT_EXCPTN_CERTIF NOT NULL VARCHAR2(20)
VAT_ROUND_RULE NOT NULL VARCHAR2(1)
COUNTRY_LOC_SELLER NOT NULL VARCHAR2(3)
STATE_LOC_SELLER NOT NULL VARCHAR2(6)
COUNTRY_LOC_BUYER NOT NULL VARCHAR2(3)
STATE_LOC_BUYER NOT NULL VARCHAR2(6)
COUNTRY_VAT_SUPPLY NOT NULL VARCHAR2(3)
STATE_VAT_SUPPLY NOT NULL VARCHAR2(6)
COUNTRY_VAT_PERFRM NOT NULL VARCHAR2(3)
STATE_VAT_PERFRM NOT NULL VARCHAR2(6)
STATE_VAT_DEFAULT NOT NULL VARCHAR2(6)
PREPAID_REF NOT NULL VARCHAR2(10)
PREPAID_AUTO_APPLY NOT NULL VARCHAR2(1)
DESCR254_MIXED NOT NULL VARCHAR2(254)
EIN_FEDERAL NOT NULL VARCHAR2(9)
EIN_STATE_LOCAL NOT NULL VARCHAR2(20)
PROCESS_INSTANCE NOT NULL NUMBER(10)
IN_PROCESS_FLG NOT NULL VARCHAR2(1)
BUSINESS_UNIT_PO NOT NULL VARCHAR2(5)
PO_ID NOT NULL VARCHAR2(10)
PACKSLIP_NO NOT NULL VARCHAR2(22)
PAY_TRM_BSE_DT_OPT NOT NULL VARCHAR2(1)
VAT_CALC_MISC_FLG NOT NULL VARCHAR2(1)
IMAGE_REF_ID NOT NULL VARCHAR2(12)
IMAGE_DATE DATE
PAY_SCHEDULE_TYPE NOT NULL VARCHAR2(3)
TAX_GRP NOT NULL VARCHAR2(4)
TAX_PYMNT_TYPE NOT NULL VARCHAR2(5)
INSPECT_DT DATE
INV_RECPT_DT DATE
RECEIPT_DT DATE
BILL_OF_LADING NOT NULL VARCHAR2(30)
CARRIER_ID NOT NULL VARCHAR2(10)
DOC_TYPE NOT NULL VARCHAR2(8)
DSCNT_DUE_DT DATE
DSCNT_PRORATE_FLG NOT NULL VARCHAR2(1)
DUE_DT DATE
ECQUEUEINSTANCE NOT NULL NUMBER(38)
ECTRANSID NOT NULL VARCHAR2(15)
FRGHT_CHARGE_CODE NOT NULL VARCHAR2(10)
LC_ID NOT NULL VARCHAR2(12)
MISC_CHARGE_CODE NOT NULL VARCHAR2(10)
REMIT_ADDR_SEQ_NUM NOT NULL NUMBER(38)
SALETX_CHARGE_CODE NOT NULL VARCHAR2(10)
VCHR_BLD_CODE NOT NULL VARCHAR2(6)
BUSINESS_UNIT_AR NOT NULL VARCHAR2(5)
CUST_ID NOT NULL VARCHAR2(15)
ITEM NOT NULL VARCHAR2(30)
ITEM_LINE NOT NULL NUMBER(38)
VCHR_SRC NOT NULL VARCHAR2(4)
VAT_EXCPTN_TYPE NOT NULL VARCHAR2(1)
USER_VCHR_CHAR1 NOT NULL VARCHAR2(1)
USER_VCHR_CHAR2 NOT NULL VARCHAR2(1)
USER_VCHR_DEC NOT NULL NUMBER(26,3)
USER_VCHR_DATE DATE
USER_VCHR_NUM1 NOT NULL NUMBER(38)
USER_HDR_CHAR1 NOT NULL VARCHAR2(1)
Sumit