Re: SQL select rrn

[Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>]

SQLCOD -204 has a message for that - SQL0204 - have you seen what that 
message is? It should be in your joblog - it says "File not found" - 
there should be some further info as to which file, but it is probably 
BIGFILE - there's nothing too complex about this - see where BIGFILE is 
on your system and be sure your LIBL is correct when running the SELECT 
statement.

Just for the future - if you need information on an SQLCOD, make a 
message ID by taking the letters SQL and follow them with a 4-digit form 
of the SQLCOD. If SQLCOD is in the 30,000 range, use SQ plus the number 
as the message ID. Look up in QSQLMSG - DSPMSGD SQLxxxx QSQLMSG.

I suspect there is nothing related to RRN in this error, other than the 
file you specify is not found, but that is also true about the FROM clause.

On 1/12/2019 7:55 PM, Booth Martin wrote:
> exec sql select rand(MICROSECOND(CURRENT_TIMESTAMP)) into :wField5
>            from SYSIBM/SYSDUMMY1;
>        wSeed = wField5 * 10000;
>        // 
> ---------------------------------------------------------------------
>        // Get random records
> exec sql select SOMEFIELD into :wSomeField from BIGFILE
>             where rrn(BIGFILE) = :wSeed;
>
> This is returning sqlcode -204.
>
> Reading about -204 and rrn leads me to believe there is more going on 
> than I realize.