lagneshp
New User
Joined: 15 Aug 2009 Posts: 29 Location: Chennai
|
|
|
|
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 |
|