MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Doubt in QMF EXPORT

 
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Database
View previous topic :: View next topic  
Author Message
Mouriyan
Beginner


Joined: 07 Nov 2005
Posts: 3
Topics: 2

PostPosted: Mon Nov 14, 2005 10:06 am    Post subject: Doubt in QMF EXPORT Reply with quote

Hi all,


While we are exporting QMF report to a dataset, we see some
numbers like

"H QMF 13 R 01 E V W E R 02 03 05/11/14 09:01
V 1001 006 PERIOD
V 1002 003 016
T 1010 022 006 1013 005 1014 006 1015 006 1016 006 1017 006 1012 008
R C 000001 000003 000018 000001
R TD 000019 000021 000030 000001
R L 000031 000033 000038 000001
R L 000039 000041 000047 000001 "

before the data we wanted.Do they convey any meaning ?
Plz explain.

Thanks,
Mouriyan
Back to top
View user's profile Send private message
Ravi
Beginner


Joined: 27 Jun 2005
Posts: 88
Topics: 2

PostPosted: Mon Nov 14, 2005 12:22 pm    Post subject: Reply with quote

I don't know what exactly you tried to Export using QMF.

But as far as I know if you Export a Query resultset/Report(F12) then The first line will say the Header Information of the QMF and the version you are using, the data and time it was created(H in the first column).
The second row says that your report is having some N no. of columns.(T in the first column)
From the 3rd row it will display the Columns and its length and what type they are. (C in the first column)
384 --> Date column (yyyy-mm-dd).
452 --> Char it also gives the length.
496 --> Integer
500 --> Small Int

Then starts the Data column. (D in the first column).

I was analysing the output of the below.

Quote:
HIXF0000QMF V6R1M02005060701220800025N -->QMF Version and date the datatime was exported.
T18 DB2 CCI00007 --> 07 represents the column count
C07DATE_COL NYNR38400000 000002 00
C05INT_1_COL NYNR49600000 000013 00
C14INT_2_COL NYNR49600000 000025 00
C05CHAT_1_COL YYNR45200000 00008000036 00
C06CHAR_2_COL NYNR45200000 00001000046 00
C17SMALL_INT_1 NYNR50000000 000048 00
C07INT_3_COL NYNR49600000 000055 00
D 2005-05-27 0000200650 0000000040 SR N 00720 0000101515
D 2005-05-27 0000210771 0000000058 CS N 01500 0000101518

Hope this helps.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Database All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group