Re: [U2] group locks and user nbr's

2008-06-24 Thread T Stokes
This is a version of an expanded LIST.READU EVERY. It changes the pid for the user name. Slight modifications can be made to use replace the inode with the file name. PID.ARRAY = '' ; ID.ARRAY = '' EXECUTE LISTU CAPTURING EXEC.LINE.OUT HEADER.LINE1 = TRIM(EXEC.LINE.OUT2)

RE: [U2] Friday query logic

2008-06-24 Thread Bill Haskett
Eric: That doesn't work either. list APOPEN WITH ANY ACCTS UNLIKE 52... OR WITH ANY ACCTS UNLIKE 29... INVDATE COMMENT ACCTS AMTS APOPEN INV-DATE DESCRIPTION ACCT. ACCT/AMTS 58*6-4 06-01-08 LOAN #123456, 06/2008 5230246.04

RE: [U2] Friday query logic

2008-06-24 Thread JPB-U2UG
I take it that you checked to make sure that the fields were associated so let's take a different look. Are the values separated by value marks or sub-value marks? What does the dictionary contain? What does the record below look like in the editor? -Original Message- From: [EMAIL

RE: [U2] Friday query logic

2008-06-24 Thread Eric Armstrong
Bill, Sorry for not responding sooner, but I agree with the comment below. It should work! So if it doesn't, we have to step back and start asking other questions. Eric -Original Message- From: JPB-U2UG [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 24, 2008 11:24 AM To:

RE: [U2] Friday query logic

2008-06-24 Thread Kathleené M Hunter
If this is not working, create a dictionary item that does the evaluation you want and have it return a 1 if it meet the condition and a 0 if it does not. Dictionary would look like IF FIELD[1,2] # SF OR FIELD[1,2] # SH THEN 0 ELSE IF CONVERT(SH,,CONVERT(SF,,OCONV(FIELD,MCA))) #

RE: [U2] Friday query logic {Unclassified}

2008-06-24 Thread HENDERSON MIKE, MR
Try WHEN not WITH LIST APOPEN WHEN(ACCTS UNLIKE 52... AND ACCTS UNLIKE 29...) etc Regards Mike -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kathleeni M Hunter Sent: Wednesday, 25 June 2008 12:23 p.m. To: u2-users@listserver.u2ug.org Subject:

RE: [U2] Friday query logic

2008-06-24 Thread Bill Haskett
I was trying to do what the OP was trying, extract MVs that didn't meet the multiple criteria, negative though those may be. So, I tested for items where an MV account didn't start with 52 and 29. This worked. But I added a requirement to output just those MV accounts that didn't start with