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.

ISQL output

11 posts in General Discussion Last posting was on 2011-07-07 19:53:11.0Z
John Posted on 2011-07-07 12:36:00.0Z
Sender: 3537.4e143bf9.1804289383@sybase.com
From: John
Newsgroups: sybase.public.ase.general
Subject: ISQL output
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4e15a830.72fe.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 7 Jul 2011 05:36:00 -0700
X-Trace: forums-1-dub 1310042160 10.22.241.41 (7 Jul 2011 05:36:00 -0700)
X-Original-Trace: 7 Jul 2011 05:36:00 -0700, 10.22.241.41
Lines: 14
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:30322
Article PK: 72501

Hi,

How do i write an ISQL "output" statement that catches the
full content of a blob field please ?

I normally use output to 'c:\\output.txt' format ascii
delimited by '\x09';

but this statement only writes partial contents of the blob
field.

Thanks in advance.

John


Bret Halford Posted on 2011-07-07 15:53:09.0Z
From: Bret Halford <bret@sybase.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.18) Gecko/20110616 Thunderbird/3.1.11
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: ISQL output
References: <4e15a830.72fe.1681692777@sybase.com>
In-Reply-To: <4e15a830.72fe.1681692777@sybase.com>
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: <4e15d665$1@forums-1-dub>
Date: 7 Jul 2011 08:53:09 -0700
X-Trace: forums-1-dub 1310053989 10.22.241.152 (7 Jul 2011 08:53:09 -0700)
X-Original-Trace: 7 Jul 2011 08:53:09 -0700, vip152.sybase.com
Lines: 18
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:30323
Article PK: 72502


On 7/7/2011 6:36 AM, John wrote:
> Hi,
>
> How do i write an ISQL "output" statement that catches the
> full content of a blob field please ?
>
> I normally use output to 'c:\\output.txt' format ascii
> delimited by '\x09';
>
> but this statement only writes partial contents of the blob
> field.
>
> Thanks in advance.
>
> John

Are you using SET TEXTSIZE to increase the default amount
of text/image data? The default is 32KB.


John Posted on 2011-07-07 16:18:37.0Z
Sender: 7376.4e15acf6.1804289383@sybase.com
From: John
Newsgroups: sybase.public.ase.general
Subject: Re: ISQL output
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4e15dc5d.786d.1681692777@sybase.com>
References: <4e15d665$1@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 7 Jul 2011 09:18:37 -0700
X-Trace: forums-1-dub 1310055517 10.22.241.41 (7 Jul 2011 09:18:37 -0700)
X-Original-Trace: 7 Jul 2011 09:18:37 -0700, 10.22.241.41
Lines: 26
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:30324
Article PK: 72507

Hi,

No i am not. Where/how should i set this parameter please ?


TIA
John

> On 7/7/2011 6:36 AM, John wrote:
> > Hi,
> >
> > How do i write an ISQL "output" statement that catches
> > the full content of a blob field please ?
> >
> > I normally use output to 'c:\\output.txt' format ascii
> > delimited by '\x09';
> >
> > but this statement only writes partial contents of the
> > blob field.
> >
> > Thanks in advance.
> >
> > John
>
> Are you using SET TEXTSIZE to increase the default amount
> of text/image data? The default is 32KB.


Bret Halford Posted on 2011-07-07 16:54:09.0Z
From: Bret Halford <bret@sybase.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.18) Gecko/20110616 Thunderbird/3.1.11
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: ISQL output
References: <4e15d665$1@forums-1-dub> <4e15dc5d.786d.1681692777@sybase.com>
In-Reply-To: <4e15dc5d.786d.1681692777@sybase.com>
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: <4e15e4b1$1@forums-1-dub>
Date: 7 Jul 2011 09:54:09 -0700
X-Trace: forums-1-dub 1310057649 10.22.241.152 (7 Jul 2011 09:54:09 -0700)
X-Original-Trace: 7 Jul 2011 09:54:09 -0700, vip152.sybase.com
Lines: 42
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:30325
Article PK: 72503

