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.

DBISQL Batch Files - Dates

2 posts in General Discussion Last posting was on 2004-08-16 18:02:33.0Z
rk Posted on 2004-08-16 16:57:19.0Z
From: "rk" <rkern@prolynx.com>
Newsgroups: ianywhere.public.mbusinessanywhere.general
Subject: DBISQL Batch Files - Dates
Lines: 7
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
X-Original-NNTP-Posting-Host: 63.145.80.132
Message-ID: <4120e8bd$1@forums-2-dub>
X-Original-Trace: 16 Aug 2004 10:02:53 -0700, 63.145.80.132
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 16 Aug 2004 09:48:06 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 16 Aug 2004 09:57:19 -0700
X-Trace: forums-1-dub 1092675439 10.22.108.75 (16 Aug 2004 09:57:19 -0700)
X-Original-Trace: 16 Aug 2004 09:57:19 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.mbusinessanywhere.general:143
Article PK: 8736

How do I pass an sql date into a .sql batch file. Feeding the batch file to
DBISQL on the command line. or is there a better way to use a date in where
clause in this manner?
Thanks
RK


Stephen Rice Posted on 2004-08-16 18:02:33.0Z
Newsgroups: ianywhere.public.mbusinessanywhere.general
Subject: Re: DBISQL Batch Files - Dates
From: Stephen Rice <srice_nospam@ianywhere.com>
References: <4120e8bd$1@forums-2-dub>
Organization: iAnywhere Solutions
Message-ID: <Xns95478D497B07Fsricenospamianywhere@10.22.241.106>
User-Agent: Xnews/5.04.25
X-Original-NNTP-Posting-Host: srice-pc1.sybase.com
X-Original-Trace: 16 Aug 2004 11:08:07 -0700, srice-pc1.sybase.com
Lines: 26
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 16 Aug 2004 10:53:20 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 16 Aug 2004 11:02:33 -0700
X-Trace: forums-1-dub 1092679353 10.22.108.75 (16 Aug 2004 11:02:33 -0700)
X-Original-Trace: 16 Aug 2004 11:02:33 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.mbusinessanywhere.general:145
Article PK: 8735


"rk" <rkern@prolynx.com> wrote in news:4120e8bd$1@forums-2-dub:

> How do I pass an sql date into a .sql batch file. Feeding the batch
> file to DBISQL on the command line. or is there a better way to use a
> date in where clause in this manner?
> Thanks
> RK
>
>
>

Take a look at the PARAMETERS statement. I think it will do what you
want

/steve

--
Stephen Rice
Technical Services Manager
iAnywhere Solutions

- Please Post-
Whitepapers, TechDocs, and bug fixes are all available through the
iAnywhere
Developer Community at www.ianywhere.com/developer