›> ›> Import Data using CRTCNNIMP

Import Data using CRTCNNIMP

7th October 2015

Updated: 06/20/2016

In 4 simple steps we will import IFS data into EXTOL EDI Integrator. This process is very handy when the data is not received via VAN; ie. Email.

In our example below, we will FTP data to the iSeries and place it into the IFS directory. Once the data is in the IFS directory we will use CMD: CPYFRMSTMF and CMD: CRTCNNIMP to place the data into the EXTOL Mailroom, as a Mailroom Connection.


STEP 1:

FTP Data to iSeries’ IFS Directory

STEP 2:

CRTPF FILE(QTEMP/TEMP) RCDLEN(1024)

STEP 3:

CPYFRMSTMF tombr(’/qsys.lib/qtemp.lib/temp.file/temp.mbr’) fromstmf(’/extol/raw.txt’) MBROPT(*REPLACE) ENDLINFMT(*FIXED) TABEXPN(*NO)

Note: you will have to modify the fromstmf parm

STEP 4:

CRTCNNIMP FILE(QTEMP/TEMP) FORMAT(*UNWRAP) NETID(LOWES850).

CRTCNNIMP Notes:

FORMAT(*UNWRAP) – Many times the data we import into EXTOL will be unwrapped (1 record per segment). If this is the case we want to specify *UNWRAP.

NETID(LOWES850) - optional -  This is a cool trick to allow users to quickly identify data in the mailroom. Let’s say the data is for Lowes850, we would use NETID(LOWES850). When we go into the EXTOL Connections screen we would see LOWES850 under the Network Column.


By: on