Re: [U2] Reporting Tools

2014-03-04 Thread Riverman 
I created a program (LIST.EXPORT) that works similar to the LIST command. The
report has tab delimited columns and is output to the HOLD file. The
command line command LIST.EXPORT allows conv and col.hdg column modifiers.
The command requires a saved list name to know which records to select. I
suspect the only limitation is the number of characters that can be entered
on a command line.
LIST.EXPORT reads the dictionary record for each column to determine if it
is a D or I type. Value marks and sub value marks are converted to
spaces. I have not yet added normalisation to the routine.



--
View this message in context: 
http://u2-universe-unidata.1073795.n5.nabble.com/Reporting-Tools-tp42725p42781.html
Sent from the U2 - Users mailing list archive at Nabble.com.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Reporting Tools

2014-03-04 Thread Riverman 
The program does use the heading from DICT as a default column heading. I
included 65 lines of explanations and examples in the program but left out
some of the information for this post in the interest of brevity.



--
View this message in context: 
http://u2-universe-unidata.1073795.n5.nabble.com/Reporting-Tools-tp42725p42783.html
Sent from the U2 - Users mailing list archive at Nabble.com.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

[U2] SQL Update Multiple rows

2013-08-22 Thread Riverman 

Here is the SQL example I am trying to follow

UPDATE dbo.Product
   SET Availability=CASE When ProductId='1' Then '5'
 When ProductId='2' Then '5'
 When ProductId='6' Then '10'
 Else Availability
 END

My attempts

UPDATE TESTFILE SET TRAN.NUMBER=CASE WHEN CONTROL.NUMBER.NFMT='9001' THEN
'' WHEN CONTROL.NUMBER.NFMT='66551' THEN '' WHEN CONTROL.NUMBER.NFMT='1205'
THEN '' ELSE TRAN.NUMBER END;
UniVerse/SQL: A WHEN clause must have at least one multi-valued column

UPDATE TESTFILE SET TRAN.NUMBER=CASE WHERE CONTROL.NUMBER.NFMT='9001' THEN
'' WHERE CONTROL.NUMBER.NFMT='66551' THEN '' WHERE
CONTROL.NUMBER.NFMT='1205' THEN '' ELSE TRAN.NUMBER END;
UniVerse/SQL: syntax error.  Unexpected symbol.  Token was THEN.
Scanned command was UPDATE RECEIPT SET TRANSACTION.H = CASE WHERE
CONTROL.NUMBER.NFMT = 900166550841 THEN 

Universe 10.1.1, Windows Server 2003



--
View this message in context: 
http://u2-universe-unidata.1073795.n5.nabble.com/SQL-Update-Multiple-rows-tp41681.html
Sent from the U2 - Users mailing list archive at Nabble.com.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] SQL Update Multiple rows

2013-08-22 Thread Riverman 
Dunces cap firmly attached to head.

For future reference can multiple rows be updated to different values for
the same field?



--
View this message in context: 
http://u2-universe-unidata.1073795.n5.nabble.com/SQL-Update-Multiple-rows-tp41681p41683.html
Sent from the U2 - Users mailing list archive at Nabble.com.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] SQL Update Multiple rows

2013-08-22 Thread Riverman 
I had to change  to NULL. The field has a format of 8R so I assume SQL is
interpreting this as a numeric field, not a string.

UPDATE TESTFILE SET TRAN.NUMBER=NULL WHERE CONTROL.NUMBER.NFMT='9001' OR
CONTROL.NUMBER.NFMT='66551' OR CONTROL.NUMBER.NFMT='1205' 





--
View this message in context: 
http://u2-universe-unidata.1073795.n5.nabble.com/SQL-Update-Multiple-rows-tp41681p41684.html
Sent from the U2 - Users mailing list archive at Nabble.com.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] SQL Update Multiple rows

2013-08-22 Thread Riverman 
As Kurt pointed out I should have used single quotes ('') instead of NULL.
NULL updated the field with char(128).



--
View this message in context: 
http://u2-universe-unidata.1073795.n5.nabble.com/SQL-Update-Multiple-rows-tp41681p41685.html
Sent from the U2 - Users mailing list archive at Nabble.com.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Benton Scheduler

2013-07-19 Thread Riverman 
Thanks to all the speedy responders. I am pleased Benton is still alive and
well, according to Google you do not exist. Searches only returned dead
links. Benton has served us well for many years and our organisation looks
forward to many more years of faithful service.



--
View this message in context: 
http://u2-universe-unidata.1073795.n5.nabble.com/Benton-Scheduler-tp41282p41299.html
Sent from the U2 - Users mailing list archive at Nabble.com.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

[U2] Benton Scheduler

2013-07-18 Thread Riverman 
I am looking for source code for Infocus's Benton scheduler. As far as i can
tell Infocus has disappeared from this planet. Our organisation is having
some challenges with reinstalling Benton. I am also looking for other
scheduler options.



--
View this message in context: 
http://u2-universe-unidata.1073795.n5.nabble.com/Benton-Scheduler-tp41282.html
Sent from the U2 - Users mailing list archive at Nabble.com.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users