Re: newbie ProC insertion question

On Sun, 5 Feb 1995, DSTI Crystal City Office wrote:

> In article <3gu8lm$dvb_at_homer.alpha.net> you write:
> >DSTI Crystal City Office (dsticc_at_access.digex.net) wrote:
> >> SOW_TEXT.len = strlen(EF4_DOC->SOW_TEXT);
> >> strncpy(SOW_TEXT.arr, EF4_DOC->SOW_TEXT,SOW_TEXT.len);
> >> EXEC SQL INSERT INTO STATEMENT_OF_WORK(SOW_TEXT)
> >> VALUES(:SOW_TEXT);
> >> SOW_TEXT in the STATEMENT_OF_WORK table is the "long".
> >> This runs without sqlerrors, but inserts only 80 characters of the host
> >> variable. Any insight on this problem will be greatly appreciated.
> >

I think it is inserting the right data but not showing it in sqlplus.
on sql> prompt type
column STATEMENT_OF_WORK format An
n = max chars for the column eg 1000
try with
column STATEMENT_OF_WORK format A1000

or set as a default option
SET LONG {n}

• Saad Ahmad *
• E-Mail: sahmad_at_mfa.com *

  ---