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
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 |
|
|
|