Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (1)

Resolved Data object functionality when using an Impala data source.

  1. How-to
0
Votes
Undo
  1. Larry Langford
    Larry Langford
  2. PowerBuilder
  3. Tuesday, 27 November 2018 22:42 PM UTC

Does anyone have experience using data objects built over an Impala database?  I'm making an ODBC connection and can successfully execute Insert, Update, and Delete statements.  I built a test data object, and the retrieve/display functionality works, but update/save is disabled.

A dropdown dw is not in correct order
FileWrite : ANSI - Unicode
Accepted Answer
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Tuesday, 27 November 2018 23:02 PM UTC
  2. PowerBuilder
  3. # Permalink

Hi Larry;

   I am assuming that you are talking about a DataWindow. If that's the case, note that the DWO will not allow updating if the target DB Table does not have either a) Unique Index and/or b) Primary Key.

HTH

Regards ... Chris

Comment
Larry Langford
  1. Larry Langford
  2. Tuesday, 27 November 2018 23:14 PM UTC
Thanks for the quick reply Chris! Actually, I haven't tried linking the data object to a DataWindow control yet. After I built the data object I used the Run/Preview function and discovered the limitation. I think I have a solution that involves using the data object painter and converting to syntax. I then stripped out the quotations and schema owner that PowerBuilder defaulted. I then had to refresh the Update Properties, re-selecting every column again, but now it works. I hadn't heard of Impala until a few weeks ago, and I can see this is going to be an adventure. Thanks again.
  1. Helpful
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Wednesday, 28 November 2018 01:12 AM UTC
FYI: you can have the DW & DB Painters drop the quotes automatically. The "quote" setting is in the DB Profile Painter's settings area. That way, you'll never have to manually do what you did to any DW you build or at runtime (manually editing the SQL).

Once you get the quote setting running properly in the IDE, make sure that you take note of the settings in the DB Profile painter's "Preview" tab. Then make sure that you use the same settings in your App's SQLCA transaction object. ?
  1. Helpful
There are no comments made yet.
Responses (1)


There are replies in this question but you are not allowed to view the replies from this question.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.