Archive for the 'comp.databases.ibm-db2' Category
Just want to know if there is a sleep command I could use to slow down the process in a stored procedure. I know people would’ve asked this question. I googled it, but everyone said that they haven’t used in the stored procedures. I want to know if the sleep cannot be done directly in an SP, is there any workaround for this.
Read full story
Hello, Quoting [link] com.ibm.db2.luw.sql.ref.doc/do c/r0000935.html : Group privileges are not considered for any table or view specified in the CREATE VIEW statement. I discovered this today because a user complained that she couldn’t create a simple view referring to a table to which she had all privileges.
Read full story
I am attempting to implement, what I believe to be, an unusual scenario, and am hoping to find someone that has experience with something similar. I currently have a series of physical and logical files on an iSeries (AS/400, System i5, or whatever IBM calls it today), version v5r4, and would like to permanently migrate them to a
Read full story
Background: The Payment Card Industry (PCI) Data Security Standard (PCI DSS) is a standard for financial institutions. It requires sensitive information, such as credit card numbers, to be "unreadable anywhere it is stored" using hashing, truncation or encryption. I am looking for a simple truncation function that replaces the last
Read full story
Data Studio Developer is only distributed on Windows and Linux/Intel. This product is based on Eclipse and integrates Java code to provide the capabilities of the product. Part of the I(ntellectual) Property is from IBM so we can understand IBM charges for the capabilities. But the assembly process (wich is also know-how and IP) results only
Read full story
Please correct me if I am wrong 1. no 2 processes can have exclusive lock on same object (by object, same row or same table) 2. on deadlock incident between 2 processes only one of them will be cancelled by db2 to let the other finish. Now, can there be an instance where 2 processes have ‘EXCLUSIVE LOCK’
Read full story
DB2 V8.2 on AIX using C language applications. I have these two queries I would like to put together: "SELECT SUM(products.loc1_size) FROM products WHERE (location1 = ‘NFUSA1′) AND (main_loc IN (SELECT main_loc FROM status WHERE backordered = ‘N’)) AND (products.main_loc IN (SELECT main_loc FROM main_store WHERE location = ‘NFUSA1′ AND location IN (SELECT item from
Read full story
Hi, We have an immediate opening for one of our MNC client. The candidate should have experience in the following skills: Java, J2ee, spring, hibernate. Experience in jsf, webservices is an added advantage. Experience level: 3.8 - 8 years Location: Bangalore Plz send across your updated profile in word format along with the
Read full story
Environment is DB2/LINUX 9.5.0. I wonder if it is possible to set the MESSAGE_TEXT dynamically when using the SIGNAL statement. The objective is to return more specific information to the calling user or application. E.g. I would rather return "Unknown value 42" than just "Unknown value". The documentation says:
Read full story