Colin: You're the best! I had created a new paragraph called "UDT.ON.PICK" that set some 15-20 UDT.OPTIONS. I run this in the LOGIN paragraph and had put "EXECUTE \UDT.ON.PICK\" into the UOLOGIN program. However, I had not re-cataloged it; thus it wasn't running in global space. I simply re-cataloged UOLOGIN globally and voi'la! :-)
Many thanks. Bill >-----Original Message----- >From: Bill Haskett [mailto:[EMAIL PROTECTED] >Sent: Wednesday, June 25, 2008 7:52 PM >To: '[email protected]' >Subject: RE: [U2] [UD] UD query anomoly > >Thanks Colin. This gives me something to look into. > >Bill > >>-----Original Message----- >>From: [EMAIL PROTECTED] [mailto:owner-u2- >>[EMAIL PROTECTED] On Behalf Of Colin Alfke >>Sent: Wednesday, June 25, 2008 12:59 PM >>To: [email protected] >>Subject: RE: [U2] [UD] UD query anomoly >> >>Bill; >> >>UO doesn't go through the LOGIN VOC so your UDT.OPTIONS may not be the same. >>You can use a globally catalogued program "UOLOGIN" to set them up (see IBM >>ref# 1181382). >> >>I tried a similar sort using IBM's Ucommand program which uses UniObjects to >>connect and run a command (ref# 105866). It didn't parse the "'V'" properly >>so it wouldn't actually run the command. Not much help there. >> >>I don't use DB but I do use SB. It has a function to download reports to >>Excel. I noticed the other day that when dict format was set to '0R' it >>actually hid the column in Excel. My point being that SB doesn't actually >>run the sort command. It parses it and creates it's own data. Perhaps DB is >>doing something similar that is messing up the output. >> >>food for thought >> >>Colin Alfke >>Calgary, Canada >> >>-----Original Message----- >>From: Bill Haskett >><snip> >> >>But I've noticed UD has some weird results with the query language. For >>instance, we have a BASIC program that creates a query and outputs to the >>spooler. Yesterday the output for a single column was different based on >>running the program from telnet or from UniObjects (DesignBais). Same >>report, same BASIC program, same account, same dictionaries, same data; but >>the output of a single column was different. >> >>From Telnet... >>3 Intel (0)-> SORT APOPEN BY ISPD LPTR INVDATE COMMENT FMT "25L" ACCTS >>BREAK-ON ISPD "'V'" TOTAL AMTS CHECKNO >> >>APOPEN.... INV-DATE DESCRIPTION.............. ACCT. ACCT/AMTS.... CK#.... >> >>1025*672 01-19-08 PMT ON ACCT#XXX8218 2920 101.19 >> >> >>980*1033 05-15-08 EMPLOYER MCARE W/H 5020 3.63 >> ------------- >> NonPaid 5,594.14 >> >> >>Same query from UniObjects (DesignBais)... >> >>APOPEN.... INV-DATE DESCRIPTION.............. ACCT. ACCT/AMTS.... CK#.... >> >>1025*672 01-19-08 PMT ON ACCT#XXX8218 2920 101.19 >> >> >>980*1033 05-15-08 EMPLOYER MCARE W/H 5020 3.63 >> ------------- >> N 5,594.14 >> >>The dictionary used by the BREAK-ON looks like... >> >>2 Intel (0)-> AE DICT APOPEN ISPD >>Top of "ISPD" in "DICT APOPEN", 9 lines, 212 characters. >>*--: p >>001: I Output 'NonPaid' if invoice not paid and 'Paid' if it is. Used for >>break lines out output. >>002: IF CHECK_ID = "" THEN "NonPaid" ELSE "Paid" >>003: >>004: \ >>005: 0R >>006: S >>007: >>008: ISPD2CHECK_ID 42IF CHECK_ID = "" THEN "NonPaid" ELSE "Paid" >>009: APOPEN >>Bottom. >> >>Although I'm not having problems with the 1st issue (I was merely trying to >>recreate what the OP presented), this second issue does present some >>problems. >> >>Bill >>------- >>u2-users mailing list >>[email protected] >>To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
