Get Data Moving 1
Results 1 to 3 of 3

Thread: Get matching record count from super-descriptor

  1. #1
    HollandDBA is offline Junior Member
    Join Date
    Jan 2010
    Posts
    5
    Rep Power
    0

    Question Get matching record count from super-descriptor

    I have a need to query Adabas to aquire a count of matching records according to a adabas super-descriptor. The Adabas file is defined as shown:
    Field Definition Table:
    Level I Name I Length I Format I Options I Flags
    -------------------------------------------------------------------------
    1 I AA I 8 I A I DE,FI I SP
    1 I AB I 11 I A I I
    1 I AC I 3 I U I I
    1 I AD I 2 I A I FI I SP
    1 I AE I 2 I A I FI I SP
    -------------------------------------------------------------------------
    Type I Name I Length I Format I Options I Parent field(s) Fmt
    -------------------------------------------------------------------------
    SUPER I S1 I 12 I A I I AA ( 1 - 8 ) A
    I I I I I AE ( 1 - 2 ) A
    I I I I I AD ( 1 - 2 ) A
    -------------------------------------------------------------------------


    Using CLOG I can see that a SQL query against ADABAS as shown below is getting the query result using database command L3 (read) which I believe means it is reading all of the records to get a count:
    select count(*) from file where AA = '20100101' and AE = 'XX' and AD = 'XX'

    If the query where issued to Adabas via the database command S1 (find) the results could be obtained more efficiently. Is Attunity capable of making this sort of call to Adabas? As a note, this Attunity connection is being created specifically to get record counts with no need to actually acquire the record data if that matters so there is flexibililty if Attunity can accomplish this through some tweaking. Thank you.

  2. #2
    Yossi Shitrit is offline US Technical Team
    Join Date
    Sep 2006
    Posts
    38
    Rep Power
    0
    Hi HollandDBA,

    I have checked with our ADABAS expert and got the following:
    The L3 command will use the index to read all of the records that matches:
    AA = '20100101' and AE = 'XX' and AD = 'XX'
    And the Attunity Query Processor will actually do the count.

    The option to use S1 command to read the ISN quantity looks compelling but we cannot use it in case there are additional filtering predicates in the query besides the index ones.

    Hope this helps.
    Thanks,
    Yossi
    To Find Out more About Attunity Technology:
    Attunity
    or:
    Contact Us

  3. #3
    HollandDBA is offline Junior Member
    Join Date
    Jan 2010
    Posts
    5
    Rep Power
    0
    Thank you Yossi, that does help. I found another post from 2006 that suggests a histogram (L9) against the super-descriptor is not possible either. Do you know if that is still the case. Unless I can avoid reading all of the records and just retrieve a count from Adabas, I think I will need to develop a Natural RPC call for this particular applications need.

    Much appreciated,
    Todd
    Last edited by HollandDBA; 01-08-2010 at 12:23 PM. Reason: L9 not L7

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •