Thanks to all who replied to this question, here are a few further details. It was suggested these reports be run automatically without the user having access...
856
Chris Bigenwald
Chris_Bigenwald@...
Nov 1, 1999 3:55 pm
Most SQL queries don't guarantee any sorting unless you provide an "order by" clause, so you should do something like: select to_char(A.FIELDNAME,'HH:MI PM') ...
857
Victor Loghin
vgl_ca@...
Nov 1, 1999 3:55 pm
When I opened my previous message in Hotmail using Netscape, it was totally unreadable. I also tried to look at it on the egroups site with the same result....
858
siva patnam
spatnam@...
Nov 1, 1999 3:56 pm
Hi Howard, Thankq very much. I would like to know the product name, so that we will plan to go for that product. thanks....
859
Garold L. Johnson
Gary_Johnson@...
Nov 1, 1999 3:56 pm
I have used MultiEdit as my programming editor for years and I still haven’t found anything to compare with it. The current program is full 32-bit windows,...
860
improvisations@...
Nov 1, 1999 3:58 pm
How is everyone doing with this chapter? For those of you who've never used SQR before, were you able to run the sample first program? Have you even tried the...
861
Carter, Cynthia
ccarter@...
Nov 1, 1999 4:55 pm
I've been OBE. I have yet to read the chapter, much less try to run anything. But I hope to get back to it. ... From: improvisations@......
862
Thompson, Lewis (Lond...
thomplew@...
Nov 1, 1999 4:55 pm
Hi, Are there any techies out there who can help me - the problem is that I am trying to fix a problem in our Production database, and in order to do this our...
863
arturo_vega-consultan...
Nov 1, 1999 4:55 pm
Hi to all, I also use TextPad with excellent results, Shimada, can you explain me how you launch your SQR's with TextPad?? TextPad is simple and haves a lot of...
864
Dianne Rowland
dianne_rowland@...
Nov 1, 1999 11:20 pm
Another way that you can use the Group By clause is to get a distinct set of data. Normally if you wanted to get a distinct value, you would use the distinct...
865
GSCHAEFF@...
Nov 1, 1999 11:20 pm
We are not using these panels right now, but my understanding is that the dependents would show up on the panels even if they were not included in the benefit...
866
Robert Torreano
torreano@...
Nov 1, 1999 11:56 pm
Greg - I believe what you are alluding to is the Dependent_Benef table. Dependent_Benef is where you store dependent indicative data. Dependents/beneficiaries...
867
GSCHAEFF@...
Nov 2, 1999 2:46 pm
We are not using these panels right now, but my understanding is that the dependents would show up on the panels even if they were not included in the benefit...
868
Karen Bentz/Towers Pe...
bentzk@...
Nov 2, 1999 2:46 pm
Dependents can be in DEPENDNT_BENEF whether or not they are covered. But only actively covered dependents should have rows in HEALTH_DEPENDNT during the ...
869
plavert2@...
Nov 2, 1999 2:46 pm
Another editor to look at is ultraedit. It is not as feature rich as multi-edit, but can do a lot with sqr and can be configured to run sqr's similar as...
870
Rhonda_Handley@...
Nov 2, 1999 3:08 pm
Hi, We are upgrading to DB2 UDB tomorrow. We are on AIX, PTools 7.05, and HRMS 7.00. We still have one outstanding issue with query performance. When we join...
871
Love, Kristin
klove@...
Nov 2, 1999 4:25 pm
What about making views of the actual tables (personal_data and job) which do not include security for reporting purposes? Then limit access to the reports...
872
eric_heilner@...
Nov 2, 1999 4:25 pm
Rhonda, We have a customer who had just this problem. The solution was to: A) Create the "Fast Security Tables". B) Create views of Job, Personal_data, etc....
873
NATALIE_PLOTT@...
Nov 2, 1999 5:32 pm
We are currently running Open Enrollment and are using Employee Self-Service for employees to enter their elections. Since running Open Enrollment (Nov 1, ...
874
cynthia.jones@...
Nov 2, 1999 11:06 pm
This is not a technical PS question - does the jobs e-group still email postings? Cynthia...
875
Bryan deSilva
improvisations@...
Nov 2, 1999 11:21 pm
I'm not familiar with the jobs eGroup. There is one available on deja-news at www.deja.com and the group is called a1.apeoplesoft. Not much activity that I can...
876
Robert Torreano
torreano@...
Nov 3, 1999 4:15 am
Can anyone check with their DBA to see what size their rollback segments are? We are on Oracle 8 and cannot run the Ben100.sqr because we keep hitting...
877
Addie Mak
amak@...
Nov 3, 1999 4:51 am
Is there anybody using PeopleSoft Competency Management? If so, how did you setup the competency tables? Any information would be appreciated. Thanks....
878
ddixon@...
Nov 3, 1999 4:51 am
We use a reporting environment, with weekly refreshes. We don't let users query Prod. As far as refreshes go... hours? To fresh how many tables? We take a few...
879
Douglas Nichols
drnichols@...
Nov 3, 1999 1:22 pm
We are running on Sun Solaris 2.6, Oracle 8.0.6 and have 1GB rollback segments. ... From: Robert Torreano <torreano@...> To:...
880
brucemitchell@...
Nov 3, 1999 1:22 pm
rhonda_handle-@... wrote: original article:http://www.egroups.com/group/peoplesoft-fans/?start=870 ... and HRMS ... join ... users to ... tables as ...
881
Thompson, Lewis (Lond...
thomplew@...
Nov 3, 1999 1:22 pm
Hi, I'm getting the following error message on trying to launch an SQR Report from a Process Scheduler job definition : (SQR 5528) ORACLE ORLON error -1004 in...
882
Posey Jim N Contr AED...
Jim.Posey@...
Nov 3, 1999 3:44 pm
Mark: We are going to use Competency Management. We plan on starting at a relative high level by using the Lominger Career Architect competencies and then...
883
siva patnam
spatnam@...
Nov 3, 1999 3:44 pm
Hi Lewis, The SQRW icon was set for defult user id VP1, so you need to change the user and password. You can do this using the property of SQRW icon. When you...
884
eric_heilner@...
Nov 3, 1999 3:45 pm
The job that is taking many hours to run is not a refresh on underlying data, but a refresh of the 2 "Fast Security" tables, which are substitutes for the...
