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: u2-users@listserver.u2ug.org >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 >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/