I don't think it is an SQL question. The SELECT works just fine as is when I run it as a TSM script.
I think your problem is something to do with extraneous characters, character set, or with stdin on the host, not with TSM SQL. -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Richard Rhodes Sent: Tuesday, January 18, 2005 11:35 AM To: ADSM-L@VM.MARIST.EDU Subject: yasq (yet another sql question . . . . ) Hi Everyone . . . I'm trying to do a couple things . . . . 1) Trying to get a listing as follows, where the occupancy filespace stats are sum'ed for each node, with the node domain thrown in: like this: <node> <domain> <sum-files> <sum-physicalMB> <sum-logicalMB> Here is the command I'm trying . . . . dsmadmc -id=admin -password=admin -tab <<EOD select - occupancy.node_name, - nodes.domain_name, - sum(occupancy.num_files), - sum(occupancy.physical_mb), - sum(occupancy.logical_mb) - from occupancy, nodes - where occupancy.node_name = nodes.node_name - group by occupancy.node_name, nodes.domain_name EOD When I run this, I get a ZILLION of the following message, and the cmd never finishes (or I'm impatient and don't wait long enough). "The character '#' stands for any decimal integer.The only valid responses are characters from this set: [Y, N]" question -> What is the above message and what dumb thing am I doing wrong? 2) I would like to generate a report that sum's files, physicalMB and logicalMB per domain. like this: <domain> <sum-files> <sum-physicalMB> <sum-logicalMB> question: Is there a cmd or a sql statement to do this? I guess it would be very similar to the above sql, except without the node_name, but since I can't get that one right, I figure I'll need help with this one also. Thanks Rick ----------------------------------------- The information contained in this message is intended only for the personal and confidential use of the recipient(s) named above. If the reader of this message is not the intended recipient or an agent responsible for delivering it to the intended recipient, you are hereby notified that you have received this document in error and that any review, dissemination, distribution, or copying of this message is strictly prohibited. If you have received this communication in error, please notify us immediately, and delete the original message.
