Hello everyone, and welcome to the eleventh week of our eStudy Group! Please start a thread with the heading “SQR-11 your topic here” as described in the...
2205
truffing@...
Apr 21, 2000 4:28 pm
I know that this has probably being asked on this discussion board many times, however I need to know if anyone has a simple way to scramble (in some way) the...
2206
Frank Ellington
fellington@...
Apr 21, 2000 4:28 pm
User was trying to update a panel in Treasury: Capture Deals – Use – Deal Entry. User updated the Counterparty field and PeopleCode fired, received the...
2207
Regina Mosher
rmosher@...
Apr 24, 2000 1:22 pm
A list of tables and descriptions would not be as useful as an entity-relationship diagram, which would show you how the tables are related to one another. ......
2208
heidi.vogt@...
Apr 24, 2000 4:54 pm
Hello, We are new to 3-tier and were wondering if there was an easy way of automatically starting the application servers after our UNIX box is rebooted every...
2209
james_strange@...
Apr 24, 2000 5:09 pm
If you are on a UNIX box, simply put together an rc script which uses the command line options to start the app server. The only difficult part is getting the...
2210
Joe Johnson
jej1216@...
Apr 25, 2000 2:01 pm
Bryan deSilva asks: Can you use an SQR bind variable when creating a dynamic query variable? ...
2211
John Powell
JPowell@...
Apr 25, 2000 2:01 pm
Is there an SQR command or function that will return the current column position? I'm trying to avoid explicit positioning, but in some circumstances, I want...
2212
Stefanie Vario
svario@...
Apr 25, 2000 2:02 pm
You can use "psadmin" to start the application servers from a shell script. Put the following line into the shell script: $PS_HOME/appserv/psadmin -c boot -d...
2213
jhill@...
Apr 26, 2000 1:58 pm
Good Morning all. I am at a client site who has a Long Term disability premium calculated as .368/100 dollars of coverage; subject to a maximum limitation of...
2214
J. Kane
j.kane@...
Apr 26, 2000 2:09 pm
John, SQR uses some pre-defined (reserved) variables you could call on. Example: #current-column !The current column on the page #current-line !The...
2215
J. Kane
j.kane@...
Apr 26, 2000 2:11 pm
Absolutely! Very useful! John Kane ... variable? ... ====================================================================== == ... ...
2216
J. Kane
j.kane@...
Apr 26, 2000 2:12 pm
Cal, That's a really interesting notion. I haven't worked at it, but I would think that it would be pretty easy in a two step manual process. 1) Write/Run SQR...
2217
Pamela Lantzy
plantzy@...
Apr 26, 2000 2:12 pm
Hi, Has anyone modified this file on the unix machine to redirect where the .lis files are written? We are on Student Admin 7.60, PT 7.58 and when we run SQRs...
2218
Amy
aclark@...
Apr 26, 2000 3:07 pm
Hi, We were wondering how other companies were handling effective sequences on the Job_Data panels. Are you using them? Have you experienced any issues with...
2219
rwright@...
Apr 26, 2000 3:27 pm
Hi Amy, We use Effective Sequences all the time. Many times employees have multiple job actions occurring on a single day. For example, an employee receives...
2220
Cathy Danatos
edcam@...
Apr 26, 2000 4:19 pm
We are on release 7.51. We use effective dated sequences frequently - mostly to differentiate between types of pay activity and other concurrent job activity...
2221
kibbles@...
Apr 26, 2000 5:06 pm
I'd answer yes as well, although you must be careful to make sure that you expand the bind variable into a literal beforehand. I once spent a long time...
2222
Shimada, Keiko
keiko@...
Apr 26, 2000 7:01 pm
Amy, we use effective sequence when we have more than one transaction occur on the same day. There are some issues with reporting. You may want the report to...
2223
Steve Rieger
riegersteve@...
Apr 26, 2000 7:02 pm
Do any of you know if there is a company hiring ps users, advanced level, in the Greater Los Angeles Area Thanx SR30M...
2224
Alan Otani
ATOI@...
Apr 27, 2000 2:38 pm
Pam: I am currently working at a site where the user's have been trained to send output to a specific directory when running on the server. We allow the ...
2225
J. Kane
j.kane@...
Apr 27, 2000 8:24 pm
Pam, At different sites we've customized the prcs_sqr to do such things as putting the file in the users' home directory or to modify the output file name so...
2226
Deshpande, Manisha
mdeshpande@...
Apr 27, 2000 8:24 pm
We just upgraded PeopleTools from 7.4 to 7.6. When we are trying to run POPO005 SQR i.e. PODispatch we are getting error messages SQR 5528: Conversion of char...
2227
Coulthard, John
jcoulthard@...
Apr 28, 2000 1:37 pm
Manisha The date-time values are also retrieved from the pssqr.ini file. Make sure you have included the location of this file in the SQR flags of the Process...
2228
Campanario, Juan
jcampanario@...
Apr 28, 2000 1:38 pm
Do you have the -ZIF variable flag set? Look under Configuration Manager -> Process Scheduler -> SQR Flags e.g. -i<YOUR_PSHOME>\sqr\...
2229
David Black
dlblack@...
Apr 28, 2000 3:00 pm
Just subscribed yesterday and found your note. We are on the AS400 v7.02 and will have to migrate. Due to $$'s and skill set, our choices have been have been...
2230
David Black
dlblack@...
Apr 28, 2000 3:54 pm
We have just been through this problem with PSQuery on our AS400/DB2 v7.02. The issue is the default "Row-Level Security" that is set on some tables and...
2231
Surit Maharana
surit@...
Apr 28, 2000 5:55 pm
Hi Amy, At the end of the client sqr, you can insert a row into PSPRCSRQST simulating the process of scheduling a process on the server. Process Scheduler will...
2232
mahonj@...
Apr 28, 2000 8:14 pm
Go -> Compensate Employees -> Administer Company Cars (GBL) Plan type for company cars = '5A' Peoplebooks has notations in it that indicate that this module is...
2233
james_strange@...
Apr 29, 2000 12:01 am
You might want to look at Oracle 8 standard edition on NT. The pricing is very similar to SQL Server. I will give you an example: 4 CPUs at 500MHz would cost...
