Questions & Answers
Active Directory, AS/400, Business Intelligence, Career Development, CIO, Database, DataCenter, Development, Hardware, IBM DB2, IBM iSeries, IT Strategy, Linux, Lotus Domino, Lotus Notes, Management, Marketing, Marketing Technology, 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, Oracle, OS, 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
Would there be a way to make an Oracle SQL query behave like it contains a MySQL limit clause? So, for example, here's what I can do in MySQL: select * from sometable order by name limit 20,10 This allows me to get the 21st to the 30th rows (meaning skip the first 20, give the next 10). The rows...
I'm trying to extract several queries to a CSV output format. The only problem is that I can't use SQL Client or Oracle. I need to use SQL Plus. How can I do it?
In Oracle, I realize that the default behavior of LIKE and other comparison operators are case-sensitive. Does anyone know if there's a way to make them case-insensitive? Appreciate the help
I have not used an AS/400 in 18 years. I can start SEU but can't seem to remember what to do next. How do I insert lines of code?
I want to design a VOIP network for a university, then show the effect of the several security mechanism on QOS , I use OPNET for this purpose, but I want to know what to design in any scenario ,who can guide me for what to add in any scenario , if I have a VOIP network without any security...
Please give me an example of building an xml with multiple child nodes, in java. I want something like : <Parent> <Child1>something</Child1> <Child2>something else</Child2> </Parent> Now, the values for Child1 and Child2 must be picked using SQL from AS400....
I want to install Oracle Developer forms 11g Release 2 and connect the forms and reports to Oracle 9i Enterprise Edition Release 184.108.40.206.1 – Production. Can you give me the step-by-step to make installation and the connection to my local server in the local network? Best Regards, Jamil...
We have a huge problem with our SQL statement in Oracle. We're trying to select the TOP 10 records that are ordered by STORAGE_DB (which aren't in a list from another SELECT statement). This code works fine for all records: SELECT DISTINCT APP_ID, NAME, STORAGE_GB, HISTORY_CREATED,...
I have a report with several subreports linked, and need to suppress the subreports based on different information for each subreport based on the data in one of the subreports.
Using ESEND function. Getting EML0023 message.
I am trying to FTP a spreadsheet to a local server but I can't seem to get the put CLLE right. Can you help?
I would like to connect to AS/400 DB from .Net 3.5. Can anybody help me with this?
I've been trying to find out if there are uncommitted INSERT, UPDATE or DELETE statements in my current session. I know one way would be is to check the v$lock with the current SID but that means I need read access to v$lock. That's a problem since my DBA doesn't want to grant me that. Is there...
In load all subfile i'm loading 100 records and displaying 10 records per page in the screen(i.e, SLFSIZE=100,SLFPAGE=10). But I need to display records from 3rd page onwards..how to do that, can I use SFLRCDNUM in DSPF. Please help me.
Hi, How can we create a single domain admin account for 7 different domino domains in a lotus environment?
What is the fix on Oracle TNS Listener Remote Poisoning?
I want to read a file 2 times in CLLE.When I'm using POSDBF to read a file in 2nd time, I got the error. Please look into the below code and help me guys. PGM DCLF FILE(CHOW12011/EXAM) OPNID(A) READ: RCVF RCDFMT(EXAMR) OPNID(A) MONMSG MSGID(CPF0864)...
Hi, I want to get detailed information about Bitcoin and how is it being misused in today's time. Please help me out with some references. Thanks and regards Ashish@S
In one of my fields, I don't need to store a datetime pair (basically not the standard Oracle date). Just like this: 01/10/2009 22:10:39 I only need the time specifically. 22:10:39 Since I have two million records, I think this will help provide faster processing. Thanks!
Two days back, I have received an email with PDF file attachment. When I tried to open PDF file, it shows an error message which says: "format error: not a PDF or corrupted" I was surprised to see such error message and thought hope it was not a virus file as attached PDF. Immediately I have called...