The first time you sign into developerWorks, a profile is created for you. Select information in your developerWorks profile is displayed to the public, but you may edit the information at any time. Your first name, last name (unless you choose to hide them), and display name will accompany the content that you post.

All information submitted is secure.

The first time you sign in to developerWorks, a profile is created for you, so you need to choose a display name. Your display name accompanies the content you post on developerworks.

Please choose a display name between 3-31 characters. Your display name must be unique in the developerWorks community and should not be your email address for privacy reasons.

All information submitted is secure.

My developerWorks:

My notifications:

Sign out

Select a language:

More scripting with DB2 UDB for Windows

Chris Fierros, DB2 Solutions Expert and principal consultant, Ten Digit Consulting

Chris Fierros is a DB2 Solutions Expert and principal consultant at Ten Digit Consulting, Inc. (www.tendigit.com), specializing in consulting, training, and support services for DB2 Universal Database. Chris began his career with DB2 on distributed platforms in 1991 at IBM Corporation and has since published articles, presented at conferences, delivered training, and written books about DB2 UDB. Chris is an IBM Certified Solutions Expert (ICSE) in DB2 UDB Administration and DB2 UDB Development as well as an IBM Certified Advanced Technical Expert (CATE) in DB2 Clustering, DB2 Replication, and DB2 Connect. You can reach him at chris at tendigit.com.

Summary: This article is the third in a series of articles covering the topic of IBM DB2 Universal Database (UDB) and Windows scripting. In this article we continue to explore in detail more scripting options including Object REXX and PerlScript with Windows Script Host (WSH) and DB2 UDB V8 for Windows.

Tag this!

Date: 03 Jun 2004
Level: Introductory

Activity: 4944 views
Comments:

Important: Read the disclaimer before reading this article.

Introduction

The first article of this series on IBM® DB2® Universal Database™ (UDB) and Windows® scripting, An Introduction to DB2 UDB Scripting on Windows, shows you how to combine DB2 commands, DB2 system commands, and operating system commands using Windows shell scripts to automate many of the administrative, operational, and maintenance tasks required to properly support a DB2 UDB for Windows systems.

In the second article in this series, DB2 UDB Scripting with Windows Script Host (WSH), we continued our exploration of scripting with DB2 UDB for Windows by covering some more advanced scripting techniques using Jscript and VBScript, the two native Windows Script languages, in the Windows Script Host (WSH) environment.

In this third article, we continue where we left off in the second article. This article shows you how to develop scripts with IBM® Object REXX and ActiveState?s ActivePerl and PerlScript. We explore some practical scripting examples using these scripting languages, including the use of the WSH environment.

Topics covered include:

Scripting with ActivePerl
Perl Database Interface (DBI)
DB2 PerlScript and WSH Scripts
Scripting with Object REXX
Installing Object REXX
DB2 REXX Interfaces
DB2 Object REXX and WSH Scripts

Disclaimer

This article contains sample code. IBM grants you ("Licensee") a non-exclusive, royalty free, license to use this sample code. However, the sample code is provided as-is and without any warranties, whether EXPRESS OR IMPLIED, INCLUDING ANY IMPLIED WARRANTY OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE OR NON-INFRINGEMENT. IBM AND ITS LICENSORS SHALL NOT BE LIABLE FOR ANY DAMAGES SUFFERED BY LICENSEE THAT RESULT FROM YOUR USE OF THE SOFTWARE. IN NO EVENT WILL IBM OR ITS LICENSORS BE LIABLE FOR ANY LOST REVENUE, PROFIT OR DATA, OR FOR DIRECT, INDIRECT, SPECIAL, CONSEQUENTIAL, INCIDENTAL OR PUNITIVE DAMAGES, HOWEVER CAUSED AND REGARDLESS OF THE THEORY OF LIABILITY, ARISING OUT OF THE USE OF OR INABILITY TO USE SOFTWARE, EVEN IF IBM HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES.

Downloads

Description	Name	Size	Download method
practical scripting examples	listings.zip	10 KB	FTP \| HTTP
More scripting with DB2 UDB for Windows	dm-0406fierros.pdf	141 KB	FTP \|HTTP

Information about download methods Get Adobe® Reader®

About the author

Close [x]

Report abuse help

Report abuse

Thank you. This entry has been flagged for moderator attention.

Close [x]

Report abuse help

Report abuse

Report abuse submission failed. Please try again later.

Close [x]

developerWorks: Sign in

The first time you sign into developerWorks, a profile is created for you. Select information in your developerWorks profile is displayed to the public, but you may edit the information at any time. Your first name, last name (unless you choose to hide them), and display name will accompany the content that you post.

All information submitted is secure.

Close [x]

Choose your display name

The first time you sign in to developerWorks, a profile is created for you, so you need to choose a display name. Your display name accompanies the content you post on developerWorks.

Please choose a display name between 3-31 characters. Your display name must be unique in the developerWorks community and should not be your email address for privacy reasons.

All information submitted is secure.

Rate this article

Comments

Close [x]

Help: Update or add to My dW interests

What's this?

This little timesaver lets you update your My developerWorks profile with just one click! The general subject of this content (AIX and UNIX, Information Management, Lotus, Rational, Tivoli, WebSphere, Java, Linux, Open source, SOA and Web services, Web development, or XML) will be added to the interests section of your profile, if it's not there already. You only need to be logged in to My developerWorks.

And what's the point of adding your interests to your profile? That's how you find other users with the same interests as yours, and see what they're reading and contributing to the community. Your interests also help us recommend relevant developerWorks content to you.

View your My developerWorks profile

Return from help

Close [x]

Help: Remove from My dW interests

What's this?

Removing this interest does not alter your profile, but rather removes this piece of content from a list of all content for which you've indicated interest. In a future enhancement to My developerWorks, you'll be able to see a record of that content.

View your My developerWorks profile

Return from help

static.content.url=http://www.ibm.com/developerworks/js/artrating/

SITE_ID=1

Zone=Information Management

ArticleID=86623

ArticleTitle=More scripting with DB2 UDB for Windows

publish-date=06032004

author1-email=chris@tendigit.com

author1-email-cc=