Regarding Parameters

veera24 · Post by **veera24** » Fri Mar 14, 2008 10:02 pm

hi all,
Am having Database as a source. I got to parameterize the TABLE NAME in that DB. After importing the required table(in both table name field and as well as the meta data of the table in the column tab) and i gave Generated SQL query. I've parameterized the table name and it got reflected only in the last of Query.I mean there was a reflection in the FROM clause only and not in the SELECT clause. But i wan it to get reflect on both SELECT and FROM clause.
your time will be highly appreciated.
Thanks in advance..
veera

ray.wurlod · Post by **ray.wurlod** » Fri Mar 14, 2008 10:19 pm

For one table, or even if there is more than one table but the table names are unambiguous, you don't need to quality the column name with a table name. On the Columns tab simply clear the Derivation fields.

If you do need qualified table names, to use the job parameter reference as the column name simply include that in the Column Derivation field, for example #CustTable#.CUST_ID

veera24 · Post by **veera24** » Sat Mar 15, 2008 5:45 am

ray.wurlod wrote:For one table, or even if there is more than one table but the table names are unambiguous, you don't need to quality the column name with a table name. On the Columns tab simply clear the Derivation ...

Consider if A is my source DB and i've parameterized that as #DB# then the #DB# shud be reflected in the SELECT clause right?If that will not be the case then it will ask for aliases..cos i've encountered the same problem as aforementioned.I get the error stating that it reuiqres aliase name in SELECT clause.

Thnx.....
veera..

chulett · Post by **chulett** » Sat Mar 15, 2008 7:49 am

Depends. With a single table, no. With multiple tables where the column names are unique, no.

ray.wurlod · Post by **ray.wurlod** » Sat Mar 15, 2008 4:18 pm

The Derivation field (or if blank, the Name field) on the Columns grid becomes the SELECT clause.

The Table Name field becomes the FROM clause.

There is no intermixing. If you need qualified column names in the SELECT clause, you must specify those in the Derivation field.

ray.wurlod · Post by **ray.wurlod** » Sat Mar 15, 2008 4:20 pm

Premium membership costs less than 30c per day and will allow you, among other things, to view the entirety of the five premium posters' contributions. All revenue from premium memberships is devoted to defraying hosting and bandwidth costs incurred by DSXchange so, by taking premium membership, you are not only receiving the benefits but also helping to keep DSXchange alive.