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

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
    251 Posts

    Re: Fetch Entity Names (SQL Data Services Builder)

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

    Re: Fetch Entity Names (SQL Data Services Builder)

    ‏2012-10-08T16:21:42Z  
    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
    251 Posts

    Re: Fetch Entity Names (SQL Data Services Builder)

    ‏2012-10-09T17:22:46Z  
    • DonH
    • ‏2012-10-08T16:21:42Z
    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!!
    Yes. Although there are some situations where even that won't show the tables you know are there.