|
View previous topic :: View next topic
|
| Author |
Message |
Majid Hussain
New User
Joined: 18 Aug 2007
Posts: 20
Location: Bangalore
|
|
|
|
Hi all
I am using BMC Utility to load and unload data to DB2 tables.I am facing exactly the same error mentioned in the below post.
ibmmainframes.com/viewtopic.php?t=53123&highlight=xml
There was a response that the feature is not supported by BMC UNLOAD back in 2011. Is it still not supported by BMC?
Here is the DDL for the table.
| Code: |
CREATE TABLE USER1.TABLE1
(
COLUMN1 CHAR(19) NOT NULL
,COLUMN2 CHAR(6) NOT NULL
,COLUMN3 CHAR(1) NOT NULL WITH DEFAULT
,COLUMN4 XML
,COLUMN5 CHAR(8) NOT NULL WITH DEFAULT
,COLUMN6 CHAR(2) NOT NULL WITH DEFAULT
)
IN DATABASE.TABLESPACE
CCSID EBCDIC
NOT VOLATILE
APPEND NO;
|
|
|
| Back to top |
|
 |
Akatsukami
Global Moderator
Joined: 03 Oct 2009
Posts: 1788
Location: Bloomington, IL
|
|
|
|
| And what does it say in the manual for your -- licensed, of course -- version of BMC Unload Plus? |
|
| Back to top |
|
|
Majid Hussain
New User
Joined: 18 Aug 2007
Posts: 20
Location: Bangalore
|
|
|
|
I could not find any direction on the unload of XML columns in the manual.
The Mainframe has UNLOAD PLUS(R) for DB2* Reference Manual V 4.1. I am not sure if this is the latest version. |
|
| Back to top |
|
|
sushanth bobby
Senior Member
Joined: 29 Jul 2008
Posts: 1020
Location: India
|
|
|
|
Hi Majid,
What version of BMC Utilities are you using ?
I am using BMC V10R1.00,
My Table Details are,
| Code: |
Column Name ColNo Datatyp Length
---1----v----2----v----3----v----4----v-
EMPNO 1 CHAR 6
EMP_XML 2 XML 6
DB2_GENE.._FOR_XML 3 BIGINT 8
************************ BOTTOM OF DATA
|
Below is a sample unload card,
TESTED
| Code: |
UNLOAD SHRLEVEL CHANGE
FIXEDVARCHAR YES
DIRECT NO
UNICODE
CNTLCARDS DB2LOAD
OUTPUT XML01 DSNAME('TEST.BOBBY.XML.TEST')
DSNTYPE LIBRARY UNIT(DASD) SPACE(500, 100) SUBSETS 1
UNIT SYSDA
SELECT EMPNO
,EMP_XML
INTO
EMPID
,EMP_XML CHAR (45) CLOBF XML01
FROM BOBBY.EMPLOYEE_XML
;
|
Load card will be sort of like this,
| Code: |
LOAD DATA INDDN SYSREC
UNICODE CCSID(367,1208,1200)
INTO TABLE
BOBBY.£TABLE1
(EMPID POSITION(1:18) CHAR MIXED(18)
,EMP_XML POSITION(19:63) CHAR(45) CLOBF
PRESERVE WHITESPACE
NULLIF BMC_NULL1=X'3F'
, BMC_NULL1 POSITION(64) CHAR(1)
)
|
Thanks,
Sushanth |
|
| Back to top |
|
|
|
|
