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.

DDLGEN issue - always has binary characters in the output file

18 posts in General Discussion Last posting was on 2009-08-22 00:02:55.0Z
Salem Posted on 2009-08-13 21:05:34.0Z
Reply-To: "Salem" <ysalem@sscinc.com>
From: "Salem" <ysalem@sscinc.com>
Newsgroups: sybase.public.ase.general
Subject: DDLGEN issue - always has binary characters in the output file
Lines: 34
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4a84801e$1@forums-1-dub>
Date: 13 Aug 2009 14:05:34 -0700
X-Trace: forums-1-dub 1250197534 10.22.241.152 (13 Aug 2009 14:05:34 -0700)
X-Original-Trace: 13 Aug 2009 14:05:34 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28152
Article PK: 77399

Hi,
Trying to use DDLgen to extract a database structure and the output file has
many binary character in the form of "&0&". If I want to use this outfile
file to create the objects, the SQL always gets interrupted because of that
special character. I tried this on both Solaris using command line and also
on Windows using Sybase central interface and the outcome is the same.
Please advise.

this is a sample of one occurences

CREATE PROCEDURE proc_get_cus_short_names;1
(@sql0_short_name dflt_short_name_dom)
AS
select s.id, s.short_name, s.exempt, s.funding_exempt,
s.long_limit, s.short_limit, s.last_credit_rev,
s.emp_employees_id, e.description,
s.next_credit_rev, s.asset_limit, s.liability_limit,
s.triggers, s.description, s.secured_asset_limit,
s.secured_liability_limit, s.net_limit, s.long_short_switch,
s.net_limit_switch
from cus_short_names s, emp_employees e
where ( s.short_name like @sql0_short_name ) and
( s.emp_employees_id = e.id )
order by s.short_name

&0&
go



Regards,,
Yasser


Neal Stack [Sybase] Posted on 2009-08-13 21:23:28.0Z
Message-ID: <4A848450.4070909@nospam.com>
From: "Neal Stack [Sybase]" <nstack@nospam.com>
User-Agent: Thunderbird 2.0.0.22 (Windows/20090605)
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
To: Salem <ysalem@sscinc.com>
Subject: Re: DDLGEN issue - always has binary characters in the output file
References: <4a84801e$1@forums-1-dub>
In-Reply-To: <4a84801e$1@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 13 Aug 2009 14:23:28 -0700
X-Trace: forums-1-dub 1250198608 10.22.241.152 (13 Aug 2009 14:23:28 -0700)
X-Original-Trace: 13 Aug 2009 14:23:28 -0700, vip152.sybase.com
Lines: 18
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28156
Article PK: 77396

Hello,

Maybe try using the DDLGEN -J parameter to specify a client character set such as iso_1?
C:\sybase\ASEP\bin>ddlgen -U root -P rooter -S nstack_1502 -N authors -D pubs2 -T U -J iso_1

-----------------------------------------------------------------------------
-- DDL for Table 'pubs2.dbo.authors'
-----------------------------------------------------------------------------
...etc...

If that doesn't help, provide the version string for DDLGEN:
C:\sybase\ASEP\bin>ddlgen -v

Sybase Adaptive Server Enterprise DDL Generator Utility/15.0.3/EBF 16556 ESD#1/S/1.6.0/ase1503/Thu Mar 5 05:14:29 PST 2009


Regards,
Neal


Sherlock, Kevin [TeamSybase] Posted on 2009-08-13 21:21:46.0Z
From: "Sherlock, Kevin [TeamSybase]" <kevin.sherlock@teamsybase.com>
Newsgroups: sybase.public.ase.general
References: <4a84801e$1@forums-1-dub>
Subject: Re: DDLGEN issue - always has binary characters in the output file
Lines: 39
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4a8483ea@forums-1-dub>
Date: 13 Aug 2009 14:21:46 -0700
X-Trace: forums-1-dub 1250198506 10.22.241.152 (13 Aug 2009 14:21:46 -0700)
X-Original-Trace: 13 Aug 2009 14:21:46 -0700, vip152.sybase.com
X-Authenticated-User: teamsybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28155
Article PK: 77400

double check and make sure your DDLGEN character set is the same as your
default ASE character set.

"Salem" <ysalem@sscinc.com> wrote in message news:4a84801e$1@forums-1-dub...
> Hi,
> Trying to use DDLgen to extract a database structure and the output file
> has many binary character in the form of "&0&". If I want to use this
> outfile file to create the objects, the SQL always gets interrupted
> because of that special character. I tried this on both Solaris using
> command line and also on Windows using Sybase central interface and the
> outcome is the same. Please advise.
>
> this is a sample of one occurences
>
> CREATE PROCEDURE proc_get_cus_short_names;1
> (@sql0_short_name dflt_short_name_dom)
> AS
> select s.id, s.short_name, s.exempt, s.funding_exempt,
> s.long_limit, s.short_limit, s.last_credit_rev,
> s.emp_employees_id, e.description,
> s.next_credit_rev, s.asset_limit, s.liability_limit,
> s.triggers, s.description, s.secured_asset_limit,
> s.secured_liability_limit, s.net_limit, s.long_short_switch,
> s.net_limit_switch
> from cus_short_names s, emp_employees e
> where ( s.short_name like @sql0_short_name ) and
> ( s.emp_employees_id = e.id )
> order by s.short_name
>
> &0&
> go
>
>
>
> Regards,,
> Yasser
>


