Create PF in SVR - Additional Parameters

[mnarewec]

Hi list
I believe something is wrong when creating a PF in SVR. The file Once ...
OVRDBF FILE(F56SSM) SHARE(*YES) ... in CL cannot be Access by the RPG
program. It comes up with dump message - File is is already OPEN or there
is an error. First I think it was the Dream Writer Specifications but I
want to be sure it is not caused by the "Additional Parameters" when
creating PF.

THanks


Cheers!
___________________
Marsh R Narewec
STC Computer Services

 

[Dave Kahn...]

Marsh, Are you running this program interactively? If so I think the most likely reason for the error message is that it is telling you the truth and the file is already open within your job.

This message often occurs when you are testing an RPG program under Dream Writer interactively, possibly in debug mode. If for any reason the program terminates abnormally, the next time you try to run it you get this message. You can try the following steps in this order:

1. Simply run it again. Often the file gets closed as the error message is generated.

2. Explicitly close the file from the command line using CLOF F56SSM.

3. The old favourite: sign off and on again. This usually works although it can be a bit of a pain.

 

[mahdy]

Missing columns in JDE 8.11 for F4211 and F42119

Can anyone help me? I have to convert an existing data warehouse extraction routine from our B733 system to a new 8.11 system.Some columns seem to have disappeared in these two tables F4211 and F42119.
These columns are
SDBALU,
SDPSDJ,
SDDSPR,
SDDSFT,
SDFAPP,
SDPRMO,
SDDFTN,
SDCDCD,
SDCOT,
SDAFT,
SDFUF1,
SDFRTC,
SDFRAT,
SDRATT,
SDCMGL,
SDSTTS,
SDSLSM,
SDSLCM,
SDSLM2,
SDSLC2,
SDANI,
SDAID,
SDOMCU,
SDOBJ,
SDSUB,
SDLT
Thank you

 

[Its not on sale]

Make sure in your CL before it finishs you specify CLOF <Filename>. What OS400 is trying to tell you that file is already open and it is set to share its path. If you try to open it again it will fail. If you get this message while in the interactive session issue CLOF <filename> and you will get over this problem. In normal situation in your CL you should do CLOF before ending the CL.

Hope this helps.

Adios

 

[DVerner]

Re: Missing columns in JDE 8.11 for F4211 and F42119

F42119 is a flex file. You get to choose some of the columns (fields) that
goes into that file.

There is a program to create the flex file. I would guess there are a bunch
of warns about when you should and shouldn't change the file.

I would advise read , re-read, ask question and then proceed cautiously
before changing the flex files.









mahdy
<f_mahdy@caramail. To: [email protected]
com> cc:
Sent by: Subject: Missing columns in JDE 8.11 for F4211 and F42119
jdeworld-bounces@j
delist.com


08/24/2005 02:38
PM
Please respond to
JD Edwards® World






Can anyone help me? I have to convert an existing data warehouse extraction
routine from our B733 system to a new 8.11 system.Some columns seem to have
disappeared in these two tables F4211 and F42119.
These columns are
SDBALU,
SDPSDJ,
SDDSPR,
SDDSFT,
SDFAPP,
SDPRMO,
SDDFTN,
SDCDCD,
SDCOT,
SDAFT,
SDFUF1,
SDFRTC,
SDFRAT,
SDRATT,
SDCMGL,
SDSTTS,
SDSLSM,
SDSLCM,
SDSLM2,
SDSLC2,
SDANI,
SDAID,
SDOMCU,
SDOBJ,
SDSUB,
SDLT
Thank you

 

[peterban]

Re: Missing columns in JDE 8.11 for F4211 and F42119

Hi mahdy,

apart from this is the wrong forum for your question.....

The differerence you are seeing is JDE/Ocl/Psft rationalising the product and so have GONE from these files and MAY NOT exist in distn at all.

Warm regards

Peter

 

[Dave Kahn...]

This is basically sound advice but a few things could be clarified.

1. You only need to do a CLOF when you explicitly open the file in the CL, usually with a shared open data path and OPNQRYF. In JDE this nearly always means you are running under DreamWriter, and the JDE standard CL code usually does a good job of tidying up after itself. You can generate a standard CL program yourself by running the Quick Start CL Generator from menu G93/5.

2. You should really be running these jobs in batch, so it normally doesn't actually matter that much if the files get left open at job end as the open data paths disappear with the job.

3. This problem occurs quite frequently in testing as the programmer runs the DreamWriter interactively in order to use the interactive debugging facilities. If the programmer terminates the program using the debugger the CLOF in the CL gets bypassed anyway, so doesn't really help. The answer in this situation when debugging is to close the file explicitly by executing a CLOF from the command line.

 

[mnarewec]

Dave.. thanks to you input.

I am actually running this job in batch. But it causes this dump and ends
the program abnormally. Actually I clone this CL from a WORKING "live" CL
and just changing the File Name and RPG program Name. The Dream Writer
Parameters are Several times reviewed to be ok.

