ADSM-L
[Top] [All Lists]
<prev [Date] next>
[Advanced]
 <prev [Thread] next>

[ADSM-L] trouble trimming collumns in select

2015-06-02 15:59:09
Subject: [ADSM-L] trouble trimming collumns in select
From: "Lee, Gary" <glee AT BSU DOT EDU>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Tue, 2 Jun 2015 19:57:33 +0000 
Have the following script, but when I run on a 6.2.5 server using a 6.4.2 
command line client no trimming is done.
Lines are thousands of characters long.

Script follows:

SELECT rtrim(node_name), -
rtrim(filespace_name), -
filespace_id, -
rtrim(filespace_type), -
DATE(backup_end) as "backup DATE" -
FROM filespaces WHERE -
  DAYS(current_date)-DAYS(backup_end)> $1


What have I missed?
[More with this subject...]
<Prev in Thread] Current Thread [Next in Thread>
Previous by Date:  Re: [ADSM-L] Problem logging in to administrator ID with DHCP node, Zoltan Forray
Next by Date:  Re: [ADSM-L] trouble trimming collumns in select, Ron Delaware
Previous by Thread:  [ADSM-L] Problem logging in to administrator ID with DHCP node, Zoltan Forray
Next by Thread:  Re: [ADSM-L] trouble trimming collumns in select, Ron Delaware
Indexes:  [Date] [Thread] [Top] [All Lists]