Salem Posted on 2009-08-13 21:37:47.0Z
Reply-To: "Salem" <ysalem@sscinc.com>
From: "Salem" <ysalem@sscinc.com>
Newsgroups: sybase.public.ase.general
References: <4a84801e$1@forums-1-dub> <4a8483ea@forums-1-dub>
Subject: Re: DDLGEN issue - always has binary characters in the output file
Lines: 57
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4a8487ab$3@forums-1-dub>
Date: 13 Aug 2009 14:37:47 -0700
X-Trace: forums-1-dub 1250199467 10.22.241.152 (13 Aug 2009 14:37:47 -0700)
X-Original-Trace: 13 Aug 2009 14:37:47 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28157
Article PK: 77401

Thanks all .. did it again with "J" switch using the same character set as
the server, but same results still exist.

Here is the exact command
$SYBASE/ASEP/bin/ddlgen -Dlightning -Usa -P$SaPwd -Stest125 -olightning.ddl
-Jiso_1

Here is "-v" of the ddlgen
Sybase DDLGen Utility/12.5.3/GA/1/S/1.3/main/Thu Oct 14 12:27:34 PDT 2004

Thanks!

"Sherlock, Kevin [TeamSybase]" <kevin.sherlock@teamsybase.com> wrote in
message news:4a8483ea@forums-1-dub...
> double check and make sure your DDLGEN character set is the same as your
> default ASE character set.
>
> "Salem" <ysalem@sscinc.com> wrote in message
> news:4a84801e$1@forums-1-dub...
>> Hi,
>> Trying to use DDLgen to extract a database structure and the output file
>> has many binary character in the form of "&0&". If I want to use this
>> outfile file to create the objects, the SQL always gets interrupted
>> because of that special character. I tried this on both Solaris using
>> command line and also on Windows using Sybase central interface and the
>> outcome is the same. Please advise.
>>
>> this is a sample of one occurences
>>
>> CREATE PROCEDURE proc_get_cus_short_names;1
>> (@sql0_short_name dflt_short_name_dom)
>> AS
>> select s.id, s.short_name, s.exempt, s.funding_exempt,
>> s.long_limit, s.short_limit, s.last_credit_rev,
>> s.emp_employees_id, e.description,
>> s.next_credit_rev, s.asset_limit, s.liability_limit,
>> s.triggers, s.description, s.secured_asset_limit,
>> s.secured_liability_limit, s.net_limit, s.long_short_switch,
>> s.net_limit_switch
>> from cus_short_names s, emp_employees e
>> where ( s.short_name like @sql0_short_name ) and
>> ( s.emp_employees_id = e.id )
>> order by s.short_name
>>
>> &0&
>> go
>>
>>
>>
>> Regards,,
>> Yasser
>>
>
>


Sherlock, Kevin [TeamSybase] Posted on 2009-08-13 22:07:56.0Z
From: "Sherlock, Kevin [TeamSybase]" <kevin.sherlock@teamsybase.com>
Newsgroups: sybase.public.ase.general
References: <4a84801e$1@forums-1-dub> <4a8483ea@forums-1-dub> <4a8487ab$3@forums-1-dub>
Subject: Re: DDLGEN issue - always has binary characters in the output file
Lines: 62
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4a848ebc$3@forums-1-dub>
Date: 13 Aug 2009 15:07:56 -0700
X-Trace: forums-1-dub 1250201276 10.22.241.152 (13 Aug 2009 15:07:56 -0700)
X-Original-Trace: 13 Aug 2009 15:07:56 -0700, vip152.sybase.com
X-Authenticated-User: teamsybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28158
Article PK: 77402

download the latest EBF and test that DDLGen utility.

"Salem" <ysalem@sscinc.com> wrote in message news:4a8487ab$3@forums-1-dub...
> Thanks all .. did it again with "J" switch using the same character set as
> the server, but same results still exist.
>
> Here is the exact command
> $SYBASE/ASEP/bin/ddlgen -Dlightning -Usa -P$SaPwd -Stest125 -olightning.ddl
> -Jiso_1
>
> Here is "-v" of the ddlgen
> Sybase DDLGen Utility/12.5.3/GA/1/S/1.3/main/Thu Oct 14 12:27:34 PDT 2004
>
> Thanks!
>
>
> "Sherlock, Kevin [TeamSybase]" <kevin.sherlock@teamsybase.com> wrote in
> message news:4a8483ea@forums-1-dub...
>> double check and make sure your DDLGEN character set is the same as your
>> default ASE character set.
>>
>> "Salem" <ysalem@sscinc.com> wrote in message
>> news:4a84801e$1@forums-1-dub...
>>> Hi,
>>> Trying to use DDLgen to extract a database structure and the output file
>>> has many binary character in the form of "&0&". If I want to use this
>>> outfile file to create the objects, the SQL always gets interrupted
>>> because of that special character. I tried this on both Solaris using
>>> command line and also on Windows using Sybase central interface and the
>>> outcome is the same. Please advise.
>>>
>>> this is a sample of one occurences
>>>
>>> CREATE PROCEDURE proc_get_cus_short_names;1
>>> (@sql0_short_name dflt_short_name_dom)
>>> AS
>>> select s.id, s.short_name, s.exempt, s.funding_exempt,
>>> s.long_limit, s.short_limit, s.last_credit_rev,
>>> s.emp_employees_id, e.description,
>>> s.next_credit_rev, s.asset_limit, s.liability_limit,
>>> s.triggers, s.description, s.secured_asset_limit,
>>> s.secured_liability_limit, s.net_limit, s.long_short_switch,
>>> s.net_limit_switch
>>> from cus_short_names s, emp_employees e
>>> where ( s.short_name like @sql0_short_name ) and
>>> ( s.emp_employees_id = e.id )
>>> order by s.short_name
>>>
>>> &0&
>>> go
>>>
>>>
>>>
>>> Regards,,
>>> Yasser
>>>
>>
>>
>
>


