I am not sure whether it is a bug or I am doing something funny but this is what I am facing:
I want to fetch a rows from DB2 table to flat file. There is a field in this table with datatype BigInt and length as 19.
I created a parallel job whose structure is
ODBC Stage --------------> Seq File
I got junk value for this particular field. Everyting else fine
I am using User defined SQL
I tried the same functionality by replacing ODBC with DB2 stage, I got valid values
All the things - query, metadata table name etc remain same in both jobs.
In both jobs I am using metadta which is imported from ODBC table definitions.
The issue is I must use ODBC. Reason is that I am developing job in test environment and the rows to be fetched is a table in production Database. I use Data source facility in ODBC to connect from test to prod. This cannot be done in DB2. When I said that I tried the job with DB2 stage, that was in production.
Please explain
ODBC stage Metadata Issue for Bigint data type
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 284
- Joined: Fri Oct 13, 2006 4:31 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 284
- Joined: Fri Oct 13, 2006 4:31 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 284
- Joined: Fri Oct 13, 2006 4:31 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
There are many versions of the ODBC standard. It is a Microsoft standard. The ODBC Enterprise stage documentation (in the Parallel Job Developer's Guide) suggests that it is compliant with version 3.5 of the ODBC standard - read the manual for more detailed information about the grammar and API.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 284
- Joined: Fri Oct 13, 2006 4:31 am