View previous topic :: View next topic
|
Author |
Message |
harinair_kn Warnings : 2 New User
Joined: 27 Feb 2006 Posts: 16 Location: India
|
|
|
|
Hi
I am having two tables A and B.Column1 of both the tables are same valuse but in table A it is declared as Integer and NOT NULL.But in table B it is Integer. Now as per the optimized query I want to use the value from column B. But due to this selection, I am getting the output record length as 28. Previously it was 29. Beacuse of this mismatch, all other steps are failing. Is there any way to add one more byte in the select statement? |
|
Back to top |
|
|
ashimer
Active Member
Joined: 13 Feb 2004 Posts: 551 Location: Bangalore
|
|
|
|
What do you mean by record length mismatch ? the Column definition is the same ..
Post your query |
|
Back to top |
|
|
harinair_kn Warnings : 2 New User
Joined: 27 Feb 2006 Posts: 16 Location: India
|
|
|
|
Its because of the Null Indicator |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
Ashimer,
He is probably dumping and the extra char was the NULL Indicator.
but it seems his explanation is a little screwy,
but then again, I got up early today and am not fully prepared for Psychic Thursday |
|
Back to top |
|
|
ashishsr123
New User
Joined: 06 May 2008 Posts: 33 Location: Chennai
|
|
|
|
If you post your SQL query then we can help you better.
Not completely sure what your are talking. |
|
Back to top |
|
|
|