Unconfigured Ad Widget

Collapse

Announcement

Collapse
No announcement yet.

How to write an SQL in a TEXT file

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Guest's Avatar
    Guest replied
    How to write an SQL in a TEXT file

    Derek, Were you planning on displaying the result? If you were, a Query Management Query might be what you are looking for. Try GO QUERY. The resulting menu is the entry point for query commands. David Morris

    Leave a comment:


  • dledbetter@adeleknits.com
    replied
    How to write an SQL in a TEXT file

    To whom it may concern: I would like to write a simple statement in a text file and then have the RUNSQLSTM run it. I have used STRSQL to see if it works and it does. Now, when I put it in the file, it does not work. The compile is listed below. I would appreciate any suggestions. Thanks. Derek Select LgInv#, Count(*) From rmfiles/viinwrk Group by Lginv# Having Count(*) > 1 * * * * * E N D O F S O U R C E 010525 Run SQL Statements . 1 ...+... 2 ...+... 3 ...+... 4 ...+... 5 ...+... MSGID RECORD TEXT SQL0084 1 Position 10 SQL statement not allowed. Message Summary Warning Error Severe Terminal 0 0 1 0 ty errors found in source

    Leave a comment:


  • T.Holt
    started a topic How to write an SQL in a TEXT file

    How to write an SQL in a TEXT file

    If I remember correctly, RUNSQLSTM only runs certain SQL commands, and SELECT isn't one of them, believe it or not.
Working...
X