(BTW, I have been doing that all the time in my other programs and they are
working fine). It just that the file concern is coded/compile by my
"Systems Analyst". And therefore, I am thinking that there are "additional"
parameters were not set when creating this PF.

I believe the problem is caused when RPG tries to open/use it. But it is
SHARED in CL and therefore, there should be no problem. And also it should
be closed when the job ends.

This thing is making me go NUTS.



Cheers!
___________________
Marsh R Narewec
STC Computer Services



"Dave Kahn..."
<david.kahn@stoltoff To: [email protected]
shore.com> cc:
Sent by: Subject: Re: Create PF in SVR - Additional
jdeworld-bounces@jde Parameters
list.com


26/08/2005 04:56
Please respond to JD
Edwards® World






This is basically sound advice but a few things could be clarified.

1. You only need to do a CLOF when you explicitly open the file in the CL,
usually with a shared open data path and OPNQRYF. In JDE this nearly always
means you are running under DreamWriter, and the JDE standard CL code
usually does a good job of tidying up after itself. You can generate a
standard CL program yourself by running the Quick Start CL Generator from
menu G93/5.

2. You should really be running these jobs in batch, so it normally doesn't
actually matter that much if the files get left open at job end as the open
data paths disappear with the job.

3. This problem occurs quite frequently in testing as the programmer runs
the DreamWriter interactively in order to use the interactive debugging
facilities. If the programmer terminates the program using the debugger the
CLOF in the CL gets bypassed anyway, so doesn't really help. The answer in
this situation when ! debugging is to close the file explicitly by
executing a CLOF from the command line.


Dave... Any views expressed are my own and do not necessarily reflect those
of Stolt Offshore

 

[mahdy]

Re: Missing columns in JDE 8.11 for F4211 and F42119

Thanks for the answer!Still, I'm quite new with JDE and I'm not sure to get what a flex file is...Are F4211 and F42119 customized tables or original standard tables?What is this program you had mentioned??Do u have any idea where the information that was in these columns might be??

I know it's a lot of question

 

[Dave Kahn...]

Marsh,

I don't think it can be due to the way the file itself was compiled. Whatever parameters were used it is still an OS/400 database file, and RPG running under DreamWriter should be able to handle it.

As this is happening in batch the most likely explanation is a mis-match between the way the file is defined in the RPG program (with or without a key), the DreamWriter sequence options, and the Open Query File Options in the DreamWriter Additional Parameters. A mis-match here often generates message ID CPF4123 in the job log. What is the ID of the CPF message you are actually seeing?

 

[John_Dickey]

RE: Missing columns in JDE 8.11 for F4211 and F42119

There is a separate list for One World users. This is the JDE World list
and there is a good amount of difference between the two software versions.
You would be better off posing these questions to the One World list.

John Dickey
JDE Financial Systems Administrator/Analyst
White-Rodgers, division of Emerson Electric
8100 West Florissant, P.O. Box 36922
St. Louis, MO 63136
314-553-3067

 

[DVerner]

Re: Missing columns in JDE 8.11 for F4211 and F42119

F4211 is a "original standard table"

F42119 is a "flex file" (table), where some of the fields that is in th e
F4211 are "optional".

Another person so kindly pointed out, it would be best to throw this
question out to the OneWorld forum.

From a "JDE World" point of view there are programs to setup the flex f iles
optional fields (columns) & then programs to rebuild the flex files.
The thought being less fields less disk space, too few fields not enoug h
information.
FYI: The flex files that I am aware of are Sales header, detail, & ledg er
and Purchasing ledger.






mahdy
<f_mahdy@caramail. To: jdelistsubscribers @jdelist.com
com> cc:
Sent by: Subject: Re: Missing c olumns in JDE 8.11 for F4211 and F42119
jdeworld-bounces@j
delist.com


08/26/2005 10:43
AM
Please respond to
JD Edwards=AE World






Thanks for the answer!Still, I'm quite new with JDE and I'm not sure to get
what a flex file is...Are F4211 and F42119 customized tables or origina l
standard tables?What is this program you had mentioned??Do u have any i dea
where the information that was in these columns might be??

I know it's a lot of question (Embedded image moved to file: pic23805.g if)

 

[mnarewec]

Dave,
You're correct !!. Thanks heaps. Yes in Additional Parameters in DW, I
select "Y" for Sequential Only in Open Query File Options. And In RPG I
have open the File as Key File i.e. "K" in RAT option. BUT the PF has NO
Key. I use one of its logical and it is now working perfectly.




Cheers!
___________________
Marsh R Narewec
STC Computer Services

 

[Dave Kahn...]

Excellent! As long as you can get the program to compile it shouldn't matter that the physical file is arrival sequence. DreamWriter builds the access path for you and the file effectively becomes a keyed one at run time.