Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Get the data from Flat file to QMF

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
Sudharsan24

New User


Joined: 23 Oct 2012
Posts: 4
Location: Arizona

PostPosted: Tue Oct 30, 2012 4:47 am    Post subject: Get the data from Flat file to QMF
Reply with quote

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
View user's profile Send private message

gylbharat

Active Member


Joined: 31 Jul 2009
Posts: 565
Location: Bangalore

PostPosted: Tue Oct 30, 2012 10:36 am    Post subject:
Reply with quote

Any specific reason of executing them in QMF?

Why not execute them in Batch - DSNTIAUL/DSNTEP2
Back to top
View user's profile Send private message
Gnanas N

Active Member


Joined: 06 Sep 2007
Posts: 785
Location: Chennai, India

PostPosted: Tue Oct 30, 2012 10:39 am    Post subject:
Reply with quote

From QMF Query panel, you can issue the below from the command line
Code:
IMPORT QUERY FROM 'hld.sql(s1)'
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Tue Oct 30, 2012 2:15 pm    Post subject:
Reply with quote

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
View user's profile Send private message
Marso

REXX Moderator


Joined: 13 Mar 2006
Posts: 1219
Location: Israel

PostPosted: Tue Oct 30, 2012 8:34 pm    Post subject: Re: Get the data from Flat file to QMF
Reply with quote

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... icon_eek.gif
I hope you brought a few sandwiches with you...
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Tue Oct 30, 2012 9:50 pm    Post subject:
Reply with quote

Hi Marso,

Quote:
I hope you brought a few sandwiches with you...
The phrase around here is:
"Ya better pack a lunch" icon_pray.gif

d
Back to top
View user's profile Send private message
Sudharsan24

New User


Joined: 23 Oct 2012
Posts: 4
Location: Arizona

PostPosted: Thu Nov 08, 2012 3:48 am    Post subject:
Reply with quote

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
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Thu Nov 08, 2012 4:40 am    Post subject:
Reply with quote

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
View user's profile Send private message
Sudharsan24

New User


Joined: 23 Oct 2012
Posts: 4
Location: Arizona

PostPosted: Fri Nov 09, 2012 1:30 am    Post subject:
Reply with quote

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
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Fri Nov 09, 2012 1:48 am    Post subject:
Reply with quote

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:
http://www.ibmmainframeforum.com/index.php

This may be better suited and many of the "helpers" here provide support there also.
Back to top
View user's profile Send private message
Phrzby Phil

Active Member


Joined: 31 Oct 2006
Posts: 961
Location: Richmond, Virginia

PostPosted: Fri Nov 09, 2012 6:31 pm    Post subject:
Reply with quote

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
View user's profile Send private message
Akatsukami

Global Moderator


Joined: 03 Oct 2009
Posts: 1738
Location: Bloomington, IL

PostPosted: Fri Nov 09, 2012 7:18 pm    Post subject:
Reply with quote

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 icon_wink.gif
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Is the 'prompt' data for the DSLIST p... Willy Jensen TSO/ISPF 0 Tue Dec 06, 2016 4:38 am
No new posts How to move a long alphanumeric data ... lind sh COBOL Programming 5 Mon Dec 05, 2016 7:51 pm
No new posts Add PD field from 2nd file to PD in 1st Sushant Garje DFSORT/ICETOOL 6 Thu Dec 01, 2016 4:32 pm
No new posts File Aid to File Manager conversion murali3955 IBM Tools 4 Thu Nov 24, 2016 3:41 pm
No new posts How to convert the VBM file to VB or... Sulabh Agrawal JCL & VSAM 4 Fri Nov 18, 2016 1:04 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us