IC SunsetThe developerWorks Connections platform will be sunset on December 31, 2019. On January 1, 2020, this forum will no longer be available. More details available on our FAQ.
Topic
  • 6 replies
  • Latest Post - ‏2019-07-10T11:09:16Z by davymartu
davymartu
davymartu
6 Posts

Pinned topic RNF0265 error with SQLRPGLE

‏2019-07-09T09:46:31Z | crtsqlrpgi options rnf0265 sqlrpgle v7r2

Hello guys,

I've a problem with an iSeries v7r2 and compiling SQLRPGLE programs.

In all my code (exported from other iSeries) I write always this directive:

H Option(*srcstmt)        

But with this release I've to delete this because there is a compilation error with CRTSQLRPGI command:

       D*      SQL COMMUNICATION AREA                                                         SQL 
*RNF0265 30    448 008600  Il numero di sequenza nel file origine non è valido;                   
                           OPTION(*SRCSTMT) viene ignorato.  

Everything is fine in other releases (V5R3 - V5R4 - V7R1 - V7R3). Everything is ok with RPGLE sources!

Any ideas?

Thanks everybody.

Martu

                                    

  • Andreas Bott
    Andreas Bott
    20 Posts

    Re: RNF0265 error with SQLRPGLE

    ‏2019-07-10T08:26:49Z  

    Hi,

     

    1. do you have more Code, perhaps an very small example code ? i dont understand what you have to delete, the H-Line or the D-Line.

    2. Can you translate the italian Error Message in English ?

     

    Thanks.

     

    Greetz

     

  • davymartu
    davymartu
    6 Posts

    Re: RNF0265 error with SQLRPGLE

    ‏2019-07-10T09:45:39Z  

    Hi,

     

    1. do you have more Code, perhaps an very small example code ? i dont understand what you have to delete, the H-Line or the D-Line.

    2. Can you translate the italian Error Message in English ?

     

    Thanks.

     

    Greetz

     

    Hi Andreas,

     

    1- All my SQLRPGLE code with H-Line Option(*srcstmt) doesn't compile. I must remove H-line to compile (or *nosrctmt), but in case of errors I can't recognize exact line of code.

    2-From IBM docs:

    RNF0265

    The sequence number in the source file is not valid; OPTION(*SRCSTMT) is ignored.

    30

    Cause . . . . . : When OPTION(*SRCSTMT) is specified, the sequence numbers in the source file (the first 6 bytes in each line of a source physical file) must be valid. Every byte in the sequence number field must contain a digit (0 - 9). From this point on in the compilation, the statement numbers will be assigned sequentially.

    Recovery . . . : Ensure the sequence numbers in the source file are all valid, or specify OPTION(*NOSRCSTMT).

     

    Thanks for reply. 

  • Andreas Bott
    Andreas Bott
    20 Posts

    Re: RNF0265 error with SQLRPGLE

    ‏2019-07-10T09:58:44Z  
    • davymartu
    • ‏2019-07-10T09:45:39Z

    Hi Andreas,

     

    1- All my SQLRPGLE code with H-Line Option(*srcstmt) doesn't compile. I must remove H-line to compile (or *nosrctmt), but in case of errors I can't recognize exact line of code.

    2-From IBM docs:

    RNF0265

    The sequence number in the source file is not valid; OPTION(*SRCSTMT) is ignored.

    30

    Cause . . . . . : When OPTION(*SRCSTMT) is specified, the sequence numbers in the source file (the first 6 bytes in each line of a source physical file) must be valid. Every byte in the sequence number field must contain a digit (0 - 9). From this point on in the compilation, the statement numbers will be assigned sequentially.

    Recovery . . . : Ensure the sequence numbers in the source file are all valid, or specify OPTION(*NOSRCSTMT).

     

    Thanks for reply. 

    Hi,

     

    thanks better description ot the problem.

     

    Is this Problem in every SQLRPGLE Programm or only in this program ?

    Yes: missing PTF for Compiler ?

    NO:

    seems there is one line with an invalid Hex Value in the Line number.

    Is in the Compile Listing any note ? Line number 008600 ? Delete the line helps ?

     

    I have tested the Problem in V7R1, but no error. Seems to be on your Machine, perhaps only with this source.

     

    Greetz

     

     

     

  • Andreas Bott
    Andreas Bott
    20 Posts

    Re: RNF0265 error with SQLRPGLE

    ‏2019-07-10T10:06:07Z  

    Hey,

     

    you could check the Line numbers in SQL .

     

    Create an ALias for your Source Member:

    create alias hs2019kk.alias1 for hs2019kk.qrpglesrc(Bankenv)

     

    SQL Statement for Line Numbers

    Select srcseq from alias1

     

    If here is something "wrong" perhaps you could find the line with the Problem.

     

     

  • davymartu
    davymartu
    6 Posts

    Re: RNF0265 error with SQLRPGLE

    ‏2019-07-10T11:08:51Z  

    Yes, this problem for every SQLRPGLE.

    How can I find the PTF compiler level or PTF that correct this problem?

    With you suggestion, I've create an Alias of my source code; this is my Alias code query result.

    SRCSEQ  SRCDAT  SRCDTA
    1,00      823 H DECEDIT('0,') DATEDIT(*DMY.)
    2,00   50.121 H DftActGrp(*NO) ActGrp('QILE') BndDir('WJ0BND')
    3,00  190.709 H Option(*nodebugio:*srcstmt)
    4,00   10.808
    5,00   40.827 FI§WRK00F UF E K DISK
    6,00  990.331 FORTES00F IF E K DISK usropn

    ........


     

    Updated on 2019-07-10T12:35:32Z at 2019-07-10T12:35:32Z by davymartu
  • davymartu
    davymartu
    6 Posts

    Re: RNF0265 error with SQLRPGLE

    ‏2019-07-10T11:09:16Z  

    And this is compiling list:

    ..............

    008200 D null_ds dim(200) like(null_ind)  
    008300  
    008400 D C§Parm E DS EXTNAME(WS0130PF)  
    008500  
    008600 * Esecuzione  
           D* SQL COMMUNICATION AREA SQL
           *RNF0265 30 448 008600 Il numero di sequenza nel file origine non è valido;
            OPTION(*SRCSTMT) viene ignorato.
    *--------------------------------------------------------------------------------------------* 

    ........

     

    Line 008600 is the first line of "C" specs!

    Updated on 2019-07-10T12:34:30Z at 2019-07-10T12:34:30Z by davymartu