How do I get rid of the quoted table names and column names? #2

I have reversed Engineered an Access 2000 DB File, then changed the Database
type from Access 2000 to Oracle 9i.  The table and column names all have
double quotes around them.

Example:
create table "Table_59"  (
   "Column_1"           CHAR(10),
   "Column_2"           CHAR(10),
   "Column_3"           CHAR(10),
   "Column_4"           CHAR(10),
   "Column_5"           CHAR(10),
   "Column_6"           CHAR(10)
)
/

Why did this happen and How do I get rid of the double quotes?

Thanks,
Troy


0
Troy
12/17/2002 9:13:42 PM
sybase.powerdesigner.general 9408 articles. 1 followers. Follow

1 Replies
655 Views

Similar Articles

[PageSpeed] 47

In the Oracle  DBMS file under the script>sql>format section set the
CaseSensitivityUsingQuote option to NO.

HTH,
Anthony Hill


On Tue, 17 Dec 2002 16:13:42 -0500, "Troy Simpson"
<Troy_Simpson@ncsu.edu> wrote:

>I have reversed Engineered an Access 2000 DB File, then changed the Database
>type from Access 2000 to Oracle 9i.  The table and column names all have
>double quotes around them.
>
>Example:
>create table "Table_59"  (
>   "Column_1"           CHAR(10),
>   "Column_2"           CHAR(10),
>   "Column_3"           CHAR(10),
>   "Column_4"           CHAR(10),
>   "Column_5"           CHAR(10),
>   "Column_6"           CHAR(10)
>)
>/
>
>Why did this happen and How do I get rid of the double quotes?
>
>Thanks,
>Troy
>

0
Anthony
12/18/2002 8:54:36 PM
Reply:

Similar Artilces:

SQL: Column names, can ONLY get "name" instead of "table.name"
Hey all, When iterating through column names returned from a query, I need to get "table.name" rather than just "name" Check it out: If I have an SQL statement "SELECT table1.ID, table2.ID FROM table1, table2;" And table1 has a column name 'ID' and table2 has a column name 'ID' aswell, and i run the query, the dataset will contain column names 'ID' and 'ID' instead of 'table1.ID' and 'table2.ID' It is extremely important that I can differenciate between the 2 fields, and know where each of them come from. The same thing happen...

How do I get rid of the quoted table names and column names?
I have reversed Engineered an Access 2000 DB File, then changed the Database type from Access 2000 to Oracle 9i. The table and column names all have double quotes around them. Example: create table "Table_59" ( "Column_1" CHAR(10), "Column_2" CHAR(10), "Column_3" CHAR(10), "Column_4" CHAR(10), "Column_5" CHAR(10), "Column_6" CHAR(10) ) / Why did this happen and How do I get rid of the double quotes? Thanks, Troy ...

