Page 2 - Document History
F T P A d a p t e r R e f e r e n c e G u i d e 2 Document History Part Number Product Version Published 528264-001 NonStop Data Transformation Engine 6.7.1 June 2004
Page 3 - Contents; About This Document
F T P A d a p t e r R e f e r e n c e G u i d e 3 Contents About This Document Related References........................................................................................... 5 Chapter 1 - FTP Adapter Overview ...............................................................................
Page 4 - Chapter 5 - Troubleshooting
Contents F T P A d a p t e r R e f e r e n c e G u i d e 4 Chapter 5 - Troubleshooting Adapter Audit Log ........................................................................................... 34 Adapter Trace File.....................................................................................
Page 5 - Related References
F T P A d a p t e r R e f e r e n c e G u i d e 5 About This Document This document contains detailed information about using the FTP Adapter. For general information regarding using any of the Mercator Resource adapters, see the Resource Adapters Reference Guide . This document assumes that the rea...
Page 6 - Chapter 1 - FTP Adapter; Overview; System Requirements
F T P A d a p t e r R e f e r e n c e G u i d e 6 Chapter 1 - FTP Adapter This chapter introduces the File Transfer Protocol (FTP) adapter. You can use this adapter with a Command Server, Event Server, Platform API, or map in a map rule. Overview Use the FTP adapter to transport data. When source da...
Page 7 - About Sockets; Access to International VANs
Chapter 1 - FTP Adapter Access to International VANs F T P A d a p t e r R e f e r e n c e G u i d e 7 About Sockets Windows (NT) or BSD (UNIX) Sockets must be installed on the client computer. ♦ The Sockets installation must support TCP/IP. ♦ The client computer must be able to access an appropriat...
Page 8 - Chapter 2 - Command Alias
F T P A d a p t e r R e f e r e n c e G u i d e 8 Chapter 2 - Command Alias Specify adapter commands by using a command string on the command line or by creating a command file that contains adapter commands. The command syntax is: -IA [alias]card_num -OA [alias]card_num In the command syntax, -IA i...
Page 9 - Chapter 3 - FTP Commands; List of Commands
F T P A d a p t e r R e f e r e n c e G u i d e 9 Chapter 3 - FTP Commands This chapter describes the functions and use of the FTP commands and their options. List of Commands The following table lists valid commands for the FTP adapter, the command syntax, and whether the command is supported ( √ )...
Page 13 - –URL
Chapter 3 - FTP Commands List of Commands F T P A d a p t e r R e f e r e n c e G u i d e 1 3 Code Page Local (-CPL) Use the Code Page Local adapter command ( -CPL ) to specify the code page of the data on the local system (the system on which Mercator is running). Use this command in conjunction wi...
Page 15 - TRANSPARENT; Example; USERLOGON; Adapter Behavior when -FIREWALL Command Present
Chapter 3 - FTP Commands List of Commands F T P A d a p t e r R e f e r e n c e G u i d e 1 5 Option Description SITE USER fw_user, PASS fw_pass, SITE ftp_host, USER ftp_user, PASS ftp_pass TRANSPARENT USER fw_user, PASS fw_pass, USER ftp_user, PASS ftp_pass USER USER ftp_user@ftp_host, PASS ftp_pas...
Page 17 - USERFWPASS
Chapter 3 - FTP Commands List of Commands F T P A d a p t e r R e f e r e n c e G u i d e 1 7 USER ftp_user@ftp_host fw_user PASS ftp_pass USER ftp_user PASS ftp_pass USERFWPASS ♦ Establish a Socket connection to the firewall host ♦ Issue the following command over the connection in this order: USER...
Page 20 - sales
Chapter 3 - FTP Commands List of Commands F T P A d a p t e r R e f e r e n c e G u i d e 2 0 Option Description Note When sending an FTP request to the AS/400, the file must first be created on the AS/400 in order for the len parameter to pad the record correctly. I Image (binary) L8 Local 8-bit ty...
Page 21 - KS
Chapter 3 - FTP Commands List of Commands F T P A d a p t e r R e f e r e n c e G u i d e 2 1 Ignore (-I or -IGNORE) The Ignore command ( -I or -IGNORE ) allows specified FTP error codes to be ignored by the adapter. -IGNORE error_code[:error_code…] Option Description error_code Specify the FTP erro...
Page 22 - LS
Chapter 3 - FTP Commands List of Commands F T P A d a p t e r R e f e r e n c e G u i d e 2 2 List Option (-LS) Use the List Option adapter command (- LS ) to allow files to be retrieved based on a user supplied sorting preference. This command is used in conjunction with the existing FTP URL ( -URL...
Page 23 - MKD
Chapter 3 - FTP Commands List of Commands F T P A d a p t e r R e f e r e n c e G u i d e 2 3 Make Directory (-MKD) Use the Make Directory adapter command (- MKD ) to create a directory. For example, if a file specified in a PUT operation belongs in a directory that does not exist, the –MKD command ...
Page 24 - QTY
Chapter 3 - FTP Commands List of Commands F T P A d a p t e r R e f e r e n c e G u i d e 2 4 By default, the adapter first tries to connect using passive mode; see the Passive Mode adapter command ( -PV ). If the adapter is unsuccessful, it uses port mode. During a port mode connection, the adapter...
Page 26 - STRONG
Chapter 3 - FTP Commands List of Commands F T P A d a p t e r R e f e r e n c e G u i d e 2 6 SSL Encryption Strength (-STR) The SSL Encryption Strength ( -STR ) command can be either WEAK (only use weak algorithms) or STRONG (only use strong algorithms). If not specified, any available algorithm is...
Page 27 - UNIX
Chapter 3 - FTP Commands List of Commands F T P A d a p t e r R e f e r e n c e G u i d e 2 7 During an upload, the FTP server generates a uniquely-named temporary file. When the transfer has completed successfully, the original file is deleted and the temporary file is renamed. For this process to ...
Page 29 - Chapter 4 - Syntax Summary; Data Sources
F T P A d a p t e r R e f e r e n c e G u i d e 2 9 Chapter 4 - Syntax Summary This chapter discusses the FTP syntax summary and how it is used. Data Sources The following is the command syntax of the FTP adapter commands used for data sources: -URL [FTP:[//]][ftp_user[:ftp_pass]@][ftp_host[:ftp_por...
Page 30 - Data Targets
Chapter 4 - Syntax Summary Data Targets F T P A d a p t e r R e f e r e n c e G u i d e 3 0 Data Targets The following is the command syntax of the FTP adapter commands used for data targets: -URL [FTP:[//]][ftp_user[:ftp_pass]@][ftp_host[:ftp_port]] [/[/]][dir/[dir/…]] [filename][;type=xfer_type[+]...
Page 31 - Using FTP Adapter Commands; GET; Examples
Chapter 4 - Syntax Summary Using FTP Adapter Commands F T P A d a p t e r R e f e r e n c e G u i d e 3 1 Using FTP Adapter Commands Use the adapter commands from the Map Designer or Integration Flow Designer as the data source of an input map card and as the data target for an output map card. You ...
Page 32 - CWD; localhost
Chapter 4 - Syntax Summary URL Syntax F T P A d a p t e r R e f e r e n c e G u i d e 3 2 an at sign ( @ ) . Within the user and password field, any : , @ , or / characters must be encoded. See URL Encoding . The url_path of an FTP URL has the following syntax: cwd1/cwd2/.../cwdN/name;type= xfer_typ...
Page 33 - URL Encoding
Chapter 4 - Syntax Summary URL Encoding F T P A d a p t e r R e f e r e n c e G u i d e 3 3 URL Encoding The URL does not need to be completely ‘URL-encoded’. You only need to use escape characters for tokens specifically used in an FTP URL, as shown in the following table. Any FTP URL that contains...
Page 34 - Adapter Audit Log; –AUDIT; Sample FTP Adapter Audit Log
F T P A d a p t e r R e f e r e n c e G u i d e 3 4 Chapter 5 - Troubleshooting For information about error codes and messages returned by the adapters, see Appendix A - Return Codes and Error Messages . Various troubleshooting tools are available in case of problems using the FTP adapter for data s...
Page 35 - Adapter Trace File; Sample FTP Adapter Trace File
Chapter 5 - Troubleshooting Adapter Trace File F T P A d a p t e r R e f e r e n c e G u i d e 3 5 Adapter Trace File The adapter trace file contains detailed information provided by the adapter and records the actions taking place such as connections established and statements executed. The trace f...
Page 37 - Appendix A - Return Codes and Error; Messages
F T P A d a p t e r R e f e r e n c e G u i d e 3 7 Appendix A - Return Codes and Error Messages Return codes and messages are returned when the particular activity completes. Return codes and messages may also be recorded as specified in the audit logs, trace files, execution summary files, etc. Me...
Page 39 - Index
F T P A d a p t e r R e f e r e n c e G u i d e 3 9 Index . .log file, 34 .mtr, 34 A Account ( -AC or -ACCT ) adapter command, 11 adapter trace file, 35 alias, 8 Audit ( -A or -AUDIT ) adapter command, 11 audit log, 34 C Certificate Authority ( -CA ) adapter command, 12 Client Certificate ( -CERT ) ...