on 11-17-2011 11:34 AM
Hello Experts,
I am very new to this Esourcing and was going through the Help document for Query Definition. I came across the syntax in the query as Alias.Tablename LIKE ? and sometimes Alias.Tablename = ?. Kindly help me in undestanding what is that Like and ? used for and what is the purpose of it.
Can I also get any link showing different syntax that can be used while writing the query.
Thanks,
rythm
Hi Rhythm,
The LIKE condition is standard SQL that allows you to use wildcards in the where clause. In your example, you say u201CAlias.Tablename LIKE ?u201D. Note, the LIKE condition is used in the where clause and not in the from clause.
? is a Sourcing specific and is a placeholder for the filter parameter. Depending on which version of Sourcing you are on, the usage is different. My suggestion would be look at the help section which explains this very well.
Hope this helps.
Regards,
Vikram
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.