Re: This may not a related question to SQR

[Anne-Marie Matula <amatula@OIT.UMASS.EDU>]

Sorry for the late delay.  I receive these in digest mode.

Can you merge all you files into one file so you only need to run the main
sqr (step 1) once?  You can call a batch file within your first sqr to do
the merge or do it outside the sqr.

Also I might suggest getting on the PS Users listserv - that is dedicated to
PeopleSoft related technical questions.  You may get more ideas for
resolving this.

Hope that helps,
Anne-Marie

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Anne-Marie Matula
Student Information System Project
Office of Information Technologies
University of Massachusetts
161 Whitmore Administration Building
Amherst Massachusetts, 01003-8165
Phone: 413/577-0685
Fax: 413/545-2150

> Date:    Thu, 22 Jun 2000 09:30:44 -0400
> From:    "PHUNG, BINH" <BPHUNG@FINEHOST.COM>
> Subject: Re: This may not a related question to SQR
>
> The main.sqr will be repeating the process as many time as there are files
> that it finds.
> So won't  i just need to schedule the main.sqr in the Process
> scheduler and
> have it call the other sqr from it?
>
> > -----Original Message-----
> > From: Anne-Marie Matula [SMTP:amatula@OIT.UMASS.EDU]
> > Sent: Thursday, June 22, 2000 9:03 AM
> > To:   SQR-USERS@list.iex.net
> > Subject:      Re: This may not a related question to SQR
> >
> > More info on this:
> >
> > Go to the Process Scheduler in PS.  Add a Job Definition that runs the 3
> > processes you mentioned in the correct order.
> >
> > Hope that helps... I suspect however things may be complicated than I
> > infer
> > from reading your post!  Good luck!
> >
> > Have a great day!
> > Anne-Marie
> >
> > > Date:    Wed, 21 Jun 2000 11:38:01 -0700
> > > From:    "Peter R. Lewandowski" <peter.lewandowski@CSUN.EDU>
> > > Subject: Re: This may not a related question to SQR.
> > >
> > > Did you look into using Process Groups within PeopleSoft?  It
> > > creates some dependency.
> > >
> > > Date sent:              Wed, 21 Jun 2000 14:11:32 -0400
> > > Send reply to:          sqr-users@list.iex.net
> > > From:                   "PHUNG, BINH" <BPHUNG@FINEHOST.COM>
> > > Subject:                This may not a related question to SQR.
> > > To:                     SQR-USERS@list.iex.net
> > >
> > > > I am using PeopleSoft7.52 on NT with SQL7.0.
> > > > Currently we are using the EDI Manager to input vouchers into
> > > PeopleSoft.
> > > > There are three steps:  step1 is an sqr and it reads the Input file
> > and
> > > > writes it out to an Output file formated for Step 2. Step 2 is
> > > also an sqr
> > > > and was developed by PS. It reads the output file from step 1
> > > and pushes it
> > > > to the staging table. The third step is a PSJOB class which posts or
> > > > something like that.
> > > > My question is can i automate these steps to be kicked off from one
> > sqr.
> > > > Have the sqr find the files to be inputed and pass the file name to
> > the
> > > > steps. Or do i have to insert the filename into the fields of the
> > steps?
> > > > I plan to use the process scheduler to schedule the main sqr.
> > > > Any hint and ideas would be great.
> > > > TIA
> > > > Binh