On 13-Dec-2011 05:22 , Silenus paparias wrote:
>
> With FTP I can transfer Physical Files which are on LIBS to PC as
> txt format, but the files are not readable!
The term "physical file" is very nebulous. For a "source physical
file", which is intended to contain "text" data, the "PF-SRC" data in
the members will transfer as record-delimited data with expected
translation, given the CCSID properly identifies the data within.
> I think the PFs must be first converted from EBCDIC to ASCII, with
> CPYTOPCD in QDLS and then transferred with FTP to a PC?
While deprecated, that may be an option. Though once in /QDLS file
system, the PC should be able to use the old client mapping to map the
old 8.3 file system; i.e. the PC can "see" and thus access the file on
the mapped drive, so no FTP would be required.
Again, that depends greatly on what the "physical files" actually
are. If they are PF-DTA "flat files" [files not externally described],
copying the data to any text stream or fixed-record-length file for
which CCSID tagging is enabled could be another option.
> (OR IS THERE A ANOTHER WAY ???)
Before making a good recommendation, I think knowing a specific
example of the file definition might be necessary.
More generically, a database file with multiple column\field
definitions which is not a "source physical file" [or "source logical
file"] should first be "exported", then the "exported text data"
transferred. If the physical file is a "source physical file", then
presumably the file needs to be tagged with the appropriate CCSID [and
perhaps data corrected to match]; CHGPF SRCFILE(*NONE) CCSID(_theCCSID_)
would assign a CCSID to the file, but would not change nor correct any
of the data to match the CCSID being assigned.
If an intermediate copy is made from a non-described\flat file,
instead of the old 8.3 [/QDLS Folder and DLO] file, using another stream
file support is recommended. CPYTOSTMF [and I think CPY] into a
directory other than /QDLS may be an option. Then like with /QDLS, the
PC can map a drive to the folder. Or using /QNTC, the data can be
copied into a file created on the share which defines that PC.
> If so, How can access with FTP the folders which are on QDLS to put
> or get txt files ?
To use /QDLS, set that as the directory of IFS to\from which the FTP
refers to the path and file name. Also the user would have to be added
to the system directory; ADDDIRE. For FTP PUT from the client to the PC
with an FTP server, the LCD subcommand can set the current directory for
the session into the QDLS: LCD /QDLS For FTP GET from the PC client,
the CD subcommand can set the current directory at the server for the
session: CD /QDLS
Regards, Chuck