Recent IT Questions

1 - 6 of 6
<<PREVIOUS 1 NEXT>>

Tables in DB2 z/OS

In which dataset will I be able to find the default tables of DB2 V9 in Z OS

View Answer   |  May 5 2009  4:28 AM GMT
DB2 Everyplace, z/OS, Mainframe Datasets
asked by KarishmaKapoor

  20 pts.

Add to Excel spreadsheet from System i

I want to add data from a DB2 file to an Excel template that has a header row and totals certain columns without overwriting the header row or the totals.

View Answer   |  Apr 10 2008  2:41 PM GMT
DB2 Everyplace, System i, Microsoft Excel
asked by Ljjk122

  5 pts.

Dynamic sql with delete and commit

Hi, I need to delete rows from different db2 tables in COBOL with commit in between after some 100 or 200 rows. Is there any away I can restrict my delete statement for some particular rows as in Select for fetch first 100 rows only. The values of table names will be known only during the...

View Answer   |  Jul 6 2005  11:18 AM GMT
DB2, DB2 administration, DB2 Everyplace
asked by sramki

  0 pts.

Changing the statement heap parameter on iSeries

Hi, I would like to know how to change the statement heap parameter DB2 (stmtheap) on the AS/400. I tried the command GET DATABASE CONFIGURATION FOR database-alias (giving alias name as the AS/400 server name) but it returns the error "SQL0901N The SQL statement failed because of a non-severe...

View Answer   |  Jun 8 2005  6:10 AM GMT
Tech support, Third-party services, Hardware
asked by sbkhole

  0 pts.

Inserting data into a vargraphic data type field

How to insert data into a vargraphic data type field. I have done the following CREATE TABLE TEST_TABLE (FLD1 VARGRAPHIC(20)) This is done succesfully INSERT INTO TEST_TABLE VALUES('TEST') This gives a SQL error Please let me know how I can acheive it.

View Answer   |  Apr 28 2005  9:44 AM GMT
Tech support, Help Desk, Third-party services
asked by sbkhole

  0 pts.

Stored Procedure Error

This is mu stored Procedure: CREATE PROCEDURE ADMINISTRATOR.DIMS_SP_PerformSearch ( vuserId integer, vsearchText varchar(500) , vfromID integer, voption integer ) ------------------------------------------------------------------------ -- SQL Stored Procedure...

View Answer   |  Dec 17 2004  2:20 AM GMT
Migration, IBM, Servers
asked by jsbaig

  0 pts.

1 - 6 of 6
<<PREVIOUS 1 NEXT>>