[U2] Excel Worksheets

2012-06-01 Thread Jim Koca
I am sending a CSV file to excel, and would like to divide it into separate
worksheets. Is there a special value I can insert in the file which would
cause the following data to create a separate work sheet ?

Thanks,


Jim Koca

Cell Phone: 630.253.0007
Home Office: 630.629.5589
Email: jk...@comcast.net

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


RE: [U2] UV - Files Stats Question

2007-08-25 Thread Jim Koca
We create new files from time to time, and forget to add them to FAST to be
resized. We are planning to look at the files in an account, and if all the
group are at 200 % and the file is not currently being review by FAST, add
it to the FAST files for resizing.

Jim

 -Original Message-
 From: [EMAIL PROTECTED]
 [mailto:[EMAIL PROTECTED] Behalf Of Jeff Fitzgerald
 Sent: Saturday, August 25, 2007 12:11 PM
 To: u2-users@listserver.u2ug.org
 Subject: RE: [U2] UV - Files Stats Question


 I am one of the authors of FAST; we'll be happy to help you if you can
 give us a bit more of an idea what you are trying to accomplish...

 Jeff Fitzgerald
 Fitzgerald  Long, Inc.

 -Original Message-
 From: [EMAIL PROTECTED]
 [mailto:[EMAIL PROTECTED] On Behalf Of Jim Koca
 Sent: Friday, August 24, 2007 10:00 PM
 To: u2-users@listserver.u2ug.org
 Subject: [U2] UV - Files Stats Question

 I need to select files in an account and determine if all the records
 fall
 in the 200% groups. This will be done in a Basic program. Other than
 FILE.STAT each file and examine the output, can it be done simpler ?

 Also if anyone is using FAST, can you tell me where FAST keeps the list
 of
 files under its control ?

 Thanks,

 Jim Koca
 ---
 u2-users mailing list
 u2-users@listserver.u2ug.org
 To unsubscribe please visit http://listserver.u2ug.org/
 ---
 u2-users mailing list
 u2-users@listserver.u2ug.org
 To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


[U2] UV - Files Stats Question

2007-08-24 Thread Jim Koca
I need to select files in an account and determine if all the records fall
in the 200% groups. This will be done in a Basic program. Other than
FILE.STAT each file and examine the output, can it be done simpler ?

Also if anyone is using FAST, can you tell me where FAST keeps the list of
files under its control ?

Thanks,

Jim Koca
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


[U2] UV - Tracking file writes

2006-07-12 Thread Jim Koca
I need to track all processes that write to a specific file. At one time I
remember that you could set some type of trigger to do this.

If someone could provided me the information on how to do this, or direct me
to the documentation that covers this I would appreciate it.

Jim Koca
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] Deciphering Pick UniBasic statement

2005-12-08 Thread Jim Koca
Think of ; as a CR/LF - separate line of code. Hope this helps 

 IF P(2)-AR(12)=28 THEN
  CC=CC+1
  INS 0 BEFORE AR(14)1,1
  DEL AR(14)1,9
 END ELSE
  IF AR(13)=DATE() THEN
   CC=CC 
  END ELSE
   INS 1 BEFORE AR(14)1,1
   DEL AR(14)1,9
  END
 END


Jim

 -Original Message-
 From: [EMAIL PROTECTED]
 [mailto:[EMAIL PROTECTED] Behalf Of Caleb Ng
 Sent: Thursday, December 08, 2005 1:11 PM
 To: u2-users@listserver.u2ug.org
 Subject: [U2] Deciphering Pick UniBasic statement
 
 
 I'm trying to decipher and break the following IF/THEN/ELSE statement
 into multiple lines because I need to add some logic into it.   Being a
 PICK newbie, I'm having difficulty understanding it.  I believe this
 code was ported from an old MD Pick system but I want to make sure it
 behaves in a similar fashion once I break it apart.  I'm sure this will
 be no problem to gurus like yourselves.
 
 IF P(2)-AR(12)=28 THEN CC=CC+1; INS 0 BEFORE AR(14)1,1; DEL
 AR(14)1,9; ELSE IF AR(13)=DATE() THEN CC=CC ELSE INS 1 BEFORE
 AR(14)1,1; DEL AR(14)1,9
 
 Thanks in advance,
 
 
 Caleb Ng
 Systems Analyst
 Sweetwater Authority
 [EMAIL PROTECTED]
 (619) 409-6763
 ---
 u2-users mailing list
 u2-users@listserver.u2ug.org
 To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] [UD] Not a verb Paragraph Error between accounts

2005-11-28 Thread Jim Koca
Drop to TCL in the good account, and ED VOC LANDSCAPE... You should get some
lines that you can list. Drop to TCL in the other account, and ED VOC
LANDSCAPE... If it says new item, type in the lines from the good account
and give it a try...

 -Original Message-
 From: [EMAIL PROTECTED]
 [mailto:[EMAIL PROTECTED] Behalf Of Caleb Ng
 Sent: Monday, November 28, 2005 1:30 PM
 To: u2-users@listserver.u2ug.org
 Subject: [U2] [UD] Not a verb Paragraph Error between accounts


 I'm sure this is a pretty simple fix but having scoured IBM's U2 docs on
 CD, I'm still lost.

 I've got a PROC that prints a report in landscape with the following
 code:

 HSP-ASSIGN =ACCTING 0
 P
 HTERM ,,146,44
 P
 HLANDSCAPE
 P
 HCPI.12
 P
 HSORT FILE 

 It works properly in one account but when I logto another account, I'm
 getting the following error when I run it:

 In Paragraph:  PROC
 Not a verb
  LANDSCAPE
 Job number is : 3

 I originally thought it might be a UDT.OPTION or ECLTYPE but I'm not
 having any success.  Any help for this newbie would be greatly
 appreciated.

 Thanks,

 Caleb Ng
 Systems Analyst
 Sweetwater Authority
 [EMAIL PROTECTED]
 (619) 409-6763
 ---
 u2-users mailing list
 u2-users@listserver.u2ug.org
 To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/