dbTalk Databases Forums  

INPUT INTO "DBA"."TableSql" FROM ....

sybase.public.sqlanywhere.general sybase.public.sqlanywhere.general


Discuss INPUT INTO "DBA"."TableSql" FROM .... in the sybase.public.sqlanywhere.general forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Timrek
 
Posts: n/a

Default INPUT INTO "DBA"."TableSql" FROM .... - 04-12-2006 , 11:47 AM






I'm having a problem to execute (WinCE):

INPUT INTO "DBA"."TableSql"
FROM \\Application\\populate.sql'
FORMAT ASCII;

The table doesn't populate!
Is it possible that i have to specify a drive in the path?
I'm using Windows CE (doesn't have a drive). It there
anything i can do? Does the command works without to specify
a drive?

Reply With Quote
  #2  
Old   
Nick Elson
 
Posts: n/a

Default Re: INPUT INTO "DBA"."TableSql" FROM .... - 04-12-2006 , 12:13 PM






INPUT is a feature of DBISQL. DBISQL is not available
on/for the CE device so if you are running DBISQL it
would be on a desktop/laptop and that will not find
the URL provide.

You probably need to use LOAD TABLE instead.

<Timrek> wrote

Quote:
I'm having a problem to execute (WinCE):

INPUT INTO "DBA"."TableSql"
FROM \\Application\\populate.sql'
FORMAT ASCII;

The table doesn't populate!
Is it possible that i have to specify a drive in the path?
I'm using Windows CE (doesn't have a drive). It there
anything i can do? Does the command works without to specify
a drive?



Reply With Quote
  #3  
Old   
Timrek
 
Posts: n/a

Default Re: INPUT INTO "DBA"."TableSql" FROM .... - 04-12-2006 , 04:45 PM



Quote:
INPUT is a feature of DBISQL. DBISQL is not available
on/for the CE device so if you are running DBISQL it
would be on a desktop/laptop and that will not find
the URL provide.

You probably need to use LOAD TABLE instead.

Timrek> wrote in message
news:443d2f07.15d1.1681692777 (AT) sybase (DOT) com... I'm having a
problem to execute (WinCE):
INPUT INTO "DBA"."TableSql"
FROM \\Application\\populate.sql'
FORMAT ASCII;

The table doesn't populate!
Is it possible that i have to specify a drive in the
path? I'm using Windows CE (doesn't have a drive). It
there anything i can do? Does the command works without
to specify a drive?


I tried this command :

LOAD TABLE "DBA"."TableSQL"
FROM '\\Application\\populatesql.sql'

but it doesn't find my file.
the «Application» directory is in the root path of my
pocket PC (Windows CE).

Anyone have a clue to my problem?


Reply With Quote
  #4  
Old   
Nick Elson
 
Posts: n/a

Default Re: INPUT INTO "DBA"."TableSql" FROM .... - 04-12-2006 , 07:21 PM



What error are you getting?

<Timrek> wrote

Quote:
INPUT is a feature of DBISQL. DBISQL is not available
on/for the CE device so if you are running DBISQL it
would be on a desktop/laptop and that will not find
the URL provide.

You probably need to use LOAD TABLE instead.

Timrek> wrote in message
news:443d2f07.15d1.1681692777 (AT) sybase (DOT) com... I'm having a
problem to execute (WinCE):
INPUT INTO "DBA"."TableSql"
FROM \\Application\\populate.sql'
FORMAT ASCII;

The table doesn't populate!
Is it possible that i have to specify a drive in the
path? I'm using Windows CE (doesn't have a drive). It
there anything i can do? Does the command works without
to specify a drive?


I tried this command :

LOAD TABLE "DBA"."TableSQL"
FROM '\\Application\\populatesql.sql'

but it doesn't find my file.
the «Application» directory is in the root path of my
pocket PC (Windows CE).

Anyone have a clue to my problem?




Reply With Quote
  #5  
Old   
Pavel Karady
 
Posts: n/a

Default Re: INPUT INTO "DBA"."TableSql" FROM .... - 04-13-2006 , 03:16 PM



Quote:
I tried this command :

LOAD TABLE "DBA"."TableSQL"
FROM '\\Application\\populatesql.sql'
Could you try the full path? That way you can eliminate the fact that it's a
path problem.

Pavel




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.