Table View SQL statement

I am new to DB2 so i don't know my question is correct. I would like a simple task to be performed which is to get the sql statement I have created few months back. I forgot the actual code so I am planning to get it back lor.Besides this, I have another small request. Is there any place that I can start off reading DB2 tutorial for newbies like me. Thanks alot

Apr 16 '07 #1

Subscribe Post Reply

1277

kalexin

I am new to DB2 so i don't know my question is correct. I would like a simple task to be performed which is to get the sql statement I have created few months back. I forgot the actual code so I am planning to get it back lor.Besides this, I have another small request. Is there any place that I can start off reading DB2 tutorial for newbies like me. Thanks alot

Here's a good place to get started assuming you are using DB2 LUW (linux, unix and windows) edition.
http://www-1.ibm.com/support/docview.wss?rs=71&uid=swg21255600

What do you mean that you want to get the SQL statement back? Did you execute the statement against a database?

Apr 16 '07 #2

Similar topics

How to do a <table> with <div> tag

by: Toby Austin | last post by:

I'm trying to replace <table>s with <div>s as much as possible. However, I can't figure out how to do the following… <table> <tr> <td valign="top" width="100%">some data that will...

HTML / CSS

RETURNS TABLE in DB2

by: purushneel | last post by:

Hi, I have a following issue in DB2 UDB v8.2. How can I build some data and store it in a temp table and return as a TABLE to a function.. This function will be called in a SELECT stmt....

DB2 Database

Error inserting into iSeries DB2 table with long name via SQL Server 2000 linked Server

by: Charles Wilt | last post by:

I have a IBM iSeries (aka AS-400) running v5r3 of OS/400 that I access via a linked server from SQL Server 2000. The following select works fine: select * from...

DB2 Database

How to ALTER a table using the ALTOBJ procedure

by: Serge Rielau | last post by:

Hi all, Following Ian's passionate postings on problems with ALTOBJ and the alter table wizard in the control center I'll try to explain how to use ALTOBJ with this thread. I'm not going to get...

DB2 Database

Column order/presentation in virtual table (result set from viewor UDF)

by: Beowulf | last post by:

I was just messing around with some ad hoc views and table returning UDFs today so I could look at and print out data from a small table and noticed something strange. If I stick my select...

Microsoft SQL Server

One-click Importing Excel Data into a*Database

by: ryjfgjl | last post by:

In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...

Microsoft Excel

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware