Dear community members,
How can I write to a database on iSeries Access. I am able to read and import the data using ODBC on windows.
What functionality are you using?
If you are using the Import Script step successfully, and you have the permissions, you may be able to use the Execute SQL script step (note, this is not the function, ExecuteSQL) to INSERT, UPDATE or DELETE:
You would write SQL calls to the external db source.
Thank you Beverly,
I am going to export updated data into csv or tab file and IBM iSeries Access will pick it up from file.
Server settings don't allow ExecuteSQL type of modification.
I was able to update database directly using ExecuteSQL command.
My original idea of export to csv and then write a routine to update the database was too error prone running two cron jobs.
Thank you a lot.
Kamal, you meant with the Execute SQL script step, right?
History lesson: I used ODBC with Import and Execute SQL script steps long before we had ESS.
It's a do-able solution and I'm glad you got it working!!
Yes, It worked with ExecuteSQL statement.
It writes directly to Access database on IBM server.
Retrieving data ...