FREE DDS to SQL conversion tool for the IBM i 


Globally and easily create SQL for your IBM i database files 

For V6R1 and above 

Command: CRTSQL
Library: EPICRTSQL

Use it for free with the compliments of EPI

IBM i DDS to SQL conversion 

IBM i SQL creation

IBM i SQL tool


To Install using FTP

 

[ Click here to download the save file ]

On the IBM i

1) CRTSAVF QGPL/EPICRTSQL

From a Windows command line:

2) FTP IBMisystemname
ftp> Sign in with your user name and password
ftp> binary (set to binary mode)
ftp> PUT DESKTOP/EPICRTSQL.SAVF QGPL/EPICRTSQL

On the IBM i

3) RSTLIB SAVLIB(EPICRTSQL) DEV(*SAVF) 
         SAVF(QGPL/EPICRTSQL)

To run the command:

4) EPICRTSQL/CRTSQL and press F4 to prompt

To activate:

When you run CRTSQL for the very first time it will require 
to be activated. Contact EPI support@epi-software.com  
for your password when requested. 

 

Need help? [ View the install tutorial video here ]

 

Installing from the CD download

 

[ Click here to download the burnable CD file ]

To install CRTSQL on your IBM i:

Using Windows:

1) Burn the unzipped EPICRTSQL file to CD and finalize it.

On the IBM i

2) RSTLIB SAVLIB(EPICRTSQL) DEV(OPT01)

To run the command:

3) EPICRTSQL/CRTSQL and press F4 to prompt

To activate:

When you run CRTSQL for the very first time it will require 
to be activated. Contact EPI support@epi-software.com  
for your password when requested.

 

Need help? [ View the install tutorial video here ]