Hi All,

I have a landing page where users keyin inputs and click on submit the report has to FTP to some shared location.I tried below steps but it seems not working.Any help would highly appreciate.
Here is my code.
-DEFAULT &COUNTRY = 'JAPAN';
-SET &HTMLNAME= '''' | 'USERID.' | &COUNTRY | '.HTMLFILE' | '''';
-SET &FILENAME='CAR_' | &COUNTRY | '.XLS';
-SET &FTPBAT='TREX998.' | &COUNTRY | '.JCL';

TABLE FILE CAR
PRINT
CAR
SALES
BY COUNTRY
WHERE COUNTRY EQ '&COUNTRY'
ON TABLE HOLD AS FINALRPT FORMAT EXCEL
END

-TYPE &HTMLNAME
-TYPE &FILENAME



DYNAM ALLOC F JCL NEW SPACE 1 3 TRACKS LRECL 80 BLKSIZE 80 RECFM FB

-WRITE BATCHJCL //USERIDG JOB (YTTT,84091010),'TEST', +
-WRITE BATCHJCL // MSGCLASS=7,CLASS=F,NOTIFY=USERID
-WRITE BATCHJCL /*JOBPARM CARDS=999999,L=9999
-WRITE BATCHJCL //**************************************************
-WRITE BATCHJCL //**************************************************
-WRITE BATCHJCL //*
-WRITE BATCHJCL //**************************************************
-WRITE BATCHJCL //************************************************
-WRITE BATCHJCL //STEP00 EXEC PGM=IDCAMS
-WRITE BATCHJCL //SYSPRINT DD SYSOUT=*
-WRITE BATCHJCL //SYSIN DD *
-WRITE BATCHJCL DELETE &FILENAME
-WRITE BATCHJCL //*
-WRITE BATCHJCL //STEP01 EXEC PGM=FTP,PARM='(TCP IBMTCPIP)'
-WRITE BATCHJCL //SYSPRINT DD SYSOUT=*
-WRITE BATCHJCL //INPUT DD *
-WRITE BATCHJCL ttcftp01
-WRITE BATCHJCL dhc\ftp-euc
-WRITE BATCHJCL cd \ftp-tnceuc
-WRITE BATCHJCL ascii
-WRITE BATCHJCL dhcommon-0
-WRITE BATCHJCL put &HTMLNAME &FILENAME
-WRITE BATCHJCL CLOSE
-WRITE BATCHJCL quit
-WRITE BATCHJCL end
DYNAM SUBMIT BATCHJCL
-RUN

Thank you

This message has been edited. Last edited by: <Kathryn Henning>,

Hi Souji,

The first thing I would try is to change the output name to match the ddname you are writing to. e.g.
DYNAM ALLOC F BATCHJCL NEW SPACE 1 3 TRACKS LRECL 80 BLKSIZE 80 RECFM FB

If that does not work, try writing the code to an actual file and upload it to this post.

Regards,