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.

Entering NULL using ISQL Edit Function

8 posts in General Discussion Last posting was on 2005-05-27 14:49:25.0Z
Steve Burbrink Posted on 2005-05-25 18:18:37.0Z
Reply-To: "Steve Burbrink" <sywalters@hotmail.com>
From: "Steve Burbrink" <sywalters@hotmail.com>
Newsgroups: ianywhere.public.general
Subject: Entering NULL using ISQL Edit Function
Lines: 8
Organization: Compass Engineering
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: ztown2-1-18.adsl.one.net
X-Original-NNTP-Posting-Host: ztown2-1-18.adsl.one.net
Message-ID: <4294c17d@forums-1-dub>
Date: 25 May 2005 11:18:37 -0700
X-Trace: forums-1-dub 1117045117 216.23.33.18 (25 May 2005 11:18:37 -0700)
X-Original-Trace: 25 May 2005 11:18:37 -0700, ztown2-1-18.adsl.one.net
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4509
Article PK: 8317

Hi,
Easy question... what keystroke is used to represent a 'null' value when
editing fields via the isql tool?

Thanks
Steve


Joshua Savill Posted on 2005-05-25 23:08:17.0Z
From: "Joshua Savill" <jsavill@ianywhere.com>
Newsgroups: ianywhere.public.general
References: <4294c17d@forums-1-dub>
Subject: Re: Entering NULL using ISQL Edit Function
Lines: 19
Organization: iAnywhere Solutions
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: jsavill-pc.sybase.com
X-Original-NNTP-Posting-Host: jsavill-pc.sybase.com
Message-ID: <42950561$1@forums-1-dub>
Date: 25 May 2005 16:08:17 -0700
X-Trace: forums-1-dub 1117062497 10.25.98.205 (25 May 2005 16:08:17 -0700)
X-Original-Trace: 25 May 2005 16:08:17 -0700, jsavill-pc.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4511
Article PK: 8319

In Interactive SQL to represent a 'null' value simply leave the field blank.
If Interactive SQL detects a blank field, then a 'null' will be inserted.

--
Joshua Savill
iAnywhere Solutions - Product Support Analyst

"Steve Burbrink" <sywalters@hotmail.com> wrote in message
news:4294c17d@forums-1-dub...
> Hi,
> Easy question... what keystroke is used to represent a 'null' value when
> editing fields via the isql tool?
>
> Thanks
> Steve
>


Steve Burbrink Posted on 2005-05-26 15:08:35.0Z
Reply-To: "Steve Burbrink" <sywalters@hotmail.com>
From: "Steve Burbrink" <sywalters@hotmail.com>
Newsgroups: ianywhere.public.general
References: <4294c17d@forums-1-dub> <42950561$1@forums-1-dub>
Subject: Re: Entering NULL using ISQL Edit Function
Lines: 29
Organization: Compass Engineering
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-RFC2646: Format=Flowed; Response
X-Original-NNTP-Posting-Host: ztown2-1-18.adsl.one.net
Message-ID: <4295e670@forums-2-dub>
X-Original-Trace: 26 May 2005 08:08:32 -0700, ztown2-1-18.adsl.one.net
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 26 May 2005 08:08:32 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 26 May 2005 08:08:35 -0700
X-Trace: forums-1-dub 1117120115 10.22.108.75 (26 May 2005 08:08:35 -0700)
X-Original-Trace: 26 May 2005 08:08:35 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4512
Article PK: 8318

I'm trying to set a NON-NULL value to NULL within the editing feature of
isql. When viewing data, I can right click on the data and edit the column.
I want to change a value to a NULL by using some keystroke (ie. Ctrl 0).

"Joshua Savill" <jsavill@ianywhere.com> wrote in message
news:42950561$1@forums-1-dub...
> In Interactive SQL to represent a 'null' value simply leave the field
> blank. If Interactive SQL detects a blank field, then a 'null' will be
> inserted.
>
> --
> Joshua Savill
> iAnywhere Solutions - Product Support Analyst
>
>
> "Steve Burbrink" <sywalters@hotmail.com> wrote in message
> news:4294c17d@forums-1-dub...
>> Hi,
>> Easy question... what keystroke is used to represent a 'null' value when
>> editing fields via the isql tool?
>>
>> Thanks
>> Steve
>>
>
>


