This week’s free IT book is Phil Simon’s Why New Systems Fail: An Insider’s Guide to Successful IT Projects. Simon provides the necessary framework to “minimize the chance of system failure before, during, and after beginning IT projects.” Win this book for some real-world and specific tips, tools and insight. You know the rules: Answer [...]
All of our ~150 remote offices use a generic mailbox in addition to the local staff mailboxes. Due to a conflict with our new single sign-on product, the site staff are unable to access the generic mailbox. So we are creating a dedicated dynamic distribution list for each office, and the generic mail will be [...]
I have a question, i create drop and create a table in pl/sql proc using execute immediate. Later I declare a ref cursor, to process data from table created. Problem is the procedure executes correctly, but after execution procedure becomes invalid. How can i solve this issue. Thanks in advance.
I have created index. It shows Type as *FILE and Attribute as LF.But i am unable to view the data. how do i view index’s data?
I have created sequence using CREATE SEQUENCE command. Then i have noticed that one data area is created in the same name. what is the actual purpose of sequence?
I have created table using CREATE TABLE Command. I want to see the source of Table. Is there possiblity to view the TABLE’s Source in AS400
What is the difference between DDL and DDS. How to use DDL in AS400
We have an existing COBOL application using files defined in DDS format. We are considering to move from DDS to DDL for future development. What is the best strategy to take this approach?





