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: 1753
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 Data replication from multiple Db2 ta... kishpra DB2 5 Mon Mar 27, 2017 9:58 pm
No new posts Count the length of the record & ... sreekusr DFSORT/ICETOOL 4 Thu Mar 23, 2017 7:52 pm
No new posts Export flat file data into excel sheet murali.andaluri DFSORT/ICETOOL 2 Mon Mar 20, 2017 5:39 pm
No new posts Append data from two files into a sin... Praveen04 DFSORT/ICETOOL 5 Thu Mar 16, 2017 7:29 pm
No new posts Display FTP Session Count within TSO Yolanda Harvey TSO/ISPF 3 Fri Mar 10, 2017 10:31 pm


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