cancel
Showing results for 
Search instead for 
Did you mean: 

Details on data types for posting data to DB2 on AS400 from XI

Former Member
0 Kudos

Hi

We have a scenario in which we post data from XI (3.0, SP23 ) to DB2 on AS400 and we are using jdbc adapters ( jdbc drivers from IBM deployed on XI J2EE server as per SAP's instructions )

On AS400-DB2, there are two files F1 and F2 that we have to update in a particular library L1 - on a server S1. Each of the two files has a single field with the same name as that of the file.

I have the following questions :

1. How do we construct/specify the data type in order to convert XML from XI to the sql that DB2 needs - I do understand there is a standard data type structure used to convert XML to sql calls when we use JDBC receiver adapter type communication channel. Do we use the same for posting XML data from XI to DB2 too ?

2. What is the url for the jdbc driver - to connect to DB2 on AS400 ?

Please share experiences of XI -- > posting to DB2 using JDBC.

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Used standard xml -->SQL constructs