Quote(') or Quote(")

prabu · Post by **prabu** » Fri Aug 11, 2006 9:38 am

Hi everyone,
maybe one of the silliest questions ever! should i use quote(') or quote(") when referring strings. any differences?.

regards,
Prabu

ArndW · Post by **ArndW** » Fri Aug 11, 2006 10:02 am

You can use either interchangeably, so it is just a matter of personal preference. You can also use the backslash as a quote character if you really want to, so a string of the form \He's a real "DataStager"\ is valid as well.

chulett · Post by **chulett** » Fri Aug 11, 2006 10:02 am

Not that I've ever seen... unless something like your database cares.

prabu · Post by **prabu** » Fri Aug 11, 2006 10:52 am

thanks ArndW and Craig! it's good to get clarified on this.

ray.wurlod · Post by **ray.wurlod** » Sat Aug 12, 2006 12:52 am

While it does not matter in DataStage itself you do have to get it right in a number of locations.

In SQL, double quotes are used for identifiers and single quotes for string constants.

In shell scripts, single quotes are "hard quotes" while double quotes are "soft quotes": some expansions are possible within soft quotes.

In C or C++ routines double quotes (only) surround string literals.