#6652: Question about parameterized script

tariqrahiman reported 2012-03-22T17:36:59Z · last modified 2012-04-27T20:48:53Z

Question about parameterized script

Dev	kin-hong
QA	NielsGron

Priority	Low
Complexity	Unknown

Component	Q Analyzer - Parameterized Scripts
Version	10.0

Informix 11.5

ADS 10.0.8

1.) While using parameterized scripts and executing the query, the below query does not prompt for values

SELECT "n's", &TuitionFeesAmount, "N" FROM y

2) The next query is basically the same as the above one, but I have changed the order of &TuitionFeesAmount to be the first item and when I execute it, it prompts for the value:

SELECT &TuitionFeesAmount, "n's", "N" FROM y

// THese queries prompt for parameter values

SELECT "N", "n's", &TuitionFeesAmount, FROM y

SELECT "n's", "N", &TuitionFeesAmount, FROM y

SELECT "N",'ns', &TuitionFeesAmount,FROM y

1 attachment

Selection_007.png

2012-03-22T17:36:59Z

31 KB

All Comments (2) Change History

tariqrahiman 2012-03-23T18:09:45Z · (edited)

Version: 10.0.8_01

Build #: 25931

Build Date: 2012-Mar-23 08:24:32 AM

All the above SQL's work. Found a new pattern which is not bringing up all 3 parameters.

SELECT

&Tariq_Tution'Amount,

"n's", &Ivan_Tution,

"n's", &Jon_Tuition,"N" FROM y

This brings up only the prompt for the first value, rest 2 are ignored.

Below SQL works

SELECT "n's", &T1,

&T2'Amount, "n's"

"n's", &T3

FROM y

tariqrahiman 2012-03-23T22:27:18Z

Resolved in 10.0.8_02

Search Tips

Aqua Data Studio / nhilam

Question about parameterized script

1 attachment

Issue #6652

Completion

Search Tips

Aqua Data Studio / nhilam

Title

Question about parameterized script

1 attachment

Issue #6652

Completion