CLI0102E Invalid Conversion SQLSTATE=07006

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
MURALI123
Participant
Posts: 46
Joined: Sun Jun 21, 2009 1:37 am
Location: CHENNAI

CLI0102E Invalid Conversion SQLSTATE=07006

Post by MURALI123 »

HI,
i am not able to viewing the data which shows :
CLI0102E Invalid Conversion SQLSTATE=07006 Repository interface error.
can anybody suggest me how can i solve this one....


Regards,
Malli
Sainath.Srinivasan
Participant
Posts: 3337
Joined: Mon Jan 17, 2005 4:49 am
Location: United Kingdom

Post by Sainath.Srinivasan »

Are you using any BLOB datatype ?
MURALI123
Participant
Posts: 46
Joined: Sun Jun 21, 2009 1:37 am
Location: CHENNAI

Post by MURALI123 »

I am using TimeStamp in DUE_DATE and TRXN_DATE columns



Sainath.Srinivasan wrote:Are you using any BLOB datatype ? ...
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Give us some details to work with here. Stage, database, your sql, something to help us help you. :?
-craig

"You can never have too many knives" -- Logan Nine Fingers
MURALI123
Participant
Posts: 46
Joined: Sun Jun 21, 2009 1:37 am
Location: CHENNAI

Post by MURALI123 »

Stage is DB2 stage, Database is DB2.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

And? Details, man, details. Are you purposefully trying to make it as hard as possible for anyone to help you?
-craig

"You can never have too many knives" -- Logan Nine Fingers
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Maybe Murali is being paid by the hour?
:wink:
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply