RE: Found: peculiar behavior w/ CPYTOIMPF

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

More info...

APAR SA78784 describes the Alias in QTEMP problem.  No listed PTFs.

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



-----Original Message-----
From: DeLong, Eric [mailto:EDeLong@sallybeauty.com]
Sent: Friday, December 20, 2002 10:50 AM
To: 'midrange-l@midrange.com'
Subject: Found: peculiar behavior w/ CPYTOIMPF


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



_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
or email: MIDRANGE-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.