Querying string variable > 255 bytes

Moderators: statman, Analyst Techy, andris, Fierce, GerineL, Smash

spsspsyc
Posts: 1
Joined: Sat Aug 25, 2012 3:07 am

Querying string variable > 255 bytes

Postby spsspsyc » Sat Aug 25, 2012 3:26 am

Hello,

I am trying to get a string variable greater than 255 bytes from SQL to SPSS 13. The following syntax successfully sets the default string width listed in Variable View to 1000, but in Data View, the text as remains as truncated as it was under the default setting. When using the syntax below, I do see that additional spaces (lots of them) have been added to the right of the text, though.

Am I missing something? I appreciate any help you all can provide. Thank you!

GET DATA /TYPE=ODBC /CONNECT=
'DSN=cpResearchDB; UID=; APP=SPSS For Windows; DATABASE=cpResearchDB;'
'Trusted_Connection=Yes'
/SQL= 'SELECT "trc"."ResearchID" AS "ResearchID", "trc"."Condition", "dbo".getTxtNum(tblDoSS.assessmentkey,tblDoSS.sequence,11346) AS "DoSSSt" '
'FROM "tblAssessmentKey" INNER JOIN "tblResearchClients" "trc"'
' ON "trc"."ResearchID"="tblAssessmentKey"."ResearchID" INNER JOIN "tblDoSS" ON "tblAssessmentKey"."AssessmentKey"="tblDoSS"."assessmentkey" '
/ASSUMEDSTRWIDTH=1000.
EXECUTE .

Who is online

Users browsing this forum: No registered users and 1 guest

cron