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
