|
|
|
Forum Newbie
Group: Forum Members
Last Login: 12/17/2008 9:22:59 AM
Posts: 1,
Visits: 10
|
|
Hi folks,
I'm hoping this is where I should put this topic, since I found a similar one in the same forum. I was hoping I could get some help on an error a user has been getting when trying to run a simple query in Access. Now please, keep in mind, I am not an Access expert in the slightest... I've made simple databases before, but nothing fancy, and definitely nothing utilizing Teradata. Upon running his code:
SELECT ACCESS_VIEWS_R2_V82109_ACCESS_NAME_ADDR.BAN, ACCESS_VIEWS_R2_V82109_ACCESS_NAME_ADDR.CABS_BILL_DATE, ACCESS_VIEWS_R2_V82109_ACCESS_NAME_ADDR.JULIAN_DATE, ACCESS_VIEWS_R2_V82109_ACCESS_NAME_ADDR.CARRIER_ROUTE, ACCESS_VIEWS_R2_V82109_ACCESS_NAME_ADDR.BILLED_ZIP_CODE, ACCESS_VIEWS_R2_V82109_ACCESS_NAME_ADDR.BILLED_ZIP_SUFFIX, ACCESS_VIEWS_R2_V82109_ACCESS_NAME_ADDR.BILLED_NAME_TAG, ACCESS_VIEWS_R2_V82109_ACCESS_NAME_ADDR.BILLED_NAME_TYPE, ACCESS_VIEWS_R2_V82109_ACCESS_NAME_ADDR.BILLED_CITY_STATE_ZIP, ACCESS_VIEWS_R2_V82109_ACCESS_NAME_ADDR.CPNI_IND, ACCESS_VIEWS_R2_V82109_ACCESS_NAME_ADDR.BILL_NAME_ADDRESS_1, ACCESS_VIEWS_R2_V82109_ACCESS_NAME_ADDR.BILL_NAME_ADDRESS_2, ACCESS_VIEWS_R2_V82109_ACCESS_NAME_ADDR.BILL_NAME_ADDRESS_3, ACCESS_VIEWS_R2_V82109_ACCESS_NAME_ADDR.BILL_NAME_ADDRESS_4, ACCESS_VIEWS_R2_V82109_ACCESS_NAME_ADDR.BILL_NAME_ADDRESS_5, ACCESS_VIEWS_R2_V82109_ACCESS_NAME_ADDR.BILLED_NAME, ACCESS_VIEWS_R2_V82109_ACCESS_NAME_ADDR.BILLED_ADDRESS, ACCESS_VIEWS_R2_V82109_ACCESS_NAME_ADDR.CUSTOMER_NAME, ACCESS_VIEWS_R2_V82109_ACCESS_NAME_ADDR.ACNA, ACCESS_VIEWS_R2_V82109_ACCESS_NAME_ADDR.ALT_EXCHANGE_COMPANY_NAME, ACCESS_VIEWS_R2_V82109_ACCESS_NAME_ADDR.CUSTOMER_IND, ACCESS_VIEWS_R2_V82109_ACCESS_NAME_ADDR.FINANCIAL_DATA_MONTH INTO SWBTTESTa
FROM ACCESS_VIEWS_R2_V82109_ACCESS_NAME_ADDR
WHERE (((ACCESS_VIEWS_R2_V82109_ACCESS_NAME_ADDR.BAN)="6100724017966"));
The user receives an error of:
ODBC call failed. [ncr][odbc teradata rdbms] Option Parcel information is invalid. 3749
According to a PDF I found, error 3749 is due to Segmented Requests (no clue what that is really) not being support in S, B and P modes (again, no clue what that's referring to). It then goes on to say, "If these requests are submitted in either the S, B or P modes, the Teradata Database would return a failure parcel with the error code set to 3749."
Is this the same thing? If so, where on Earth do I go to check these settings/change them? This query was apparently working just fine up until last week and then all of a sudden the user has been getting this.
If anyone has any insight, it would be much appreciated!
EDIT: To clarify, running a simple query against the DB in QueryBuilder works just fine, as well as executing this full script in Access when he's just viewing the data. However, when he switches it to Make Table, it prompts him telling him that it will display the 7 rows of data, and then blows this error. So... we know the information is there and viewable/accessible, but for whatever reason it doesn't want to be turned into a table. :(
|
|
|
|