RFC Connection From SAP to Iseries server

[Former Member]

Hi,

I wish you can help me wtih this issue.

We are running ECC 6.0 on iseries v5r3m0.

We are trying to connect to an other non-SAP V5r1M0 system. We are using OSS note 146624 for this purpose.

Our first problem is that we cannot copy pgm files to a V5R1 system from V5R3 system. This can be solved with manual extraction kernel.

However our problem is that we are getting an "SQL Error 0" short dump when we start abap report. What ever the entry in DBCON table is we get this short dump.

Did anyone configured RFC connection to a non-SAP Iseries system? What methos should we use?

Best Regards

[Former Member]

Hi Sez,

We had a hard time to connect SAP DB2/400 V5R3 to non-SAP DB2/400 V5R2 through DBCON long time ago. But eventually it works.

Based on Chapter 18 of IBM RedBook SG24-5190-00, we successfully configured DDM/DRDA first. Logon with <SID><instance#>, enter STRSQL/SQLUTIL, "connect to <non-SAP DB2/400>" should work.

Then configure DBCON with Tcode DBCO... Afterwards ABAP code.

For your first question, 4.6D ext kernel is still available fro V5R1. But does DBCON need any kernel program on non-SAP side?

For your second question, standalone Gateway instance could be another option.

Good luck,

Victor

[Former Member]

Hi Sez,

I would typically suggest a RFC connection from your V5R1 AS/400 to your SAP AS/400. We mostly do this in such customer environments. You would use the librfc sdk (available for V5R1) and compile an rpg program for the connection. This type is pretty fast and flexible.

The new redbook contains examples for both directions:

http://www.redbooks.ibm.com/redpieces/abstracts/sg247166.html?Open

If you have more special questions, let me know.

Regards

Volker Gueldenpfennig, consolut.gmbh

http://www.consolut.de - http://www.4soi.de - http://www.easymarketplace.de

[Former Member]

Hello Volker,

it is some time ago, you posted the original message here. I have a follow on question and I hope you can help.

Apart from the redbook I can't find any documentation about rfc with iseries and that gives some examples but no real explanation about what you are supost to do

I followed the rfc example "ILE RPG evoked from ABAP" and I can get it to work, as long as I ask for only one parameter from the ABAP.

Do you know how to get multiple parameters from ABAP? Just repeating the RfcGetData with different parameters doesn't work. The ABAP will cancel with "no data to receive" on the second parameter.

Also do you know how to create a rfc-trace for these requests?

Best Regards.

Richard la Croix

[Former Member]

Hallo Richard,

I believe that in the RFCSDK library there should be a TXT file, which describes the use of the different functions in some detail. Maybe you can find the information you need in there.

Regards,

Sally Power

Development Support for SAP on IBM i

[Former Member]

Hi again,

I just noticed your supplementary question. Setting up the RFC trace is described in

[SAP note 176277|http://service.sap.com/~IRON/FM/011000358700000431401997E/00176277].

All the best,

Sally Power

Development Support for SAP on IBM i

Edited by: Sally Power on Jun 23, 2008 5:17 PM

Edited by: Sally Power on Jun 23, 2008 5:23 PM

Edited by: Sally Power on Jun 23, 2008 5:24 PM

[Former Member]

Hi Richard,

for sure, we are using this with more than one parameter )

This works on pointer chains - it is a bit tricky when you don't understand the full picture ...

I can only offer you consulting from us here - sorry it is too complicate for describing it in detail here ...

Regards

Volker Gueldenpfennig, consolut international ag

http://www.consolut.de - http://www.4soi.de - http://www.easymarketplace.de

[Former Member]

Hello Sally,

thanks for the info. I looked at the text files before I started, but it was to 'C-ish' for me then. Now that I have the 'single parameter example' working, I think I understand the functions described in this file a bit better.

If I am correct, for multiple parameters I have to use an array of the same parameter structure, with the last element initialized to *null (probable to act as some kind of terminator).

I will try this tomorrow.

Thanks,

Richard