Found: peculiar behavior w/ CPYTOIMPF

["DeLong, Eric" <EDeLong@xxxxxxxxxxxxxxx>]

Hey folks,

Just wanted to pass on the fruits of some research.  We've had recurring
problems with an email command option that uses CPYTOIMPF to email data from
our /400.   When emailing a file from a job's QTEMP library, if the
CPYTOIMPF command was given a member name other than *FIRST (command
default), then the CPYTOIMPF command will fail to copy any data to the
import file.  I have concluded that the problem occurs because:

1) When CPYTOIMPF is supplied a member name, it tries to create an SQL alias
that points to the specified member.
2) SQL will create the alias object (type *DDMF) but will NOT register the
alias in the system database cross-reference.
3) CPYTOIMPF looks for the alias entry in the system database xref, and
cannot find the entry, so issues SQL0204.
4) Procedure "Copy_The_Records" fails and issues SQ99999 (*diag) reporting
CLI error (type 10 - function sequence error).

Ultimately, it appears that the CPYTOIMPF commands will FAIL for any QTEMP
file specified by member.

This was identified on V4R4.  V5 does not exhibit this behavior.

Eric DeLong
Sally Beauty Company
MIS-Project Manager (BSG)
940-898-7863 or ext. 1863