Salem Posted on 2009-08-13 22:28:48.0Z
Reply-To: "Salem" <ysalem@sscinc.com>
From: "Salem" <ysalem@sscinc.com>
Newsgroups: sybase.public.ase.general
References: <4a84801e$1@forums-1-dub> <4a8483ea@forums-1-dub> <4a8487ab$3@forums-1-dub> <4a848ebc$3@forums-1-dub>
Subject: Re: DDLGEN issue - always has binary characters in the output file
Lines: 72
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4a8493a0$2@forums-1-dub>
Date: 13 Aug 2009 15:28:48 -0700
X-Trace: forums-1-dub 1250202528 10.22.241.152 (13 Aug 2009 15:28:48 -0700)
X-Original-Trace: 13 Aug 2009 15:28:48 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28159
Article PK: 77403

OH - will do then and report back

Thanks!

"Sherlock, Kevin [TeamSybase]" <kevin.sherlock@teamsybase.com> wrote in
message news:4a848ebc$3@forums-1-dub...
> download the latest EBF and test that DDLGen utility.
>
> "Salem" <ysalem@sscinc.com> wrote in message
> news:4a8487ab$3@forums-1-dub...
>> Thanks all .. did it again with "J" switch using the same character set
>> as the server, but same results still exist.
>>
>> Here is the exact command
>> $SYBASE/ASEP/bin/ddlgen -Dlightning -Usa -P$SaPwd -Stest125 -olightning.ddl
>> -Jiso_1
>>
>> Here is "-v" of the ddlgen
>> Sybase DDLGen Utility/12.5.3/GA/1/S/1.3/main/Thu Oct 14 12:27:34 PDT 2004
>>
>> Thanks!
>>
>>
>> "Sherlock, Kevin [TeamSybase]" <kevin.sherlock@teamsybase.com> wrote in
>> message news:4a8483ea@forums-1-dub...
>>> double check and make sure your DDLGEN character set is the same as your
>>> default ASE character set.
>>>
>>> "Salem" <ysalem@sscinc.com> wrote in message
>>> news:4a84801e$1@forums-1-dub...
>>>> Hi,
>>>> Trying to use DDLgen to extract a database structure and the output
>>>> file has many binary character in the form of "&0&". If I want to use
>>>> this outfile file to create the objects, the SQL always gets
>>>> interrupted because of that special character. I tried this on both
>>>> Solaris using command line and also on Windows using Sybase central
>>>> interface and the outcome is the same. Please advise.
>>>>
>>>> this is a sample of one occurences
>>>>
>>>> CREATE PROCEDURE proc_get_cus_short_names;1
>>>> (@sql0_short_name dflt_short_name_dom)
>>>> AS
>>>> select s.id, s.short_name, s.exempt, s.funding_exempt,
>>>> s.long_limit, s.short_limit, s.last_credit_rev,
>>>> s.emp_employees_id, e.description,
>>>> s.next_credit_rev, s.asset_limit, s.liability_limit,
>>>> s.triggers, s.description, s.secured_asset_limit,
>>>> s.secured_liability_limit, s.net_limit, s.long_short_switch,
>>>> s.net_limit_switch
>>>> from cus_short_names s, emp_employees e
>>>> where ( s.short_name like @sql0_short_name ) and
>>>> ( s.emp_employees_id = e.id )
>>>> order by s.short_name
>>>>
>>>> &0&
>>>> go
>>>>
>>>>
>>>>
>>>> Regards,,
>>>> Yasser
>>>>
>>>
>>>
>>
>>
>
>


Salem Posted on 2009-08-14 15:42:58.0Z
Reply-To: "Salem" <ysalem@sscinc.com>
From: "Salem" <ysalem@sscinc.com>
Newsgroups: sybase.public.ase.general
References: <4a84801e$1@forums-1-dub> <4a8483ea@forums-1-dub> <4a8487ab$3@forums-1-dub> <4a848ebc$3@forums-1-dub> <4a8493a0$2@forums-1-dub>
Subject: Re: DDLGEN issue - always has binary characters in the output file
Lines: 88
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4a858602$4@forums-1-dub>
Date: 14 Aug 2009 08:42:58 -0700
X-Trace: forums-1-dub 1250264578 10.22.241.152 (14 Aug 2009 08:42:58 -0700)
X-Original-Trace: 14 Aug 2009 08:42:58 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28162
Article PK: 77406

Tried with two other servers and still same issue - version string of both
ddlgen is below