SET TEXTSIZE is a TSQL command, you would execute it as
part of the code submitted to ASE, in a batch prior
to the one where output the data.

http://infocenter.sybase.com/help/topic/com.sybase.infocenter.dc32300.1550/html/sqlug/X11184.htm


Note that the usage example on this page isn't great - it
is lowering the amount of text returned to 25 bytes. You
probably want to go ahead and set it to 2147483648 (2GB),
which is the max size of a text/image value.

-bret

On 7/7/2011 10:18 AM, John wrote:
> Hi,
>
> No i am not. Where/how should i set this parameter please ?
>
>
> TIA
> John
>
>> On 7/7/2011 6:36 AM, John wrote:
>>> Hi,
>>>
>>> How do i write an ISQL "output" statement that catches
>>> the full content of a blob field please ?
>>>
>>> I normally use output to 'c:\\output.txt' format ascii
>>> delimited by '\x09';
>>>
>>> but this statement only writes partial contents of the
>>> blob field.
>>>
>>> Thanks in advance.
>>>
>>> John
>>
>> Are you using SET TEXTSIZE to increase the default amount
>> of text/image data? The default is 32KB.


John Posted on 2011-07-07 18:36:26.0Z
Sender: 7a65.4e15ede6.1804289383@sybase.com
From: John
Newsgroups: sybase.public.ase.general
Subject: Re: ISQL output
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4e15fcaa.7bbd.1681692777@sybase.com>
References: <4e15e4b1$1@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 7 Jul 2011 11:36:26 -0700
X-Trace: forums-1-dub 1310063786 10.22.241.41 (7 Jul 2011 11:36:26 -0700)
X-Original-Trace: 7 Jul 2011 11:36:26 -0700, 10.22.241.41
Lines: 68
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:30327
Article PK: 72506

Hi,

Thanks for your reply. TSQL doesn't ring any bell with me ,
but i tried your suggestion in ISQL.

I've tried the following

set textsize 2147483648;

When executing this ISQL statement , it resulted in an
error.

When i try set textsize 2147483648; , it doesn't give me an
error but the results are still not what i want... The
contents of the blob date in the table are not fully
'exported' into the text file...

Using ASE 11.5 - ISQL , what am i missing here ?

TIA
John

> SET TEXTSIZE is a TSQL command, you would execute it as
> part of the code submitted to ASE, in a batch prior
> to the one where output the data.
>
>
http://infocenter.sybase.com/help/topic/com.sybase.infocenter.dc32300.1550/html/sqlug/X11184.htm
>
>
> Note that the usage example on this page isn't great - it
> is lowering the amount of text returned to 25 bytes. You
> probably want to go ahead and set it to 2147483648 (2GB),
> which is the max size of a text/image value.
>
> -bret
>
> On 7/7/2011 10:18 AM, John wrote:
> > Hi,
> >
> > No i am not. Where/how should i set this parameter
> please ? >
> >
> > TIA
> > John
> >
> >> On 7/7/2011 6:36 AM, John wrote:
> >>> Hi,
> >>>
> >>> How do i write an ISQL "output" statement that catches
> >>> the full content of a blob field please ?
> >>>
> >>> I normally use output to 'c:\\output.txt' format ascii
> >>> delimited by '\x09';
> >>>
> >>> but this statement only writes partial contents of the
> >>> blob field.
> >>>
> >>> Thanks in advance.
> >>>
> >>> John
> >>
> >> Are you using SET TEXTSIZE to increase the default
> amount >> of text/image data? The default is 32KB.
>


John Posted on 2011-07-07 18:40:08.0Z
Sender: 7a65.4e15ede6.1804289383@sybase.com
From: John
Newsgroups: sybase.public.ase.general
Subject: Re: ISQL output
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4e15fd87.7bdd.1681692777@sybase.com>
References: <4e15fcaa.7bbd.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 7 Jul 2011 11:40:08 -0700
X-Trace: forums-1-dub 1310064008 10.22.241.41 (7 Jul 2011 11:40:08 -0700)
X-Original-Trace: 7 Jul 2011 11:40:08 -0700, 10.22.241.41
Lines: 79
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:30329
Article PK: 72508

When i try set textsize 2147483647; , it doesn't give me an
error but the results are still not what i want... The
contents of the blob date in the table are not fully
'exported' into the text file...


sorry typed 2 times the same value in my previous post.

John

> Hi,
>
> Thanks for your reply. TSQL doesn't ring any bell with me
> , but i tried your suggestion in ISQL.
>
> I've tried the following
>
> set textsize 2147483648;
>
> When executing this ISQL statement , it resulted in an
> error.
>
> When i try set textsize 2147483648; , it doesn't give me
> an error but the results are still not what i want... The
> contents of the blob date in the table are not fully
> 'exported' into the text file...
>
> Using ASE 11.5 - ISQL , what am i missing here ?
>
> TIA
> John
>
>
>
>
> > SET TEXTSIZE is a TSQL command, you would execute it as
> > part of the code submitted to ASE, in a batch prior
> > to the one where output the data.
> >
> >
>
http://infocenter.sybase.com/help/topic/com.sybase.infocenter.dc32300.1550/html/sqlug/X11184.htm
> >
> >
> > Note that the usage example on this page isn't great -
> > it is lowering the amount of text returned to 25 bytes.
> > You probably want to go ahead and set it to 2147483648
> > (2GB), which is the max size of a text/image value.
> >
> > -bret
> >
> > On 7/7/2011 10:18 AM, John wrote:
> > > Hi,
> > >
> > > No i am not. Where/how should i set this parameter
> > please ? >
> > >
> > > TIA
> > > John
> > >
> > >> On 7/7/2011 6:36 AM, John wrote:
> > >>> Hi,
> > >>>
> > >>> How do i write an ISQL "output" statement that
> > catches >>> the full content of a blob field please ?
> > >>>
> > >>> I normally use output to 'c:\\output.txt' format
> > ascii >>> delimited by '\x09';
> > >>>
> > >>> but this statement only writes partial contents of
> > the >>> blob field.
> > >>>
> > >>> Thanks in advance.
> > >>>
> > >>> John
> > >>
> > >> Are you using SET TEXTSIZE to increase the default
> > amount >> of text/image data? The default is 32KB.
> >


"Mark A. Parsons" <iron_horse Posted on 2011-07-07 19:42:49.0Z
From: "Mark A. Parsons" <iron_horse@no_spamola.compuserve.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.13) Gecko/20101207 Lightning/1.0b2 Thunderbird/3.1.7
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: ISQL output
References: <4e15e4b1$1@forums-1-dub> <4e15fcaa.7bbd.1681692777@sybase.com>
In-Reply-To: <4e15fcaa.7bbd.1681692777@sybase.com>
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: <4e160c39@forums-1-dub>
Date: 7 Jul 2011 12:42:49 -0700
X-Trace: forums-1-dub 1310067769 10.22.241.152 (7 Jul 2011 12:42:49 -0700)
X-Original-Trace: 7 Jul 2011 12:42:49 -0700, vip152.sybase.com
Lines: 79
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:30332
Article PK: 72511

TSQL/T-SQL is the flavor of SQL used by the ASE dataserver, like PL-SQL is the flavor of SQL used by Oracle.

If you received an error message you might want to post the entire contents of the error message.

Assuming the error may be with the value itself ... I can never remember the exact digits for 2B[-1], so I just use
something close like 2147000000.

If you happen to use the 'isql' command line tool then the ';' is invalid a) in T-SQL code and b) as an 'isql' command
syntax.

