Topic
  • 2 replies
  • Latest Post - ‏2013-10-02T12:15:57Z by 7FEU_Andre_Stark
7FEU_Andre_Stark
7FEU_Andre_Stark
10 Posts

Pinned topic Found an unsupported syntax at 'IMMEDIATE'. Ignore this EXEC statement.

‏2013-09-27T11:43:21Z |

Following SQL inside COBOL code

           EXEC SQL                                                             
                TRUNCATE TABLE RAATEST                                           
                REUSE STORAGE IMMEDIATE                                                        
           END-EXEC  

leads to the error:

RC=8 TYPE=COBOL DMH3801E: (RAAtest, line:21) Found an unsupported syntax at 'IMMEDIATE'. Ignore this EXEC statement.

I did not find a scan configuration to resolve this. Is there a solution or do we need a PMR?

  • jcdelmo
    jcdelmo
    352 Posts

    Re: Found an unsupported syntax at 'IMMEDIATE'. Ignore this EXEC statement.

    ‏2013-09-30T15:24:28Z  

    1) What version of RAA are you running?

    2) Assuming you are using RAA v6.1 or greater, there is an option on the inventory wizard (step 6) to specifiy the level of SQL the program uses when the compile based scan is used.   The keyword IMMEDIATE is supported for DB2 v9 and DB2 v10.

    3) The proprietary scanner's SQL processor does not support DB2 v9 or v10 syntax.

    4) So....    plesae rescan the program using the compile based scan  (or submit a PMR if you require the proprietary scanner)

  • 7FEU_Andre_Stark
    7FEU_Andre_Stark
    10 Posts

    Re: Found an unsupported syntax at 'IMMEDIATE'. Ignore this EXEC statement.

    ‏2013-10-02T12:15:57Z  

    It did not work.

    1) We are using: Rational Asset Analyzer V6.1.0.1

    2) COBOL realted ScanningInfo: 

    [ScanningInfo]
    cobolLanguage =
    cobolLibrary = C:\PROGRA~1\ibm\RATION~1\COMPIL~1\COBOL
    cobolOptions =
    cobolScanner = CBSO
    db2Version = 10
    sqlOptions =
     

    3) I assume that with tose ScanningInfo settings we use the CompileBasedScanner. Nothing else is defined at the scanning options for the program.

    4) Rescanning leads to the same error DMH3801E. Error description also says ist is a message form the "Compiler Based Scanner": http://pic.dhe.ibm.com/infocenter/rassan/v6r0/topic/com.ibm.raa.messages.doc/topics/dmh3801e.html