How to connect AS400&Unix using HTTP

[Former Member]

Hi,

1) How do we connect to AS400 and read files from directory/library or read data from database using HTTP protocol from XI.

2)How do we achieve the above scenario incase of Unix and windows?

Is it possible to do the above scenario's using HTTP?

Thanks in advance.

Regards,

Srinivas

[prateek · Accepted solution]

<i>1) How do we connect to AS400 and read files from directory/library or read data from database using HTTP protocol from XI.</i>

DB2 is the default database of AS400. If u r reading data from database, u shud use JDBC adapter.

Another option is the use of File adapter, however for this u have to set up FTP on ur server

<i>

2)How do we achieve the above scenario incase of Unix and windows?</i>

Similar manner

<i>

Is it possible to do the above scenario's using HTTP?</i>

JDBC and fie r most feasible options

<i>[reward if helpful]</i>

Regards,

Parteek

[Former Member · Accepted solution]

Thanks Prateek..

My scenario is, I have got few tables in AS400 and table1(control data table) is having control data like GUI no as primary key field,no of records&status field etc.Table2....tableN (data tables) having data with GUi no as the key field.based on GUI no, i have to read data from data tables and finally compare the no of records with control table no of rec field.

How do we achieve it using JDBC?

Thanks in advance.

Regards,

Srinivas

[Former Member · Accepted solution]

Srinivasa

Go for SQL Joins

https://weblogs.sdn.sap.com/pub/wlg/1725 [original link is broken] [original link is broken] [original link is broken] [original link is broken]

regards

krishna

[justin_santhanam · Accepted solution]

Srini,

If you want to combine both the table and get the data, then use the JOIN query in the sender communication channel parameter, this what ur looking for?

Best Regards,

raj

[prateek · Accepted solution]

Joins would be helpful. The use of Stored Procedures in these cases are normal.

But while actually designing, first of all u finalize the approach to use JDBC

/people/saravanakumar.kuppusamy2/blog/2005/01/19/rdbms-system-integration-using-xi-30-jdbc-senderreceiver-adapter

A generalized solution

/people/bhavesh.kantilal/blog/2006/07/03/jdbc-receiver-adapter--synchronous-select-150-step-by-step

/people/yining.mao/blog/2006/09/13/tips-and-tutorial-for-sender-jdbc-adapter

Additional

/people/laxman.molugu/blog/2006/08/13/integration-with-databases-made-easy-150-part-1

Regards,

Prateek

[Former Member]

Also check this blog

/people/sap.user72/blog/2005/10/04/extracting-data-from-an-as400-with-multimember-tables-using-xi

Regards

krishna

[Former Member]

Hey Srinivasa,

GOing thru the following thread might answer most of your questions

REgards

krishna

[justin_santhanam]

Srini,

If you want to connect to AS400 DB2 then you can use JDBC adapter.

If you want to connect to unix/windows then you can use File adapter.

Best regards,

raj.