I assume that you want to load the data without reentry. Check with your company's PS developers for a list of fields and tables. Converting data works well....
2492
Michelini, Daniel S.
dmicheli@...
Jul 3, 2000 2:58 pm
My client does not maintain a balance from a previous employer. Balances are used to create W-2's, so any changes to the balances would need to be re-adjusted...
2493
Barb Van Horn
barb.vanhorn@...
Jul 3, 2000 5:16 pm
None of the companies for which I have worked track the withholding from previous employers for the employees. It is the employee's responsibility to monitor...
2494
alana.aguirre@...
Jul 3, 2000 8:07 pm
Hi all !! I want to know if anybody have installed eProcurement 1.0. I have a few questions: 1.- Do you have any documents about how administrate and customize...
2495
Brendan Lyng
roundiem@...
Jul 5, 2000 5:15 am
Looking for ideas.... I need to use the Unix function sed within an sqr. Calling unix functions is not usually a problem, but this time I am using sed which ...
2496
MARIA DEL MAR BARRON ...
mbarron@...
Jul 5, 2000 5:15 am
Hi !!! I donīt know if was there some answer for that questions, really, iīm searching this kind of information too, but i donīt receive any answer for ...
2497
MARIA DEL MAR BARRON ...
mbarron@...
Jul 5, 2000 5:15 am
Hi! Does exist a way to "export" and "import" Classes between Data Bases. ??? I created some new classes, and i defined some new operators, and i spend like 2...
2498
Barb Van Horn
barb.vanhorn@...
Jul 5, 2000 2:25 pm
What a problem! You might try using the backslash (\) before the quotes that you want to be ignored by the SQR command. This will work for edit masks, but I...
2499
Peter Clark
pgclark@...
Jul 5, 2000 3:24 pm
"inverted comma"? I didn't realize there was such a thing :-) I assume the term you are looking for is "single quote" ... or so your example would infer. In...
2500
Tara K
tkurtz999@...
Jul 5, 2000 3:24 pm
Our DBA uses SQL scripts to copy data from our Production DB into our Testing & Development DB. The Security is copied on a full DB refresh. However, I am sure...
2501
Coulthard, John
jcoulthard@...
Jul 5, 2000 3:24 pm
The tricky part in working with string literals comes when you need to include a single quote inside a string literal. Generally, the rule is that you write...
2502
Ralph Blough
rblough@...
Jul 5, 2000 3:24 pm
There are a couple of solutions. I solved it a couple of years ago, so this may not be exact. But, what I did was to create a $charvar when I did the defines...
2503
drnichols@...
Jul 5, 2000 3:24 pm
Try building the string with the sed command as a variable, kind of like: let $sed = 'sed -e' || '''' || 's+ /g' || '''' ... then use the call system command...
2504
Jerry Coleman
colemanj@...
Jul 5, 2000 3:24 pm
Put double quotes around the command - e.g. #include 'setup01.sqc' #include 'setenv.sqc' begin-report do Init-DateTime do Init-Number do Get-Current-DateTime ...
2505
c.george@...
Jul 5, 2000 3:24 pm
Brendan, I'm not a sed or Unixy person but I just tried a :- CALL SYSTEM USING 'sed -e ''s/+ //g'' sqr.log > new_sqr.log' #sed_stat The SQR executed with no...
2506
Peter Clark
pgclark@...
Jul 5, 2000 6:19 pm
John, As you state, "the rule is that you write two single quotes next to each other inside a string if you want the literal to contain a single quote in that...
2507
Peter Clark
pgclark@...
Jul 5, 2000 6:19 pm
the ascii value of a single quote is 39 i.e. Let $Q = chr(39) ... There are a couple of solutions. I solved it a couple of years ago, so this may not be exact....
2508
Ralph Blough
rblough@...
Jul 5, 2000 11:44 pm
Great, I just could not think of it this morning with all the distractions (virtual Monday.) I also forgot to mention that when I did it the string was...
2509
Brendan Lyng
roundiem@...
Jul 6, 2000 1:10 pm
Thanks everyone. My SQR is now working a treat. I went for the simplest option - placing two sets of single quotes in the SED statement. CALL SYSTEM USING...
2510
Gu, Helen
helen.gu@...
Jul 6, 2000 3:47 pm
Hi: I am using SQR ver.4.3.4. My goal is to pad 0 on the left for a string if the string is less then 8. So if the string is 1234, my output should be ...
2511
c.george@...
Jul 6, 2000 4:01 pm
Your #padnumber should be the length of the finished variable, 8 in your case. So you dont need to calculate the #padnumber. Regards, CG...
2512
Robert Stojkovic
robert_stojkovic@...
Jul 6, 2000 4:14 pm
Hi Helen The lpad function should read as such let $hashTransit = lpad($hashTransit,8,0) The pad number is the max length that you wish not the difference in...
2513
Gu, Helen
helen.gu@...
Jul 6, 2000 4:36 pm
Thanks CG. It's working now. Have a nice day. --HG ... From: c.george@... [mailto:c.george@...] Sent: Thursday, July 06, 2000 8:50...
2514
MARIA DEL MAR BARRON ...
mbarron@...
Jul 6, 2000 5:51 pm
Thaks, by the tip. Does Anyone knows what tables must i to import? Regards. Mara ... From: Tara K [mailto:tkurtz999@...] Sent: 07/05/00 05:42 AM To:...
2515
Subba Mullapudi
subba_mullapudi@...
Jul 6, 2000 5:51 pm
Try the following block. let #hashTransit = to_number(&F.Transit#) move #hashTransit to $hashTransit 09999999 show 'hashtransit after : ' $hashTransit ... ...
2516
David Black
dlblack@...
Jul 6, 2000 5:51 pm
Another way. I have been using the edit mask, example below, and that seems to work but maybe I am just lucky. let $count = edit($count,'000000009') ... string...
2517
Barb Van Horn
barb.vanhorn@...
Jul 6, 2000 7:15 pm
Is there anyone out there who would not mind having their brain picked on this one? We will be implementing this summer and I would like to know the good AND...
2518
Ellen Segersin
esegers@...
Jul 6, 2000 7:41 pm
Mara, I recently refreshed all our Finance security tables with production data and these are the tables I refreshed or at least looked at. We are on version...
2519
james_strange@...
Jul 6, 2000 7:41 pm
The PSOPRDEFN table contains the definitions for all userids in the system. I copy that from production to development in order to transfer the users and their...
2520
Bryan deSilva
improvisations@...
Jul 6, 2000 8:34 pm
The interfacing to CES is a tough one but can be done. I'm forwarding this on to my Payroll buddy for more info ... From: ...
