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/
