Ibm db2 udb


 
Thread Tools Search this Thread
Operating Systems AIX Ibm db2 udb
# 1  
Old 06-04-2009
Ibm db2 udb

Am trying to export the content of Stored Procedure to a file using GET ROUTINE command. After executing the command first few lines of the file contains ASCII characters though i have original text following that.
Any help is appreciated.
Login or Register to Ask a Question

Previous Thread | Next Thread

8 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Read a input file and insert it to UDB sequentially

Guys, I'm very new to Unix script. I need to add some logics into the existing script. Read a record 1) if it's a header record then verify the file sequence no aginst the file sequence no in UDB control table. 2) if Step 1 is ok then CONNECT UDB otherwise stop or abend. 3) if... (0 Replies)
Discussion started by: Sunny TK Sun
0 Replies

2. Shell Programming and Scripting

Unix Korn Shell script on Solaris to DB2 UDB LUW database

I am rather new to korn shell scripting and attempting to write a Unix script that would detach, attach a range partition table in DB2 UDB LUW database. This would be a job scheduled in control M that reads in an input file with 5 parameters passed to it from the application. I don't have much... (1 Reply)
Discussion started by: tjhanso
1 Replies

3. AIX

IBM DB2 Product Suite

Can anyone have any idea on IBM DB2 Product suite??? (4 Replies)
Discussion started by: dinesh1985
4 Replies

4. Programming

Acceessing DB2 UDB in AIX COBOL on unix

Hi , We are migrating our database from DB2 z/os to DB2 UDB on UNIX. and cobol on mainframes to AIX cobol on UNIX. We have some cobol Db2 programs that are accessing different Databases how do we code such type of programs in AIX cobol. Do we need to Establish connection for accessing... (0 Replies)
Discussion started by: nal.satish
0 Replies

5. UNIX and Linux Applications

How to install IBM db2 database server in cygwin ??

Hi folks, I am looking for a clue to install db2 in cygwin.....kindly help.;) (0 Replies)
Discussion started by: frozensmilz
0 Replies

6. AIX

UDB 9.5 upgrade from 8.2 on AIX 5.3

We are going from UDB DPF 8.2 to 9.5 and changing HW from P4+ to P6 and moving from 5.2 to 5.3. Anyone out there gone through this upgrade? Any words of wisdom, warnings, or other gotchas you could pass on. TIA. ART (0 Replies)
Discussion started by: ArtF
0 Replies

7. AIX

IBM DB2 UDB to SQL Server 2005 Porting

Hi All, Am porting my application from AIX to Windows. As a part of this I need to port the Database in IBM DB2 UDB to SQL Server 2005. Is there any Guide/Doc/Article available on this? How to convert the stored procedures and physical data from DB2 to SQL Server 2005? Thanks in Advance (0 Replies)
Discussion started by: mvictorvijayan
0 Replies

8. UNIX for Dummies Questions & Answers

Exception while loading DB2 driver Class.forName("com.ibm.db2.jcc.DB2Driver")

Hi... I m working on UNIX z/OS. Actually i have to pass the parameters from the JCL to java-db2 program thru PARM. I am able to pass the arguments but the problem occured is, it is throwing an exception while loading the db2 driver as 'Javaclassnotfound:com.ibm.db2.jcc.DB2Driver'... (0 Replies)
Discussion started by: Sujatha Gowda
0 Replies
Login or Register to Ask a Question
SQL::ReservedWords::DB2(3pm)				User Contributed Perl Documentation			      SQL::ReservedWords::DB2(3pm)

NAME
SQL::ReservedWords::DB2 - Reserved SQL words by DB2 SYNOPSIS
if ( SQL::ReservedWords::DB2->is_reserved( $word ) ) { print "$word is a reserved DB2 word!"; } DESCRIPTION
Determine if words are reserved by DB2. METHODS
is_reserved( $word ) Returns a boolean indicating if $word is reserved by either DB2 5, 6, 7 or 8. is_reserved_by_db2v5( $word ) Returns a boolean indicating if $word is reserved by DB2 5. is_reserved_by_db2v6( $word ) Returns a boolean indicating if $word is reserved by DB2 6. is_reserved_by_db2v7( $word ) Returns a boolean indicating if $word is reserved by DB2 7. is_reserved_by_db2v8( $word ) Returns a boolean indicating if $word is reserved by DB2 8. reserved_by( $word ) Returns a list with DB2 versions that reserves $word. words Returns a list with all reserved words. EXPORTS
Nothing by default. Following subroutines can be exported: is_reserved is_reserved_by_db2v5 is_reserved_by_db2v6 is_reserved_by_db2v7 is_reserved_by_db2v8 reserved_by words SEE ALSO
SQL::ReservedWords <http://www-306.ibm.com/software/data/db2/udb/> AUTHOR
Christian Hansen "chansen@cpan.org" COPYRIGHT
This program is free software, you can redistribute it and/or modify it under the same terms as Perl itself. perl v5.8.8 2008-03-28 SQL::ReservedWords::DB2(3pm)