Translate function binding issue

I am using SQLJ as the data set is quite large for the application. I am trying to incorporate a query into my SQLJ file, but at the time of binding it gives me an error. Please help me with an alternative to the same. I cannot drop the translate function as I have been told to do that only.

sql [myConn] cursor = { SELECT ORD_TEMPLT_GRP_ID,DSO_CD, ACCT_SUBTYPE_CD, GRP_DESC,LAST_CHANGED_BY_ID FROM TEMPLATE_GRP WHERE TRANSLATE(ORD_TEMPLT_GRP_ID) = TRANSLATE(:templateGp) WITH UR };

cursor over here is iterator and templateGp is the value which I am getting from an object.

Category:java Views:0 Time:2011-07-17
Tags: java sqlj

Related post

  • Javascript function binding issue 2011-10-20

    before three years I was a javascript guru. After the JQuery release I forgot everything about JavaScript. This may be a great drawback of this framework, for me. LOL My issue How I bind a function with the onload event of the document? I tried so fa

  • Function.bind vs Closure in Javascript : how to choose? 2011-06-18

    As said here: http://jqfundamentals.com/book/index.html Closures can also be used to resolve issues with the this keyword, which is unique to each scope. This mechanism can be particularly useful when dealing with callbacks, though in those cases, it

  • Postgres 9.0 + translate function and ascii codes 2012-04-13

    I use the translate function to process searches accent insensitive. To improve this request, i've created a matching index : CREATE INDEX person_lastname_ci_ai_si ON person USING btree (translate(upper(lastname::text), '\303\200\303\201\303\202\303\

  • whole page translator function points to the wrong web address 2012-08-08

    In MS word 2012 the translator function for English to Spanish points to the wrong web address. The dialog box shows this address: micorsofttranslation.com/officetrans/httpquery.aspx A web browser launches and it returns a 404 not found error message

  • WPF - ComboBox binding issue 2009-08-20

    I'm using WPF/MVVM and am having a binding issue with a ComboBox - any help appreciated! Heres my Combo ... <ComboBox Name="ComboBoxAvailableCriteria" Width="255" ItemsSource="{Binding AvailableCriteria}" DisplayMemberPath="SearchableAttribute.Nam

  • how to systematically solve binding issues 2010-10-12

    I have been using data binding for several years with win forms, but now with more rich and full featured data binding in wpf I can easily do stuff that would have taken a lot of code in winforms. Lurking beneath the surface is an unsettling feeling

  • WPF Binding Issue - UI Updates, Object Does Not 2010-12-20

    I'm having yet another WPF binding issue. Just when I think I've got this stuff figured out, I run into more problems... :S Anyway... I've created a custom user control for selecting files. It's a simple textbox followed by a button contained within

  • ASP.NET AJAX 4.0 Live binding - Issue with Sys.registerComponent 2010-12-20

    I am trying to design a client template using the AJAX 4.0 framework with live binding. I have WCF Service defined called VesselData (will provide code if needed) which returns a datatable class called VesselCollection. Also, I am referencing the fol

  • joomla function bind Problem 2011-01-03

    I'm writing a custom component for my work. I'm using hello component for building it. When I edit a form and save it I get this error: Call to a member function bind() on a non-object My code: function save() { global $option; JTable::addIncludePath

  • Xpath translation function turns things into lowercase? 2011-05-01

    I am using xpath's translation function to remove some characters in a string but it also converts all the letters into lower case. Is this supposed to happen? How can I change this behavior. --------------Solutions------------- The standard XPath fu

  • MVVM combobox binding issue 2011-07-14

    I have a project with a number of comboboxes, all binding correctly. Since installing SL5 I started experiencing all sorts of binding issues as well as the debugger being crippled. The problem is that when you switch from SL4 to SL5 and then back to

  • PlSql Translate function question 2011-07-14

    I've created a cursor to select the actual data, and loop through it outputting the raw value and the value after it was converted to a number. The application occasionally throws invalid number errors. Below is my test (not including the select stat

  • WPF binding issues with resource dictionaries 2011-07-22

    I have developed a custom data grid control. This control has two parts, one is the custom template used by the data grid itself and the other is my custom control which adds a title area to the data grid. I have a class called CustomDataGrid, here i

  • Why does Function.bind("foo").call("bar") always refer this to "foo"? 2011-08-27

    I just experienced a behavior in JS which I couldn't understand: I wanted to create a method which calls String.prototype.replace with some args given, therefore I came up with that: String.prototype.replace.bind("foo", /bar/g, function(){}).call I g

  • Listing (in C#) all JS functions binded to client side events of a web page 2011-12-13

    what I want to do, is to write a program to check if clicking on a links, or buttons in a web page fires a client side code (JS). Also I want, to list all JS functions binded to client side event (onclick for example). Please help me, thats interesti

  • How to call a function binding it to a jQuery object 2011-12-21

    Does jQuery provides a API to call functions binding the this variable to the jQuery object? E.g.: function log() { console.log(this); } $('body').execute(log); // prints the $('body') object in the console I know that this could be solved by making

  • JQuery translate function not working in firefox / chrome 2012-01-24

    I have a HTML page which is divided into two frames. Separate web sites are being opened by users in those frames as I provided an open web site option. These web sites can be in any language. So. i need to translate the languages of these websites t

  • Is HTML5's Canvas API Rotate or Translate function better? 2012-03-05

    After a short discussion with a friend on a Canvas project, we realized that there is no clear cut answer on whether the Canvas rotate or translate functions are better to use. Mainly we want to know which is the best for rendering performance and wh

  • Compiling code that uses socket function bind() with libcxx fails 2012-04-05

    I am using the new libcxx library and I have a code that calls the socket function bind(). The problem is that when I type using namespace std; the compiler gives me an error for the following code: int res = bind(sockfd, (struct sockaddr *)&myAd

Copyright (C) dskims.com, All Rights Reserved.

processed in 0.133 (s). 11 q(s)