RE: [SYSTEM21] AFI

["Prill, Steve" <sprill@xxxxxxxxxxxxx>]

We run the CL below from the AS/400 job scheduler each night.  Try
running your AFI manually and see what parameters are in positions
118-119, 770-771, and 809-810.

Copy and compile my CL below and put in your parameters, create a custom
task, and you should be all set.

Hope this helps. 
------------------ 
CHGDTAARA  DTAARA(*LDA (770 2)) VALUE('IN')             
CHGDTAARA  DTAARA(*LDA (809 2)) VALUE('RX')             
CHGDTAARA  DTAARA(*LDA (118 2)) VALUE('YY')             
                                                              
RUNAMTASK  APPL(FI) ENVN(MF4) RLSL(03) TASK(9001) +     
              PGM(FI512CLP) CONO(RX) USER(STEVE)       
-------------------                            
                     

Steve


-----Original Message-----
From: system21-bounces+sprill=rexairinc.com@xxxxxxxxxxxx
[mailto:system21-bounces+sprill=rexairinc.com@xxxxxxxxxxxx] On Behalf Of
Geac User
Sent: Tuesday, August 03, 2004 11:45 AM
To: System 21 Users
Subject: RE: [SYSTEM21] AFI
Importance: High

Nigel is spot on with the clue he gave you.  But loading '&&' won't
resolve the problem for you.  

If you look at what happens when you initially load the job into Machine
Manager (suggest you go and add a dummy entry to follow the example) you
have to define the task entry with && since it uses the EXCAMTASK
command to execute the tasks.  (As Nigel said, tasks less than 99 do not
allow company number to be
specified.) When you then press enter it looks at the task definition
and sees that there is an interactive component on the definition and it
pops up that selection window (same as 3/INW does) and asks you to tell
it what company number you're trying to run the AFI extract for.  Once
you press F8 it captures that LDA information in the Machine Manager
files for later use when the job actually executes that command.

So the '&&' bit isn't really what is used when the job runs but rather
it's the company number stored when the interactive selection screen
pops up and F8 is pressed.

I don't know what your CL is calling to try to make the extract run but
I have a feeling a straight forward call may not cut it.  There are many
program examples of embedded calls to submit a job via the Cross-APPs
submit job facility. (Search for XA902 in your RPG source code for an
example.) With the LDA set just right I believe this simulates the batch
component of the EXCAMTASK command.  

You can issue the EXCAMTASK command directly from inside a batched CL
pgm but only if there is NO interactive component on the task
definition.

Another thought, take a close look at the task definition for 3/INW =
FI/ /03/0046 you will see the initial return code set to 'AM' and that's
also a critical bit.

As a simpler alternative, I would suggest running the MM version more
often to accomplish the same thing. 
Run it every night if you like.  It can't hurt.  And timing isn't an
issue with regard to the rolling of the Inventory calendars, AFI can run
before or after that.

Cheers

--- Rose Clarke <rclarke@xxxxxxxxx> wrote:

> Thanks Nigel, we will try it with '&&' and see if it either solves the

> problem or gives us some more clues.
> 
> Rose.
> 
> -----Original Message-----
> From: system21-bounces@xxxxxxxxxxxx
> [mailto:system21-bounces@xxxxxxxxxxxx] On Behalf Of 
> nigel.ainsworth@xxxxxxxxxxxx
> Sent: 03 August 2004 13:25
> To: System 21 Users
> Subject: [SYSTEM21] AFI
> 
> Rose,
> 
> I presume you are trying to automate the AFI stock movements extract. 
> We also have this as a MNGADEJOB on the job scheduler and it runs 
> fine.
> 
> I think the problem may be in the area of the company number 
> associated with the task. As the task number is below 99 it uses '&&' 
> as the company number.
> Tasks
> under 100 do not require company validation (?)
> 
> This doesn't solve your problem but it might point you in the right 
> direction.
> 
> Kind regards
> 
> Nigel Ainsworth
> 
> I.T.Manager
> Openshaw International Limited
> Tel -   01706 811394
> Fax -   01706 816023
> Email - Nigel.Ainsworth@xxxxxxxxxxxx

> 
> 



                
__________________________________
Do you Yahoo!?
Yahoo! Mail - 50x more storage than other providers!
http://promotions.yahoo.com/new_mail
_______________________________________________
This is the System 21 Users (SYSTEM21) mailing list To post a message
email: SYSTEM21@xxxxxxxxxxxx To subscribe, unsubscribe, or change list
options,
visit: http://lists.midrange.com/mailman/listinfo/system21
or email: SYSTEM21-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/system21.

This email and any attachment are confidential and may be 
legally privileged.  If you are not the intended recipients,
please notify the author by replying to this email message,
and then delete all copies of the email on the system.  If
you are not the intended recipient, you must not disclose,
distribute, copy, print or use this email in any manner.

Email messages and attachments may contain viruses.  Although
we take precautions to check for viruses, we make no assurances
about the absence of viruses.  We accept no liability and suggest
that you carry out your own virus checks.