cancel
Showing results for 
Search instead for 
Did you mean: 

JDBC Adaptor

Former Member
0 Kudos
32

Hi,

Can it be get the get the flat file (text file not tables) in AS400 using JDBC Adaptor?

I need some links or samples.

Ravichandran K

Accepted Solutions (1)

Accepted Solutions (1)

bhavesh_kantilal
Active Contributor
0 Kudos

You will need to use the file adapter and not the JDBC adapter in this case.

In your file adapter you will have to use content conversion to convert text to XML.

Regards

Bhavesh

Former Member
0 Kudos

Hi Bhavesh,

In AS400 the terms are slightly confusing. They call a table a file in AS400. No idea why...

It is possible to retrieve or update entries in the file (table) using JDBC adapter.

Regards,

Jai Shankar

bhavesh_kantilal
Active Contributor
0 Kudos

Jai,

Thnaks for that clarification. Was not aware of such contradiciting naming convention.

Regards

Bhavesh

Answers (1)

Answers (1)

MichalKrawczyk
Active Contributor
0 Kudos

hi,

yes you can - there are some jdbc adapters that can pull

info from flat files

http://www.download3000.com/download_17129.html

Regards,

michal

Former Member
0 Kudos

Thanks Michal.

I am using PI7.0, Where i can download the JDBC Adapter for AS400 and how to define the strcutre, what could be communication channel setting for file pulling through jdbc adpator. and one more double, data type same as general jdbc specifcation or normal text file structure.

Ravi