Date:         Mon, 3 May 2004 09:48:29 +0200
Reply-To:     "Becker, Eckhard [IK-05]" <EBecker@VHV.DE>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Becker, Eckhard [IK-05]" <EBecker@VHV.DE>
Subject:      Problem SAS V8, V6, MVS, DB2
Comments: To: SAS-L@LISTSERV.VT.EDU
Content-Type: text/plain; charset="iso-8859-1"

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