• Share
  • ?
  • Profiles ▼
  • Communities ▼
  • Apps ▼

Blogs

  • My Blogs
  • Public Blogs
  • My Updates
  • Administration
  • Log in to participate

▼ Tags

 

▼ Similar Entries

Are you an AIX perso...

Blog: AIXpert Blog
nagger 100000MRSJ
Updated
1 people likes thisLikes 1
CommentsComments 26

Check out the new In...

Blog: Appropriate C...
IngeHalilovic 060000MPB8
Updated
0 people like thisLikes 0
No CommentsComments 0

The Great Escape #

Blog: AIX Down Unde...
AnthonyEnglish 270000RKFN
Updated
0 people like thisLikes 0
No CommentsComments 0

Simple location serv...

Blog: U-CRE8! Mashu...
jdornbos 270002XYA7
Updated
1 people likes thisLikes 1
No CommentsComments 0

Scripting Dbaccess

Blog: Administratin...
gbowerman 100000B5T0
Updated
0 people like thisLikes 0
CommentsComments 1

▼ Archive

  • February 2017
  • January 2017
  • December 2016
  • September 2016
  • August 2016
  • January 2015
  • October 2014
  • May 2014
  • April 2014
  • March 2014
  • February 2014
  • January 2014
  • December 2013
  • October 2013
  • September 2013
  • August 2013
  • June 2013
  • May 2013
  • April 2013
  • March 2013
  • February 2013
  • January 2013
  • December 2012
  • November 2012
  • October 2012
  • September 2012
  • August 2012
  • July 2012
  • June 2012
  • May 2012
  • April 2012
  • March 2012
  • October 2010
  • March 2010
  • December 2009
  • June 2009
  • May 2009
  • April 2009
  • March 2009
  • February 2009
  • December 2008
  • November 2008
  • October 2008
  • August 2008
  • June 2008
  • May 2008
  • March 2008
  • January 2008
  • December 2007
  • November 2007
  • October 2007
  • September 2007
  • August 2007
  • July 2007
  • June 2007
  • May 2007
  • April 2007
  • March 2007

▼ Blog Authors

Informix Experts

View All Entries
Clicking the button causes a full page refresh. The user could go to the "Entry list" region to view the new content.) Entry list

C-Style Comment Indicator with DB-Access

cheetahblog 0600028TE8 | | Tags:  comment dbaccess ‎ | 9,217 Views


Earlier versions of Informix Dynamic Server (IDS) had restriction with C-style comment indicators ( /* ... */ ) in SQL statements, within the DB–Access operations.



Without the C-style comment indicator it was not compliance with SQL-99 standard and caused problems while migrate from other databases server.



Starting with IDS Version 11.10, restrictions with C-style comment are no longer in effect. Any of the following styles SQL comment indicators can be use in all DB–Access statements.



  • Double hyphen ( -- ) complies with the ANSI/ISO standard for SQL
  • Braces ( { } ) are an Informix extension to the ANSI/ISO standard
  • C-style slash-and-asterisk ( /* . . . */ ) comply with the SQL-99 standard



The comment symbol indicator can be choosing depends on ANSI/ISO compliance requirements.



Comment symbol indicator can be use on the same line with the SQL statement. It can spans across single-line or multiple-line, but cannot be nested.



DB-Access will filter any comments before sending SQL statement to the database server.



Examples:  -- Double hyphen comment  SELECT * FROM orders;     -- Selects all columns and rows                            -- from the orders table

{ Comment using braces } SELECT * FROM orders; { Selects all columns and rows from the orders table }

/* C-style comment */ SELECT * FROM orders; /* Selects all columns and rows from the orders table */


Sanjit Chakraborty
  • Add a Comment Add a Comment
  • Edit
  • More Actions v
  • Quarantine this Entry
Notify Other People
notification

Send Email Notification

+

Quarantine this entry

deleteEntry
duplicateEntry

Mark as Duplicate

  • Previous Entry
  • Main
  • Next Entry
Feed for Blog Entries | Feed for Blog Comments | Feed for Comments for this Entry