Barbara & Steve: Good book. It's one that we're reviewing right now as a possible next eStudy Group. It's part of that list I posted a while back - which I'll...
2081
Douglas Nichols
drnichols@...
Apr 3, 2000 4:29 pm
There is a way to set the Process Scheduler on NT up as a NT service. This means you don't have to have somebody logged in all day. The directions for setting...
2082
Todd Kurlowski
tkurlowski@...
Apr 3, 2000 4:30 pm
The following has worked for us on NT and 95. First get the path and name to the command interpreter. Append the /c flag. Add your command after that. In...
2083
Amy Harvel
aharvel@...
Apr 4, 2000 3:23 pm
I have two SQR's I need to run in order; the first SQR must run on the Client (NT), once it completes it should kick off the second SQR on the Server (UNIX). I...
2084
cwhite@...
Apr 4, 2000 3:50 pm
I would like the names of folks who have implemented also. Thanks. "Bryan deSilva" <improvisations@...> on 03/30/2000 11:42:47 PM Please respond to...
2085
Manoj Gurjar
mgurjar@...
Apr 4, 2000 3:50 pm
It is Entity-Relation Diagram. Problem is if you print, it breaks down to number of pages and then we have to use some tapes to stick them in order. Its a...
2086
Victor Loghin
vgl_ca@...
Apr 4, 2000 4:50 pm
SQR Study Group, I want to use the on-break to signal a change in the pay line when selecting from the pay earnings table. The rows can come from multiple...
2087
Frank Cowley
fcowley@...
Apr 5, 2000 4:07 pm
Customer is converting to PeopleSoft HRMS 7.5, Oracle V8. They are heavy Lotus Notes users and would like to keep that functionality. Currently they...
2088
Jaime Busse
Jaime_Busse@...
Apr 5, 2000 5:51 pm
At the 1997 PS conference in Orlando and at my previous employer they used Domino (Lotus Notes product) to get information in and out of Oracle. They also used...
2089
Frank Agent/Towers Pe...
agentf@...
Apr 5, 2000 11:52 pm
Platinum Infopump works well for this. Actually Computer Associates just bought Platinum out so you could probably get information from CA. You can also use ...
2090
Morgan, Michael
mimorgan@...
Apr 5, 2000 11:52 pm
I'm having a problem compiling the following PeopleCode. The error message says "unmatched quote" on the SQLExec statement. Any ideas would be appreciated. ...
2091
S+A Sills
ssills@...
Apr 6, 2000 2:25 pm
looks like a bug to me. when I tried SQLExec ("Select DESCR from PS_REVW_RATING_TBL where RATING_MODEL = 'SBHC' and EFFDT = ( Select MAX(A.EFFDT) from...
2092
pghannagan@...
Apr 6, 2000 2:26 pm
You can't use fancy indentation for the SQL statement within PeopleCode. Use this... SQLExec("Select DESCR from PS_REVW_RATING_TBL where RATING_MODEL = 'SBHC'...
2093
Robert Buford
rbuford@...
Apr 6, 2000 2:26 pm
How about using a variable that is set inside the procedure Process-Line and is not reset until you've begun processing code inside the loop? Ex. ...
2094
Tajinder Chahal
Tchaha@...
Apr 6, 2000 2:27 pm
Mike, I also used to get this error when I first started writing PeopleCode and I couldn't figure out initially. But now I know thet whenever you write a...
2095
Todd Kurlowski
tkurlowski@...
Apr 6, 2000 2:27 pm
The problem, if you are attempting to enter the code as you have it displayed, is that with all the embedded spaces, the command line is too long to interpret....
2096
Jaramillo, Mannie: CO...
mjaramil@...
Apr 6, 2000 3:10 pm
Mike, I used your SQLExec and tried it without any indentation and it work. PS seems like you to just type in you text straightforward without any indentation....
2097
snafissi@...
Apr 6, 2000 3:10 pm
The white-space and the end-of-line carriage returns are confusing the processor. Put everything in one line and let PeopleSoft wrap and go to the next line by...
2098
Morgan, Michael
mimorgan@...
Apr 6, 2000 3:19 pm
Thanks group! I got many responses....and my code is fixed! Hope to return the favor soon! Mike Morgan PeopleSoft Programmer/Analyst Phone # (973) 322-4237 ...
2099
DWITTENB@...
Apr 6, 2000 5:24 pm
You can get a Wall Mountable sheet for lots of PS modules from PeopleSoft Press on Customer Connection. There is a price, but it beats spending your time and...
2100
Coulthard, John
jcoulthard@...
Apr 6, 2000 5:39 pm
I am having trouble sending a multiple reporting SQR to the printer. I keep getting the same error (SQR 6003) Unexpected End-Of-File while processing the...
2101
Peter Clark
PGCLARK@...
Apr 6, 2000 6:22 pm
Sounds like you need to add -keep to the command line (SQR Flags in Configuration Manager). If that does not resolve your problem, check out this document. It...
2102
truffing@...
Apr 7, 2000 2:41 pm
All: I am trying to find out if anyone has installed and used the Workstation Wizard, which PeopleSoft is suppose to have. I am told that this 'add-on' tool...
2103
Frank Cowley
fcowley@...
Apr 7, 2000 2:59 pm
Mike, It's great that you found an answer for your problem/question and it's also great that we have this forum where we can all share ideas and help others. ...
2104
SRI Technologies
sritech@...
Apr 7, 2000 3:00 pm
Hello everyone, This is about the release of version 3 of SqrPlus. As acknowledged by many SQR developers/consultants, SqrPlus has been recognized as a great...
2105
Bryan deSilva
improvisations@...
Apr 7, 2000 6:43 pm
Hello everyone, and welcome to the tenth week of our eStudy Group! I guess I never did post this chapter <g> Please start a thread with the heading “SQR-10...
2106
mahonj@...
Apr 7, 2000 6:43 pm
PS_COMP_CR_CRD_TBL CREDIT_CARD_NBR CREDIT_CARD_TYPE ('AE' or 'CD') I need to restrict certain users to certain credit card types. I would like to let one...
2107
Deshpande, Manisha
mdeshpande@...
Apr 7, 2000 6:43 pm
For public sector, student and HR systems are on the same database sharing common tabels. So can anybody tell me how to delete EMPLIDs from HR side of PS and...
2108
mahonj@...
Apr 7, 2000 6:43 pm
PS_COMP_CR_CRD_TBL CREDIT_CARD_NBR CREDIT_CARD_TYPE ('AE' or 'CD') I need to restrict certain users to certain credit card types. I would like to let one...
2109
Fraser, Douglas PSER:EX
Douglas.Fraser@...
Apr 7, 2000 7:26 pm
http://www.bcstools.com/ ... From: truffing@... [mailto:truffing@...] Sent: Friday, April 07, 2000 7:36 AM To: peoplesoft-fans@egroups.com ...