Stephen RIce Posted on 2005-05-26 15:39:48.0Z
From: Stephen RIce <sNSrice@ianywhere.com>
Newsgroups: ianywhere.public.general
Subject: Re: Entering NULL using ISQL Edit Function
Organization: iAnywhere Solutions
Reply-To: sNSrice@ianywhere.com
Message-ID: <gcrb91lln08n809d7442knr863m77mjq6h@4ax.com>
References: <4294c17d@forums-1-dub> <42950561$1@forums-1-dub> <4295e670@forums-2-dub>
X-Newsreader: Forte Free Agent 2.0/32.652
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Original-NNTP-Posting-Host: srice-laptop.sybase.com
X-Original-Trace: 26 May 2005 08:39:44 -0700, srice-laptop.sybase.com
Lines: 43
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 26 May 2005 08:39:46 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 26 May 2005 08:39:48 -0700
X-Trace: forums-1-dub 1117121988 10.22.108.75 (26 May 2005 08:39:48 -0700)
X-Original-Trace: 26 May 2005 08:39:48 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4513
Article PK: 8321

AFAIK there is no single keystroke to do this.

/steve
Stephen Rice
Technical Services Manager
iAnywhere Solutions

--- Please Post ---
Whitepapers, Tech Docs, Solved Cases, Bug Fixes and
"Report a bug" are all available on www.ianywhere.com

On 26 May 2005 08:08:35 -0700, "Steve Burbrink"

<sywalters@hotmail.com> wrote:

>I'm trying to set a NON-NULL value to NULL within the editing feature of
>isql. When viewing data, I can right click on the data and edit the column.
>I want to change a value to a NULL by using some keystroke (ie. Ctrl 0).
>
>
>"Joshua Savill" <jsavill@ianywhere.com> wrote in message
>news:42950561$1@forums-1-dub...
>> In Interactive SQL to represent a 'null' value simply leave the field
>> blank. If Interactive SQL detects a blank field, then a 'null' will be
>> inserted.
>>
>> --
>> Joshua Savill
>> iAnywhere Solutions - Product Support Analyst
>>
>>
>> "Steve Burbrink" <sywalters@hotmail.com> wrote in message
>> news:4294c17d@forums-1-dub...
>>> Hi,
>>> Easy question... what keystroke is used to represent a 'null' value when
>>> editing fields via the isql tool?
>>>
>>> Thanks
>>> Steve
>>>
>>
>>
>


Nick Elson Posted on 2005-05-26 18:16:32.0Z
From: "Nick Elson" <no_spam_nicelson@sybase.com>
Newsgroups: ianywhere.public.general
References: <4294c17d@forums-1-dub> <42950561$1@forums-1-dub> <4295e670@forums-2-dub> <gcrb91lln08n809d7442knr863m77mjq6h@4ax.com>
Subject: Re: Entering NULL using ISQL Edit Function
Lines: 56
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-RFC2646: Format=Flowed; Original
X-Original-NNTP-Posting-Host: nicelson-xp.sybase.com
Message-ID: <4296127c$1@forums-2-dub>
X-Original-Trace: 26 May 2005 11:16:28 -0700, nicelson-xp.sybase.com
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 26 May 2005 11:16:29 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 26 May 2005 11:16:32 -0700
X-Trace: forums-1-dub 1117131392 10.22.108.75 (26 May 2005 11:16:32 -0700)
X-Original-Trace: 26 May 2005 11:16:32 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4514
Article PK: 8322

If you are thinking of inserting an ASCII NUL then \x00 may work
but, otherwise, Josh is correct.

By editing the cell and deleting every char in that nullable column, the
cell should display as (NULL). In the case of varchar test we did here
that results in a SQL NULL value as we understood the question to be.

