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.

cannot reload data

5 posts in General Discussion Last posting was on 2007-10-10 18:57:07.0Z
Chris Posted on 2007-10-09 03:46:32.0Z
From: "Chris" <Chris@gmail.com>
Newsgroups: ianywhere.public.general
Subject: cannot reload data
Lines: 18
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
NNTP-Posting-Host: 125.160.232.11
X-Original-NNTP-Posting-Host: 125.160.232.11
Message-ID: <470af998@forums-1-dub>
Date: 8 Oct 2007 20:46:32 -0700
X-Trace: forums-1-dub 1191901592 125.160.232.11 (8 Oct 2007 20:46:32 -0700)
X-Original-Trace: 8 Oct 2007 20:46:32 -0700, 125.160.232.11
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6359
Article PK: 2850

I have unloaded the db and wish to have it reloaded.
the option used was UNLOAD DATA only since UNLOAD STRUCTURE AND DATA would
not resolve RI problem in my previous posts.

During reload several error messages appearred saying some columns are
missing whereas the columns are actually there.

I conclude that ASA won't reload if the source and destination table have
incorrect column order.

for example
source_table : id, name, address
destinatin_table: id, address, name

Is it true? why is that so?


"Nick Elson" < Posted on 2007-10-09 13:50:18.0Z
From: "Nick Elson" <@@@nick@@@.@@@elson@sybase@@@.@@@com@@@>
Newsgroups: ianywhere.public.general
References: <470af998@forums-1-dub>
Subject: Re: cannot reload data
Lines: 29
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2962
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: nicelson-d620.sybase.com
X-Original-NNTP-Posting-Host: nicelson-d620.sybase.com
Message-ID: <470b871a@forums-1-dub>
Date: 9 Oct 2007 06:50:18 -0700
X-Trace: forums-1-dub 1191937818 10.25.98.247 (9 Oct 2007 06:50:18 -0700)
X-Original-Trace: 9 Oct 2007 06:50:18 -0700, nicelson-d620.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6368
Article PK: 2856

Since you seem to be chasing an issue around our feature set
maybe it would be better to open up a support case and
talk the issue through.

FWIW load table has a column list ability which may help
you out but I am not clear on the core problem within your
question.

"Chris" <Chris@gmail.com> wrote in message news:470af998@forums-1-dub...
>I have unloaded the db and wish to have it reloaded.
> the option used was UNLOAD DATA only since UNLOAD STRUCTURE AND DATA would
> not resolve RI problem in my previous posts.
>
> During reload several error messages appearred saying some columns are
> missing whereas the columns are actually there.
>
> I conclude that ASA won't reload if the source and destination table have
> incorrect column order.
>
> for example
> source_table : id, name, address
> destinatin_table: id, address, name
>
> Is it true? why is that so?
>
>
>


Chris Posted on 2007-10-10 03:15:12.0Z
From: "Chris" <Chris@gmail.com>
Newsgroups: ianywhere.public.general
References: <470af998@forums-1-dub> <470b871a@forums-1-dub>
Subject: Re: cannot reload data
Lines: 53
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: 125.160.239.190
X-Original-NNTP-Posting-Host: 125.160.239.190
Message-ID: <470c43c0@forums-1-dub>
Date: 9 Oct 2007 20:15:12 -0700
X-Trace: forums-1-dub 1191986112 125.160.239.190 (9 Oct 2007 20:15:12 -0700)
X-Original-Trace: 9 Oct 2007 20:15:12 -0700, 125.160.239.190
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6373
Article PK: 4725

how do i open a support case. never done it before.

i have done some pipelining in the past and found out that it would yield a
proper result only when source and destination both have correct column
order.
let' say if source has id, name, address and destination has id, address,
name
then pipeline would incorrectly place name (of source table) into address
(of destination table) and address (source) into name (dest).

the same happen when reloading the database (using dbisql) where all columns
of all tables must be in correct and same order both for source and dest

Is it only because of my limited knowledge that I come to conclusion that
ASA copies data based on column order instead of column name? Is there a way
to make ASA use column name instead?

"Nick Elson" <@@@nick@@@.@@@elson@sybase@@@.@@@com@@@> wrote in message
news:470b871a@forums-1-dub...
> Since you seem to be chasing an issue around our feature set
> maybe it would be better to open up a support case and
> talk the issue through.
>
> FWIW load table has a column list ability which may help
> you out but I am not clear on the core problem within your
> question.
>
> "Chris" <Chris@gmail.com> wrote in message news:470af998@forums-1-dub...
>>I have unloaded the db and wish to have it reloaded.
>> the option used was UNLOAD DATA only since UNLOAD STRUCTURE AND DATA
>> would not resolve RI problem in my previous posts.
>>
>> During reload several error messages appearred saying some columns are
>> missing whereas the columns are actually there.
>>
>> I conclude that ASA won't reload if the source and destination table have
>> incorrect column order.
>>
>> for example
>> source_table : id, name, address
>> destinatin_table: id, address, name
>>
>> Is it true? why is that so?
>>
>>
>>
>
>
>


