View previous topic :: View next topic
|
Author |
Message |
thala_ds
New User
Joined: 05 Jun 2012 Posts: 18 Location: India
|
|
|
|
Hi,
I tried to unload data from DB2 table using Syncsort and i got the below error :
DB2 QUERY SUPPORT ERROR: UNKNOWN DATA TYPE FOUND
Could somebody help me out in resolving the above issue?
P.S. Please find the jcl in the attachment
Thanks in advance,
thala_ds. |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
xxx yyyyy yyyy \\\\\\ iiiiiiii zzzzzzz jjjlllllk |
|
Back to top |
|
|
thala_ds
New User
Joined: 05 Jun 2012 Posts: 18 Location: India
|
|
|
|
Hi,
Since we are not supposed to show the table names outside my firm, i just gave the dummy name... Sorry abt that.
WER468A DB2 QUERY SUPPORT ERROR: UNKNOWN DATA TYPE FOUND
Do you need the exact query? |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
don't post screen shots.
cut and paste with the code tags is sufficient.
(but you would have known that had you read thru the FAQS
before posting)
now to figure out your problem.
UNKNOWN DATA TYPE FOUND
ok, what db2 data types will be returned in the result set?
btw,
if you read the manual, it will tell you what data types are supported. |
|
Back to top |
|
|
thala_ds
New User
Joined: 05 Jun 2012 Posts: 18 Location: India
|
|
|
|
Thanks for your help .
Below are the datatypes returned from the query.
TIMESTAMP
DATE
INTEGER
BIGINT
In the above set, it is getting the error for BIGINT datatype while unloading from the table. |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
why don't you cast it as char? |
|
Back to top |
|
|
thala_ds
New User
Joined: 05 Jun 2012 Posts: 18 Location: India
|
|
|
|
But i need to unload the entire table.
Please advise me how can i cast one field alone in SELECT statement?
Thanks. |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
Back to top |
|
|
don.leahy
Active Member
Joined: 06 Jul 2010 Posts: 765 Location: Whitby, ON, Canada
|
|
|
|
If you haven't already, you should also report this error to your support folks so that they can notify the Syncsort vendor. |
|
Back to top |
|
|
|