how to unload a DB2 table

karthik3883 · New User Joined: 19 Oct 2007 Posts: 16 Location: chennai

Hi,

I have a query i want to unload the DB2 table in to a sequential file in that i want to see the first 100 records only,Could anyone tell me how to do that as am new to DB2

Thanks in Advance

Karthik

murmohk1 · Posted: Thu Dec 27, 2007 1:52 pm Post subject:

Karthik,

Discussed earlier. Search the forum.

ksk · Posted: Thu Dec 27, 2007 4:36 pm Post subject:

Hi karthik,

write a Select query to extract data from DB2 table and move those values into file variables.

Hope you understood.

KSk

Anuj D. · Posted: Thu Dec 27, 2007 4:56 pm Post subject:

Hi Karthik,

As suggested you can search the forum on the key word "Unload Table", hopefully you will get some good hits. There can be many methods, if you would like to use JCL, below code can be handy.

sachin_kaushik84 · New User Joined: 03 Oct 2008 Posts: 18 Location: noida

//SYSTSIN DD *
DSN SYSTEM(DB2D)
RUN PROGRAM(DSNTIAUL) PLAN(DSNTIAUL) -
PARM('SQL')

hi anuj one short question to be asked here in this jcl the program name and a plan name mentioned here is system defined program or we have to give here the actual program name and a plan name whare a logic is written to perform some conditions.

Anuj D. · Posted: Fri Oct 17, 2008 2:20 am Post subject:

Hi,

DSNTIAUL example program is well documented (with example) in the fine manual.