Ansicht
Dokumentation
05298 - Are other libraries available from SAP?
SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up CPI1466 during BackupThis documentation is copyright by SAP AG.
Are other libraries available from SAP?
Hi, Robert.
There are 2 points to remember here:
1) You cannot access a file in the QSYS.LIB structure if it has a DDS
structure (record/field format). If it is a "flat" file (PF without DDS -
fixed record length), then you can access it from ABAP.
2) To access a flat file from ABAP, you need to declare the file as a
dataset. Use a variable for the dataset name and set the variable up front
to the name of the file in the format
'/QSYS.LIB/YOURLIB.LIB/YOURFILE.FILE/YOURFILE.MBR'. After that, treat the
file as a normal dataset as if you were reading it from the IFS.
Regards,
Des Olwage
Snr. Systems Administrator
Goodyear South Africa
Tel. +27 41 5055441
Cell. +27 82 824 6900
"zreclay"
<zreclayZyaho To: DoNotReply@consolut.eu
o.com> cc:
Subject: Are other
libraries available from SAP?
07/03/2002
21:51
Please
respond to
SAP on System i
Hi, group
We are trying to access a file in a non-R/3 library via a little ABAP
program using native SQL. It isn't working. My question is: is it
possible to access files in data libraries other than R/3-specific
libraries? If so, how?
Here's our dummy code:
REPORT ZBC_TEST_SQL .
DATA: V_ITEM(10) TYPE C,
V_ITEMNO(6),
V_VNDRNO(10) TYPE C.
V_ITEMNO = 56023.
EXEC SQL.
SELECT ITEMNO, VNDRNO INTO :V_ITEM, :V_VNDRNO FROM KERRDATA/INVMAS
WHERE ITEMNO = V_ITEMNO
ENDEXEC.
WRITE: / V_ITEM.
Any suggestions/information is greatly appreciated.
Robert Clay
consolut Sponsor
Have a look to our homepage at: http://www.consolut.net
DoNotReply@consolut.eu
Durban Tours - Südafrika Safari
BAL_S_LOG - Application Log: Log header data BAL Application Log Documentation
This documentation is copyright by SAP AG.
Length: 2576 Date: 20240427 Time: 003052 sap01-206 ( 3 ms )