Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

UNLOAD/LOAD DB2 table with XML data type

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
Majid Hussain

New User


Joined: 18 Aug 2007
Posts: 20
Location: Bangalore

PostPosted: Thu Aug 14, 2014 4:45 am    Post subject: UNLOAD/LOAD DB2 table with XML data type
Reply with quote

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.

http://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
View user's profile Send private message

Akatsukami

Global Moderator


Joined: 03 Oct 2009
Posts: 1738
Location: Bloomington, IL

PostPosted: Thu Aug 14, 2014 5:27 am    Post subject:
Reply with quote

And what does it say in the manual for your -- licensed, of course -- version of BMC Unload Plus?
Back to top
View user's profile Send private message
Majid Hussain

New User


Joined: 18 Aug 2007
Posts: 20
Location: Bangalore

PostPosted: Thu Aug 14, 2014 5:40 am    Post subject:
Reply with quote

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
View user's profile Send private message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Tue Sep 02, 2014 12:35 pm    Post subject:
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Is the 'prompt' data for the DSLIST p... Willy Jensen TSO/ISPF 2 Tue Dec 06, 2016 4:38 am
No new posts How to move a long alphanumeric data ... lind sh COBOL Programming 6 Mon Dec 05, 2016 7:51 pm
No new posts ODPP(Optim Data privacy Provider) Iss... Rama kishore IBM Tools 1 Mon Nov 07, 2016 5:46 pm
No new posts Can sending 5 MB data between cobol p... Kevin Vaz CICS 12 Tue Oct 18, 2016 4:50 pm
No new posts output data in CSV Format janmejay COBOL Programming 8 Sat Oct 15, 2016 2:20 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us