Sybase reserved word "dummy" 
Author Message
 Sybase reserved word "dummy"
Could anyone explain to me the meaning and use of Sybase reserved word
"dummy" please?

Thanks,
Alex

--
Posted via Mailgate.ORG Server - http://www.***.com/



Tue, 02 Nov 2004 19:31:28 GMT
 Sybase reserved word "dummy"

I think it's the same meaning as "simulated". A "dummy" object, value,etc
is when you don't really need it for production
purposes but you are required to use it for different reasons.

example:
-- in a table you have two columns. they don't accept null values. For
production purposes you just need to fill one of them, but you are required
to fill in the other because it doesn't accept null values, so you're
required to insert a "dummy" value in that column.

-- You need to make some supervision controls over your production database,
but you're going to lock and slow down the daily processes over it,so you
could create a "dummy" (simulated) database to work on to solve this
problem.

juan



Quote:
> Could anyone explain to me the meaning and use of Sybase reserved word
> "dummy" please?

> Thanks,
> Alex

> --
> Posted via Mailgate.ORG Server - http://www.Mailgate.ORG



Wed, 03 Nov 2004 01:13:28 GMT
 Sybase reserved word "dummy"
Thank you for your message. Let me rephrase my question.

Sybase Transact SQL has a number of reserved words including
WHILE, BEGIN, GO, etc., etc. and DUMMY. I was wondering what
DUMMY is used for? I could not find an answer in Sybase manuals,
so I assumed that DUMMY is some kind of historic nonsense.
Does anyone know the genesis of this reserved word?

--
Posted via Mailgate.ORG Server - http://www.Mailgate.ORG



Wed, 03 Nov 2004 08:52:44 GMT
 Sybase reserved word "dummy"

Quote:

> Sybase Transact SQL has a number of reserved words including
> WHILE, BEGIN, GO, etc., etc. and DUMMY. I was wondering what
> DUMMY is used for? I could not find an answer in Sybase manuals,
> so I assumed that DUMMY is some kind of historic nonsense.
> Does anyone know the genesis of this reserved word?

        I have 3 theories -

        1) Its historical. Raise a request at http://www.isug.com to
           have it removed or explained.
        2) It was added for MS's benefit when they got the code to
           Transact-SQL. Perhaps an in joke regarding MS's users.
        3) It was created for one person in particular. Regular
           readers will know whom I'm referring to.

-am     ? 2002



Wed, 03 Nov 2004 10:16:03 GMT
 Sybase reserved word "dummy"

Quote:


>> Sybase Transact SQL has a number of reserved words including WHILE,
>> BEGIN, GO, etc., etc. and DUMMY. I was wondering what DUMMY is used
>> for? I could not find an answer in Sybase manuals, so I assumed that
>> DUMMY is some kind of historic nonsense. Does anyone know the genesis
>> of this reserved word?

>    I have 3 theories -

>    3) It was created for one person in particular. Regular
>       readers will know whom I'm referring to.

Talk about an in-joke :-)

Michael
--
Michael Peppler                              Data Migrations, Inc.

http://www.mbay.net/~mpeppler
International Sybase User Group: http://www.isug.com



Fri, 05 Nov 2004 23:09:29 GMT
 
 [ 5 post ] 

 Relevant Pages 

1. Reserved word "dummy"

2. "value" a reserved word

3. "value" a reserved word

4. "old", "new" secret reserved words ??

5. max of ("...","...","..")

6. OLAP cube for "project reserves"

7. keyword "NAME" not reserved keyword

8. "Function" key word

9. "Query Contains Only Ignored Words" (#7619)

10. Language "noise word" in FTS

11. A few words on the "normaliztion"

12. problemas con createobject("word.basic")


 
Powered by phpBB® Forum Software