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
 

 

To display or unload VARGRAPHIC data

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

New User


Joined: 15 Aug 2009
Posts: 29
Location: Chennai

PostPosted: Fri Aug 24, 2012 8:45 pm    Post subject: To display or unload VARGRAPHIC data
Reply with quote

Hi i am unable to unload VARGRAPHIC data..

When i use the below query :

Code:
  SELECT SRC_SYS_ACRNM,                     
         SRC_AFLTN_CD,                       
         ACCT_ID_NO,                         
         MST_CUST_NM                         
  FROM Z1EP001$.CIM_STG_CUST_CFSC_ML         
  FETCH FIRST 5 ROWS ONLY                   
          ;                         


Note : MST_CUST_NM --> VARGRAPHIC Datatype

I am facing below error

Code:
CFSC           UNISON        100003           .........                   
DSNT400I SQLCODE = 000,  SUCCESSFUL EXECUTION                             
DSNT418I SQLSTATE   = 01517 SQLSTATE RETURN CODE                           
DSNT415I SQLERRP    = DSN SQL PROCEDURE DETECTING ERROR                   
DSNT416I SQLERRD    = 0 0  0  -1  0  0 SQL DIAGNOSTIC INFORMATION         
DSNT416I SQLERRD    = X'00000000'  X'00000000'  X'00000000'  X'FFFFFFFF'   
         X'00000000'  X'00000000' SQL DIAGNOSTIC INFORMATION               
DSNT417I SQLWARN0-5 = W,,,,, SQL WARNINGS                                 
DSNT417I SQLWARN6-A = ,,W,,   SQL WARNINGS                                 
CFSC           UNISON        100004           ...(....) 

DSNT400I SQLCODE = 000,  SUCCESSFUL EXECUTION           
DSNT418I SQLSTATE   = 01517 SQLSTATE RETURN CODE



Even SQL Code is ).. i could nt see any data...
=======================
if i remove the VARGRAPHIC column and if try to execute below query the query completes successful and i am able to see data..

Is there any special key word i need to add in SQL query to see VARGRAPHIC Data...

Please Suggest

Code'd
Back to top
View user's profile Send private message

Akatsukami

Global Moderator


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

PostPosted: Fri Aug 24, 2012 8:59 pm    Post subject:
Reply with quote

Are you using the correct CCSID?
Back to top
View user's profile Send private message
lagneshp

New User


Joined: 15 Aug 2009
Posts: 29
Location: Chennai

PostPosted: Fri Aug 24, 2012 9:07 pm    Post subject:
Reply with quote

When I checked CCSID for the column i got the below:

---------+---------+---------+--
FOREIGNKEY CCSID
---------+---------+---------+--
S 37
S 37
S 37
1200
S 37

Please suggest me where and how i need to use this in my SQL to see VARGRAPHIC data..
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 Replace values in the input data Vikas Maharnawar DFSORT/ICETOOL 10 Thu May 11, 2017 2:18 pm
No new posts Group Data based on a key Arun Raj DFSORT/ICETOOL 7 Thu Apr 27, 2017 11:29 pm
No new posts unload data from table with lob columns farhad_evan DB2 0 Sat Apr 22, 2017 1:32 pm
No new posts SORT JSON type of data maxsubrat DFSORT/ICETOOL 8 Wed Apr 19, 2017 6:01 pm
This topic is locked: you cannot edit posts or make replies. Need help in estimating space of unlo... ashek15 IMS DB/DC 12 Fri Apr 07, 2017 5:11 am


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