×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

spool to a dynamically created file

spool to a dynamically created file

spool to a dynamically created file

(OP)
I would like to spool a SQL result to a file.  But, I want the file to change depending on what the user enters at a prompt.  The problem I am having is that now I want part of my file name to be built depending on what the user enters.  

For example, I want the file name to contain a year and some text.  The text is conditional: if the user enters 1, then 'PNC'.  If the user enters 2, then 'LAH' else 'NULL'.

ACCEPT yr PROMPT 'Enter Year: '
ACCEPT instype PROMPT 'Ins Type: '

DEFINE underscore = '_'
DEFINE ext = '.csv'
DEFINE report = 'CustomReports\D3F_&instype&underscore&yr&ext'
SPOOL &report

I do not really want to spool to a file called 'CustomReports\D3F_2_2002.csv'
Instead, I would rather spool to a file called 'CustomReports\D3F_LAH_2002.csv'

I tried using PL/SQL to build my file name but I am still having trouble.  

Does anyone have any ideas?

Thanks in advance.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources