Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Using prompt in SQL

Status
Not open for further replies.
craig322

craig322

MIS
Apr 19, 2001
108
US
How do you embed a cognos prompt in a custom SQL in impromptu? I keep receiving an error when I try to insert a prompt in the SQL I have created for the report.

I am connecting to an Informix database.

I have tried enclosing it in '', "" and ().

TIA

Craig
 
Sort by date Sort by votes
Don't know if this will help as we are not informix users, however, when we have inserted prompts into sql we use the insert prompt button within the query builder window and the syntax appears as below within the sql, we then subsequently place it where it is required:

T3.Year_Text IN ?Year?

Where ?Year? is the prompt.

Cheers,

Adam.
 
Upvote 0 Downvote
It has been awhile, but I believe that ?prompt? syntax is correct.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

beegeeblueboy
  • Locked
  • Question
cdate function Impromptu 7.5 SQL script not recognised by SQL Server
Replies
0
Views
272
beegeeblueboy
beegeeblueboy
tushargaurav
  • Locked
  • Question
date time prompt not working in arabic language in cognos
Replies
0
Views
245
tushargaurav
tushargaurav
wwconslt
  • Locked
  • Question
Wild Card for Nine Digit Zip Codes in Prompt
Replies
0
Views
222
wwconslt
wwconslt
sreevp2020
  • Locked
  • Question
dynamic deafult date in date prompt calandar
Replies
0
Views
226
sreevp2020
sreevp2020
deborahyr63
  • Locked
  • Question
how to code for service year milestones in 2020
Replies
0
Views
212
deborahyr63
deborahyr63

Part and Inventory Search

Sponsor

Back
Top