Re: ACS Run SQL Scripts - define a variable

[Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>]

In RPG I think you would get this message, because you have to use a 
host variable, which has the colon in front - the Valid tokens: phrase 
says there should be a colon where rows is. Maybe in ACS for this 
statement you still need the colon - maybe check the documentation.

In ACS, go to the Edit menu and look for the Examples item - once you 
open that dialog, search for diagnostics in the text box - see if there 
is anything with an example that you can see how it is used.

Vern

So I'm kind of confused and not at a system right now.

On 6/17/2020 6:34 PM, Don Brown via MIDRANGE-L wrote:
> No difference
>
> CREATE OR REPLACE VARIABLE rows INTEGER;
> GET DIAGNOSTICS rows = ROW_COUNT ;
>
> SQL State: 42601 Vendor Code: -104 Message: [SQL0104] Token ROWS was not
> valid. Valid tokens: :. Cause . . . . . :   A syntax error was detected at
> token ROWS.  Token ROWS is not a valid token.  A partial list of valid
> tokens is :.  This list assumes that the statement is correct up to the
> token.  The error may be earlier in the statement, but the syntax of the
> statement appears to be valid up to this point. Recovery  . . . :   Do one
> or more of the following and try the request again: -- Verify the SQL
> statement in the area of the token ROWS. Correct the statement.  The error
> could be a missing comma or quotation mark, it could be a misspelled word,
> or it could be related to the order of clauses. -- If the error token is
> <END-OF-STATEMENT>, correct the SQL statement because it does not end with
> a valid clause.
>
> Interestingly in the Global variables tab there is NOT a ROW_COUNT
> variable shown ???
>
>
> Don
>
>
> ______________________________________________________________________
> This email has been scanned for computer viruses. Although MSD has taken reasonable precautions to ensure no viruses are present in this email, MSD cannot accept responsibility for any loss or damage arising from the use of this email or attachments.
> ______________________________________________________________________