DB2 Administration

DECFLOAT - Internal Format

Hello, How to translate an internal DECFLOAT value into a visual format? DB2 Administration Guide: "Convert and return a DECFLOAT representation of a number or string representation of a number", (Appendix A. Writing exit routines). There is an example there: Internal...

Trigger for DB2 user administration

Hi guys.... Please help me.... I want to create trigger to avoid users updating records or when he update that data want to write one log file with his Login ID, time, date etc. please help me. If these is possible using trigger then pls tell me how ? Thanks Amar

How to limit the number of application connections in DB2?

I want to limit the number of application connections to 1 in DB2 server. And try connecting with 2 applications to check the behavior?

Granting and Revoking DB2 authority

We've had several requests to grant 'temporary' SELECT authority on a table (meaning they want the user to have the authority for today, and not tomorrow). The DBAs don't want the housework of remembering to revoke the authority tomorrow, so we were wondering if anyone knows a way to grant...

AS400 ODBC

Hi Our company uses AS400 for our financial processing application. The users access the AS400 through an emulator. They also access the application database through ODBC. They extract the data to excel sheets to create certain reports for their own purpose. Recently, one the data base files in...

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

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

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

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

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.

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

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.

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