On 07/07/2011 14:36, John wrote:
> Hi,
>
> Thanks for your reply. TSQL doesn't ring any bell with me ,
> but i tried your suggestion in ISQL.
>
> I've tried the following
>
> set textsize 2147483648;
>
> When executing this ISQL statement , it resulted in an
> error.
>
> When i try set textsize 2147483648; , it doesn't give me an
> error but the results are still not what i want... The
> contents of the blob date in the table are not fully
> 'exported' into the text file...
>
> Using ASE 11.5 - ISQL , what am i missing here ?
>
> TIA
> John
>
>
>
>
>> SET TEXTSIZE is a TSQL command, you would execute it as
>> part of the code submitted to ASE, in a batch prior
>> to the one where output the data.
>>
>>
> http://infocenter.sybase.com/help/topic/com.sybase.infocenter.dc32300.1550/html/sqlug/X11184.htm
>>
>>
>> Note that the usage example on this page isn't great - it
>> is lowering the amount of text returned to 25 bytes. You
>> probably want to go ahead and set it to 2147483648 (2GB),
>> which is the max size of a text/image value.
>>
>> -bret
>>
>> On 7/7/2011 10:18 AM, John wrote:
>>> Hi,
>>>
>>> No i am not. Where/how should i set this parameter
>> please ?>
>>>
>>> TIA
>>> John
>>>
>>>> On 7/7/2011 6:36 AM, John wrote:
>>>>> Hi,
>>>>>
>>>>> How do i write an ISQL "output" statement that catches
>>>>> the full content of a blob field please ?
>>>>>
>>>>> I normally use output to 'c:\\output.txt' format ascii
>>>>> delimited by '\x09';
>>>>>
>>>>> but this statement only writes partial contents of the
>>>>> blob field.
>>>>>
>>>>> Thanks in advance.
>>>>>
>>>>> John
>>>>
>>>> Are you using SET TEXTSIZE to increase the default
>> amount>> of text/image data? The default is 32KB.
>>


J Posted on 2011-07-07 17:39:48.0Z
From: jtotally_bogus@sbcglobal.net (J)
Newsgroups: sybase.public.ase.general
Subject: Re: ISQL output
Reply-To: J@bogusemailAddress.com
Message-ID: <4e15eed4.71143296@forums.sybase.com>
References: <4e15a830.72fe.1681692777@sybase.com>
X-Newsreader: Forte Free Agent 1.21/32.243
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 7 Jul 2011 10:39:48 -0700
X-Trace: forums-1-dub 1310060388 10.22.241.152 (7 Jul 2011 10:39:48 -0700)
X-Original-Trace: 7 Jul 2011 10:39:48 -0700, vip152.sybase.com
Lines: 27
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:30326
Article PK: 72504

On 7 Jul 2011 05:36:00 -0700, John wrote:

Are you talking about the openclient, isql command line program? The
caps, ISQL throws me off.

You could do something like this:

prompt> select .....
prompt> go > <myfile>

Jay

>Hi,
>
>How do i write an ISQL "output" statement that catches the
>full content of a blob field please ?
>
>I normally use output to 'c:\\output.txt' format ascii
>delimited by '\x09';
>
>but this statement only writes partial contents of the blob
>field.
>
>Thanks in advance.
>
>John


John Posted on 2011-07-07 18:38:13.0Z
Sender: 7a65.4e15ede6.1804289383@sybase.com
From: John
Newsgroups: sybase.public.ase.general
Subject: Re: ISQL output
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4e15fd15.7bcc.1681692777@sybase.com>
References: <4e15eed4.71143296@forums.sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 7 Jul 2011 11:38:13 -0700
X-Trace: forums-1-dub 1310063893 10.22.241.41 (7 Jul 2011 11:38:13 -0700)
X-Original-Trace: 7 Jul 2011 11:38:13 -0700, 10.22.241.41
Lines: 35
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:30328
Article PK: 72505

No, the INTERACTIVE SQL (ISQL) tool that comes with ASE.

I am starting to doubt whether i am posting in the correct
newsgroup here ... :)

TIA
JOHN

> On 7 Jul 2011 05:36:00 -0700, John wrote:
>
> Are you talking about the openclient, isql command line
> program? The caps, ISQL throws me off.
>
> You could do something like this:
>
> prompt> select .....
> prompt> go > <myfile>
>
> Jay
>
> >Hi,
> >
> >How do i write an ISQL "output" statement that catches
> the >full content of a blob field please ?
> >
> >I normally use output to 'c:\\output.txt' format ascii
> >delimited by '\x09';
> >
> >but this statement only writes partial contents of the
> blob >field.
> >
> >Thanks in advance.
> >
> >John
>


