Attempting to extract data from an Oracle database table using ODBC.
The Oracle table has one column that is 31 characters long: TEST_RPT_HARDCPY_CHECK_CHEM_IND I can successfully attach the table but when I try to query it I get this error from Oracle: TEST_RPT_HARDCPY_CHECK_CHEM_I was not found in the tables in the current scope Note that the column name is truncated by 2 characters. The catch is that using Turbo V8 version build 8.0.18.30919 I can extract the data with no problem. Version 8.0.21.30515 will not let me. I have tried using the full names when SCONNECTing and SATTACHing and I have tried using the ALIAS option like this: SCONNECT CPDB1CPY IDENTIFIED BY BLAHBLAH blahblah SATTACH TEST_RPT_QUALITATIVE_REQ + AS TEST_REQ + USING DUNS_NUMBER + ALIAS DUNS_NUMBER, + PRODUCT_NUMBER, + TEST_CODE, + TEST_END_CODE, + TEST_REQ_TYPE, + TEST_REQ_POS, + TEST_HARDCOPY_IND, + TEST_EDI_IND, + TEST_HARDCOPY_CHK, + TEST_EDI_CHK Neither way works. Is there a setting that determines whether to use long names or not? As it currently stands I cannot extract the necessary data from the Oracle table like I used to. A solution would be greatly appreciated. Thanks - Mike Ramsour Confidentiality Notice This message is intended exclusively for the individual or entity to which it is addressed and may contain privileged, proprietary, or otherwise private information. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message.
