Its a startup file used by SQR when building a Postscript print file. It is normally in the sqrbinw directory <<postscri.str>> Dale Willard CNA Life...
dale.willard@...
Sep 15, 2000 1:11 pm
6009
Dan, You can use the Data Mover GRANT_USER command with the specific oprid to create the Oracle user. Corey Elder ... From: Hebert, Daniel W....
Elder, Corey
celder@...
Sep 15, 2000 1:14 pm
6010
When I run the DataMover script (delivered script), I receive a Dr. Watson error when it encounters the GRANT_USER command. I believe it reports an error with...
Hebert, Daniel W.
dwhebert@...
Sep 15, 2000 1:36 pm
6011
Normal simple stuff to recommend. 1) Take your time and follow a good plan 2) Analyze your needs and set up the tables carefully 3) Have someone audit the...
Bryan deSilva
improvisations@...
Sep 15, 2000 4:14 pm
6012
No problem. Just keep the group open until I’m done <g>. I won’t be able to get to it until next week. Bryan ... From: ...
Bryan deSilva
improvisations@...
Sep 15, 2000 4:24 pm
6013
Just wondering if anyone out there has already created a script to refresh either a dev or test environment from production. We want to be able to do 'normal'...
Salameh, Ramzi
salamer@...
Sep 15, 2000 4:33 pm
6014
Can't your DBA take a backup copy of your production database and make a new copy for testing? That is what we do here at our site because there are too many...
Pamela Lantzy
plantzy@...
Sep 15, 2000 4:56 pm
6015
To all, I have written an SQR that reads an excel file ;then it runs a procedure that takes those values to insert in to the PS_JOB table. I have check the...
Dianderas, Edgardo
Edgardo.Dianderas@...
Sep 15, 2000 5:12 pm
6016
I see in do ps_job_check you move &std_hours to #std_hours so instead of .... if &std_hours > 0 do insert_into_job do update_proc_employment do...
Schelske, Steve K.
skschelske@...
Sep 15, 2000 5:19 pm
6017
When we ran Crystal Report APY3200-.rpt, Transaction Detail by Vendor, it produces blank report. However, there's data there. Are we missing a step when...
jquizon@...
Sep 15, 2000 5:36 pm
6018
Usually, a file with an XLS extension is in Excel's own binary format and doesn't lend itself to reading line by line. But if you're doing as save as... to...
Criss Laidlaw
Criss.Laidlaw@...
Sep 15, 2000 5:53 pm
6019
If you go to query and open the query name apy3200, you'll see the tables, criterias, etc. The tables are PS_REPORTING_VW2 A, PS_REP_BALANCE_VW2 B,...
jnguye7@...
Sep 15, 2000 6:03 pm
6020
Tell your DBA to run an onunload which is a n informix utility. After this is created your DBA can then run an onload in your test environment. If sysadm has a...
Mike Byrne
mbyrne@...
Sep 15, 2000 6:05 pm
6021
Thanks for the input, I didn't think of doing it thru our DBA - you live and learn. Thanks again! Ramzi ... From: Mike Byrne [mailto:mbyrne@...] Sent:...
Salameh, Ramzi
salamer@...
Sep 15, 2000 6:14 pm
6022
Has anyone modified the BAS004.SQR to sort or staple the enrollment forms for each employee? Thanks fro any info. Larry...
larry lundstrom
llundstrom@...
Sep 15, 2000 6:17 pm
6023
Hi Paul, You mentioned that your security administrator runs the data mover script. Did you realize that you can run DataMover from the command line ? I found...
Hebert, Daniel W.
dwhebert@...
Sep 15, 2000 6:51 pm
6024
Greetings! We aren't merged yet, so I'm double-posting here. We have a simple SQR which sets the PSASOFDATE.ASOFDATE field to SYSDATE. The SQR is set to run...
Joe Johnson
jej1216@...
Sep 15, 2000 7:07 pm
6025
How many times is it queued? Could it be someone mistakenly submitted 3 times? If you delete 2 of them the next time the job runs does it submit it again 3 ...
Pamela Lantzy
plantzy@...
Sep 15, 2000 7:09 pm
6026
remember the show statement is one of the best debugging tools with SQR. When I have a procedure that is not being called, I start there and work back putting...
Carlton Conley
cconley@...
Sep 15, 2000 11:54 pm
6027
My process inserts into the psoprdefn table along with the osprcls and psopralias tables. The dms script contains two lines for each employee: CREATE_USER...
Paul Haninger
phaninge@...
Sep 16, 2000 12:38 am
6028
We had a similar problem when we ran the psoprload script. I can' remember the exact cause but I believe they had the grant_user command in the wrong place in...
Paul Haninger
phaninge@...
Sep 16, 2000 12:41 am
6029
Thanks for the info. I know we were looking into automating the process, we actually wanted to do the entire thing in a batch mode on a unix box but could not...
Paul Haninger
phaninge@...
Sep 16, 2000 12:43 am
6030
HI, I am working in Peoplesoft finanicals. I want to make a query which would give the purchase order vendor ID,po reference number, po qty and po amount. The...
ankit jain
ankitjain_99@...
Sep 17, 2000 9:31 pm
6031
Actually the total line amount is held in MERCH_AMT_BSE and MERCHANDISE_AMT, and the unit amount is held in PRICE_PO_BSE and PRICE_PO. So all you have to do is...
martin
martin.gribben@...
Sep 17, 2000 11:04 pm
6032
Your code looks ok. I assume that the .xls file is just a misnamed tab delim file. Add some display code to your program, like display $newemplid, as it is...
scott sills
ssills@...
Sep 17, 2000 11:29 pm
6033
Jim Hardesty Software Engineer NCR Corporation GAD US HR/Payroll Systems...
Hardesty, James E
jh151011@...
Sep 18, 2000 11:53 am
6034
psusers to be combined with peoplesoft-fans. (see below for a repeat of the proposal). In a few minutes I will sending the list of current subscribers to the ...
Hardesty, James E
jh151011@...
Sep 18, 2000 12:03 pm
6035
There appears to be a delay in getting everyone from psusers over to peoplesoft-fans. Bryan has sent in the subscription invitations, but they have not gone...
Hardesty, James E
jh151011@...
Sep 20, 2000 3:16 pm
6036
If anyone has received an invitation to the peoplesoft-fans list please let me know. Please respond directly to jh151011@... not the list, since the list...
Hardesty, James E
jh151011@...
Sep 21, 2000 12:57 pm
6037
Bryan has not heard back from Egroups about the mass update of users he attempted to perform. In the meantime he can manually invite new subscribers but he is...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
