[Date Prev][Date Next][Thread Prev][Thread Next]
[SQRUG Home Page]
Re: This may not a related question to SQR
- Subject: Re: This may not a related question to SQR
- From: Anne-Marie Matula <amatula@OIT.UMASS.EDU>
- Date: Fri, 23 Jun 2000 08:47:27 -0400
- Importance: Normal
- In-reply-to: <200006230600.AAA26923@list.iex.net>
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
Hope that helps,
Student Information System Project
Office of Information Technologies
University of Massachusetts
161 Whitmore Administration Building
Amherst Massachusetts, 01003-8165
> 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: firstname.lastname@example.org
> > > 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