"Stephen RIce" <sNSrice@ianywhere.com> wrote in message
news:gcrb91lln08n809d7442knr863m77mjq6h@4ax.com...
> AFAIK there is no single keystroke to do this.
>
> /steve
> Stephen Rice
> Technical Services Manager
> iAnywhere Solutions
>
> --- Please Post ---
> Whitepapers, Tech Docs, Solved Cases, Bug Fixes and
> "Report a bug" are all available on www.ianywhere.com
>
> On 26 May 2005 08:08:35 -0700, "Steve Burbrink"
> <sywalters@hotmail.com> wrote:
>
>>I'm trying to set a NON-NULL value to NULL within the editing feature of
>>isql. When viewing data, I can right click on the data and edit the
>>column.
>>I want to change a value to a NULL by using some keystroke (ie. Ctrl 0).
>>
>>
>>"Joshua Savill" <jsavill@ianywhere.com> wrote in message
>>news:42950561$1@forums-1-dub...
>>> In Interactive SQL to represent a 'null' value simply leave the field
>>> blank. If Interactive SQL detects a blank field, then a 'null' will be
>>> inserted.
>>>
>>> --
>>> Joshua Savill
>>> iAnywhere Solutions - Product Support Analyst
>>>
>>>
>>> "Steve Burbrink" <sywalters@hotmail.com> wrote in message
>>> news:4294c17d@forums-1-dub...
>>>> Hi,
>>>> Easy question... what keystroke is used to represent a 'null' value
>>>> when
>>>> editing fields via the isql tool?
>>>>
>>>> Thanks
>>>> Steve
>>>>
>>>
>>>
>>
>


Steve Burbrink Posted on 2005-05-26 21:05:29.0Z
Reply-To: "Steve Burbrink" <steveburbrink@hotmail.com>
From: "Steve Burbrink" <steveburbrink@hotmail.com>
Newsgroups: ianywhere.public.general
References: <4294c17d@forums-1-dub> <42950561$1@forums-1-dub> <4295e670@forums-2-dub> <gcrb91lln08n809d7442knr863m77mjq6h@4ax.com> <4296127c$1@forums-2-dub>
Subject: Re: Entering NULL using ISQL Edit Function
Lines: 62
Organization: Compass Engineering
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: ztown2-1-18.adsl.one.net
X-Original-NNTP-Posting-Host: ztown2-1-18.adsl.one.net
Message-ID: <42963a19$1@forums-1-dub>
Date: 26 May 2005 14:05:29 -0700
X-Trace: forums-1-dub 1117141529 216.23.33.18 (26 May 2005 14:05:29 -0700)
X-Original-Trace: 26 May 2005 14:05:29 -0700, ztown2-1-18.adsl.one.net
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4515
Article PK: 8320

Unfortunately these are timestamps...

"Nick Elson" <no_spam_nicelson@sybase.com> wrote in message
news:4296127c$1@forums-2-dub...
> If you are thinking of inserting an ASCII NUL then \x00 may work
> but, otherwise, Josh is correct.
>
> By editing the cell and deleting every char in that nullable column, the
> cell should display as (NULL). In the case of varchar test we did here
> that results in a SQL NULL value as we understood the question to be.
>
> "Stephen RIce" <sNSrice@ianywhere.com> wrote in message
> news:gcrb91lln08n809d7442knr863m77mjq6h@4ax.com...
>> AFAIK there is no single keystroke to do this.
>>
>> /steve
>> Stephen Rice
>> Technical Services Manager
>> iAnywhere Solutions
>>
>> --- Please Post ---
>> Whitepapers, Tech Docs, Solved Cases, Bug Fixes and
>> "Report a bug" are all available on www.ianywhere.com
>>
>> On 26 May 2005 08:08:35 -0700, "Steve Burbrink"
>> <sywalters@hotmail.com> wrote:
>>
>>>I'm trying to set a NON-NULL value to NULL within the editing feature of
>>>isql. When viewing data, I can right click on the data and edit the
>>>column.
>>>I want to change a value to a NULL by using some keystroke (ie. Ctrl 0).
>>>
>>>
>>>"Joshua Savill" <jsavill@ianywhere.com> wrote in message
>>>news:42950561$1@forums-1-dub...
>>>> In Interactive SQL to represent a 'null' value simply leave the field
>>>> blank. If Interactive SQL detects a blank field, then a 'null' will be
>>>> inserted.
>>>>
>>>> --
>>>> Joshua Savill
>>>> iAnywhere Solutions - Product Support Analyst
>>>>
>>>>
>>>> "Steve Burbrink" <sywalters@hotmail.com> wrote in message
>>>> news:4294c17d@forums-1-dub...
>>>>> Hi,
>>>>> Easy question... what keystroke is used to represent a 'null' value
>>>>> when
>>>>> editing fields via the isql tool?
>>>>>
>>>>> Thanks
>>>>> Steve
>>>>>
>>>>
>>>>
>>>
>>
>
>


