Report Field getting Delimited

[dicowins]

I created this script
'select cast((NODE_NAME) as char(20)) as "NODE",cast((REPORTING_MB) as char(20)) as "MB",cast((FILESPACE_NAME) as char(50)) as "FS",TYPE from OCCUPANCY where REPORTING_MB>0.00'

This is the Structure of OCCUPANCY
Fieldname Length
--------------------------------------------------- ---------------------
FILESPACE_ID 4
FILESPACE_NAME 1025
LOGICAL_MB 31
NODE_NAME 65
NUM_FILES 8
PHYSICAL_MB 31
REPORTING_MB 31
STGPOOL_NAME 31
TYPE 4

However when I run script
NODE MB FS TYPE
----------------- --------------------- ----------------------------------------------------------------------------------------------------- -----
N1IBNPRP01 29.37 /usr/local Bkup
RV_RVI_DATACENTE .02 \VMFULL-NUTHMirthPRD Bkup
FV_FH_DATACENTER .79 \VMFULL-NUTH-FOM05 Bkup
RV_RVI_DATACENTE .83 \VMFULL-VIRTUAL-SQL Bkup


RV_RVI_DATACENTE should be RV_RVI_DATACENTER !

Edited by marclant to fix font size to be readable.

 

[marclant]

The formatting comes out all wrong, it's hard to see what you mean. Although by counting the number of dashes, it looks like the char(20) and char(50) didn't work.

In the future when pasting outputs, select </> Code from this drop down:


Paste your text in the pop-up and this will keep the text formatting as you were seeing it and not wrap into multiple lines.