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 derfloh 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
Joined
Apr 19, 2001
Messages
108
Location
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 Question
cdate function Impromptu 7.5 SQL script not recognised by SQL Server
Replies
0
Views
590
beegeeblueboy
beegeeblueboy
tushargaurav
  • Locked
  • Question Question
date time prompt not working in arabic language in cognos
Replies
0
Views
535
tushargaurav
tushargaurav
wwconslt
  • Locked
  • Question Question
Wild Card for Nine Digit Zip Codes in Prompt
Replies
0
Views
521
wwconslt
wwconslt
sreevp2020
  • Locked
  • Question Question
dynamic deafult date in date prompt calandar
Replies
0
Views
499
sreevp2020
sreevp2020
deborahyr63
  • Locked
  • Question Question
how to code for service year milestones in 2020
Replies
0
Views
495
deborahyr63
deborahyr63

Part and Inventory Search

Sponsor

Back
Top