Topic
3 replies Latest Post - ‏2012-10-09T17:22:46Z by DGawron
DonH
DonH
2 Posts
ACCEPTED ANSWER

Pinned topic Fetch Entity Names (SQL Data Services Builder)

‏2012-10-05T17:03:26Z |
This is probably an easy one but I'm missing it just the same... :-)

Using the SQL Data Services Builder, I can "Fetch Datasource Names" and I get a list of all the datasources that I expected to see.
However, when I click "Fetch Entity Names" , sometimes I see tables ... sometimes I don't.

For example, I am using the DB2 SAMPLE database as a datasource and can only see 5 of its tables when I try to "fetch entity names". I've also added a couple of tables to this database (which I would like to use for CRUD testing) but cannot test CRUD because they don't appear when I try to get the entities.

Is this a problem in WEF or in DB2?

Thanks !!
Updated on 2012-10-09T17:22:46Z at 2012-10-09T17:22:46Z by DGawron
  • DGawron
    DGawron
    250 Posts
    ACCEPTED ANSWER

    Re: Fetch Entity Names (SQL Data Services Builder)

    ‏2012-10-08T14:30:22Z  in response to DonH
    This is a bug that is addressed by the WEF 8.0.0.1 fixpack release.
  • DonH
    DonH
    2 Posts
    ACCEPTED ANSWER

    Re: Fetch Entity Names (SQL Data Services Builder)

    ‏2012-10-08T16:21:42Z  in response to DonH
    Coincidentally, I had another trawl through the forums at the weekend and I found a similar question, the answer to which suggested that I should use a wild card ("%") in the search box for the "fetch entity names".
    This enables you to list all the tables in the database etc.
    Thanks!!
    • DGawron
      DGawron
      250 Posts
      ACCEPTED ANSWER

      Re: Fetch Entity Names (SQL Data Services Builder)

      ‏2012-10-09T17:22:46Z  in response to DonH
      Yes. Although there are some situations where even that won't show the tables you know are there.