Browse categories
Explore
Fiverr Pro
English
$
USD
I will write db2 for i sql queries, reports and data exports for IBM i as400
Dodik S
About this gig
Need data out of your IBM i (AS/400) quickly and correctly? I write SQL for Db2 for i every day.
I am an IBM i developer with 7 years of production experience in core banking, working with Db2 for i tables that hold millions of records.
What I can do:
- SQL queries for reports, reconciliation and data checks
- Joins across physical and logical files, CTEs, OLAP functions (ROW_NUMBER, RANK, running totals)
- Data export to CSV or JSON (JSON_OBJECT, JSON_ARRAYAGG), or data import from JSON (JSON_TABLE)
- SQL scripts for data correction, written safely: a SELECT to preview the rows first, then the UPDATE, run by you
- SQLRPGLE programs or printer file reports when the query must run as a job
- Useful IBM i services (QSYS2) for object, job and spool information
How I work:
- I confirm the expected result with you before writing the final query
- You get the SQL with comments, how to run it (ACS Run SQL Scripts, STRSQL or RUNSQLSTM), and sample output
- Queries are read-only unless you ask for a change script
Send me a message with your file layouts if you are not sure which package fits.
Get to know Dodik S
Dodik S
IBM i AS400 RPGLE Developer, SQL, CL and DDS
- FromIndonesia
- Member sinceSep 2026
- Avg. response time3 hours
Languages
English, Indonesian
IBM i (AS/400) developer with 7 years of production experience in core banking. I write and maintain RPGLE, SQLRPGLE, CL and DDS on a live system every day, from old fixed-format code to modern free-format RPG, ILE service programs and REST/JSON integrations. I fix bugs, add features, build screens and reports, and write SQL for Db2 for i. I read your code before changing it, mark every change, and deliver the source with compile steps and test notes. No production changes without your approval.
Other Software Development Services I Offer
FAQ
Can you connect to my database and run the query?
I can work from your file layouts (DSPFFD or DDL) and sample data, then you run the query. If you give me read-only access to a test system, I can also test it there.
Can you write UPDATE or DELETE statements?
Yes, as a script with a preview SELECT first. You review and run it yourself, so nothing changes without your approval.
What output formats can you provide?
Screen result, CSV, JSON, a spooled report (printer file), or a table in a library you choose.
