Ansicht
Dokumentation
05297 - Are other libraries available from SAP?
BAL_S_LOG - Application Log: Log header data SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3upThis documentation is copyright by SAP AG.
Are other libraries available from SAP?
Robert,Your SQL statement looks correct. Does the R/3 user profile (or *PUBLIC)
have authority to file and library? Here's a modified version of my example
with a WHERE clause.
Regards,
Stan
REPORT z_sm_sql_native .
DATA: BEGIN OF pdmopt,
option(2), " user option
command(250), " command
END OF pdmopt.
DATA: select(2).
select = 'CM'.
EXEC SQL PERFORMING output-option.
SELECT option, command
INTO :pdmopt
FROM mcpartland/qauooptsam
WHERE option = :select
ORDER BY option
ENDEXEC.
FORM output-option.
WRITE: / pdmopt-option, pdmopt-command.
ENDFORM.
-----Original Message-----
From: zreclay [mailto:zreclayZy...]
Sent: Thursday, 07 March, 2002 2:48 PM
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
Durban Tours - Südafrika Safari
Addresses (Business Address Services) Addresses (Business Address Services)
This documentation is copyright by SAP AG.
Length: 2326 Date: 20240329 Time: 133023 sap01-206 ( 3 ms )