Date:         Tue, 4 May 2004 11:37:10 -0400
Reply-To:     Charles Harbour <harbourcharles@JOHNDEERE.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Charles Harbour <harbourcharles@JOHNDEERE.COM>
Subject:      Re: Problem SAS V8, V6, MVS, DB2
Comments: To: EBecker@VHV.DE

Welcome to the wonderful world of v8!

Not to burst your bubble, but there is no easy workaround for this.  Since
sas continues to make improvements in their system, it's not quite as
stable as some other languages (but even cobol folks have to make changes
every now and again).  You'd think after 40 years of mainframe programming,
managers would include program maintenance as part of their budgets  :-)

My solution would be to create a rename statement for your views.  You
could either do it on the fly, as you access individual views, or do it as
you create the views using v8.  Run a proc contents against your 'old'
view, to get the list of variables, and do the same against the db2 table.
Set the view name = to the long name from db2 and you're good to go.

HTH,
CH



On Mon, 3 May 2004 09:48:29 +0200, Becker, Eckhard [IK-05] <EBecker@VHV.DE>
wrote:

>Hi SAS-gurus,
>
>I have a problem using SAS V8 under MVS:
>
>I have a V6-library with views to access DB2-tables. The views are created
>with a macro (so no explicit column-nmaes are given):
>
>PROC SQL;
>CONNECT TO DB2(SSID=&SSID);
>CREATE VIEW &LIB..&DIM AS
>SELECT *
>FROM CONNECTION TO DB2(
>  SELECT
>      *
>FROM &CRE..&DB2TAB
>);
>%PUT SQLXRC  = &SQLXRC.;
>%PUT SQLXMSG = &SQLXMSG.;
>DISCONNECT FROM DB2;
>QUIT;
>
>There are DB2-columns with names longer then 8 characters, which are cut in
>SAS V6, e.g.
>
>DB2-Column: LONG_VARIABLE_NAME
>SAS-View (V6): LONG_VAR
>
>When I allocate the V6-library with V8, the name is resolved to
>LONG_VARIABLE_NAME so my programs crash :-(
>
>The following workarounds are prssible but not useful:
>
>1) option validvarname -> ALL Var.-Names are only 8 char. long, not just
the
>once for the views
>2) Make select with explicit var-name -> Not funny writing a own program
for
>every DB2-table instead of one macro.
>
>Any hint anyone?
>
>Tnx in advance.
>
>E.Becker