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.

Problem to execute a ASA sql script by a batch script

4 posts in General Discussion Last posting was on 2007-06-27 15:49:45.0Z
liy Posted on 2007-06-26 20:50:21.0Z
From: "liy" <li_yuping@bls.gov>
Newsgroups: ianywhere.public.general
Subject: Problem to execute a ASA sql script by a batch script
Lines: 24
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3028
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028
NNTP-Posting-Host: 146.142.34.79
X-Original-NNTP-Posting-Host: 146.142.34.79
Message-ID: <46817c0d$2@forums-1-dub>
Date: 26 Jun 2007 13:50:21 -0700
X-Trace: forums-1-dub 1182891021 146.142.34.79 (26 Jun 2007 13:50:21 -0700)
X-Original-Trace: 26 Jun 2007 13:50:21 -0700, 146.142.34.79
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6114
Article PK: 2571

The script remote_ddl can be executed manually in interactive SQL without
any problem. However, an error encountered when the script is called by a
batch script. Any ideas? The two files are attached.

Thanks,
liy


Breck Carter [Team iAnywhere] Posted on 2007-06-27 08:05:52.0Z
From: "Breck Carter [Team iAnywhere]" <NOSPAM__bcarter@risingroad.com>
Newsgroups: ianywhere.public.general
Subject: Re: Problem to execute a ASA sql script by a batch script
Organization: RisingRoad Professional Services
Reply-To: NOSPAM__bcarter@risingroad.com
Message-ID: <ii6483titcpl3a13vpuvf0o0dduu8efda7@4ax.com>
References: <46817c0d$2@forums-1-dub>
X-Newsreader: Forte Agent 2.0/32.640
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 208.253.124.99
X-Original-NNTP-Posting-Host: 208.253.124.99
Date: 27 Jun 2007 01:05:52 -0700
X-Trace: forums-1-dub 1182931552 208.253.124.99 (27 Jun 2007 01:05:52 -0700)
X-Original-Trace: 27 Jun 2007 01:05:52 -0700, 208.253.124.99
Lines: 18
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6115
Article PK: 2572

What is the error message?

On 26 Jun 2007 13:50:21 -0700, "liy" <li_yuping@bls.gov> wrote:

>The script remote_ddl can be executed manually in interactive SQL without
>any problem. However, an error encountered when the script is called by a
>batch script. Any ideas? The two files are attached.
>
>Thanks,
>liy
>

--
Breck Carter [Team iAnywhere]
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com
The book: http://www.risingroad.com/SQL_Anywhere_Studio_9_Developers_Guide.html
breck.carter@risingroad.com


liy Posted on 2007-06-27 14:42:31.0Z
From: "liy" <li_yuping@bls.gov>
Newsgroups: ianywhere.public.general
References: <46817c0d$2@forums-1-dub> <ii6483titcpl3a13vpuvf0o0dduu8efda7@4ax.com>
Subject: Re: Problem to execute a ASA sql script by a batch script
Lines: 31
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3028
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028
NNTP-Posting-Host: 146.142.34.79
X-Original-NNTP-Posting-Host: 146.142.34.79
Message-ID: <46827757$2@forums-1-dub>
Date: 27 Jun 2007 07:42:31 -0700
X-Trace: forums-1-dub 1182955351 146.142.34.79 (27 Jun 2007 07:42:31 -0700)
X-Original-Trace: 27 Jun 2007 07:42:31 -0700, 146.142.34.79
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6117
Article PK: 2567

The error message as follows,

Error in file "c:\remote_ddl.txt" at line 0
Syntax error near '(end of line)' on line 5
add outlet_type char(2) null

Thanks,
liy

"Breck Carter [Team iAnywhere]" <NOSPAM__bcarter@risingroad.com> wrote in
message news:ii6483titcpl3a13vpuvf0o0dduu8efda7@4ax.com...
> What is the error message?
>
> On 26 Jun 2007 13:50:21 -0700, "liy" <li_yuping@bls.gov> wrote:
>
>>The script remote_ddl can be executed manually in interactive SQL without
>>any problem. However, an error encountered when the script is called by a
>>batch script. Any ideas? The two files are attached.
>>
>>Thanks,
>>liy
>>
>
> --
> Breck Carter [Team iAnywhere]
> RisingRoad SQL Anywhere and MobiLink Professional Services
> www.risingroad.com
> The book:
> http://www.risingroad.com/SQL_Anywhere_Studio_9_Developers_Guide.html
> breck.carter@risingroad.com


Breck Carter [Team iAnywhere] Posted on 2007-06-27 15:49:45.0Z
From: "Breck Carter [Team iAnywhere]" <NOSPAM__bcarter@risingroad.com>
Newsgroups: ianywhere.public.general
Subject: Re: Problem to execute a ASA sql script by a batch script
Organization: RisingRoad Professional Services
Reply-To: NOSPAM__bcarter@risingroad.com
Message-ID: <mn1583tftcpjgplsmvaspmuf9gmu6uitp4@4ax.com>
References: <46817c0d$2@forums-1-dub> <ii6483titcpl3a13vpuvf0o0dduu8efda7@4ax.com> <46827757$2@forums-1-dub>
X-Newsreader: Forte Agent 2.0/32.640
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 199.90.35.10
X-Original-NNTP-Posting-Host: 199.90.35.10
Date: 27 Jun 2007 08:49:45 -0700
X-Trace: forums-1-dub 1182959385 199.90.35.10 (27 Jun 2007 08:49:45 -0700)
X-Original-Trace: 27 Jun 2007 08:49:45 -0700, 199.90.35.10
Lines: 43
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6119
Article PK: 2574

Looks like a limitation of dbisqlc. Try using dbisql.

Breck

On 27 Jun 2007 07:42:31 -0700, "liy" <li_yuping@bls.gov> wrote:

>The error message as follows,
>
>Error in file "c:\remote_ddl.txt" at line 0
>Syntax error near '(end of line)' on line 5
>add outlet_type char(2) null
>
>Thanks,
>liy
>"Breck Carter [Team iAnywhere]" <NOSPAM__bcarter@risingroad.com> wrote in
>message news:ii6483titcpl3a13vpuvf0o0dduu8efda7@4ax.com...
>> What is the error message?
>>
>> On 26 Jun 2007 13:50:21 -0700, "liy" <li_yuping@bls.gov> wrote:
>>
>>>The script remote_ddl can be executed manually in interactive SQL without
>>>any problem. However, an error encountered when the script is called by a
>>>batch script. Any ideas? The two files are attached.
>>>
>>>Thanks,
>>>liy
>>>
>>
>> --
>> Breck Carter [Team iAnywhere]
>> RisingRoad SQL Anywhere and MobiLink Professional Services
>> www.risingroad.com
>> The book:
>> http://www.risingroad.com/SQL_Anywhere_Studio_9_Developers_Guide.html
>> breck.carter@risingroad.com
>

--
Breck Carter [Team iAnywhere]
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com
The book: http://www.risingroad.com/SQL_Anywhere_Studio_9_Developers_Guide.html
breck.carter@risingroad.com