IBM Mainframe Forum

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



Error

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

Hi Sergeyken

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


Works.. is there any other way

Prasanna G wrote:Hi Sergeyken

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

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?

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

Prasanna G wrote: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.

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!