Option of using DSNUTILB alone for unload

Alice · New User Joined: 04 Jun 2009 Posts: 4 Location: India

I have the option of using DSNUTILB alone for unload.

Is it possible to use SUBSTR function in the WHEN clause of UNLOAD command.

When I enter the following in SYSIN

UNLOAD TABLESPACE <TS Name>
FROM TABLE <Table name>
WHEN ((SUBSTR(<Column Name>,m,n)) = '<value>')

I get the message " INVALID KEYWORD - <column name>"

Escapa · Posted: Thu Jun 04, 2009 1:06 pm

post your sysout and sysprint messages..

Alice · New User Joined: 04 Jun 2009 Posts: 4 Location: India

Only Sysprint is available..
DSNU082I DSNUGPRW - INVALID KEYWORD - <Column Name>
DSNU012I DSNUGBAC - UTILITY EXECUTION TERMINATED, HIGHEST RETURN CODE=8

dbzTHEdinosauer · Posted: Thu Jun 04, 2009 2:27 pm

Try:
WHEN (SUBSTR(<Column Name>,m,n) = '<value>')

Alice · New User Joined: 04 Jun 2009 Posts: 4 Location: India

I first tried this only. It gave the same error. Thats why I included extra paranthesis.

dbzTHEdinosauer · Posted: Thu Jun 04, 2009 3:05 pm

try (column_name LIKE ...)

it appears that the predicate options of the WHEN clause are rather restrictive.
I would not be surprised if SUBSTR is not allowed.

Alice · New User Joined: 04 Jun 2009 Posts: 4 Location: India

Tried with WHEN (SUBSTR(<Column Name>,m,n) LIKE '<value>')
It doesnt work.

The problem might be with the usage of SUBSTR in WHEN clause.

dbzTHEdinosauer · Posted: Thu Jun 04, 2009 3:21 pm

glad you found your answer.

sushanth bobby · Posted: Thu Jun 04, 2009 4:11 pm

Alice,

This worked for me,

Anuj Dhawan · Posted: Thu Jun 04, 2009 4:14 pm

I seem to recall that the WHEN clause only allowed basic comparisons and wouldn't let you do functions in the comparison such as SUSBTR etc. I'd have to dig out the documentation and check (or you could do that yourself).