Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I am working through someone else SQL code and am getting a syntax error near @ line 106 col 43 (pos 2964). I typed in

I am working through someone else SQL code and am getting a syntax error near "@" line 106 col 43 (pos 2964).

I typed in line numbers to help with referencing.

I believe that I need to re-write the code after the @Prompt but do not understand what the @Prompt is doing.

104 WHERE

105 (

106 Table__1."SL_SPECIAL_PROCESS_FLAG" = @Prompt('Special Process Flag:','N','PR/SL/GR Detail Reporting\SL Data\SL Special Process Flag',Mono,Free,Persistent,,User:0,Optional)

107 AND

108 Table__1."MENGE_EKET" Is Not Null

109 AND

110 Table__1."OPEN_FLAG" = 1

111 )

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Databases questions