Unloading specific records in a foreign key, cascade format.
Hi,We have DB2 version 8, os/390. I know how to use QMF and JCL.I would like to unload, to files, specific records that I would enter, by the key, in a where clause. The record would then cascade down to unload ALL tables, with a specified TBCREATOR name based on foreign keys. I would like the...
Answer Question
| May 13 2008 6:33 PM GMT
| asked by
Donnaw
DB2 Administration, OS/390, DB2
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
reusedlt *yes
Hi, Has reusedlt *yes behavior changed with V5R3?When I add a record to a PF that is reusedlt *yes in V5R2 is uses a record that has been deleted, however when i do the same thing on a V5R3 system it adds a new record rather than re-use one.Anyone run into this before?Thanks, Luis
View Answer
| May 23 2005 2:52 PM GMT
| asked by
xixones
Data center operations, Disaster Recovery, Security management
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
Deleting journal receivers
HI,When I try to delete a journal receiver that hasn't been saved, I get the "never fully saved" message even though I'm using DLTOPT(*IGNINQMSG) Does anyone have a piece of code that will get rid of receivers no matter what? E.G. not saved, remote, attached......Thanks
View Answer
| Jan 18 2005 11:04 AM GMT
| asked by
xixones
Hardware, Database Management Systems, DB2
Monitor Internet Bandwidth
Good day, we are using windows2000 smallbusiness server in our organisation with Exchange,Dns and Isa server configured.1. I want to monitor the internet usage by the users.2. I want to take a report on monthly or daily basis how much mb/gb utilised By Each User.Thanks for u'r reply in advance.
View Answer
| Nov 29 2004 1:55 AM GMT
| asked by
GiriPrasad
DataCenter, Data center operations, E-business
Moving spool files from one AS400 to another
I'm having a problem retaining the spool file attributes when I tranfer spool files from one ISeries to another. I can use the SNDTCPSPLF and it retains most of the attributes but does not retain the user and date/time attributes of the original spool file. Any suggestions??
View Answer
| Nov 12 2004 5:47 AM GMT
| asked by
pperry
AS/400, Hardware, DB2
