Problem with LongVarchar datatype in DataStage
Posted: Sun Nov 13, 2005 11:29 pm
Hi Forum,
Firstly, Thank you all for helping me so far. Its simply gr8
Secondly: I have searched the forum before posting this problem, Igot lots of matches, but nothing helped.(keyword I used Longvarchar)
Now the problem, I have a job in which I am populating the contents of a SQL Server table to a file (Sequential File). One of the fields is a text in SQL. When I import the table's metadata it converts it to longvarchar2147483647. I ran the job it gave me error
Test_It..Dynamic_RDBMS_1: Error occurred during link open processing.
Test_It..Dynamic_RDBMS_1.DSLink2: DSP.Open GCI $DSP.Open error -100.
Test_It..Sequential_File_0.IDENT1: |Test_It..Dynamic_RDBMS_1.DSLink2: DSP.Open GCI $DSP.Open error -100.|
Morethan that when I tried to modify the size of this column it shows me only 214748364 instead of 2147483647. The moment I get out of the column it again show 2147483647. (Is it a known bug)
.
Then I modified the column size to 214748364, it worked fine.
What's the problem with 2147483647? Any suggestions!
Do we have any global settings for datatype longvarchar's max size that I need to modify?, I didn't find it in uvconfig.
Thanks in advance.
Firstly, Thank you all for helping me so far. Its simply gr8
![Smile :)](./images/smilies/icon_smile.gif)
Secondly: I have searched the forum before posting this problem, Igot lots of matches, but nothing helped.(keyword I used Longvarchar)
Now the problem, I have a job in which I am populating the contents of a SQL Server table to a file (Sequential File). One of the fields is a text in SQL. When I import the table's metadata it converts it to longvarchar2147483647. I ran the job it gave me error
Test_It..Dynamic_RDBMS_1: Error occurred during link open processing.
Test_It..Dynamic_RDBMS_1.DSLink2: DSP.Open GCI $DSP.Open error -100.
Test_It..Sequential_File_0.IDENT1: |Test_It..Dynamic_RDBMS_1.DSLink2: DSP.Open GCI $DSP.Open error -100.|
Morethan that when I tried to modify the size of this column it shows me only 214748364 instead of 2147483647. The moment I get out of the column it again show 2147483647. (Is it a known bug)
![Question :?:](./images/smilies/icon_question.gif)
Then I modified the column size to 214748364, it worked fine.
What's the problem with 2147483647? Any suggestions!
Do we have any global settings for datatype longvarchar's max size that I need to modify?, I didn't find it in uvconfig.
Thanks in advance.