Sybase Adaptive Server Enterprise DDL Generator Utility/15.0.3/EBF
16381/S/1.6.0/ase1503/Thu Nov 13 14:54:51 PST 2008

Sybase DDLGen Utility/15.0/ESD #2 Build 1/S/1.4.2/ase150/Thu Jan 12 07:04:04
PST 2006

Please advise

"Salem" <ysalem@sscinc.com> wrote in message news:4a8493a0$2@forums-1-dub...
> OH - will do then and report back
>
> Thanks!
>
>
> "Sherlock, Kevin [TeamSybase]" <kevin.sherlock@teamsybase.com> wrote in
> message news:4a848ebc$3@forums-1-dub...
>> download the latest EBF and test that DDLGen utility.
>>
>> "Salem" <ysalem@sscinc.com> wrote in message
>> news:4a8487ab$3@forums-1-dub...
>>> Thanks all .. did it again with "J" switch using the same character set
>>> as the server, but same results still exist.
>>>
>>> Here is the exact command
>>> $SYBASE/ASEP/bin/ddlgen -Dlightning -Usa -P$SaPwd -Stest125 -olightning.ddl
>>> -Jiso_1
>>>
>>> Here is "-v" of the ddlgen
>>> Sybase DDLGen Utility/12.5.3/GA/1/S/1.3/main/Thu Oct 14 12:27:34 PDT
>>> 2004
>>>
>>> Thanks!
>>>
>>>
>>> "Sherlock, Kevin [TeamSybase]" <kevin.sherlock@teamsybase.com> wrote in
>>> message news:4a8483ea@forums-1-dub...
>>>> double check and make sure your DDLGEN character set is the same as
>>>> your default ASE character set.
>>>>
>>>> "Salem" <ysalem@sscinc.com> wrote in message
>>>> news:4a84801e$1@forums-1-dub...
>>>>> Hi,
>>>>> Trying to use DDLgen to extract a database structure and the output
>>>>> file has many binary character in the form of "&0&". If I want to use
>>>>> this outfile file to create the objects, the SQL always gets
>>>>> interrupted because of that special character. I tried this on both
>>>>> Solaris using command line and also on Windows using Sybase central
>>>>> interface and the outcome is the same. Please advise.
>>>>>
>>>>> this is a sample of one occurences
>>>>>
>>>>> CREATE PROCEDURE proc_get_cus_short_names;1
>>>>> (@sql0_short_name dflt_short_name_dom)
>>>>> AS
>>>>> select s.id, s.short_name, s.exempt, s.funding_exempt,
>>>>> s.long_limit, s.short_limit, s.last_credit_rev,
>>>>> s.emp_employees_id, e.description,
>>>>> s.next_credit_rev, s.asset_limit, s.liability_limit,
>>>>> s.triggers, s.description, s.secured_asset_limit,
>>>>> s.secured_liability_limit, s.net_limit, s.long_short_switch,
>>>>> s.net_limit_switch
>>>>> from cus_short_names s, emp_employees e
>>>>> where ( s.short_name like @sql0_short_name ) and
>>>>> ( s.emp_employees_id = e.id )
>>>>> order by s.short_name
>>>>>
>>>>> &0&
>>>>> go
>>>>>
>>>>>
>>>>>
>>>>> Regards,,
>>>>> Yasser
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>


Bret Halford [Sybase] Posted on 2009-08-14 16:02:59.0Z
From: "Bret Halford [Sybase]" <bret@sybase.com>
Organization: Sybase, Inc.
User-Agent: Thunderbird 2.0.0.22 (Windows/20090605)
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: DDLGEN issue - always has binary characters in the output file
References: <4a84801e$1@forums-1-dub> <4a8483ea@forums-1-dub> <4a8487ab$3@forums-1-dub> <4a848ebc$3@forums-1-dub> <4a8493a0$2@forums-1-dub> <4a858602$4@forums-1-dub>
In-Reply-To: <4a858602$4@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4a858ab3$3@forums-1-dub>
Date: 14 Aug 2009 09:02:59 -0700
X-Trace: forums-1-dub 1250265779 10.22.241.152 (14 Aug 2009 09:02:59 -0700)
X-Original-Trace: 14 Aug 2009 09:02:59 -0700, vip152.sybase.com
Lines: 4
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28163
Article PK: 77404

Have a look at the contents of syscomments for the procedure.
Are the binary characters in there already?

-bret


Salem Posted on 2009-08-14 16:29:24.0Z
Reply-To: "Salem" <ysalem@sscinc.com>
From: "Salem" <ysalem@sscinc.com>
Newsgroups: sybase.public.ase.general
References: <4a84801e$1@forums-1-dub> <4a8483ea@forums-1-dub> <4a8487ab$3@forums-1-dub> <4a848ebc$3@forums-1-dub> <4a8493a0$2@forums-1-dub> <4a858602$4@forums-1-dub> <4a858ab3$3@forums-1-dub>
Subject: Re: DDLGEN issue - always has binary characters in the output file
Lines: 16
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4a8590e4$1@forums-1-dub>
Date: 14 Aug 2009 09:29:24 -0700
X-Trace: forums-1-dub 1250267364 10.22.241.152 (14 Aug 2009 09:29:24 -0700)
X-Original-Trace: 14 Aug 2009 09:29:24 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28164
Article PK: 77405

