Questions & Answers
Active Directory, AS/400, Backup, Business Intelligence, Career Development, CIO, CRM, Data Management, Database, DataCenter, Development, Hardware, IBM DB2, IBM iSeries, IT Strategy, Linux, Lotus Domino, Lotus Notes, Microsoft Access, Microsoft Excel, Microsoft Exchange, Microsoft Exchange 2003, Microsoft Exchange 2007, Microsoft Outlook, Microsoft Outlook 2003, Microsoft Outlook 2007, Microsoft Windows, Microsoft Windows 7, Microsoft Windows Server 2003, Microsoft Windows XP, Mobile, Networking, NPfIT, Oracle, Routers, RPG, RPGLE, SAP, Security, Servers, SQL, SQL Server, SQL Server 2005, Storage, Virtualization, Visual Basic, VoIP, VPN, Windows Server, Windows Server 2008 ...VIEW ALL TAGS
- Business Intelligence
- Career Development
- Cloud Computing
- Content Management
- Data Management
- Desktop Management
- Email Administration
- IT Strategy
- Lotus Domino
- Microsoft Exchange
- Microsoft Windows
Sir I am stuck in a logic. I have dynamic tables. Let's say one large data Big_Table is stamped with profile 1,2,3,....n So I create table profile1, profile2,... profilen (example profile1 :- select * from Big_Table where rule = profile1) table data example :- table_profile1 transaction_id profile...
How do I list all jobs in iSeries JobScheduler?
Does anyone know if I'm able to see the definition of a view in DB2? Is there a SQL query I can use? I already tried this code: SELECT * FROM SYSCAT.VIEWS But I'm getting an error message saying it's an undefined name. What can I do?
Why would ost files be created if the cache mode is off for outlook 2007?
Is it possible to manipulate a RPG program of one vendor to make it compatible with another RPG vendor?
Hi All, I am new to CL/400, please help me to understand it. Below is the simple CL program. PGM DCL VAR(&A) TYPE(*DEC) LEN(4 0) VALUE(10) DCL VAR(&B) TYPE(*DEC) LEN(4 0) VALUE(20) DCL VAR(&C) TYPE(*DEC) LEN(4 0) DCL VAR(&D) TYPE(*CHAR) LEN(6) CHGVAR VAR(&C) VALUE(&A +...
Which is the best testing tool for project based on insurance? And How?
I believe I have found a bug in the way that RPGLE handles primary and secondary files with no match fields. My program will not process the primary file if there are no records in the secondary file; but it will process the secondary file, if there are no records in the primary file. RPG bug?
I'm fairly new to DB2 - been working on for the past few months. I just installed DB2 on my local machine and I'm trying to run my queries through the terminal. This is a Linux machine. Whenever I try to run any queries, I keep getting this error message: SQL1092N "ROOT" does not have the authority...
I have a corrupted Word 2010 and 2013 file that I want to recover damaged Word file. I have tried several online freeware programs without success. I was unable to use the repair/recover feature in MS Word, issue with my computer finding the file on the network (using work computer). Any...
I'm trying to test my connection to my DB2 database. Usually with my Oracle databases, I would just run 'SELECT' from dual but I know that's for Oracle only. How can I do this for DB2? Is there a specific SQL statement?
My phone has been stolen. How can I track / search for it?
I have an IBM Thinkpad 390x with windows 2000 installed after the updates it now is locked will not boot asking for a password has an icon of a computer next to a icon of a lock can not boot to floppy or cd and will not let me in the bios
Hello, does anyone know how to or what program I need to convert an excel file to a SIF file?
How does cyber security affect international politics?
I failed to locate DPMI server while running DOSBox. What can I do?
What are the differences between SAP & ERP? Is it convenient for the user of ERP to use SAP?
I need to access several Oracle tables and copy them into DB2. What's the best way to do that? Thanks so much.
Inside of DB2, I'm trying to rename one of my tables. But I keep getting this error message: the name "mytable" has the wrong number of qualifiers.. SQLCODE=-108,SQLSTATE=42601 What should I do? How can I fix it.
Hello everyone, I'm trying to figure out if a certain table exists in DB2. And if that table does, how can I drop it? Thank you.