Ansicht
Dokumentation
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.
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 )