Description

SQLSELECT: Support for PICK dictionary names

This patch attempts to get the dictionary names closer to what jDP would have previously allowed, in many cases it should not always be needed to setup the extended dictionaries.

This patch should:

• Allow some of the most common PICK dictionary names that are SQL reserved words; DATE is the main offender and is then prepended with a an underscore character, e.g.

DATE with _DATE

• Allow column names to contain with @, $ or .
  The parsing of dictionary names requires replacing the following characters in the dictionary name:

@ with _
$ with _
. with _

• Allow full or aliased names to be used in any case.

Without setting DONT_EXPAND_NONE_ASSOCATED_MV=1, much of this functionality is disabled.

DONT_EXPAND_NONE_ASSOCATED_MV will force any MV’s to only return the first value

Previous Release Behavior

Could not use many pick dictionary names due to SQL restrictions, e.g.

a.b.c.d.e
@ID
DATE

Current Release Behavior

Most dictionary names should now be valid.

For example, given a CUSTOMERS file with 10 records and a dictionary called CUSTOMER.NAME where the firstname is in attribute 1 and the lastname is in attribute 2:

    CUSTOMER.NAME
001 A
002 0
003
004
005
006
007
008 C;1;' ';2
009 L
010 25

jsh home ~ -->SQLSELECT CUSTOMER_NAME FROM CUSTOMERS
CUSTOMER_NAME
-------------------------
DAVID FLETCHER
TED WALKER
GREG SMITH
ERIC ATKINS
MICK McNEALY
RON FLETCHER
BRUCE BAILEY
BRUCE McNEALY
RON SMITH
BILL WALKER

Selected 10 rows.