How to use Join while using DSNUTILB for unload

[Prasanna G]

Hi

Can anyone let me know the sample unload card that can be used to unload table A by joining Table B. I am getting error when I try to use the below control card

Code: Select all

UNLOAD TABLESPACE DBAPC001.TSAPCACT PART 5
NOPAD MAXERR 1
SHRLEVEL CHANGE ISOLATION UR
FROM APCWTBT.TBAPCACT A, DGSWTBT.TBDGSACT B
WHERE A.MLACNO =B.MLACNO
 

Error

Code: Select all

INVALID OPERAND 'A' FOR KEYWORD 'FROM'
 

[sergeyken]

RTFM:
1) UNLOAD TABLESPACE syntax is not compatible with FROM TABLE syntax.
2) FROM TABLE syntax is not the same as SELECT FROM syntax

Read here carefully

[Prasanna G]

Hi Sergeyken

Is it possible to get the table A partition 5 data based on joining with table B. I know

Code: Select all

Select a.* From table1 a, table2 b
Where a.key=b.key
 

Works.. is there any other way

[sergeyken]

Hi Sergeyken

Is it possible to get the table A partition 5 data based on joining with table B. I know

Code: Select all

Select a.* From table1 a, table2 b
Where a.key=b.key
 

Works.. is there any other way

The SELECT statement, and UNLOAD utility - those are two completely different entities.
Is your problem with either SELECT, or UNLOAD?

[Prasanna G]

I would like to unload the partition 5 of table A for the matching rows of Table B.

[sergeyken]

I would like to unload the partition 5 of table A for the matching rows of Table B.

Why not to read the manual on UNLOAD utility?

Plus: read #1 of my first reply.

[engh]

since the SQL 1992 standard, joins are no longer coded in the WHERE restriction, but with the JOIN operator.
it would be time to get started.
In addition, SELECT * compromises the use of covering indexes if they exist and makes impact studies inoperative, moreover, with joins, the joined columns appear as many times as there are joined tables...
instruction to be replaced by the list of columns useful for processing!