×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
CREATE TABLE DBMSTF/FTPSITES (
FTPSITEKEY CHAR(20) CCSID 37 NOT NULL DEFAULT '' ,
FTPSITE CHAR(60) CCSID 37 NOT NULL DEFAULT '' ,
RMTDIR CHAR(60) CCSID 37 NOT NULL DEFAULT '' ,
RMTUSRID CHAR(40) CCSID 37 NOT NULL DEFAULT '' ,
RMTPWD CHAR(40) CCSID 37 NOT NULL DEFAULT '' ,
FTPPASV CHAR(1) CCSID 37 NOT NULL DEFAULT '' ,
FTPPORT CHAR(5) CCSID 37 NOT NULL DEFAULT '' ,
PRIMARY KEY ( FTPSITEKEY ) )
NOT VOLATILE
RCDFMT FTPSITESRC ;
LABEL ON TABLE DBMSTF/FTPSITES
IS 'FTP Sites' ;
LABEL ON COLUMN DBMSTF/FTPSITES
( FTPSITEKEY IS 'FTP Site ID' ,
FTPSITE IS 'FTP Site' ,
RMTDIR IS 'Remote Directory' ,
RMTUSRID IS 'Remote User ID' ,
RMTPWD IS 'Remote User Password' ,
FTPPASV IS 'Use Passive Mode' ,
FTPPORT IS 'FTP Port' ) ;
LABEL ON COLUMN DBMSTF/FTPSITES
( FTPSITEKEY TEXT IS 'FTP Site ID' ,
FTPSITE TEXT IS 'FTP Site' ,
RMTDIR TEXT IS 'Remote Directory' ,
RMTUSRID TEXT IS 'Remote User ID' ,
RMTPWD TEXT IS 'Remote Password' ,
FTPPASV TEXT IS 'Use Passive Mode' ,
FTPPORT TEXT IS 'Port To Use' ) ;
And here's the index I created over it:
CREATE INDEX DBMSTF/FTPSITES1
ON DBMSTF/FTPSITES (FTPSITE) ;
RPG handles it fine. I'm on V5R4.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
