QDLS doesn't support "Multi Threading"

[minishoppe]

Hi All,

I am using Scott Klement API's for creating the excel sheet by calling POI classes in RPG program and its working fine and creating spreadsheet in IFS but after that when I try to email using SNDDST and in order to do that I am copying that file from IFS to folder and /QDLS filesystem, because that filesystem (which was designed for the S/38 back in the 80's) can't handle multi-threaded access. It would cause the filesystem to be corrupt.

I am getting this error:

CPFA0A8 received by procedure PICMN5520. (C D I R)
C
Application error. CPFA0A8 unmonitored by PICMN5520 at statement
0000008700, instruction X'0000'.
Function check. CEE9901 unmonitored by PICMN5500 at statement 0000001646
instruction X'0000'.
Message 'CEE9901' in called program 'PICMN5520' (C D F G).
C
Message ID . . . . . . : CPFA0A8 Severity . . . . . . . : 40
Message type . . . . . : Escape
Date sent . . . . . . : 03/29/12 Time sent . . . . . . : 07:32:52

Message . . . . : Operation not allowed in a job running multiple threads.
Cause . . . . . : An operation was attempted on an object residing in a file
system that is not threadsafe.
Recovery . . . : Either retry the operation in a job that is not running
multiple threads, or retry the operation on an object residing in a file
system that is threadsafe.


Please advise if you guys have any solution other using any third party utility like MMAIL and other JAVA API's.

Thanks in advance

[GLS400]

Re: QDLS doesn't support "Multi Threading"

Hi minishoppe:

If you're stuck with snddst you need to break this into 2 seperate programs.
1. create the xls
2. send the xls

It's far easier to grab some other works by scott
http://www.code400.com/forum/showthr...l-(attachments)

Qtmmsendmail can send attachments and run in a multi-threaded environment

Best of Luck
GLS

[tomholden]

Re: QDLS doesn't support "Multi Threading"

you simply will not be able to use QDLS for this...unless you create the file in a multi-threaded job, submit a new job that isn't multi-threaded to copy the .xls to QDLS. however if you are creating a .xlsx file QDLS is totally out since QDLS only supports 8.3 file names. regardless of your aversion to using MMAIL (or other tools including a "roll your own" solution using the QtmmSendMail API) you'd better move away from QDLS & SNDDST since you'll soon have to use extensions longer than 3 characters, require longer file names than 8 characters, etc.