Thisid

Thisid

Sign up or log in to customize your list.

more stack exchange communities

company blog

2022 Developer Survey is open! Take survey .

Stack Overflow for Teams
– Start collaborating and sharing organizational knowledge.

Create a free Team
Why Teams?

Asked
6 years, 9 months ago

Modified
6 years, 9 months ago

13.4k 1 1 gold badge 45 45 silver badges 71 71 bronze badges

Sorted by:

Reset to default

Highest score (default)

Date modified (newest first)

Date created (oldest first)

18.9k 1 1 gold badge 17 17 silver badges 39 39 bronze badges

7,318 20 20 silver badges 25 25 bronze badges

Stack Overflow

Questions
Help

Products

Teams
Advertising
Collectives
Talent

Company

About
Press
Work Here
Legal
Privacy Policy
Terms of Service
Contact Us
Cookie Settings
Cookie Policy

Stack Exchange Network

Technology

Culture & recreation

Life & arts

Science

Professional

Business

API

Data

Accept all cookies

Customize settings

Find centralized, trusted content and collaborate around the technologies you use most.
Connect and share knowledge within a single location that is structured and easy to search.
Today, I found some DB2 field name gets started and ended by double quotes when I was using STRSQL and F4. But it seems that it happens randomly.
Is there anyone can answer for me why it's happened?
Also I'd like to hear if we can keep this as it is or is needed to be fixed?
You're creating the table from Excel, I assume by using the Transfer Data add-in?
Two reason why a column name gets quoted...
1) It's a reserved word. For example, DATE as a column name
CREATE TABLE MYTBL("DATE" DATE NOT NULL WITH DEFAULT)
2) to preserve case
CREATE TABLE MYTBL("MyColumn" CHAR(10) NOT NULL WITH DEFAULT)
In the first case, the system is often smart enough to allow you to reference the column without quoting it; this works:
select date from mytbl
However, in the second case, you always have to reference the column with quotes and the correct case; this DOES NOT work:
select mycolumn from mytbl
An ordinary identifier is an uppercase letter followed by zero or more characters, each of which is an uppercase letter, a digit, or the underscore character. Note that ordinary identifiers are converted to uppercase. An ordinary identifier should not be a reserved word.
A delimited identifier is a sequence of one or more characters enclosed within SQL escape characters. The sequence must consist of one or more characters. Leading blanks in the sequence are significant. Trailing blanks in the sequence are not significant. The length of a delimited identifier does not include the two SQL escape characters. Note that delimited identifiers are not converted to uppercase. The escape character is the quotation mark (").
Thanks for contributing an answer to Stack Overflow!

By clicking “Post Your Answer”, you agree to our terms of service , privacy policy and cookie policy

To subscribe to this RSS feed, copy and paste this URL into your RSS reader.

Site design / logo © 2022 Stack Exchange Inc; user contributions licensed under cc by-sa . rev 2022.5.20.42186

By clicking “Accept all cookies”, you agree Stack Exchange can store cookies on your device and disclose information in accordance with our Cookie Policy .

Shop Our Spring Collection. Now Available.

Matte

Glossy

Metallic

See All

Acetate

Metal

Narrow

Medium

Wide

Matte

Glossy

See All

Acetate

Metal

Narrow

Medium

Wide

Glossy

Matte

See All

Medium

Wide

Search
Magnifying glass

Bag

Menu
3 horizontal bars

Close

Matte

Glossy

Metallic

See All

Narrow

Medium

Wide

Matte

Glossy

See All

Narrow

Medium

Wide

Glossy

Matte

See All

Instagram

Twitter

Facebook

Eyewear is so personal. I started wearing glasses at the age of 8; and pretty much ever since, I have loved how they can be a statement—a form of self-expression that extends beyond their function.
DL Eyewear is the result of decades of experimenting with my own eyewear. Essentially, eyewear should be fun. The thrill of matching a frame to your mood. The exploration of personal style. The building of an optical wardrobe. I wanted to create special yet accessible frames that people would love to wear and collect.
In doing so, we will release frames when they are ready rather than sticking to a seasonal schedule. We are investing time and considerable care in every element—from addressing a multitude of face shapes to arriving at the perfect name. Rose, for instance, is for all the Moiras out there (wigs optional).
These words are inscribed in every frame as a friendly reminder to do just that every day. Which is why DL Eyewear will be giving back through our support of Local Initiatives Support Corporation (LISC) , which assists small businesses—prioritizing those owned by women, people of color, members of the LGBTQIA+ community, and entrepreneurs located in historically disadvantaged communities. In this way, the growth of our business ensures that others can advance, as well.

If you have any questions or concerns, please feel free to contact us.
Thank you for your support of the ThisIsIT experiment! We couldn’t have gotten this far without your support. At this point, we’ve decided to head a different direction to ensure we can continue creating the most content we can with the least amount of administrative overhead.
We stopped all charges for recurring donors; it will remain this way until the end of May, at which point we will take the site down. Thank you again for all your support as we learn and grow together!
If you want to continue supporting us, please visit our websites:
If you have any questions or concerns, please feel free to contact us.
Existing Account login here : https://my.thisisit.io/sign_in

Cuckold Ass To Mouth
Jenna Jameson Pee
Girls Puking Video

Thisid

Report Page