That's right.... Your original query was not to connect database... and I was astonished.
________________________________
From: s.[Email address protected] [mailto:s.[Email address protected]
Sent: Thursday, September 28, 2006 7:06 PM
To: [Email address protected]
Cc: Durgesh Mankar-GA
Subject: db2 command
THERE IT IS!!!! But one thing..We do need a connection ; that means we need to connect to a database..
But we don't need a table to do that.
VALUES month('12/12/2006')
Salih Sipahi/SAHINLER
26.09.2006 11:42
Kime
"Durgesh" <Durgesh.[Email address protected]
Bilgi
Konu
Ynt: RE: db2 commandBağlantı <Notes:///C2256D1E004EA26C/DABA975B9FB113EB852564B5001283EA/EC3F99AED36F5988C22571F5002F8959>
I was making it (and had also learned it from here in this mail group) but I forgot :((
Salih Sipahi
Veritabanı Yöneticisi
Hitit Güneşi
Hattusas
"Durgesh" <Durgesh.[Email address protected]
26.09.2006 11:41
Kime
S.[Email address protected]
Bilgi
Konu
RE: db2 command
**A LazyDBA.com subscriber has responded to your lazydba.com post**
**LazyDBA.com mail shield has forwarded you this email,
**and removed any attachments, and kept your email address secret
**from this person, and any viruses/trojans.
**If you reply to this email, the person will see your email address as normal
**Anything below this line is the original email text
Hi Sahil,
I think I'm going to learn something new today.
Is it possible to execute DB2 built-in or UDFs w/o connecting to
database?
Cheers
-----Original Message-----
From: s [Email address protected]
Sent: Tuesday, September 26, 2006 2:01 PM
To: LazyDBA Discussion
Subject: db2 command
I forgot the correct syntax for that can you help me please?
I am trying to test some functions return values e.g
month(12/12/1985') and trying to get the result 12 .
When we write it exactly into the command center I get the error "a
db
connection doesn't exist".
What was the method to run the db2-specific functions without connecting
to a database?
Salih Sipahi
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
DB2 & UDB email list listserv db2-l LazyDBA home page