CPYTOIMPF SQLCLI failures - was Batch file transfer with Client Access

Hi Rob,

You have previously run a command / program in the job that uses SQLCLI.

CPYTOIMPF (& CPYFRMIMPF I think) does not play well with fellow users of SQLCLI in the same job that leave environments, connections etc around for performance reasons. For example BRMS uses some in reports & there is an APAR saying permanent restriction regarding this.

We have tilted at that windmill for our own reasons previously.

We have requested that these commands be insulated from all previous SQLCLI use & been denied.

We have then requested a list of commands that have similar issues, but have been told that this is an "implementation detail" that cannot be relied on not to change.

Regards,

Kevin Wright

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of rob@xxxxxxxxx
Sent: Friday, 26 August 2011 6:37 AM
To: Midrange Systems Technical Discussion
Subject: Re: Batch file transfer with Client Access


Tried to duplicate this again to go over it with you, but,
once again, it
has issues:

CPYTOIMPF FROMFILE(GDIDIVF/IIM) TOSTMF('/ROB/IIM.CSV')
STMFCCSID(*PCASCII)
RCDDLM(*CRLF) FLDDLM(*TAB)
Ownership of object QCPEXTEMPS in QTEMP type *USRSPC changed.
Ownership of object QACP877218 in QTEMP type *USRSPC changed.
Ownership of object QACEXFLD12 in QTEMP type *USRSPC changed.
Error occurred in SQL Call Level Interface
Error occurred in SQL Call Level Interface
No records copied from file IIM in GDIDIVF.
Copy command ended because of error.

Message . . . . : Error occurred in SQL Call Level Interface
Cause . . . . . : A procedure call encountered an error.
The error code
is
10. Error codes are:
10 -- Function sequence error.

From program . . . . . . . . . : QSQCLI
From library . . . . . . . . : QSYS
From module . . . . . . . . : SQLSEA
From procedure . . . . . . . : SQLSetEnvAttr
From statement . . . . . . . : 12449

To program . . . . . . . . . . : QCPEXPRT
To library . . . . . . . . . : QSYS
To module . . . . . . . . . : QCPEXPRT
To procedure . . . . . . . . : Copy_The_Records
To statement . . . . . . . . : 157


Rob Berendt