Ansicht
Dokumentation

05308 - Are other libraries available from SAP?

05308 - Are other libraries available from SAP?

Fill RESBD Structure from EBP Component Structure   Addresses (Business Address Services)  
This documentation is copyright by SAP AG.
SAP E-Book

Are other libraries available from SAP?

Hi Robert,

I don't know what you mean with "bomb", but I guess it is running quite a
while. The question would be, if you really had an index over this field ?
otherwise a full table scan would be completely correct. You should keep in
mind, that this is run through the SQL-optimizer. So, you could try this
statement with STRSQL or SQLUTIL and see if the same problems in performance
arise.

If you would like to use tables from other AS/400s than the DB-server, you
might want to look into note 146624 as well.

Regards

Volker

> -----Original Message-----
> From: zreclay [mailto:zreclayZy...]
> Sent: Donnerstag, 7. März 2002 23:48
> To: DoNotReply@consolut.eu
> Subject: Re: Are other libraries available from SAP?
>
>
> Stan,
>
> There are over 1/2 million records in this file and I only want to
> return the values from one. I can't seem to get a "where" portion of
> the SQL statement to take. Any suggestions?
>
> Based on your example, I came up with this code which is
> syntactically correct but bombs out when run:
>
>
> REPORT ZBC_TEST_NATIVE_SQL .
>
> DATA: V_ITEMNO(6) type p decimals 0.
>
> DATA: BEGIN OF i_item,
> v_item(6),
> v_upcndc(11),
> END OF i_item.
>
> V_ITEMNO = 56023.
>
> EXEC SQL PERFORMING output-option.
> SELECT itemno, upcndc
> INTO :i_item
> FROM kerrdata/invmas
> WHERE itemno = :v_itemno
> ENDEXEC.
>
> FORM output-option.
> WRITE: / v_itemno, i_item-v_item, i_item-v_upcndc.
> ENDFORM.
>
>
> Thanks for your help.
>
> Robert Clay
>
>
>
> ------------------------ consolut Sponsor
> ---------------------~-->
> Tiny Wireless Camera under $80!
> Order Now! FREE VCR Commander!
> Click Here - Only 1 Day Left!
> http://us.click.consolut.net/nuyOHD/7.PDAA/yigFAA/dkFolB/TM
> --------------------------------------------------------------
> -------~->
>
> Have a look to our homepage at: http://www.consolut.net
> DoNotReply@consolut.eu
>
> Your use of consolut is subject to
> http://www.consolut.net
>
>

Durban Tours - Südafrika Safari

SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up   BAL Application Log Documentation  
This documentation is copyright by SAP AG.

Length: 3336 Date: 20240329 Time: 073252     sap01-206 ( 3 ms )