Hi all,
We have a file (Unidata 7.1) called B10.COMMONAPP where a MV'd attribute
called AVAILABILITY contains values representing a day and time.
AE DICT B10.COMMONAPP AVAILABILITY
Top of "AVAILABILITY" in "DICT B10.COMMONAPP", 6 lines, 24 characters.
*--: P
001: D
002: 63
003:
004: AVAILABILITY
005: 10L
006: M
Bottom.
Example record -->
063:
sun8a}mon8a}tue8a}wed8a}thu8a}fri8a}sat8a}sun830a}mon830a}tue830a}wed830a}th
u830a}fri830a}sat830a}sun9a}mon9a}tue9a}wed9a}thu9a}fri9a}sat9a}sun930a}mon9
30a}tue930a}wed930a}thu930a}fri930a}sat930a}sun10a}mon10a}tue10a}wed10a}thu1
0a}fri10a}sat10a}sun1030a}mon1030a}tue1030a}wed1030a}thu1030a}fri1030a}sat10
30a}sun11a}sat11a}sun1130a}sat1130a}sun12p}sat12p}sun1230p}sat1230p}sun1p}sa
t1p}sun130p}sat130p}sun2p}sat2p}sun230p}sat230p}sun3p}sat3p}sun330p}sat330p}
sun4p}sat4p}sun430p}sat430p}sun5p}sat5p}sun530p}sat530p}sun6p}sat6p}sun630p}
mon630p}tue630p}wed630p}thu630p}fri630p}sat630p}sun7p}mon7p}tue7p}wed7p}thu7
p}fri7p}sat7p}sun730p}mon730p}tue730p}wed730p}thu730p}fri730p}sat730p}sun8p}
mon8p}tue8p}wed8p}thu8p}fri8p}sat8p}sun830p}mon830p}tue830p}wed830p}thu830p}
fri830p}sat830p
Bottom.
Can anyone tell us why ->
SELECT B10.COMMONAPP WITH AVAILABILITY LIKE "...8a..."
Produces->
No data retrieved from current (S)SELECT statement.
Thanks,
*-----------------------------------------------------------*
Jon Wells
Database Administrator Beloit College
Information Services & Resources Beloit, Wisconsin
608-363-2290 [EMAIL PROTECTED] 608-363-2100 (fax)
*-----------------------------------------------------------*
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
