Hello Experts,
I have a question regarding the ruled based optimization techniques used in DB2 ,if we have a set of conditions in the where clause, is there anyway we can affect the way those conditions are applied...
Like if we have "where condition1 and condition2" etc and we know that...
Thank you guys for your replies (fredericofonseca & HanbingL ), from what I could infer from you posts like can be as efficient as the = operator if not used with the wild card operator.
HanbingL that was interesting to know that = operator would pick up the trailing spaces as well.
Hello Experts,
I have a scenario where I need to compare multiple fields using the like operator in a SP and the input can have the wild card operator '%' or it might not have it , in either case I use the LIKE operator (like input_variable) in SQL.
I would like to know if using the LIKE...
Hello Experts,
I am trying to implement a module that allows the users thru a jsp to explore the file system on their machine and select multiple documents to be uploaded into the server.
I am thinking how to go about it and the possible solutions seem to be using Swing /SWT in Java Web...
Hello Expets,
I am applying the following cs to teh table rows and tds which are under a table with class name "subparent"
.subparent tr.subhidden td {
padding:3px 0px 3px 10px;background-color:#ffffff;display: none;
}
.subparent tr.subshow td {
padding:3px 0px 3px...
Hello Lewis,
The second code I had a typo actually I am passing 'POSITION_DETAIL','SECURITY' in the working code, the problem is you cant have a dynamic IN clause, you will have to use Dynamic SQL , I was avoiding to not to use it , but looks like there is no way out.
Hello Experts ,
I am trying to build a dynamic in clause from a string passed in as an input parameter as follows but the following code doesnt work, but when I replace the IN clause content with a string literal it returns results, can you please let me what might be the issue here.
The...
Thanks Monksnake,actually there was a syntax error outside this function in the js file , for some reason the mozilla debuger was pointing to this curly bracket .
Hello All,
I get an error at the end of the fucntion i.e a syntax error in Mozilla, can you please let me know can you please let me know what wrong with this ,I am unable to see anything wrong with this piece of code.
Thanks in advance!
function initializeGroupByList(selectTag,jpfScopeID){...
Hello jcale,
Since you are exploring the data exchange format , I would recommend using JSON instead of XML for its simplicity, and yes you will have to using some form of data exchaneg format unless you want to write your down yoru own complex parser .It all depends on the the complexity of...
Hello Experts,
I have a scenario where I need to let the users select multiple values from a dropdown and still have a dropdown becuase in HTML when you set the multiple attribute to 'true' you have to specify the size of the select tag and if you dont specify the size we have a select tag with...
Hello Experts,
I am using a regular expression to replace a url typed in input with an anchor to display the input, I am using the following code, the RegExp works fine but the replace method cannot replace the matched text.Please advise.
<script>var test_match =...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.