|
View previous topic :: View next topic
|
| Author |
Message |
Sudharsan24
New User
Joined: 23 Oct 2012
Posts: 4
Location: Arizona
|
|
|
|
Hi,
I am new user to IBM mainframes. I have around 100,000 select query in a flat file and I am trying to execute those query using QMF. Could anyone help me out in getting the query from flat file to QMF. I remember there is some query which will get the data from Flat file to QMF.
Thanks In Advance. |
|
| Back to top |
|
 |
gylbharat
Active Member
.jpg)
Joined: 31 Jul 2009
Posts: 565
Location: Bangalore
|
|
|
|
Any specific reason of executing them in QMF?
Why not execute them in Batch - DSNTIAUL/DSNTEP2 |
|
| Back to top |
|
|
Gnanas N
Active Member
Joined: 06 Sep 2007
Posts: 792
Location: Chennai, India
|
|
|
|
From QMF Query panel, you can issue the below from the command line
| Code: |
| IMPORT QUERY FROM 'hld.sql(s1)' |
|
|
| Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India
|
|
|
|
| Or once you're in QMF, on command line key-in ED (edit) and press enter key -- you will be in "QMF EDIT" panel, which is an ISPF edit panel with all the facilities of cut/paste for you... |
|
| Back to top |
|
|
Marso
REXX Moderator
Joined: 13 Mar 2006
Posts: 1353
Location: Israel
|
|
|
|
| Sudharsan24 wrote: |
| I have around 100,000 select query in a flat file and I am trying to execute those query using QMF. |
At the rate of one select query per second, it will take you over 27 hours to finish your work... 
I hope you brought a few sandwiches with you... |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hi Marso,
| Quote: |
| I hope you brought a few sandwiches with you... |
The phrase around here is:
"Ya better pack a lunch" 
d |
|
| Back to top |
|
|
Sudharsan24
New User
Joined: 23 Oct 2012
Posts: 4
Location: Arizona
|
|
|
|
gylbharat
we tried the DSNTEP2 but it doesnt execute the whole query before that the job has been canceled by operator.
Gnanas N and Anuj, Thank you for your suggestion it works for me. |
|
| Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne
|
|
|
|
| Sudharsan24 wrote: |
gylbharat
we tried the DSNTEP2 but it doesnt execute the whole query before that the job has been canceled by operator.
Gnanas N and Anuj, Thank you for your suggestion it works for me. |
and the job class that you used was for 20 seconds,
what do you expect?
hey, sorry, you actually have to know 3 or 4 things
before you can do something on the mainframe.
but glad the qmf option worked.
actually that is better.
it appears that you know very little about your environment or tools available,
so it is better that your terminal be locked up for long periods of time
doing interactive stuff,
instead of letting you loose on the mainframe via batch jobs. |
|
| Back to top |
|
|
Sudharsan24
New User
Joined: 23 Oct 2012
Posts: 4
Location: Arizona
|
|
|
|
You are right Dick, I have just started working on this new application, This is a new environments for me. I guess it will take time for me to get to know abt the environments.
Thank You,
M.Sudharsan. |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello,
| Quote: |
| This is a new environments for me. I guess it will take time for me to get to know abt the environments. |
Yes, it will - but is time well-invested.
When you get stuck, someone should be here. Suggest you might look at our Student and Fresher forum:
www.ibmmainframeforum.com/index.php
This may be better suited and many of the "helpers" here provide support there also. |
|
| Back to top |
|
|
Phrzby Phil
Senior Member
Joined: 31 Oct 2006
Posts: 1042
Location: Richmond, Virginia
|
|
|
|
| Quote: |
| Suggest you might look at our Student and Fresher forum |
The student forum also disallows George Carlin's seven words from responders. |
|
| Back to top |
|
|
Akatsukami
Global Moderator
Joined: 03 Oct 2009
Posts: 1788
Location: Bloomington, IL
|
|
|
|
| Phrzby Phil wrote: |
| Quote: |
| Suggest you might look at our Student and Fresher forum |
The student forum also disallows George Carlin's seven words from responders. |
My vocabulary is larger than that  |
|
| Back to top |
|
|
|
|
