Error : Not bounded length
Moderators: chulett, rschirm, roy
Apologies on my part, I re-read your previous post. Insert is working but update is not huh..
Have you tried generated sql query as I asked you before.
The error maybe due to the fact that you are passing less number of columns in update as compared to the number specified in the column's tab. Try adding all the columns and see if that works.
Have you tried generated sql query as I asked you before.
The error maybe due to the fact that you are passing less number of columns in update as compared to the number specified in the column's tab. Try adding all the columns and see if that works.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
Thanks DSGuru2B,
I tried as you said and found that Actully Insert Giving me Fatal:
Thanks
I tried as you said and found that Actully Insert Giving me Fatal:
What is wrong with this ? All columns are there in Column Tab.INSERT INTO Table_name
( SUB_NM, G_SK, EFF_DT,EXP_DT, C_CD, A_SK)
VALUES
(
ORCHESTRATE.SUB_NM,
ORCHESTRATE.G_SK ,
CURRENT DATE,
'9999-12-31',
'C',
ORCHESTRATE.A_SK
)
Thanks
-
- Premium Member
- Posts: 1255
- Joined: Wed Feb 02, 2005 11:54 am
- Location: United States of America
I think it doesn't like the string '9999-12-31' - what is the column data type for that value? Perhaps you need to cast this string to a date or timestamp...
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Try "DATE('9999-12-31')"
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Did you try ArndW's suggestion?
Alternatively, do all the hardcoding in the transformer and dont hardcode anything inside the sql.
Are you getting any sql codes along with your error message, including the warning messages?
Alternatively, do all the hardcoding in the transformer and dont hardcode anything inside the sql.
Are you getting any sql codes along with your error message, including the warning messages?
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
Post the reply for ArndW's question. There is little we can do sitting on the other side of your screen. Try making the date column as varchar and see if that helps.ArndW wrote:What are your column definitions? At least one of these is incorrect for DataStage.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.