Recieving the error following error message.

yogi1982 · Post by **yogi1982** » Tue Dec 26, 2006 7:45 am

I am recieving the following error in DataStage, can you please help me out:

"ETSMasterPRCNLoad..JobControl (insert jobstatistics [DataStage][SQL Client][ODBC][DataDirect][ODBC DB2 Wire Protocol driver]The DataDirect ODBC driver you are attempting to access has been provided to you by Ascential Software for exclusive use with Ascential Data Integration Suite. You are not licensed to use this driver with any application other than Ascential Data Integration Suite. If you would like to purchase a driver for some other use, please call 800-876-3101 or visit DataDirect at www.datadirect.com /S1000/6091"

Let me give breif about the job, This is the master job which calls the update job. The master job does not have any stages, just in the job control tab in the job parameter i have wriiten some sql statements,
I am getting this error message when the job tries to insert the details about the job in ADS.V_JOB_STATISTICS table:

chulett · Post by **chulett** » Tue Dec 26, 2006 7:49 am

It pretty much said all there is to say. The 'branded' ODBC drivers that ship with the product are licensed for use by the stages the product provides. Any other use, including direct access in 'job control' like you are doing, violates the license agreement and throws this message.

Build a job using the ODBC stage. Call it in your master job rather than running the sql directly there.

ray.wurlod · Post by **ray.wurlod** » Tue Dec 26, 2006 3:25 pm

And the reason it's worked so far is that you get a 30 day "grace period". Like a "try before you buy".

Now you need to send some $$$ (actually quite a lot) to Data Direct to buy a licence for the ODBC driver, or find some other way to achieve your result (such as using a DataStage stage rather than your own code).

Write the row(s) into a text file and invoke a standard job to move from there into the ODBC table.