John Posted on 2011-07-07 18:56:47.0Z
Sender: 7a65.4e15ede6.1804289383@sybase.com
From: John
Newsgroups: sybase.public.ase.general
Subject: Re: ISQL output
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4e16016f.7c4c.1681692777@sybase.com>
References: <4e15fd15.7bcc.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 7 Jul 2011 11:56:47 -0700
X-Trace: forums-1-dub 1310065007 10.22.241.41 (7 Jul 2011 11:56:47 -0700)
X-Original-Trace: 7 Jul 2011 11:56:47 -0700, 10.22.241.41
Lines: 41
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:30330
Article PK: 72509

Mixed-up in the product name and version..

I am using SQL Anywhere 11.0.1.

My bad

> No, the INTERACTIVE SQL (ISQL) tool that comes with ASE.
>
> I am starting to doubt whether i am posting in the correct
> newsgroup here ... :)
>
> TIA
> JOHN
>
> > On 7 Jul 2011 05:36:00 -0700, John wrote:
> >
> > Are you talking about the openclient, isql command line
> > program? The caps, ISQL throws me off.
> >
> > You could do something like this:
> >
> > prompt> select .....
> > prompt> go > <myfile>
> >
> > Jay
> >
> > >Hi,
> > >
> > >How do i write an ISQL "output" statement that catches
> > the >full content of a blob field please ?
> > >
> > >I normally use output to 'c:\\output.txt' format ascii
> > >delimited by '\x09';
> > >
> > >but this statement only writes partial contents of the
> > blob >field.
> > >
> > >Thanks in advance.
> > >
> > >John
> >


"Mark A. Parsons" <iron_horse Posted on 2011-07-07 19:53:11.0Z
From: "Mark A. Parsons" <iron_horse@no_spamola.compuserve.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.13) Gecko/20101207 Lightning/1.0b2 Thunderbird/3.1.7
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: ISQL output
References: <4e15fd15.7bcc.1681692777@sybase.com> <4e16016f.7c4c.1681692777@sybase.com>
In-Reply-To: <4e16016f.7c4c.1681692777@sybase.com>
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: <4e160ea7$1@forums-1-dub>
Date: 7 Jul 2011 12:53:11 -0700
X-Trace: forums-1-dub 1310068391 10.22.241.152 (7 Jul 2011 12:53:11 -0700)
X-Original-Trace: 7 Jul 2011 12:53:11 -0700, vip152.sybase.com
Lines: 48
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:30333
Article PK: 72512

ahhh, that would explain a lot ... if you haven't figured it out already ...

sybase.public.sqlanywhere.general

On 07/07/2011 14:56, John wrote:
> Mixed-up in the product name and version..
>
> I am using SQL Anywhere 11.0.1.
>
> My bad
>
>> No, the INTERACTIVE SQL (ISQL) tool that comes with ASE.
>>
>> I am starting to doubt whether i am posting in the correct
>> newsgroup here ... :)
>>
>> TIA
>> JOHN
>>
>>> On 7 Jul 2011 05:36:00 -0700, John wrote:
>>>
>>> Are you talking about the openclient, isql command line
>>> program? The caps, ISQL throws me off.
>>>
>>> You could do something like this:
>>>
>>> prompt> select .....
>>> prompt> go> <myfile>
>>>
>>> Jay
>>>
>>>> Hi,
>>>>
>>>> How do i write an ISQL "output" statement that catches
>>> the>full content of a blob field please ?
>>>>
>>>> I normally use output to 'c:\\output.txt' format ascii
>>>> delimited by '\x09';
>>>>
>>>> but this statement only writes partial contents of the
>>> blob>field.
>>>>
>>>> Thanks in advance.
>>>>
>>>> John
>>>