Skip to main content
Question

SQL statements et al

  • August 2, 2023
  • 2 replies
  • 1 view
Stefano Gallotta

Hi all - any advice here, please? (or please explain my "potential" misunderstanding :)

I am experiencing difficulties in understanding why when attempting to use the D3 SQL ISQL commands.
I have this version :
On executing:
which I checked in the code and the code looks for an implementation > 8.
Furthermore, from the documentation I see that there is a NT_ISQL verb; which I also attempted 


This one just drops to TCL - the code looks for (field function) a '~' separator which I give:
And then things get "pear-shaped" 

    2 replies

    Chris Macadam

    Hi all - any advice here, please? (or please explain my "potential" misunderstanding :)

    I am experiencing difficulties in understanding why when attempting to use the D3 SQL ISQL commands.
    I have this version :
    On executing:
    which I checked in the code and the code looks for an implementation > 8.
    Furthermore, from the documentation I see that there is a NT_ISQL verb; which I also attempted 


    This one just drops to TCL - the code looks for (field function) a '~' separator which I give:
    And then things get "pear-shaped" 

    Hi Stefano,

    Not sure what happened but the version and the statement being executed were stripped from the comment so I'll answer in general terms: ISQL is not a supported feature on D3/Windows which may or may not answer your question.  If, on the other hand, you are using D3/Linux then it should work.  If that is the case, seeing the statement would be the next step in trying to get this sorted out.

    Cheers.

    Brian Cram
    Forum|alt.badge.img+3
    • Brian CramRocketeer
    • Rocketeer
    • August 2, 2023

    Hi all - any advice here, please? (or please explain my "potential" misunderstanding :)

    I am experiencing difficulties in understanding why when attempting to use the D3 SQL ISQL commands.
    I have this version :
    On executing:
    which I checked in the code and the code looks for an implementation > 8.
    Furthermore, from the documentation I see that there is a NT_ISQL verb; which I also attempted 


    This one just drops to TCL - the code looks for (field function) a '~' separator which I give:
    And then things get "pear-shaped" 

    Stefano, as we determined while we were working the case, your D3 Linux system was not activated. I believe that's the core reason it's not working, but I'll do a sanity check.

    Recent badge winners

    Explore all badges
    Terms & ConditionsAccessibility statement