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
 

 

DB2 Unload -Parameter + Version

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

New User


Joined: 05 Dec 2006
Posts: 89
Location: chennai

PostPosted: Mon Jul 06, 2009 11:38 am    Post subject: DB2 Unload -Parameter + Version
Reply with quote

Hi All,

I have 2 doubts regarding DB2 Unload Utility.

1)In My production,we are using below version

INZU224I IBM DB2 HIGH PERFORMANCE UNLOAD V2.2
INZU219I PTFLEVEL=PK17548-Z206

But in Development we are using latest one i guess

INZU224I IBM DB2 HIGH PERFORMANCE UNLOAD V2.2
INZU219I PTFLEVEL=PK38404-Z256

could you please tell me what is INZU219I PTFLEVEL=? how can i chk that..


2)My second doubt is

While unloading DB2 table,below parameter is used

FORMAT VARAIBLE END

what is the meaning for format variable end?


Thanks
Jagadesh
Back to top
View user's profile Send private message

Anuj Dhawan

Senior Member


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

PostPosted: Mon Jul 06, 2009 12:10 pm    Post subject:
Reply with quote

Try your luck in these PDFs:

http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=/com.ibm.db2tools.inz.doc.ug/inzhome.htm

http://www.google.co.in/search?hl=en&q=FORMAT+VARAIBLE+END+in+INZU224I+&meta=&aq=f&oq=
Back to top
View user's profile Send private message
itjagadesh

New User


Joined: 05 Dec 2006
Posts: 89
Location: chennai

PostPosted: Mon Jul 06, 2009 4:43 pm    Post subject: Reply to: DB2 Unload -Parameter + Version
Reply with quote

Thanks Anuj for your Link provided.
But still i am not able to get infomation about.

"FORMAT VARIABLE END"
I am not sure of the use of above while unloading DB2 tables.
Can anyone give me explanation about the above parameter.

Thanks
Jagadesh
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


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

PostPosted: Mon Jul 06, 2009 4:54 pm    Post subject:
Reply with quote

part of joining this community is attempting to do something on your part.

use the first link that Anuj gave you.

enter FORMAT VARIABLE END (and not FORMAT VARAIBLE END] in the search box
(left side of page)
and click on 'GO'.
now, start looking at the links provided.
Suggest you right click and open in a new tab
instead of just clicking on the link.
that way you will always have your search results.
Back to top
View user's profile Send private message
itjagadesh

New User


Joined: 05 Dec 2006
Posts: 89
Location: chennai

PostPosted: Mon Jul 06, 2009 9:46 pm    Post subject: Reply to: DB2 Unload -Parameter + Version
Reply with quote

Hi Dick Brenholtz ,

I tried in that document.But not able to find proper definition of
"FORMAT VARIABLE END" parameter in DB2 Unload.(Given some example with that parameter..thats it)

Could anyone please tell me what will heppen if we specify above parameter along with Unload.

Thanks
Jagades
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: Mon Jul 06, 2009 10:06 pm    Post subject:
Reply with quote

Hello,

Quote:
I tried in that document.But not able to find proper definition of "FORMAT VARIABLE END" parameter in DB2 Unload

If you use the parameter correctly, only 8 results are returned. Each one has "some example". . .
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 DDNAME parameter mistah kurtz JCL & VSAM 6 Mon Dec 19, 2016 4:41 pm
No new posts Execessive parameter issue Sumeendar JCL & VSAM 5 Mon Dec 19, 2016 4:35 pm
No new posts TOT & DATE parameter in ICEMAN hemanthj642 DFSORT/ICETOOL 4 Mon Nov 14, 2016 5:19 am
No new posts COBOL Version 6.1 Virendra Shambharkar COBOL Programming 5 Tue Nov 01, 2016 11:24 am
No new posts How to display value of an exit param... lind sh CICS 2 Sun Oct 09, 2016 12:28 pm


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