Inserting records in table

[pravin1581]

Hi All,

we have designed a simple job that loads data into a table using ODBC stage from a file. The records are imported from the file successfully , but it is unable to load in the database . The table to which it loads has been created in the database. The job is getting aborted with the error Create External Table Permission denied. The table is the Netezza table.

Thanx in advance.

[siddesai]

Hi All,

we have designed a simple job that loads data into a table using ODBC stage from a file. The records are imported from the file successfully , but it is unable to load in the database . The table to which it loads has been created in the database. The job is getting aborted with the error Create External Table Permission denied. The table is the Netezza table.

Thanx in advance.

The error itself seems to be self explanatory.

You need to allow(give access rights) to external sources (in this case odbc) to create tables in your database.

[pravin1581]

Hi All,

we have designed a simple job that loads data into a table using ODBC stage from a file. The records are imported from the file successfully , but it is unable to load in the database . The table to which it loads has been created in the database. The job is getting aborted with the error Create External Table Permission denied. The table is the Netezza table.

Thanx in advance.

The error itself seems to be self explanatory.

You need to allow(give access rights) to external sources (in this case odbc) to create tables in your database.

The table is in the database , how can i give write access to the ODBC stage.

[chulett]

It's got to be about granting those rights to the user you are connecting as rather than to any particular stage. Talk to your Netezza DBA.

[VCInDSX]

The table to which it loads has been created in the database. The job is getting aborted with the error Create External Table Permission denied.

Hi Pravin,
Your initial statement says the table is already in the database. Are you sure you want your insert process to create the table from the ODBC stage? Maybe you should check the properties of the stage to ensure that you haven't enabled that.
To check your permissions, login using your account id and password to the DB via Standard (Netezza) SQL Client UI or command interface and try creating a table. If that is allowed then your DBA has granted permissions for creating tables on the fly. If not, your project policies would dictate if table creation is required or if all tables are pre-created and users can only insert/update/delete records from the tables.
Some of the policies may allow creation of "#Temp" tables only.

HTH,

[pravin1581]

The table to which it loads has been created in the database. The job is getting aborted with the error Create External Table Permission denied.

Hi Pravin,
Your initial statement says the table is already in the database. Are you sure you want your insert process to create the table from the ODBC stage? Maybe you should check the properties of the stage to ensure that you haven't enabled that.
To check your permissions, login using your account id and password to the DB via Standard (Netezza) SQL Client UI or command interface and try creating a table. If that is allowed then your DBA has granted permissions for creating tables on the fly. If not, your project policies would dictate if table creation is required or if all tables are pre-created and users can only insert/update/delete records from the tables.
Some of the policies may allow creation of "#Temp" tables only.

HTH,

That part has been handled , now i am stuck in another problem . There are certain conditions in the job like the server name, pwd, user , database and the datasource that have been parameterized and the table name has been hardcoded. When I am running the job with the dsjob command the job is getting aborted with the error as "Unrecognized argument:<TABLE NAME>, even though the table name is not passed as the parameter.

[ray.wurlod]

What value - precisely - do you have in the Table field of your ODBC stage?

[pravin1581]

What value - precisely - do you have in the Table field of your ODBC stage?

The stage is the Netezza stage .Table name is hardcoded.

[ray.wurlod]

With what value?

[pravin1581]

With what value?

Thanx for all the suggestions, the issue has been resolved.

[ray.wurlod]

To aid future searchers, please post HOW this issue was resolved.

[pravin1581]

To aid future searchers, please post HOW this issue was resolved.

Actually there was an issue with the database name, the job was being run from unix and the database name passed in the script was not same as the name in the uvodbc.config file.