If I remember correctly, RUNSQLSTM only runs certain SQL commands, and SELECT isn't one of them, believe it or not.
Unconfigured Ad Widget
Collapse
Announcement
Collapse
No announcement yet.
How to write an SQL in a TEXT file
Collapse
X
-
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
Comment