Archives of the TeradataForum

Message Posted: Thu, 20 Nov 2008 @ 13:42:31 GMT


	<Prev	Next>		<<First	<Prev	Next>	Last>>

Subj:		Re: Change Request Processing Option

From:		Nadine Cox

Mike Dempsey wrote:

These fields are in the DBCArea structure passed by the application. Only the application developer can assign these values.

My guess would be that they either forgot to initialize the DBCArea structure or they have an ASCII/Unicode problem.

Thanks Mike. Whatever the problem is, it's specific to a single PC \ client install of CLI or the user. I found the code and what we set from BI Query. This is the only report of this error occurring on creating temp tables from BI with CLI. I am unable to reproduce it using the same environment.

     /* set options */
     dbcp->change_opts = 'Y';
     dbcp->resp_mode = 'I';           /* indicator-mode responses */
     dbcp->use_presence_bits = 'N';
     dbcp->keep_resp = 'N';           /* discard response when have sent it all */
     dbcp->wait_across_crash = 'N';
     dbcp->tell_about_crash = 'Y';    /* get EM_DBC_CRASH err when DBC crashes */
     //  dbcp->give_msg = 'Y';             /* unused */
     dbcp->loc_mode = 'Y';            /* locate mode - data returned in response buffer */
     dbcp->var_len_req = 'N';
     dbcp->var_len_fetch = 'N';
     dbcp->save_resp_buf = 'N';       /* not used */
     dbcp->two_resp_bufs = 'N'; //((doubleBufferFlag) ? 'Y' : 'N');
     dbcp->ret_time = 'N';            /* do not generate timestamps */
     dbcp->parcel_mode = 'Y';
     dbcp->wait_for_resp = 'N';       /* 'N' for non-blocking (was 'Y' [RN]) */
     dbcp->req_proc_opt = 'E';        /* execute request (not analyse it) */
     dbcp->req_buf_len = 1024;        /* wild guess - was 256 */
     dbcp->resp_buf_len = 4096;       /* wild guess - was 1024 */


	<Prev	Next>		<<First	<Prev	Next>	Last>>

Attachments

Library

Quick Reference