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.

Replace Tables

7 posts in PB Infomaker Report Writer Last posting was on 1999-02-18 23:00:22.0Z
Doreen Weekley Posted on 1999-02-03 22:17:26.0Z
Newsgroups: sybase.public.infomaker.general
From: "Doreen Weekley" <dweekley@primavera.com>
Subject: Replace Tables
Date: Wed, 3 Feb 1999 17:17:26 -0500
Lines: 11
X-Newsreader: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
Message-ID: <348_sOsgdI8T#GA.226@forums.powersoft.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.infomaker.general:6585
Article PK: 241570

Infomaker uses the format tableName.columnName when reports pull data from
more than one table. That means all column objects and computed fields
referring to columns will have the tableName embedded. Any suggestions on a
way to build a multitable report that I can use for multiple data sets
where all the column names are identical but table names are different?
I've seen this called a replace table command in other report writers.
Hopefully I'm just overlooking something.
Tks ahead of time for any suggestions.
Doreen


Terry Dykstra Posted on 1999-02-04 19:06:05.0Z
Newsgroups: sybase.public.infomaker.general
From: "Terry Dykstra" <tdykstra@cfol.ab.ca>
Subject: Re: Replace Tables
Date: Thu, 4 Feb 1999 12:06:05 -0700
Lines: 20
X-Newsreader: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
Message-ID: <348_NOSjjEHU#GA.231@forums.powersoft.com>
References: <348_sOsgdI8T#GA.226@forums.powersoft.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.infomaker.general:6584
Article PK: 241571

You can convert the sql to syntax and then replace the table names easily.

--
Terry Dykstra (TeamPS)
Canadian Forest Oil Ltd.

Doreen Weekley wrote in message ...
>Infomaker uses the format tableName.columnName when reports pull data from
>more than one table. That means all column objects and computed fields
>referring to columns will have the tableName embedded. Any suggestions on
a
>way to build a multitable report that I can use for multiple data sets
>where all the column names are identical but table names are different?
>I've seen this called a replace table command in other report writers.
>Hopefully I'm just overlooking something.
>Tks ahead of time for any suggestions.
>Doreen
>
>


Doreen Weekley Posted on 1999-02-04 19:49:52.0Z
Newsgroups: sybase.public.infomaker.general
From: "Doreen Weekley" <dweekley@primavera.com>
Subject: Re: Replace Tables
Date: Thu, 4 Feb 1999 14:49:52 -0500
Lines: 32
X-Newsreader: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
Message-ID: <348_u0E7paHU#GA.224@forums.powersoft.com>
References: <348_sOsgdI8T#GA.226@forums.powersoft.com> <348_NOSjjEHU#GA.231@forums.powersoft.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.infomaker.general:6583
Article PK: 241567

Yes but then I also have to edit all my objects on the report painter
individually to replace the old table name and if any column objects were on
the report they get deleted. Also, after going into syntactical SQL you
can't go back to graphical SQL nicely all the time. Anyway, I'm not
knocking the suggestion just wondered if I'd missed a way that may eliminate
all the extra work.

Doreen

Terry Dykstra wrote in message ...
>You can convert the sql to syntax and then replace the table names easily.
>
>--
>Terry Dykstra (TeamPS)
>Canadian Forest Oil Ltd.
>Doreen Weekley wrote in message ...
>>Infomaker uses the format tableName.columnName when reports pull data from
>>more than one table. That means all column objects and computed fields
>>referring to columns will have the tableName embedded. Any suggestions on
>a
>>way to build a multitable report that I can use for multiple data sets
>>where all the column names are identical but table names are different?
>>I've seen this called a replace table command in other report writers.
>>Hopefully I'm just overlooking something.
>>Tks ahead of time for any suggestions.
>>Doreen
>>
>>
>
>


Terry Dykstra (TeamPS) Posted on 1999-02-05 03:38:16.0Z
Newsgroups: sybase.public.infomaker.general
From: "Terry Dykstra (TeamPS)" <dont_spam_me_tdykstra@cfol.ab.ca>
Subject: Re: Replace Tables
Date: Thu, 4 Feb 1999 20:38:16 -0700
Lines: 51
X-Newsreader: Microsoft Outlook Express 4.72.2106.4
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4
Message-ID: <348_QBx2qoLU#GA.209@forums.powersoft.com>
References: <348_sOsgdI8T#GA.226@forums.powersoft.com> <348_NOSjjEHU#GA.231@forums.powersoft.com> <348_u0E7paHU#GA.224@forums.powersoft.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.infomaker.general:6581
Article PK: 241565

Use aliases:
select mytable.myfield myfield
from mytable

Now you can safely replace mytable with yourtable, without affecting the
report iself.

Converting back to graphical mode is indeed something that not always works
properly.
--
Terry Dykstra (TeamPS)
Canadian Forest Oil Ltd.

