From my understanding it is not really a Process scheduler thing as much as a SQR thing. For example Crystal will allow you to use your windows print queues...
222
plavert2@...
Aug 1, 1999 11:21 pm
If you use a process type that has the printer::wp setup, it will automatically print to the default printer. Assuming you are working through a process...
223
rko22@...
Aug 1, 1999 11:22 pm
Hi. I moderate a mail list here at Egroups that relate to jobs with Peoplesoft and other ERP skills. http://www.egroups.com/group/a1a-erpjobs/info.html I am...
224
kibbles@...
Aug 2, 1999 3:05 pm
Hi. I have had problems with writing dynamic SQL in the past. I think the problem I had was that SQR didn't like having a $ sign embedded in the dynamic where ...
225
krutberg@...
Aug 2, 1999 3:49 pm
In this SQL clause, what do the colon and $HEADER_AND_LINE_REC signify? FROM [PS_JRNL_HEADER JH, PS_JRNL_LN JL:$HEADER_AND_LINE_REC] ... begin-SELECT...
226
Chang, Chaw-Ye
CCHANG@...
Aug 2, 1999 3:50 pm
How do I capture the SQLs generated by the COBOL program? Or how do I monitor the performance of the SQLs generated by the COBOL program? I am in particular...
227
Ponce Martinez Juan M...
jmponcemartinez@...
Aug 2, 1999 5:14 pm
If your run location is client you only need to enable the check boxes in the trace tab of your Configuration Manager. The trace file created you'll find it in...
228
SNafissi@...
Aug 2, 1999 5:14 pm
There is a file on your UNIX-box called pstools.ini. Within this file, you will see a list of numbers that each does capture something from the COBOL process....
229
chris.harney@...
Aug 2, 1999 5:15 pm
You're looking at the use of dynamic query variables to specify table names. In your example SQR uses the ps_jrnl_header and ps_jrnl_ln tables for the...
230
Robert Stojkovic
rstojkovic@...
Aug 2, 1999 5:15 pm
Hi Chaw. Run a cobal trace. The trace will show you the SQL statements called. Then you can query on PS_SQLSTMT to see the actual statement. These are the...
231
Robert Stojkovic
rstojkovic@...
Aug 2, 1999 5:15 pm
Here you go Let $BF = '''' LET $AF = '''' Let $WHERECLAUSE = ' A.course=B.course AND A.COURSE= '||$BF|| $COURSE||$AF||' AND...
232
Robert Stojkovic
rstojkovic@...
Aug 2, 1999 5:15 pm
When using a Dynamic Where Clause the conditions need to have the " s in the string statement or the statement will not work. $Session must contain " if the...
233
Gita sanjeeviah
gsanjeeviah@...
Aug 2, 1999 7:32 pm
Hi All: How does the following code produce the output shown: THE CODE: to_char(to_date(to_char(B.sessn_start_time, 'HH24.MI.SS."000000"'), ...
234
Gita sanjeeviah
gsanjeeviah@...
Aug 2, 1999 7:32 pm
Hi All: How does the following code produce the output shown: THE CODE: to_char(to_date(to_char(B.sessn_start_time, 'HH24.MI.SS."000000"'), ...
235
Michel Keable
Michel.Keable@...
Aug 2, 1999 8:30 pm
The important part is 'HH:MIAM' which formats the date field as hours and minutes am or pm. When you query your database, you get 01-JAN-00 from the same field...
236
Robert Stojkovic
rstojkovic@...
Aug 2, 1999 8:30 pm
Sure no Problem. to_char(to_date(to_char(B.sessn_start_time, 'HH24.MI.SS."000000"'), 'HH24.MI.SS."000000"'),'HH:MIAM') &START_TIME to_char(B.sessn_start_time,...
237
Gita sanjeeviah
gsanjeeviah@...
Aug 2, 1999 9:34 pm
Thanks.. I read your mail again, and figured out how to write the query. Thanks Gita _____________________________________________________________ Do You...
238
SARDA Shailesh
ss048@...
Aug 3, 1999 3:46 am
Hi Chang, Go to configuration manager, Trace tab and check the boxes to see the SQL traces. The file will be generated in the TEMP\PS\(dbname)\*.trc directory...
239
cbrunelle@...
Aug 3, 1999 9:05 pm
How can a payment, which has been posted and has a posted status of Complete, have a payment status of Identified??...
240
krutberg@...
Aug 3, 1999 9:27 pm
I would like to display the values for A.ACCOUNT and L.ACCOUNT from the SELECT statement below. Using $A.ACCOUNT displays nothing. I am including the full...
241
kibbles@...
Aug 4, 1999 2:16 pm
We are starting to use the training letters process i.e. TRN001.SQR followed by a Word Macro. What we really want to do is to merge the SQR output file with a ...
242
chris.harney@...
Aug 4, 1999 2:16 pm
You'll find informtaion on using to_date and to_char in any sql book. The statement is basically printing the start and end dates (with no time) with an am...
243
chris.harney@...
Aug 4, 1999 2:16 pm
The 2 account numbers are not being selected. You need to select them first. $A.ACCOUNT will print the value of that text variable, but unless you've moved...
244
Karen Rutberg
krutberg@...
Aug 4, 1999 3:11 pm
Thanks for the response. Follow up question... When I add L.ACCOUNT to my select statement, I get the error "SQL Statuts =8120, SQL Error... Column...
245
SNafissi@...
Aug 5, 1999 3:09 am
add L.ACCOUNT also on your GROUP BY clause. It seems that you have an aggregate function (min, max, count) on your SELECT line and all fields within SELECT...
246
Mahon, Jack
mahonj@...
Aug 5, 1999 3:09 am
Hello, We are implementing Peoplesoft HRMS by Q2 of next year and we are trying to work with our current payroll vendor without much success. We have ...
247
Ray, Dorla
DKR@...
Aug 5, 1999 3:09 am
Our company is implementing HRMS 7.5 including the Benefits Administration module. We intend to use pricetags and credits. Are there any of you out there...
248
bibremerkamp@...
Aug 5, 1999 3:55 pm
We just went live with 7.5 using Payroll Interface. We were a Ceridian client, but after researching how People Soft and Ceridian would work together we ...
249
Joe
jejohn1216@...
Aug 5, 1999 6:01 pm
Hello Group! Panel Design 101 question here. Is it possible to have two level 1 scrollbars in one panel? I have PRCSRUNCNTL and I have record A with scroll...
250
Dianne Rowland
dianne_rowland@...
Aug 5, 1999 7:43 pm
Yes, it is possible. Though I have not created one and don't know why that would happen, you may want to look at the panel PRCSDEFN as a sample. D ... From:...
