Skip to main content

Hi,

I got a error , when NET EXPRESS complier source like :

" 316 EXEC SQL
  317       SELECT ITEMA
  318              INTO :ITEM_A
  319               FROM MY_TABLE
  320 END-EXEC  "

error message

* 801-S******************** ( 0)**
** External Compiler Module message
** ES0109 ITEM-A

I don't know why host varible was changed , and how to fix that problem.

Regards


Hi,

I got a error , when NET EXPRESS complier source like :

" 316 EXEC SQL
  317       SELECT ITEMA
  318              INTO :ITEM_A
  319               FROM MY_TABLE
  320 END-EXEC  "

error message

* 801-S******************** ( 0)**
** External Compiler Module message
** ES0109 ITEM-A

I don't know why host varible was changed , and how to fix that problem.

Regards


Maybe: ES0109 token is not a data item.

Resolution: Verify that the host variable exists. If it does not, make the required changes to correct the error. Variables defined in COBOL copybooks are also valid for host variables, unlike mainframe DB2.

Regards

Michael

Hi,

I got a error , when NET EXPRESS complier source like :

" 316 EXEC SQL
  317       SELECT ITEMA
  318              INTO :ITEM_A
  319               FROM MY_TABLE
  320 END-EXEC  "

error message

* 801-S******************** ( 0)**
** External Compiler Module message
** ES0109 ITEM-A

I don't know why host varible was changed , and how to fix that problem.

Regards


The problem is because the OpenESQL preprocessor does not allow host variables with an underscore in the name.

That is why when you use the OpenESQL Assistant to generate your host variables in a copybook it will automatically change column names with an underscore to use a hyphen in the host variable.

  INTO :ITEM_A

should be

  INTO :ITEM-A

Hi,

I got a error , when NET EXPRESS complier source like :

" 316 EXEC SQL
  317       SELECT ITEMA
  318              INTO :ITEM_A
  319               FROM MY_TABLE
  320 END-EXEC  "

error message

* 801-S******************** ( 0)**
** External Compiler Module message
** ES0109 ITEM-A

I don't know why host varible was changed , and how to fix that problem.

Regards


Thank you for your answer.

Unfortunately, I can't change host variables in my copybook.  And I found this problem just in the "SELECT" statement. When I use "UPDATE" or  "DELETE" ,  complier is OK.

So, I think may be NET EXPRESS has some options that  can cancel  automatically change column names.

Regards

Terms & ConditionsAccessibility statement