Date: Thu, 14 Sep 2000 15:40:53 GMT
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
Organization: Deja.com - Before you buy.
Subject: Re: SAS/V8 Special Characters on OS/390 - Help request
In Tom Ceyssens <email@example.com> wrote:
> We're trying to access DB2-tables on an OS/390 platform using SAS/V8
> Batch and Online with a simple PROC SQL.
> Our libname statement is: libname mylib db2 schema=ibh ;
> When trying to read observations...
> select *
> from mylib.v_table_cost#m
> We get an error message regarding the use of "#". It won't accept the
> character, which is obligatory. Do you know what we can do to make it
> accept the #-symbol in the table name?
I believe the solution is to wrap the mylib.v_table_cost#m in either
single or double quotes (' or "). I'd suspect that it needs to be
" but would try either.
Sent via Deja.com http://www.deja.com/
Before you buy.