Doreen Weekley wrote in message ...
>Yes but then I also have to edit all my objects on the report painter
>individually to replace the old table name and if any column objects were
on
>the report they get deleted. Also, after going into syntactical SQL you
>can't go back to graphical SQL nicely all the time. Anyway, I'm not
>knocking the suggestion just wondered if I'd missed a way that may
eliminate
>all the extra work.
>
>Doreen
>
>Terry Dykstra wrote in message ...
>>You can convert the sql to syntax and then replace the table names easily.
>>
>>--
>>Terry Dykstra (TeamPS)
>>Canadian Forest Oil Ltd.
>>Doreen Weekley wrote in message ...
>>>Infomaker uses the format tableName.columnName when reports pull data
from
>>>more than one table. That means all column objects and computed fields
>>>referring to columns will have the tableName embedded. Any suggestions
on
>>a
>>>way to build a multitable report that I can use for multiple data sets
>>>where all the column names are identical but table names are different?
>>>I've seen this called a replace table command in other report writers.
>>>Hopefully I'm just overlooking something.
>>>Tks ahead of time for any suggestions.
>>>Doreen
>>>
>>>
>>
>>
>
>


Doreen Weekley Posted on 1999-02-16 13:24:30.0Z
Newsgroups: sybase.public.infomaker.general
From: "Doreen Weekley" <dweekley@primavera.com>
Subject: Re: Replace Tables
Date: Tue, 16 Feb 1999 08:24:30 -0500
Lines: 69
X-Newsreader: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
Message-ID: <348_0LhRL7aW#GA.94@forums.powersoft.com>
References: <348_sOsgdI8T#GA.226@forums.powersoft.com> <348_NOSjjEHU#GA.231@forums.powersoft.com> <348_u0E7paHU#GA.224@forums.powersoft.com> <348_QBx2qoLU#GA.209@forums.powersoft.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.infomaker.general:6561
Article PK: 241548

This is an addition to my most recent post. I'm also having problems using
aliases when using more than one table. IM continues (as mentioned in my
last post) to not only continue to list the original field name but attaches
the table name and so when I replace tables I still have computed objects
with the old table name embedded in it.

I've tried using table aliases also, no luck....
I'm doing all this in sql syntax mode.
Any ideas? I may be doing something wrong, but if so I don't see it and
would appreciate the help.

Tks again
Doreen

Terry Dykstra (TeamPS) wrote in message ...
>Use aliases:
>select mytable.myfield myfield
>from mytable
>
>Now you can safely replace mytable with yourtable, without affecting the
>report iself.
>
>Converting back to graphical mode is indeed something that not always works
>properly.
>--
>Terry Dykstra (TeamPS)
>Canadian Forest Oil Ltd.
>Doreen Weekley wrote in message ...
>>Yes but then I also have to edit all my objects on the report painter
>>individually to replace the old table name and if any column objects were
>on
>>the report they get deleted. Also, after going into syntactical SQL you
>>can't go back to graphical SQL nicely all the time. Anyway, I'm not
>>knocking the suggestion just wondered if I'd missed a way that may
>eliminate
>>all the extra work.
>>
>>Doreen
>>
>>Terry Dykstra wrote in message ...
>>>You can convert the sql to syntax and then replace the table names
easily.
>>>
>>>--
>>>Terry Dykstra (TeamPS)
>>>Canadian Forest Oil Ltd.
>>>Doreen Weekley wrote in message ...
>>>>Infomaker uses the format tableName.columnName when reports pull data
>from
>>>>more than one table. That means all column objects and computed fields
>>>>referring to columns will have the tableName embedded. Any suggestions
>on
>>>a
>>>>way to build a multitable report that I can use for multiple data sets
>>>>where all the column names are identical but table names are different?
>>>>I've seen this called a replace table command in other report writers.
>>>>Hopefully I'm just overlooking something.
>>>>Tks ahead of time for any suggestions.
>>>>Doreen
>>>>
>>>>
>>>
>>>
>>
>>
>
>


Terry Dykstra Posted on 1999-02-18 23:00:22.0Z
Newsgroups: sybase.public.infomaker.general
From: "Terry Dykstra" <tdykstra@cfol.ab.ca>
Subject: Re: Replace Tables
Date: Thu, 18 Feb 1999 16:00:22 -0700
Lines: 81
X-Newsreader: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
Message-ID: <348_LMg6kI5W#GA.271@forums.powersoft.com>
References: <348_sOsgdI8T#GA.226@forums.powersoft.com> <348_NOSjjEHU#GA.231@forums.powersoft.com> <348_u0E7paHU#GA.224@forums.powersoft.com> <348_QBx2qoLU#GA.209@forums.powersoft.com> <348_0LhRL7aW#GA.94@forums.powersoft.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.infomaker.general:6538
Article PK: 241524

I don't have a solution for you. IM always seems to prefix the tablename as
soon as you have 2 or more tables. It's probably a built-in safeguard to
ensure that objects always have unique names.

--
Terry Dykstra (TeamPS)
Canadian Forest Oil Ltd.

