Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Proxy table field not the same length as source

2 posts in General Discussion Last posting was on 2004-09-27 15:34:31.0Z
Brian J Posted on 2004-09-27 15:15:17.0Z
Sender: 7fde.41582d49.1804289383@sybase.com
From: Brian J
Newsgroups: ianywhere.public.general
Subject: Proxy table field not the same length as source
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <41582e85.7ff3.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 27 Sep 2004 08:15:17 -0700
X-Trace: forums-1-dub 1096298117 10.22.241.41 (27 Sep 2004 08:15:17 -0700)
X-Original-Trace: 27 Sep 2004 08:15:17 -0700, 10.22.241.41
Lines: 9
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3623
Article PK: 7524

Currently I have a proxy table set up on my ASA 8.0.3.5002
db that shows a field length one character shorter than the
actual field length in the source table for the
"account_num" field in the table. Other than this anomaly I
can query the table and return results as long as the
"account_Num" of the returned row is less than or equal to
the field length in the proxy table. Unfortunately I have
records that have the extra length in the source table that
I need to return as well. Any thoughts on this matter??


Robert Waywell Posted on 2004-09-27 15:34:31.0Z
From: "Robert Waywell" <nospam_rwaywell@ianywhere.com>
Newsgroups: ianywhere.public.general
References: <41582e85.7ff3.1681692777@sybase.com>
Subject: Re: Proxy table field not the same length as source
Lines: 38
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
NNTP-Posting-Host: rwaywell-pc.sybase.com
X-Original-NNTP-Posting-Host: rwaywell-pc.sybase.com
Message-ID: <41583307$1@forums-1-dub>
Date: 27 Sep 2004 08:34:31 -0700
X-Trace: forums-1-dub 1096299271 10.25.100.118 (27 Sep 2004 08:34:31 -0700)
X-Original-Trace: 27 Sep 2004 08:34:31 -0700, rwaywell-pc.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3624
Article PK: 7523

Since you can reproduce this problem, you should submit the reproducible to
Tech Support.

--
-----------------------------------------------
Robert Waywell
Sybase Adaptive Server Anywhere Developer - Version 8
Sybase Certified Professional

Sybase's iAnywhere Solutions

Please respond ONLY to newsgroup

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports:
http://case-express.sybase.com/cx/cx.stm?starturl=casemessage.ssc?CASETYPE=B
ug

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

Whitepapers, TechDocs, and bug fixes are all available through the iAnywhere
Developer Community at www.ianywhere.com/developer

<Brian J> wrote in message news:41582e85.7ff3.1681692777@sybase.com...
> Currently I have a proxy table set up on my ASA 8.0.3.5002
> db that shows a field length one character shorter than the
> actual field length in the source table for the
> "account_num" field in the table. Other than this anomaly I
> can query the table and return results as long as the
> "account_Num" of the returned row is less than or equal to
> the field length in the proxy table. Unfortunately I have
> records that have the extra length in the source table that
> I need to return as well. Any thoughts on this matter??