Re: UNLOAD LOB-Columns > 32KB

Geschrieben von Gernot Ruban am November 12, 2003 um 20:11:

Als Antwort auf UNLOAD LOB-Columns > 32KB geschrieben von Stefan Ridinger on November 07, 2003 um 14:22:

Hallo Stefan,

folgendes kann nicht UNLOAD'ed werden:

- Dropped tables: They cannot be unloaded from an image copy that still exists. Even if you recreate the table, you still will be unable to unload the data (the OBID number will have changed when you recreate)
- DSNDB01 cannot be unloaded: Some of the objects in DSNDB01 are not even real tables and also DSNDB01 does not have entries in DSNDB06.
- LOB data > 32K: A MVS restriction is that records cannot be larger then 32K. LOBs can be (much) larger than 32K. To unload LOBs YOU have to unload the base table.
- Global temp table: These tables are empty until SQL processing puts data into them
- Views or SQL statements as input: This is a powerful feature of DSNTIAUL but requires SQL processing

Gruß
Gernot

Antworten:

Schreibe eine Antwort

Name:
E-Mail:

Thema:

Kommentar:
: Hallo Stefan, : folgendes kann nicht UNLOAD'ed werden: : - Dropped tables: They cannot be unloaded from an image copy that still exists. Even if you recreate the table, you still will be unable to unload the data (the OBID number will have changed when you recreate) : - DSNDB01 cannot be unloaded: Some of the objects in DSNDB01 are not even real tables and also DSNDB01 does not have entries in DSNDB06. : - LOB data > 32K: A MVS restriction is that records cannot be larger then 32K. LOBs can be (much) larger than 32K. To unload LOBs YOU have to unload the base table. : - Global temp table: These tables are empty until SQL processing puts data into them : - Views or SQL statements as input: This is a powerful feature of DSNTIAUL but requires SQL processing : Gruß : Gernot

Optionale Link URL:
Link Titel:
Optionale Image URL:

[ Antworten ] [ Forum ]