I can .. but create SP mentioned before was only a example .. this character
is spread all across the DDL output file and in many other locations (create
table, create trigger , create index, ...etc) and I can not notice any
pattern for it.

Yasser

"Bret Halford [Sybase]" <bret@sybase.com> wrote in message
news:4a858ab3$3@forums-1-dub...
> Have a look at the contents of syscomments for the procedure.
> Are the binary characters in there already?
>
> -bret


Neal Stack [Sybase] Posted on 2009-08-14 18:09:14.0Z
Message-ID: <4A85A84A.6000706@nospam.com>
From: "Neal Stack [Sybase]" <nstack@nospam.com>
User-Agent: Thunderbird 2.0.0.22 (Windows/20090605)
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
To: Salem <ysalem@sscinc.com>
Subject: Re: DDLGEN issue - always has binary characters in the output file
References: <4a84801e$1@forums-1-dub> <4a8483ea@forums-1-dub> <4a8487ab$3@forums-1-dub> <4a848ebc$3@forums-1-dub> <4a8493a0$2@forums-1-dub> <4a858602$4@forums-1-dub> <4a858ab3$3@forums-1-dub> <4a8590e4$1@forums-1-dub>
In-Reply-To: <4a8590e4$1@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 14 Aug 2009 11:09:14 -0700
X-Trace: forums-1-dub 1250273354 10.22.241.152 (14 Aug 2009 11:09:14 -0700)
X-Original-Trace: 14 Aug 2009 11:09:14 -0700, vip152.sybase.com
Lines: 8
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28166
Article PK: 77411

Hello,

Can you provide the version of ASE you are running? (select @@version)

Also the output from "sp_helpsort"?

Regards,
Neal


Salem Posted on 2009-08-14 18:16:30.0Z
Reply-To: "Salem" <ysalem@sscinc.com>
From: "Salem" <ysalem@sscinc.com>
Newsgroups: sybase.public.ase.general
References: <4a84801e$1@forums-1-dub> <4a8483ea@forums-1-dub> <4a8487ab$3@forums-1-dub> <4a848ebc$3@forums-1-dub> <4a8493a0$2@forums-1-dub> <4a858602$4@forums-1-dub> <4a858ab3$3@forums-1-dub> <4a8590e4$1@forums-1-dub> <4A85A84A.6000706@nospam.com>
Subject: Re: DDLGEN issue - always has binary characters in the output file
Lines: 94
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4a85a9fe$3@forums-1-dub>
Date: 14 Aug 2009 11:16:30 -0700
X-Trace: forums-1-dub 1250273790 10.22.241.152 (14 Aug 2009 11:16:30 -0700)
X-Original-Trace: 14 Aug 2009 11:16:30 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28167
Article PK: 77410

I tried this on many version and servers I have and all exact behavior
(Solaris & Linux) 12.5.3, 15.0 & 15.0.3
This is last one I did

gepetto:/home/sybase/admin>$SYBASE/ASEP/bin/ddlgen -v
Sybase DDLGen Utility/15.0/ESD #2 Build 1/S/1.4.2/ase150/Thu Jan 12 07:04:04
PST 2006

gepetto:/home/sybase/admin>dataserver -v
Adaptive Server Enterprise/15.0/EBF 13194 EC ESD/P/Linux Intel/Linux
2.4.21-20.ELsmp i686/ase150/2179/32-bit/FBO/Mon Feb 6 04:14:19 2006


12:33 master 1> sp_helpsort
12:33 master 2> go

Collation Name Collation ID
------------------------------ ------------
altdict 45
altnoacc 39
altnocsp 46
binary 25
cyrnocs 64
defaultml 20
dict 51
elldict 65
espdict 55
espnoac 57
espnocs 56
hundict 69
hunnoac 70
hunnocs 71
iso14651 22
noaccent 54
nocase 52
nocasep 53
rusnocs 59
scandict 47
scannocp 48
thaidict 21
turknoac 73
turknocs 74
utf8bin 24


Loadable Sort Table Name Collation ID
------------------------------ ------------
gb2312bn 137
euckscbn 161
cp932bin 129
turdict 155
gbpinyin 163
cyrdict 140
big5bin 194
rusdict 165
sjisbin 179
eucjisbn 192
dynix 130

Sort Order Description


------------------------------------------------------------------
Character Set = 1, iso_1
ISO 8859-1 (Latin-1) - Western European 8-bit character set.
Sort Order = 50, bin_iso_1
Binary ordering, for the ISO 8859/1 or Latin-1 character set (
iso_1).
Characters, in Order