Greg Fenton Posted on 2005-05-27 01:27:25.0Z
From: Greg Fenton <greg.fenton_NOSPAM_@ianywhere.com>
Organization: iAnywhere Solutions Inc.
User-Agent: Mozilla Thunderbird 1.6.3.2f (Windows/20050317)
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Entering NULL using ISQL Edit Function
References: <4294c17d@forums-1-dub> <42950561$1@forums-1-dub> <4295e670@forums-2-dub> <gcrb91lln08n809d7442knr863m77mjq6h@4ax.com> <4296127c$1@forums-2-dub> <42963a19$1@forums-1-dub>
In-Reply-To: <42963a19$1@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Original-NNTP-Posting-Host: cpec2cdc91b1d31-cm000f212f9e50.cpe.net.cable.rogers.com
Message-ID: <42967779$1@forums-2-dub>
X-Original-Trace: 26 May 2005 18:27:21 -0700, cpec2cdc91b1d31-cm000f212f9e50.cpe.net.cable.rogers.com
Lines: 16
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 26 May 2005 18:27:22 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 26 May 2005 18:27:25 -0700
X-Trace: forums-1-dub 1117157245 10.22.108.75 (26 May 2005 18:27:25 -0700)
X-Original-Trace: 26 May 2005 18:27:25 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4516
Article PK: 8324


Steve Burbrink wrote:
> Unfortunately these are timestamps...
>

BTW: which version and build number are you using? I know that early
8.x releases had problems setting different column types to NULL or
DEFAULT values.

greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/


Steve Burbrink Posted on 2005-05-27 14:49:25.0Z
Reply-To: "Steve Burbrink" <steveburbrink@hotmail.com>
From: "Steve Burbrink" <steveburbrink@hotmail.com>
Newsgroups: ianywhere.public.general
References: <4294c17d@forums-1-dub> <42950561$1@forums-1-dub> <4295e670@forums-2-dub> <gcrb91lln08n809d7442knr863m77mjq6h@4ax.com> <4296127c$1@forums-2-dub> <42963a19$1@forums-1-dub> <42967779$1@forums-2-dub>
Subject: Re: Entering NULL using ISQL Edit Function
Lines: 22
Organization: Compass Engineering
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-RFC2646: Format=Flowed; Response
X-Original-NNTP-Posting-Host: ztown2-1-18.adsl.one.net
Message-ID: <42973371@forums-2-dub>
X-Original-Trace: 27 May 2005 07:49:21 -0700, ztown2-1-18.adsl.one.net
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 27 May 2005 07:49:22 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 27 May 2005 07:49:25 -0700
X-Trace: forums-1-dub 1117205365 10.22.108.75 (27 May 2005 07:49:25 -0700)
X-Original-Trace: 27 May 2005 07:49:25 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4517
Article PK: 8326

Linux Ver 9.X

"Greg Fenton" <greg.fenton_NOSPAM_@ianywhere.com> wrote in message
news:42967779$1@forums-2-dub...
> Steve Burbrink wrote:
>> Unfortunately these are timestamps...
>>
>
> BTW: which version and build number are you using? I know that early 8.x
> releases had problems setting different column types to NULL or DEFAULT
> values.
>
> greg.fenton
> --
> Greg Fenton
> Consultant, Solution Services, iAnywhere Solutions
> --------
> Visit the iAnywhere Solutions Developer Community
> Whitepapers, TechDocs, Downloads
> http://www.ianywhere.com/developer/