SELECT 'JOB' as "KEY",
'eText_Job' TEMPLATE,
'ETEXT' TEMPLATE_FORMAT,
'en-US' LOCALE,
'TEXT' OUTPUT_FORMAT,
'JOB_FTP' output_name,
'FTP' DEL_CHANNEL,
'INTERFACE_TEST' PARAMETER1,--server name set on xmlpserver as admin
'userid' PARAMETER2,--userid
'password#1234' PARAMETER3,--password
'/DIR_TEST/FOLDER' PARAMETER4,--file path
'JOB_FTP.txt' PARAMETER5,--file name
'true' PARAMETER6--secure ftp or not
FROM dual
'eText_Job' TEMPLATE,
'ETEXT' TEMPLATE_FORMAT,
'en-US' LOCALE,
'TEXT' OUTPUT_FORMAT,
'JOB_FTP' output_name,
'FTP' DEL_CHANNEL,
'INTERFACE_TEST' PARAMETER1,--server name set on xmlpserver as admin
'userid' PARAMETER2,--userid
'password#1234' PARAMETER3,--password
'/DIR_TEST/FOLDER' PARAMETER4,--file path
'JOB_FTP.txt' PARAMETER5,--file name
'true' PARAMETER6--secure ftp or not
FROM dual