hi

I want to unload the data from a view.(z/os DB2). Is there any way to select data to unload from a view.
right now I am using this to unload the whole table

UNLOAD TABLESPACE R1BANCS.TSMFFM DELIMITED COLDEL '-'
FROM TABLE
"R1BANCS"."MFFM"

how can I unload only from the view (eg:MFFM_VIEW)

Thanks
Navid

I don't know from view.
But, you can specify DATA option to unload columns of tables in a tablespace.

Here is a description in the manual "DB2 Version 9.1 for z/OS Utility Guide and Reference"

Navid2000, Going by your syntax, I believe you are using the Unload utility. This Utility is very restrictive on what it can do. It unloads by accessing a Table space. If you only have one table per table space, you can only unload the one table. If you have 2 or more tables in the same table space, you can unload from those tables with one Unload Utility statement.

Also, you can not join tables (or use subqueries, I believe). If your view does any of these things, it can't be used. And because of its restrictive nature, I would be surprised if it can unload from a View at all (there is no mention of this ability).

You should have the IBM DSNTIAUL program available. If you use this with the PARMS(SQL) option, it indicates it will accept any valid dynamic SQL Statement. Since using a View is valid in dynamic SQL, you should be able to use DSNTIAUL program to Unload using a View. But I don't think you can unload to a CSV file as you are trying to do.

There is a third option but you have to pay for it. There is an IBM High Performance Unload (HPU). When you supply HPU with an SQL statement that it can't not process directly, it call DSNTIAUL to perform the SQL. You can define CSV output and I believe it will the output will be in CSV format even if the SQL was passed to DSNTAIUL.

You can unload from view using DSNTIAUL in z/OS as stealth_DBA mentioned. The job card of this type some thing like as below.

//SYSTSIN DD *
DSN SYSTEM(DBSYSTEM)
RUN PROGRAM(DSNTIAUL) PLAN(DSNTIAUL) PARM('SQL')
//SYSIN DD *
SELECT * FROM SCHEMA.VIEWNAME
;

Thanks guys. Appreciate it.