Ansicht
Dokumentation

05298 - Are other libraries available from SAP?

05298 - Are other libraries available from SAP?

General Material Data   Vendor Master (General Section)  
This documentation is copyright by SAP AG.
SAP E-Book

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

rdisp/max_wprun_time - Maximum work process run time   SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up  
This documentation is copyright by SAP AG.

Length: 2576 Date: 20240302 Time: 134853     sap01-206 ( 2 ms )