Recent IT Questions

1 - 5 of 5
<<PREVIOUS 1 NEXT>>

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   |  asked by Ljjk122
Excel, DB2 Everyplace, System i


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 execution...

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


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   |  asked by sbkhole
DataCenter, Data center operations, Physical security


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 succesfullyINSERT 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   |  asked by sbkhole
DataCenter, Data center operations, IT architecture


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...

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


1 - 5 of 5
<<PREVIOUS 1 NEXT>>