Pro*COBOL and CLOB Columns

From: Chris (ctaliercio_at_yahoo.com)
Date: 12/17/04 

Date: 17 Dec 2004 06:46:05 -0800

All:

I have another interesting scenario.

I have a data item in a COBOL program that is declared as follows:

EXEC SQL BEGIN DECLARE SECTION END-EXEC.

01 LogBuffer PIC X(262146) VARYING.

EXEC SQL END DECLARE SECTION.

The Pro*COBOL pre-compiler expands this to:

01 LogBuffer.
02 LogBuffer-LEN PIC S9(4) COMP.
02 LogBuffer-ARR PIC X(262146).

As you can see - the exploded definition produced by Pro*COBOL is not
correct. I cannot seem to find a decent way around this - does anyone
have a good suggestion.

Standard Info:

COBOL: MF Server Express 4.0 SP1
Oracle: 9i
Pro*COBOL: 1.8 (don't ask why ...)
OS: HP-UX 11i

Thanks in advance,
Chris

Relevant Pages

  • Re: Dynamic SQL
    ... EXEC SQL BEGIN DECLARE SECTION END-EXEC. ... EXEC SQL VAR WS-SQL-STR IS CHARF END-EXEC. ...
    (comp.lang.cobol)
  • Re: Dynamic SQL
    ... Host variables need to be inside a DECLARE section. ... > END-EXEC. ... > EXEC SQL BEGIN DECLARE SECTION END-EXEC and ...
    (comp.lang.cobol)
  • Re: Dynamic SQL
    ... Don't you need to have WS-SQL-STR within in an EXEC SQL DECLARE? ... > END-EXEC. ...
    (comp.lang.cobol)
  • Re: Dynamic SQL
    ... > EXEC SQL BEGIN DECLARE SECTION END-EXEC. ... > MOVE WS-SQL TO SQLSTMT. ...
    (comp.lang.cobol)
  • Re: Dynamic SQL
    ... > in the SQL DECLARE section? ... > EXEC SQL END DECLARE SECTION END-EXEC ... Prev by Date: ...
    (comp.lang.cobol)