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

  • 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

  • #2
    How to write an SQL in a TEXT file

    You cannot run any sql stmts in this manner if they return information. You can run things like CREATE TABLE, CREATE VIEW, DELETE TABLE, and INSERT but not a SELECT.

    Comment

    Working...
    X