JDBC Adaptor

[Former Member]

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

[bhavesh_kantilal · Accepted solution]

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 · Accepted solution]

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 · Accepted solution]

Jai,

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

Regards

Bhavesh

[MichalKrawczyk]

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]

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