RE: Help With SQL400 RUNSQLSTM

[Bruce.Odum@xxxxxxxxxxxxxx]

its to bad query mgr has the 250 column limit.  I will give the create
table and insert into a shot.  Thank you all for your help.






Bruce Odum
Delivery Services
2601 Technology Drive
Orlando, Fl 32804-8068
Phone : (407) 513-6264 Fax : (407) 659-0438
E-mail : bruce.odum@cbs.fiserv.com



                    "DeLong, Eric"
                    <EDeLong@Sallybeaut        To:     
"'midrange-l@midrange.com'" <midrange-l@midrange.com>
                    y.com>                     cc:
                    Sent by:                   Fax to:
                    midrange-l-admin@mi        Subject:     RE: Help With 
SQL400 RUNSQLSTM
                    drange.com


                    10/22/2001 09:27 AM
                    Please respond to
                    midrange-l






Well, to do this in SQL, first you create your output file:

CREATE TABLE xxxxxxxx.........

Followed by:
INSERT INTO xxxxxxxxx (SELECT ...............)

Pretty easy.

Eric DeLong
Sally Beauty Company
MIS-Sr. Programmer/Analyst
940-898-7863 or ext. 1863



-----Original Message-----
From: Bruce.Odum@cbs.fiserv.com [mailto:Bruce.Odum@cbs.fiserv.com]
Sent: Monday, October 22, 2001 8:12 AM
To: midrange-l@midrange.com
Subject: Help With SQL400 RUNSQLSTM



I am trying to create a dynamic reporting eng using sql and the runsqlstm.
I was going to use query manager to do this but it has a limit of 250
columns.  Does any one know how to use the runsqlstm command and have the
result set placed in a file?






Bruce Odum
Delivery Services
2601 Technology Drive
Orlando, Fl 32804-8068
Phone : (407) 513-6264 Fax : (407) 659-0438
E-mail : bruce.odum@cbs.fiserv.com

_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
or email: MIDRANGE-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.


_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
or email: MIDRANGE-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.