Eclipse Community Forums: EGL Development Tools

Help

Home

Home » Archived » EGL Development Tools » SQL parameters(How to specify parameters)

Show: Today's Messages :: Show Polls :: Message Navigator

SQL parameters [message #774099]

Tue, 03 January 2012 09:06

Trond Einar Nilsen

Messages: 36
Registered: December 2011

Member

I am developing for Power7 (iSeries) and have used EGL CE width success. For EDT I expected this to work:

function getG8(G8search string inOut, UserLogon string in, counter int in) returns(G8A[])
LIBFIL = "NOR.SECNREL0";
get G8Array from ds
with #sql{SELECT G8JWNB as G8JWNB FROM :LIBFIL where G8AUNA like :G8search};
return(G8Array);
end

but it seems like the ":" is not used to specify parameters anymore. I cannot find out how to do it. Probably I have to use "?" somehow, but how?
/Trond E. Nilsen

[Updated on: Tue, 03 January 2012 09:06]

Report message to a moderator

Re: SQL parameters [message #774767 is a reply to message #774099]

Wed, 04 January 2012 14:59

Will Smythe

Messages: 41
Registered: July 2009

Member

As you have discovered, the :hostVariable syntax is not supported in EDT. You can use "?" in your SQL to identify parameters, but this does not work for the table name (as you may have discovered). This is a SQL limitation.

The following code demonstrates how you might accomplish what you are trying to do:

    ds SQLDataSource?{@resource {}};
    tableName String = "snippet";
    
    stmt SQLStatement?;
    prepare stmt from ds with "select * from " + tableName + " where id > ?";
    
    snippets Snippet[];
    get snippets from ds with stmt using id;

See the EGL Data Access spec for more details on Prepare and the other data access statements: https://bugs.eclipse.org/bugs/show_bug.cgi?id=355573

Report message to a moderator