0

I have a variable in batch script and I want to use this variable at sqlloader code for infile. How can I do?

mbakay
  • 21
  • 5
  • 1
    elaborate your question, as of now it makes no sense to anybody. – Sunny Dec 31 '13 at 15:57
  • 1
    ok, I defined a variable in batch script for a directory and I want to use this in sqlloader control file. I'm going to use this variable in sqlloader control file for 'infile'. thnks. – mbakay Jan 01 '14 at 04:11

1 Answers1

1

I solved my question.

my variable is directory_name in batch script. i define this variable like set directory_name = C:\a\b.csv. And i use this variable in sqlloader control file infile '%directory_name%'.

thanks.

mbakay
  • 21
  • 5
  • with `set` don't use spaces before and after the equal sign. This (these) space(s) would be part of the variablename or the value – Stephan Jan 01 '14 at 08:40
  • you are true. i written these spaces mistakenly. sorry for this. – mbakay Jan 01 '14 at 21:12