"Nick Elson" < Posted on 2007-10-10 18:57:07.0Z
From: "Nick Elson" <@@@nick@@@.@@@elson@sybase@@@.@@@com@@@>
Newsgroups: ianywhere.public.general
References: <470af998@forums-1-dub> <470b871a@forums-1-dub> <470c43c0@forums-1-dub>
Subject: Re: cannot reload data
Lines: 78
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2962
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: nicelson-d620.sybase.com
X-Original-NNTP-Posting-Host: nicelson-d620.sybase.com
Message-ID: <470d2083$1@forums-1-dub>
Date: 10 Oct 2007 11:57:07 -0700
X-Trace: forums-1-dub 1192042627 10.25.98.247 (10 Oct 2007 11:57:07 -0700)
X-Original-Trace: 10 Oct 2007 11:57:07 -0700, nicelson-d620.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6394
Article PK: 2865

To contact support look up you regional support office/access point
http://www.sybase.com/contactus/support
technical support is offered along these guidelines
http://www.sybase.com/support/aboutsupport/guide

If you use the "load table" statement explicitly you can
list the column names explicitly.

In the 9.0.2 look at the optional
(column-name, ...)
column list and the example at the bottom which
shows this statement
LOAD TABLE T ( filler(), c, a )

Alternative, rows can be loaded into a clone of your old
schema an copied into the new table schema using a

insert into new_table select col1, ...., coln from old_table;

"Chris" <Chris@gmail.com> wrote in message news:470c43c0@forums-1-dub...
> how do i open a support case. never done it before.
>
> i have done some pipelining in the past and found out that it would yield
> a proper result only when source and destination both have correct column
> order.
> let' say if source has id, name, address and destination has id, address,
> name
> then pipeline would incorrectly place name (of source table) into address
> (of destination table) and address (source) into name (dest).
>
> the same happen when reloading the database (using dbisql) where all
> columns of all tables must be in correct and same order both for source
> and dest
>
> Is it only because of my limited knowledge that I come to conclusion that
> ASA copies data based on column order instead of column name? Is there a
> way to make ASA use column name instead?
>
>
>
> "Nick Elson" <@@@nick@@@.@@@elson@sybase@@@.@@@com@@@> wrote in message
> news:470b871a@forums-1-dub...
>> Since you seem to be chasing an issue around our feature set
>> maybe it would be better to open up a support case and
>> talk the issue through.
>>
>> FWIW load table has a column list ability which may help
>> you out but I am not clear on the core problem within your
>> question.
>>
>> "Chris" <Chris@gmail.com> wrote in message news:470af998@forums-1-dub...
>>>I have unloaded the db and wish to have it reloaded.
>>> the option used was UNLOAD DATA only since UNLOAD STRUCTURE AND DATA
>>> would not resolve RI problem in my previous posts.
>>>
>>> During reload several error messages appearred saying some columns are
>>> missing whereas the columns are actually there.
>>>
>>> I conclude that ASA won't reload if the source and destination table
>>> have incorrect column order.
>>>
>>> for example
>>> source_table : id, name, address
>>> destinatin_table: id, address, name
>>>
>>> Is it true? why is that so?
>>>
>>>
>>>
>>
>>
>>
>
>


"Stephen Rice" Posted on 2007-10-09 15:12:38.0Z
From: "Stephen Rice" <srice[at]sybase[dot]com>
Newsgroups: ianywhere.public.general
References: <470af998@forums-1-dub>
Subject: Re: cannot reload data
Lines: 31
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3138
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: srice-pciii.sybase.com
X-Original-NNTP-Posting-Host: srice-pciii.sybase.com
Message-ID: <470b9a66$1@forums-1-dub>
Date: 9 Oct 2007 08:12:38 -0700
X-Trace: forums-1-dub 1191942758 10.25.98.226 (9 Oct 2007 08:12:38 -0700)
X-Original-Trace: 9 Oct 2007 08:12:38 -0700, srice-pciii.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6370
Article PK: 2858

If you don't (or can't) specify column order in the SQL statement the
default order is the order the columns where created in.

If you want to unload columns in a different order from the default you have
to unload each table with either the UNLOAD SELECT or SELECT/OUTPUT TO
--
/steve
Stephen Rice
Sybase iAnywhere

"Chris" <Chris@gmail.com> wrote in message news:470af998@forums-1-dub...
>I have unloaded the db and wish to have it reloaded.
> the option used was UNLOAD DATA only since UNLOAD STRUCTURE AND DATA would
> not resolve RI problem in my previous posts.
>
> During reload several error messages appearred saying some columns are
> missing whereas the columns are actually there.
>
> I conclude that ASA won't reload if the source and destination table have
> incorrect column order.
>
> for example
> source_table : id, name, address
> destinatin_table: id, address, name
>
> Is it true? why is that so?
>
>
>