[freetds] truncated data from query
robert lazarski
robertlazarski at gmail.com
Wed Oct 4 16:53:24 EDT 2006
> Ach, sorry, I'm wasting your time. Let's just see the TDSDUMP output. (If you see your password in that log, you're using TDS 4.2 whether you mean to be or not. But I doubt that's the case.)
>
You actually might end up saving my time. If I can get my query
non-truncated via freetds, I don't have to use microsoft and its tools
to do this ;-) .
Since this file is big, I put it here for those that want to look at it:
http://www.braziloutsource.com/random/freetds.log
I'm using a shell pipe to execute the query:
cat dt.sql | isql -m8196 -v newat3 newatuser3 newatpassword
The -m8196 doesn't seem to help. The dt.sql content I ran is:
EXEC sp_generate_inserts [FUNDASSET], at owner = [dbo], at ommit_images = 1,
@disable_constraints = 1
That produced about 20 lines truncated like:
| INSERT [dbo].[FUNDASSET]
([fundAssetID],[created],[modified],[createdUserID],[modifiedUserID],[currentShares],[washRuleDate],[maxPositionSize],[maxPositionReason],[annualizeReturn],[expectedReturnCalculation],[assetID],[fundID],[statusID],[categoryID])VALUES(1,NULL,NULL,NULL,NULL,1250000,'Jul
5 200|
| INSERT [dbo].[FUNDASSET]
([fundAssetID],[created],[modified],[createdUserID],[modifiedUserID],[currentShares],[washRuleDate],[maxPositionSize],[maxPositionReason],[annualizeReturn],[expectedReturnCalculation],[assetID],[fundID],[statusID],[categoryID])VALUES(2,NULL,NULL,NULL,NULL,350000,'Jul
5 2006|
The date is truncated as well as 8 more columns of data.
Thanks! Sure, let me know off line how I can help work out the linux problems.
Robert
More information about the FreeTDS
mailing list