Forum Stats

  • 3,757,167 Users
  • 2,251,204 Discussions
  • 7,869,748 Comments

Discussions

sqlcl path setting

User_ZUUOD
User_ZUUOD Member Posts: 798 Bronze Badge
edited Jan 7, 2019 10:25AM in SQLcl

Hi

i have downloaded sqlcl and setup it as in window 7 environmental path variable but when i run it on cmd like sql it says not recognized command.

can you suggest whats wrong I did.

Best Answer

  • Glen Conway
    Glen Conway Member Posts: 859 Gold Badge
    edited Nov 29, 2018 4:05PM Accepted Answer

    Did you include the sqlcl\bin portion of the path to sql.exe in your PATH?  It should look something like:

    PATH=C:\Tools\sqlcl\r18_3\sqlcl\bin;C:\windows\system32; ...

    As an alternative (what I do), create a shortcut to a CMD window that starts in:

    C:\Tools\sqlcl\r18_3\sqlcl\bin 

    then run sql from there.

    Cheers

    Edit:

    Or maybe if you edited the PATH variable in your Windows System Properties -> Environment Variables,

    rather than on the fly in the CMD window,

    you forgot to open a new CMD window so the change will take effect?

Answers

  • Frank Kulash
    Frank Kulash Member, Moderator Posts: 41,027 Red Diamond
    edited Nov 29, 2018 1:46PM

    Hi,

    You've got the wrong Forum.  This Forum is just for questions about using the SQL or PL/SQL languages.

    I'll move this thread to the

    SQLcl

    Froum

  • Glen Conway
    Glen Conway Member Posts: 859 Gold Badge
    edited Nov 29, 2018 4:05PM Accepted Answer

    Did you include the sqlcl\bin portion of the path to sql.exe in your PATH?  It should look something like:

    PATH=C:\Tools\sqlcl\r18_3\sqlcl\bin;C:\windows\system32; ...

    As an alternative (what I do), create a shortcut to a CMD window that starts in:

    C:\Tools\sqlcl\r18_3\sqlcl\bin 

    then run sql from there.

    Cheers

    Edit:

    Or maybe if you edited the PATH variable in your Windows System Properties -> Environment Variables,

    rather than on the fly in the CMD window,

    you forgot to open a new CMD window so the change will take effect?