How to write an SQL in a TEXT file

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

[dledbetter@adeleknits.com]

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

[T.Holt]

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