Read iSeries Data and write them into SQL-Database

[Tobias Hammerschmidt]

Hello,

how can i read Data from an iseries server and write them into a sql database (same db structure) ?

should i create the reading funtion in my iseries environment model and call a meta defined function which inserts the data in the sql server or should i read the iseries data in my sql environment model and write them into the sql db?

i dont understand how the client function (c++) can seperate between iseries function (RPGIV) to read the data and sql (c++) function to write the data... can i control this with the "language" triple in plex?

i successfully called a cl programm on the iseries from an c++ function in an other functionality.
can i make it the same for my actual problem?

thanks for your help.

tha

[George Jeffcock]

See plex help "Connecting to Multiple Databases"

[Tobias Hammerschmidt]

thanks for your reply but this chapter describes the following:

[font=Courier New]An AllFusion Plex application can hold multiple concurrent connections to one or more databases open. The databases can be from the same or different vendor but must be accessed by C#, Java, OLE-DB, WinC, or WinNTC functions.[font]

but i want to acces iseries (RPG FNC) and sql...


i think this can help. i try: Chapter 10: Dynamic Application Partitioning

greets, tha

[Tobias Hammerschmidt]

it works. thanks for the tip in the online help of plex.
problem solved!
greets, tha