Re: Embedded SQL problem

Are any of the colums variable-length? In C, at least, these come in as
struct, with 2 elements - length and data. Does this happen in COBOL?
That'd be a second level, as someone else pointed out.

At 08:53 PM 7/31/02 +1000, you wrote:

>Hello Jon,
>
>You wrote:
> >Anybody got any ideas?
>
>The problem is with one or more of the other fields in the host data
>structure.  I say that because I took your excerpt and make it compile by
>doing little more than adding the COBOL overhead...
>
>        IDENTIFICATION DIVISION.
>        PROGRAM-ID. JON.
>        ENVIRONMENT DIVISION.
>        CONFIGURATION SECTION.
>        SOURCE-COMPUTER. IBM-AS400.
>        OBJECT-COMPUTER. IBM-AS400.
>        DATA DIVISION.
>        WORKING-STORAGE SECTION.
>            EXEC SQL
>                INCLUDE SQLCA
>            END-EXEC.
>        01 VendorRecordWS.
>           05 VendR.
>           10 VENDORID              PIC X(6).
>           10 VENDORNAME            PIC X(30).
>           10 ADDRESSLINE1          PIC X(30).
>        PROCEDURE DIVISION.
>        MAIN SECTION.
>       *    Write VendorRecord
>            Exec SQL
>                 Insert into VendP
>                 Values( :VendR)
>            End-exec.
>            STOP RUN.
>            EXIT.
>
>Regards,
>Simon Coulter.