Create table Before load ?

[AhmedSamir]

hi there

I need to create table and let the job load data on it, it's working with me under this conditions :

1- Teradata connector
- Access method : immediate
- Before SQL : create statement
- APPEND

but in my case when u change to BULK load the error raise on the WORKTABLE for the BULK

ERR:

Teradata_Connector_6: RDBMS code 3807: Object 'TEST_SQL8' does not exist. SQL statement: CREATE TABLE DEVDB.TEST_SQL8_wk AS TEST_SQL8 WITH NO DATA (CC_TeraConnection::execute, file CC_TeraConnection.cpp, line 3,086)

How to create table this insert values on it under BULK access .

thank you

[major]

Hi,

This error is related to Teradata.

BULK load uses worktable to load first before loading to actual table.
So , in your case the actual table must exist in db before job establishes connection to Teradata db for loading.

Thanks
major

[vinothkumar]

Are you using UPDATE or LOAD in your load method. In otherwords, are you trying to implement M-load or Fast-load.

If you select UPDATE (M-load) then whatever given in Pre-SQL wont get execute.

There are some limitations in both utilities. Depends on the requirement you need to decide which one to use.