DECODE Question again
From: Systems Admin <sysadmin_at_doj.vic.gov.au>
Date: 1996/11/07
Message-ID: <55roqe$gae_at_news.mel.aone.net.au>#1/1
Date: 1996/11/07
Message-ID: <55roqe$gae_at_news.mel.aone.net.au>#1/1
However, although the LOG file shows no errors, the column is empty
when I do a select from the table. If I put 'xxx' after the 'sdisk174'
in the CTL file, this gets loaded ok.
Also, if I load the data in the original form, when I do a
SELECT
It also shows an empty column.
What am I missing?
Thanks,
Andy Horne
Received on Thu Nov 07 1996 - 00:00:00 CET
DECODE('disk_name','(dgsc(vme(0),1,7),0,4)','sdisk174')
FROM diskstats;