Doreen Weekley wrote in message <0LhRL7aW#GA.94@forums.powersoft.com>...
>This is an addition to my most recent post. I'm also having problems using
>aliases when using more than one table. IM continues (as mentioned in my
>last post) to not only continue to list the original field name but
attaches
>the table name and so when I replace tables I still have computed objects
>with the old table name embedded in it.
>
>I've tried using table aliases also, no luck....
>I'm doing all this in sql syntax mode.
>Any ideas? I may be doing something wrong, but if so I don't see it and
>would appreciate the help.
>
>Tks again
>Doreen
>
>Terry Dykstra (TeamPS) wrote in message ...
>>Use aliases:
>>select mytable.myfield myfield
>>from mytable
>>
>>Now you can safely replace mytable with yourtable, without affecting the
>>report iself.
>>
>>Converting back to graphical mode is indeed something that not always
works
>>properly.
>>--
>>Terry Dykstra (TeamPS)
>>Canadian Forest Oil Ltd.
>>Doreen Weekley wrote in message ...
>>>Yes but then I also have to edit all my objects on the report painter
>>>individually to replace the old table name and if any column objects were
>>on
>>>the report they get deleted. Also, after going into syntactical SQL you
>>>can't go back to graphical SQL nicely all the time. Anyway, I'm not
>>>knocking the suggestion just wondered if I'd missed a way that may
>>eliminate
>>>all the extra work.
>>>
>>>Doreen
>>>
>>>Terry Dykstra wrote in message ...
>>>>You can convert the sql to syntax and then replace the table names
>easily.
>>>>
>>>>--
>>>>Terry Dykstra (TeamPS)
>>>>Canadian Forest Oil Ltd.
>>>>Doreen Weekley wrote in message ...
>>>>>Infomaker uses the format tableName.columnName when reports pull data
>>from
>>>>>more than one table. That means all column objects and computed fields
>>>>>referring to columns will have the tableName embedded. Any suggestions
>>on
>>>>a
>>>>>way to build a multitable report that I can use for multiple data sets
>>>>>where all the column names are identical but table names are different?
>>>>>I've seen this called a replace table command in other report writers.
>>>>>Hopefully I'm just overlooking something.
>>>>>Tks ahead of time for any suggestions.
>>>>>Doreen
>>>>>
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>


Doreen Weekley Posted on 1999-02-12 18:39:02.0Z
Newsgroups: sybase.public.infomaker.general
From: "Doreen Weekley" <dweekley@primavera.com>
Subject: Re: Replace Tables
Date: Fri, 12 Feb 1999 13:39:02 -0500
Lines: 75
X-Newsreader: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
Message-ID: <348_OFRbUYrV#GA.220@forums.powersoft.com>
References: <348_sOsgdI8T#GA.226@forums.powersoft.com> <348_NOSjjEHU#GA.231@forums.powersoft.com> <348_u0E7paHU#GA.224@forums.powersoft.com> <348_QBx2qoLU#GA.209@forums.powersoft.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.infomaker.general:6567
Article PK: 241551

Terry

This does indeed allow me to replace my tables without loosing or having to
redefine info in the report objects. I have a question, however. I'm using
6.5 Build 444. I expected, after setting my alias names to see the alias
names over on the report side. IM, however, continues to use the original
column name but treat it differently. For example:

Select mytable.field1 myfield
from mytable

On the report side, nowhere do I see a reference to myfield. IM still refers
to the column as field1 but does, indeed, treat it as an alias and leave it
in the report when I swap table names. Is this a bug, by design, or am I
overlooking something?

Tks again, a head of time
PS - You run a great newsgroup, it is quite helpful.
Doreen

Terry Dykstra (TeamPS) wrote in message ...
>Use aliases:
>select mytable.myfield myfield
>from mytable
>
>Now you can safely replace mytable with yourtable, without affecting the
>report iself.
>
>Converting back to graphical mode is indeed something that not always works
>properly.
>--
>Terry Dykstra (TeamPS)
>Canadian Forest Oil Ltd.
>Doreen Weekley wrote in message ...
>>Yes but then I also have to edit all my objects on the report painter
>>individually to replace the old table name and if any column objects were
>on
>>the report they get deleted. Also, after going into syntactical SQL you
>>can't go back to graphical SQL nicely all the time. Anyway, I'm not
>>knocking the suggestion just wondered if I'd missed a way that may
>eliminate
>>all the extra work.
>>
>>Doreen
>>
>>Terry Dykstra wrote in message ...
>>>You can convert the sql to syntax and then replace the table names
easily.
>>>
>>>--
>>>Terry Dykstra (TeamPS)
>>>Canadian Forest Oil Ltd.
>>>Doreen Weekley wrote in message ...
>>>>Infomaker uses the format tableName.columnName when reports pull data
>from
>>>>more than one table. That means all column objects and computed fields
>>>>referring to columns will have the tableName embedded. Any suggestions
>on
>>>a
>>>>way to build a multitable report that I can use for multiple data sets
>>>>where all the column names are identical but table names are different?
>>>>I've seen this called a replace table command in other report writers.
>>>>Hopefully I'm just overlooking something.
>>>>Tks ahead of time for any suggestions.
>>>>Doreen
>>>>
>>>>
>>>
>>>
>>
>>
>
>