F986110 and JCSRVBLOBA

[Tom_Davidson]

Does anyone have the layout of the blob field in F986110, or know where I
can find it?

I need to retrieve the name of the member the PDF is stored in on my AS/400
and can see it in this BLOB. I would like to write a program to retrieve
it, but am afraid that some of the information precedind the name are
actually offsets to the start of information.

I really do not want to re-write the program from SP to SP or version to
version if I can help it.

TIA

Tom Davidson

Xe Update 1; SP 17.1D; AS/400; CO on SQL 7; TSE Metaframe 1.8a



OW 7332 SP 11.3VER, NT 4.0 SP 5, TSE 4.0 SP 4, Metrframe 1.8, CO SQL 7.0

 

[Z_Cader]

Here is the magic .....

When you submit the job system assigns a job number. you can find the job number in the F986110 file. at the same time a member is added to PRINTQUEUE PF for the job. usually the member naming convention is Fnnnnnnn ( where nnnnnn - Job number ) Actually it is in PDF format. if you want you can generate in CSV file as well.

Zakeer

 

[Tom_Davidson]

Zakeer,

number )

It's the 'usually' thats the problem. Sometimes it starts with a 'D' or
'T', I know the offset in the F986110 that the member name exists today.
What I am trying to confirm is that when the next version/SP comes out it
doesn't move.

Often in C programming, you have a table at the beginning of a space that
gives you the offset to the various information in the object. If you
program using this offset, you are guaranteed that you will always be able
to find the information. Normally this is done to ensure backward
compatability. If JDE does not use the offsets in the blob, then I won't
bother to code for them, it it does, I want to code for them, so I don't
have to code again. My appologies to whoever said 'Stop me before I xxx
again .

Tom Davidson
Xe Update 1 SP 17.1D; AS/400; CO on SQL 7; TSE Metaframe 1.8a.





OW 7332 SP 11.3VER, NT 4.0 SP 5, TSE 4.0 SP 4, Metrframe 1.8, CO SQL 7.0

 

[Z_Cader]

Tom,

I am just curious what is the requrment to access the blob. ? are you planning on redirecting the output to another system ?

Zakeer

 

[Tom_Davidson]

Zakeer,

planning on >>redirecting the output to another system ?

Yes, I would like to copy the member to a text file that can be e-mailed
or faxed. This requires me to know the member name. I'd copy it to a pc
document (CPYTOPCD) and use it as an attachment. Using this method, I pick
up all the formatting my developers have invested in each report,
especially on customer facing documents.

Tom Davidson
Xe Update 1 SP 17.1D; AS/400; CO on SQL 7.0; TSE Metaframe 1.8a



OW 7332 SP 11.3VER, NT 4.0 SP 5, TSE 4.0 SP 4, Metrframe 1.8, CO SQL 7.0