------------------------------------------------------------------
! " # $ % & ' ( ) * + , - . / 0 1 2 3 4 5 6 7 8 9 : ; < = > ?
@ A B C D E F G H I J K L M N O P Q R S T U V W X Y Z [ \ ] ^ _
` a b c d e f g h i j k l m n o p q r s t u v w x y z { | } ~
¡ ¢ £ ¤ ¥ ¦ § ¨ © ª « ¬ ­ ® ¯ ° ± ² ³ ´ µ ¶ · ¸ ¹ º » ¼ ½ ¾ ¿ À
Á Â Ã Ä Å Æ Ç È É Ê Ë Ì Í Î Ï Ð Ñ Ò Ó Ô Õ Ö × Ø Ù Ú Û Ü Ý Þ ß à
á â ã ä å æ ç è é ê ë ì í î ï ð ñ ò ó ô õ ö ÷ ø ù ú û ü ý þ ÿ


(return status = 0)

"Neal Stack [Sybase]" <nstack@nospam.com> wrote in message
news:4A85A84A.6000706@nospam.com...
> Hello,
>
> Can you provide the version of ASE you are running? (select @@version)
>
> Also the output from "sp_helpsort"?
>
> Regards,
> Neal


Neal Stack [Sybase] Posted on 2009-08-14 20:01:08.0Z
Message-ID: <4A85C284.6070905@nospam.com>
From: "Neal Stack [Sybase]" <nstack@nospam.com>
User-Agent: Thunderbird 2.0.0.22 (Windows/20090605)
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
To: Salem <ysalem@sscinc.com>
Subject: Re: DDLGEN issue - always has binary characters in the output file
References: <4a84801e$1@forums-1-dub> <4a8483ea@forums-1-dub> <4a8487ab$3@forums-1-dub> <4a848ebc$3@forums-1-dub> <4a8493a0$2@forums-1-dub> <4a858602$4@forums-1-dub> <4a858ab3$3@forums-1-dub> <4a8590e4$1@forums-1-dub> <4A85A84A.6000706@nospam.com> <4a85a9fe$3@forums-1-dub>
In-Reply-To: <4a85a9fe$3@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 14 Aug 2009 13:01:08 -0700
X-Trace: forums-1-dub 1250280068 10.22.241.152 (14 Aug 2009 13:01:08 -0700)
X-Original-Trace: 14 Aug 2009 13:01:08 -0700, vip152.sybase.com
Lines: 24
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28168
Article PK: 77414

Hello,

Can you email me (nstack@sybase.com) one of the files that ddlgen created?

Also send the output from the Linux "locale" command from where you are running ddlgen. For example:
[nstack@redsun4 nstack]$ locale
LANG=en_US.UTF-8
LC_CTYPE="en_US.UTF-8"
LC_NUMERIC="en_US.UTF-8"
LC_TIME="en_US.UTF-8"
LC_COLLATE="en_US.UTF-8"
LC_MONETARY="en_US.UTF-8"
LC_MESSAGES="en_US.UTF-8"
LC_PAPER="en_US.UTF-8"
LC_NAME="en_US.UTF-8"
LC_ADDRESS="en_US.UTF-8"
LC_TELEPHONE="en_US.UTF-8"
LC_MEASUREMENT="en_US.UTF-8"
LC_IDENTIFICATION="en_US.UTF-8"
LC_ALL=


Regards,
Neal


Salem Posted on 2009-08-17 17:40:15.0Z
Reply-To: "Salem" <ysalem@sscinc.com>
From: "Salem" <ysalem@sscinc.com>
Newsgroups: sybase.public.ase.general
References: <4a84801e$1@forums-1-dub> <4a8483ea@forums-1-dub> <4a8487ab$3@forums-1-dub> <4a848ebc$3@forums-1-dub> <4a8493a0$2@forums-1-dub> <4a858602$4@forums-1-dub> <4a858ab3$3@forums-1-dub> <4a8590e4$1@forums-1-dub> <4A85A84A.6000706@nospam.com> <4a85a9fe$3@forums-1-dub> <4A85C284.6070905@nospam.com>
Subject: Re: DDLGEN issue - always has binary characters in the output file
Lines: 2602
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5843
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4a8995ff$1@forums-1-dub>
Date: 17 Aug 2009 10:40:15 -0700
X-Trace: forums-1-dub 1250530815 10.22.241.152 (17 Aug 2009 10:40:15 -0700)
X-Original-Trace: 17 Aug 2009 10:40:15 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28174
Article PK: 77417

locale output is below and the file is attached - thanks!



gepetto:/home/sybase/admin>locale

LANG=

LC_CTYPE="POSIX"

LC_NUMERIC="POSIX"

LC_TIME="POSIX"

LC_COLLATE="POSIX"

LC_MONETARY="POSIX"

LC_MESSAGES="POSIX"

LC_PAPER="POSIX"

LC_NAME="POSIX"

LC_ADDRESS="POSIX"

LC_TELEPHONE="POSIX"

LC_MEASUREMENT="POSIX"

LC_IDENTIFICATION="POSIX"

LC_ALL=

"Neal Stack [Sybase]" <nstack@nospam.com> wrote in message
news:4A85C284.6070905@nospam.com...
> Hello,
>
> Can you email me (nstack@sybase.com) one of the files that ddlgen created?
>
> Also send the output from the Linux "locale" command from where you are
> running ddlgen. For example:
> [nstack@redsun4 nstack]$ locale
> LANG=en_US.UTF-8
> LC_CTYPE="en_US.UTF-8"
> LC_NUMERIC="en_US.UTF-8"
> LC_TIME="en_US.UTF-8"
> LC_COLLATE="en_US.UTF-8"
> LC_MONETARY="en_US.UTF-8"
> LC_MESSAGES="en_US.UTF-8"
> LC_PAPER="en_US.UTF-8"
> LC_NAME="en_US.UTF-8"
> LC_ADDRESS="en_US.UTF-8"
> LC_TELEPHONE="en_US.UTF-8"
> LC_MEASUREMENT="en_US.UTF-8"
> LC_IDENTIFICATION="en_US.UTF-8"
> LC_ALL=
>
>
> Regards,
> Neal


Neal Stack [Sybase] Posted on 2009-08-17 19:36:00.0Z
Message-ID: <4A89B120.6020302@nospam.com>
From: "Neal Stack [Sybase]" <nstack@nospam.com>
User-Agent: Thunderbird 2.0.0.22 (Windows/20090605)
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
To: Salem <ysalem@sscinc.com>
Subject: Re: DDLGEN issue - always has binary characters in the output file
References: <4a84801e$1@forums-1-dub> <4a8483ea@forums-1-dub> <4a8487ab$3@forums-1-dub> <4a848ebc$3@forums-1-dub> <4a8493a0$2@forums-1-dub> <4a858602$4@forums-1-dub> <4a858ab3$3@forums-1-dub> <4a8590e4$1@forums-1-dub> <4A85A84A.6000706@nospam.com> <4a85a9fe$3@forums-1-dub> <4A85C284.6070905@nospam.com> <4a8995ff$1@forums-1-dub>
In-Reply-To: <4a8995ff$1@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 17 Aug 2009 12:36:00 -0700
X-Trace: forums-1-dub 1250537760 10.22.241.152 (17 Aug 2009 12:36:00 -0700)
X-Original-Trace: 17 Aug 2009 12:36:00 -0700, vip152.sybase.com
Lines: 14
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28182
Article PK: 77425

Hello,

If I use the octal dump utility "od -c lightning_gepetto_150.ddl" I can see
that the special character that is being inserted into your DDL is the NULL
character.

I can't reproduce this behavior even with all of my locale settings=POSIX.

Can you reproduce it if you set LC_ALL=C?

What does the output from "stty -a" show?

Regards,
Neal


Salem Posted on 2009-08-18 17:23:58.0Z
Reply-To: "Salem" <ysalem@sscinc.com>
From: "Salem" <ysalem@sscinc.com>
Newsgroups: sybase.public.ase.general
References: <4a84801e$1@forums-1-dub> <4a8483ea@forums-1-dub> <4a8487ab$3@forums-1-dub> <4a848ebc$3@forums-1-dub> <4a8493a0$2@forums-1-dub> <4a858602$4@forums-1-dub> <4a858ab3$3@forums-1-dub> <4a8590e4$1@forums-1-dub> <4A85A84A.6000706@nospam.com> <4a85a9fe$3@forums-1-dub> <4A85C284.6070905@nospam.com> <4a8995ff$1@forums-1-dub> <4A89B120.6020302@nospam.com>
Subject: Re: DDLGEN issue - always has binary characters in the output file
Lines: 47
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5843
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4a8ae3ae$3@forums-1-dub>
Date: 18 Aug 2009 10:23:58 -0700
X-Trace: forums-1-dub 1250616238 10.22.241.152 (18 Aug 2009 10:23:58 -0700)
X-Original-Trace: 18 Aug 2009 10:23:58 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28184
Article PK: 77428

thank you for all your time and help on this.

Yes - it was a NULL character and I managed to edit the output DDL file to
remove this character before using the DDL file. But, still it will be there
with every attempt to run the DDLGEN program.

Re-Run it again with LC=ALL=C - that produced a much more frequent binary
characters but it is ^M this time

In both cases, here is the stty output ..

gepetto:/home/sybase>stty -a
speed 38400 baud; rows 40; columns 130; line = 0;
intr = ^C; quit = ^\; erase = ^?; kill = ^U; eof = ^D; eol = <undef>; eol2 =
<undef>; swtch = <undef>; start = ^Q; stop = ^S;
susp = ^Z; rprnt = ^R; werase = ^W; lnext = ^V; flush = ^O; min = 1; time =
0;
-parenb -parodd cs8 -hupcl -cstopb cread -clocal -crtscts
-ignbrk -brkint -ignpar -parmrk -inpck -istrip -inlcr -igncr icrnl
ixon -ixoff -iuclc -ixany -imaxbel -iutf8
opost -olcuc -ocrnl onlcr -onocr -onlret -ofill -ofdel nl0 cr0 tab0 bs0 vt0
ff0
isig icanon iexten echo echoe echok -echonl -noflsh -xcase -tostop -echoprt
echoctl echoke

"Neal Stack [Sybase]" <nstack@nospam.com> wrote in message
news:4A89B120.6020302@nospam.com...
> Hello,
>
> If I use the octal dump utility "od -c lightning_gepetto_150.ddl" I can
> see
> that the special character that is being inserted into your DDL is the
> NULL
> character.
>
> I can't reproduce this behavior even with all of my locale settings=POSIX.
>
> Can you reproduce it if you set LC_ALL=C?
>
> What does the output from "stty -a" show?
>
> Regards,
> Neal


Neal Stack [Sybase] Posted on 2009-08-18 21:01:54.0Z
Message-ID: <4A8B16C2.209@nospam.com>
From: "Neal Stack [Sybase]" <nstack@nospam.com>
User-Agent: Thunderbird 2.0.0.22 (Windows/20090605)
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
To: Salem <ysalem@sscinc.com>
Subject: Re: DDLGEN issue - always has binary characters in the output file
References: <4a84801e$1@forums-1-dub> <4a8483ea@forums-1-dub> <4a8487ab$3@forums-1-dub> <4a848ebc$3@forums-1-dub> <4a8493a0$2@forums-1-dub> <4a858602$4@forums-1-dub> <4a858ab3$3@forums-1-dub> <4a8590e4$1@forums-1-dub> <4A85A84A.6000706@nospam.com> <4a85a9fe$3@forums-1-dub> <4A85C284.6070905@nospam.com> <4a8995ff$1@forums-1-dub> <4A89B120.6020302@nospam.com> <4a8ae3ae$3@forums-1-dub>
In-Reply-To: <4a8ae3ae$3@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 18 Aug 2009 14:01:54 -0700
X-Trace: forums-1-dub 1250629314 10.22.241.152 (18 Aug 2009 14:01:54 -0700)
X-Original-Trace: 18 Aug 2009 14:01:54 -0700, vip152.sybase.com
Lines: 14
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28186
Article PK: 77429

Hello,

I don't see anything different with your stty output.

Does it happen with every database in your server? For example, if you try it on "master"?
ddlgen -Uroot -Prooter -Snstack_1502 -TDB -Dmaster -o master.sql

If you use the "od -c" command on your dump, does the ^M represent the "\r\n" typically seen with DOS files?
If so, you could use the "dos2unix" command to strip them out.

I'm out of suggestions. You may want to log a case with Sybase Technical Support.

Regards,
Neal


Salem Posted on 2009-08-18 21:09:42.0Z
Reply-To: "Salem" <ysalem@sscinc.com>
From: "Salem" <ysalem@sscinc.com>
Newsgroups: sybase.public.ase.general
References: <4a84801e$1@forums-1-dub> <4a8483ea@forums-1-dub> <4a8487ab$3@forums-1-dub> <4a848ebc$3@forums-1-dub> <4a8493a0$2@forums-1-dub> <4a858602$4@forums-1-dub> <4a858ab3$3@forums-1-dub> <4a8590e4$1@forums-1-dub> <4A85A84A.6000706@nospam.com> <4a85a9fe$3@forums-1-dub> <4A85C284.6070905@nospam.com> <4a8995ff$1@forums-1-dub> <4A89B120.6020302@nospam.com> <4a8ae3ae$3@forums-1-dub> <4A8B16C2.209@nospam.com>
Subject: Re: DDLGEN issue - always has binary characters in the output file
Lines: 32
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5843
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4a8b1896$6@forums-1-dub>
Date: 18 Aug 2009 14:09:42 -0700
X-Trace: forums-1-dub 1250629782 10.22.241.152 (18 Aug 2009 14:09:42 -0700)
X-Original-Trace: 18 Aug 2009 14:09:42 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28187
Article PK: 77432

Many thanks for your help.

Yes this is the case with every database
I'm already getting rid of this character after running ddlgen - which is
kind of ok .. but not as it should be.
I will log the case with Sybase support and will update the thread if they
advise with anything different.

Thanks all!

"Neal Stack [Sybase]" <nstack@nospam.com> wrote in message
news:4A8B16C2.209@nospam.com...
> Hello,
>
> I don't see anything different with your stty output.
>
> Does it happen with every database in your server? For example, if you
> try it on "master"?
> ddlgen -Uroot -Prooter -Snstack_1502 -TDB -Dmaster -o master.sql
>
> If you use the "od -c" command on your dump, does the ^M represent the
> "\r\n" typically seen with DOS files?
> If so, you could use the "dos2unix" command to strip them out.
>
> I'm out of suggestions. You may want to log a case with Sybase Technical
> Support.
>
> Regards,
> Neal


rick_806 Posted on 2009-08-22 00:02:55.0Z
Sender: e64.4a89feef.1804289383@sybase.com
From: rick_806
Newsgroups: sybase.public.ase.general
Subject: Re: DDLGEN issue - always has binary characters in the output file
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4a8f35af.52ab.1681692777@sybase.com>
References: <4a8b1896$6@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 21 Aug 2009 17:02:55 -0700
X-Trace: forums-1-dub 1250899375 10.22.241.41 (21 Aug 2009 17:02:55 -0700)
X-Original-Trace: 21 Aug 2009 17:02:55 -0700, 10.22.241.41
Lines: 36
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28203
Article PK: 77443

Maybe a silly question but some editors will insert strange
characters based on the file type. What editor are you using
to view this stuff? Does "cat ..." show the characters?

> Many thanks for your help.
>
> Yes this is the case with every database
> I'm already getting rid of this character after running
> ddlgen - which is kind of ok .. but not as it should be.
> I will log the case with Sybase support and will update
> the thread if they advise with anything different.
>
> Thanks all!
>
>
> "Neal Stack [Sybase]" <nstack@nospam.com> wrote in message
> news:4A8B16C2.209@nospam.com...
> > Hello,
> >
> > I don't see anything different with your stty output.
> >
> > Does it happen with every database in your server? For
> > example, if you try it on "master"?
> > ddlgen -Uroot -Prooter -Snstack_1502 -TDB -Dmaster -o
> master.sql >
> > If you use the "od -c" command on your dump, does the ^M
> > represent the "\r\n" typically seen with DOS files?
> > If so, you could use the "dos2unix" command to strip
> them out. >
> > I'm out of suggestions. You may want to log a case with
> > Sybase Technical Support.
> >
> > Regards,
> > Neal
>
>