column "name" is not in table "name "
I have a problem with PB 6.5.1, and Informix 5.02 (Online) ... We receive the error above in subject.... when i tried to make a Datawindow updated. (settings) .. I`m not sute what that mean.. I have done all the testing.. and I did not find anything...Please .. help me Carlos BDT-Caracas-Venezuela Carlos, It sounds like the datawindow has a select statement that selects data from multiple tables using a SQL Join. nd perhaps when the update properties were set, columns from multiple tables were selected and marked as updateable columns. I will test this when I get a ...

How to get rid of the table name prefix in column names
Hi, Folks. This is driving me up the wall. I have a pfc application where I log in to an Adaptive Server Anywhere 8 database using the pfc functions. In this app I have a function where I create a datastore, do a retrieve and then loop through the rows fetching the column names as follows: s_name = lower(ds_export.Describe("#" + String(i_col) + ".Name")) This works fine. Now I want to run this function as a standalone program. So I create a simple non-pfc application and copy the code to a new function adding log-in code. This also works fine. Except.... N...

How to use a full column name (table name and column name) with a DataReader
Hi, I have a problem retrieving the data with a DataReader from a stored proc that performs a join of two table with the same column's names but different data. Let me explain with an example: I have two tables: Table1: Id, Name Table2: Id, Name, IdTable1 The sproc is something like this: CREATE PROCEDURE [dbo].[SearchByName] (@Name nvarchar(40)) AS BEGIN SELECT * FROM dbo.Table1, dbo.Table2 WHERE Table1.Id = Table2.IdTable1 AND Table1.Name LIKE '%' + @Name + '%' END And my c# code is something like this: Database db = Databas...

Trying to put dw.SetItem (ll_Row, "Column Name", dw.GetItemDec (ll_Row, "Column Name for CF"))
hello for some reason, it seems like my strings from yesterday doesnt come up on this newsgroup list. Anyways.. my problem is to put dw.SetItem (ll_Row, "Column Name", dw.GetItemDec (ll_Row, "Column Name for CF")). so that i can give a column value and a computed field so the data i give through the computed field gets inserted in a column. 1. where in the code do i put this.. 2. i have a global function which i called with a computed field "Column Name for CF".. tried attaching the pbl but no luck cany anyone help me please.. this is very critical f...

how to get table and columns names in quotes
I am using PowerDesigner 7.0.2.549 for an existing Sybase Anywhere 6 database. I have reversed engineered the database. Unfortunately some of the column names are reserved words such as "comment". When I generate the script and try to run the script it will error out. If there were quotes around the table and column names it would not error out. How can I get it to use quotes around table names and column names in the script? Thanks for the help. First I suggest that you upgrade to 7.5.0 at the very least. The patch is available at http://www.sybase.com. Mod...

superreview granted: [Bug 287390] Name & default action do not work on <input type="image"> : [Attachment 178402] 1) Create correct kind of accessible for each kind of button, 2) Better name getting
Johnny Stenback <jst@mozilla.org> has granted Aaron Leventhal <aaronleventhal@moonset.net>'s request for superreview: Bug 287390: Name & default action do not work on <input type="image"> https://bugzilla.mozilla.org/show_bug.cgi?id=287390 Attachment 178402: 1) Create correct kind of accessible for each kind of button, 2) Better name getting algorithm for buttons 3) Better recognize anonymous frames https://bugzilla.mozilla.org/attachment.cgi?id=178402&action=edit ------- Additional Comments from Johnny Stenback <jst@mozilla.org> - In ...

IM 9.0
Hi, I am using InfoMaker 9.0 Build 5507. In my PBL file, I create a new Freeform object. Then I choose SQL Select to select the table and the columns. In the Reports view, in the Column Specifictions tab, there is a "DB Name" column which shows the column name in "table_name.column_name" format. When a column name ends with a number (i.e. street1), the table name does not get prefixed in the Column Specification tab. For example, it displays "street1" instead of "mytable.street1". Has anyone else encountered this problem before? Please h...

IM 9.0
Hi, I am using PowerBuilder 9.0 Build 5507. 1) From within Powerbuilder, click File->New. Click the DataWindow Tab and double-click on the FreeForm icon. 2) From the "Choose Data Source for FreeForm DataWindow" dialog window, select the "SQL Select" icon and click "Next". 3) From the "Select Tables" dialog window, I selected the table MYTABLE, and then I selected the first 10 fields in that table. 4) Continue creating the form using the default values. 5) In the Column Specifications tab, there is a "DB Name" column which ...

Whan can i do? make "string" data type convert to "window" data type, and use a "window" name to get it ancestor "window name", thanks! i use pb5
Rich, With a string window name, you can open a window of that type if you need to. You could, of course, query that window object for any attributes. Another option is to use the LibraryExport function to export the definition of the window which is specified by the string. You can then parse the resulting file to get information on the ancestor object. HTH Sanjiv. "Rich" <windows_ce@netease.com> wrote in message news:2Xsr1WW0AHA.178@forums.sybase.com... > > > ...

META name="title" + META name="description" + META name="keywords" in MasterPage head section
Hy Guys, I've placed these META tags on the HEAD section of my MASTERPAGE of my application (used in all my webforms) Last Monday week I was on the first page of GOOGLE at the sixth position. Last Friday, I've added a script section on my head too. Something like: function .... .... .... This week, I can't even find my site even if I put on the search engine te exact site name. Did I do something wrong? Does the scrip section stop the google robots to read the META tags? Thank you in advance MarcoMarco First of all, META tags...

Mail resending duplicates in the "from" field the (Given Name Last Name) if name contains a "-"
Hello, An other incredible behavior with client GW8.01 and GW8.01HP if you resend one of your mail and if you given name or last name contains a "-" in eDir, the from field of your email is populated with a second occurrence of (givenname lastname); if you resend this again, then you get it 2 times (givenname lastname)(givenname lastname)etc... so an example: Suppose you are Snow White, with a frenchy touch, eDir Given Name: Blanche-Neige eDir Last Name: Disney and your GW address book is updated with it in first name/last name/name according eDir, Then if...

"Column name or number of supplied values does not match table definition" when trying to populate temp table
Hello, I am receiving the following error: Column name or number of supplied values does not match table definition I am trying to insert values into a temp table, using values from the table I copied the structure from, like this: SELECT TOP 1 * INTO #tbl_User_Temp FROM tbl_User TRUNCATE TABLE #tbl_User_Temp INSERT INTO #tbl_User_Temp EXECUTE UserPersist_GetUserByCriteria @Gender = 'Male', @Culture = 'en-GB' The SP UserPersist_GetByCriteria does a "SELECT * FROM tbl_User WHERE gender = @Gender AND culture = @Culture", so why am I receiving this error when both tab...

Web resources about - How do I get rid of the quoted table names and column names? #2 - sybase.powerdesigner.general

QuotEd ACT Science on the App Store on iTunes
Get QuotEd ACT Science on the App Store. See screenshots and ratings, and read customer reviews.

Sam Johnson quoted, Satya Nadella Microsoft Keynote, SES - Flickr - Photo Sharing!
"The trad of advertising is now so near perfection that it is not easy to propose any improvement." Sam Johnson, quote from The Idler, 1758. ...

Jehovah's Witness abuser quoted scripture while assaulting daughter, royal commission told
As a child growing up in a strict Jehovah's Witness household she was taught to obey her father as head of the family and warned&nbsp;that outsiders&nbsp;were ...

Carr says Romney quoted his 'US in decline' remark out of context
FOREIGN minister Bob Carr says he wasn't criticising America when he spoke of a nation "in decline" during a private conversation with Republican ...


Man accused in B.C. terror plot quoted bin Laden, planned rocket attack
A man accused of plotting to bomb the British Columbia legislature on Canada Day with his wife lamented that the death toll from the Boston Marathon ...

Quick update: Quoted in WSJ on dating apps, recent podcast interview, plus recent essays
... wrote the code for Apollo 11, and designed the Mac Ten classic books that define tech Thanks for reading! The post Quick update: Quoted in ...

Twitterrific adds support for quoted tweets on iPhone & emoji + quick reply on Apple Watch
... its iPhone app and with it come new features for both the Watch and phone. Version 5.12 of Twitterrific adds support for Twitter’s new quoted ...

The Most Quoted Experts
Justin Wolfers charts the recent dominance of economists: There’s an old Bob Dylan song that goes “there’s no success like failure,” and it’s ...


Resources last updated: 11/24/2015 2:25:41 PM