how to read records from DB2 table through routines

ragunathan13 · Post by **ragunathan13** » Tue Oct 17, 2006 3:36 am

Hi to all,
Can anybody tell how to get the records from DB2 table through routines?
if possible, pls send the routine.

Advanced Thanks.
Ragunathan J.

kumar_s · Post by **kumar_s** » Tue Oct 17, 2006 3:45 am

It is very much like you execute your OS command.
You have Command line call facility avaialble in DB2.
>db2 connect to database.....
>db2 "select * from .....";
You need to wrap this command as the OS comand call.

kumar_s · Post by **kumar_s** » Tue Oct 17, 2006 3:47 am

Hi Ragunathan,
Pls delete the other duplicate post created on the Server forum.

ragunathan13 · Post by **ragunathan13** » Tue Oct 17, 2006 4:03 am

hi kumar..

actually my req. is, using routines i have to extract the records from db2 table

Regards
Ragunathan J

kumar_s · Post by **kumar_s** » Tue Oct 17, 2006 4:09 am

Are you refering to BASIC Routine?
If so Call DSExecute can be used to call OS commands. Through which you can call DB2 commands.

ragunathan13 · Post by **ragunathan13** » Tue Oct 17, 2006 5:34 am

hi kumar

yes... but i don't know how to connect with db2..

can u give some sample code for this pl...

Regards
Ragunatha J

kumar_s · Post by **kumar_s** » Tue Oct 17, 2006 6:17 am

Find the full detail of CLP here.
http://publib.boulder.ibm.com/infocente ... 010412.htm
And revert back if you still find any further issues.

ArndW · Post by **ArndW** » Tue Oct 17, 2006 6:32 am

You will need to issue a command line:

db2 connect {options}
db2 set schema {options}
db2 SELECT {blah blah, options}

chulett · Post by **chulett** » Tue Oct 17, 2006 6:52 am

ragunathan13 wrote:actually my req. is, using routines i have to extract the records from db2 table

Perhaps you could share with us why you 'need' to do this, why the requirement? Then we can tell you why you don't want to do it that way and give you an alternative or two.

ragunathan13 · Post by **ragunathan13** » Tue Oct 17, 2006 7:51 am

hi chulett

Actually my requirement is read the "jobnames" from db2 table one by one and run those jobs sequentially using routine.

Thanks and regards
Ragunathan J

chulett · Post by **chulett** » Tue Oct 17, 2006 8:07 am

Read them in a job using the DB2 stage and then use the UtilityRunJob routine (conveniently located in the sdk\Utilities branch) in a transformer.