how to update an entire column of an table by an subquery in an update statement.and that subquery is returning multiple rows
Answer Question | May 22, 2012 11:28 AM
Oracle Query, Oracle SQL
After listening to the podcast it suggested that if you are running sharepoint and exchange on separate servers you need to install SMTP!? Well from my point of view you don’t. You just need to set the server name to your exchange server that is smtp enabled, and doing anything with SMTP Server / Service [...]
Answer Question | May 22, 2012 11:10 AM
Exchange 2003, SharePoint 2010 integration, Windows XP Professional SP3
Hello, In my job i have to create backup daily….i use isql commands in command prompt…these are the commands i used…. 1)d:2)cd medical_backup*(*folder name) 3)isql -Usa -P 4)dump database medical to”d:/medical_backup/medical_currentdate.bmp” 5)go could u pls tell me the script for it so that i can schedule that script and it will run automatically everyday. thanks.
Answer Question | May 22, 2012 7:39 AM
isql, iSQL commands
How do I change the setting of the lotus notes to do alarm? The alarm always goes off at noon. Any ideas? Thank
Answer Question | May 23, 2012 6:45 AM
Lotus Notes Alarm, Lotus Nots 8.5.2
Hi, I am doing customization of Lotus Notes client to accumulate CRM related functionality. I have added one Hotspot button on Message scrren so that user can invoke CRM functions while composing mail/editing/replying etc. Hotspot button is to be displayed above TO, CC boxes and below advanced Mail options(These oprions are availablle Lotus Notes v8.0 [...]
Answer Question | May 22, 2012 5:59 AM
CRM, Lotus Notes 8.0
Hi, I am trying to extract data out of SAP using VBScript. I remember this worked earlier, but ever since we upgraded to VB7, I am getting an error. Can you please look into this? code: Dim R3, MyFunc, App, objFileSystemObject, filOutput, objmessage As Object Dim nTotalRecords As Long ‘ Define the objects [...]
Answer Question | May 22, 2012 8:20 PM
SAP, VBScript, VBScript Debugging
I’m creating a db to track reports for my organization in Access 2007. We have a unique report numbering system. For example, a report number would be GR-50-12-002, where GR and 50 are constants, 12 is the year, and 002 is the second report issued that year. I want to create a form to add [...]
Answer Question | May 22, 2012 5:42 PM
Microsoft Access 2007, Microsoft Access reports
I know all too well about Level Check in an RPG. Today we had a CLP (doing SNDRCV of a screen file)get this error. Is this something new or merely so rare to get this in a CLP? I recompiled and all seems well, so certainly no urgent problem. V6R1.
Answer Question | May 22, 2012 4:25 PM
AS400/RPG, CLP, SNDRCV
Sir what, Oracle 10g Software is needed to be downloaded from the Internet, for installing it into the system for compiling JDBC java programs. Sir please tell me the reply sir, for the running JDBC java programs.
Answer Question | May 22, 2012 1:30 PM
JDBC, Oracle 10g
AS00 Gurus, I work for a midsized General Insurance Company and our core business application runs in As400, in the exercise to upgrade as400 server hardware and OS, a local IBM reseller is proposing us the following 2 options system p ( Server 8202 Model E4C) + system i OS V6.1 (or) 7402- C08 Deskside [...]
Answer Question | May 22, 2012 1:28 PM
AS/400, Server upgrades
Hi everyone. I’ve a problem with PRAIM’s as400 terminal: when I try to log in, the Enter key doesn’t work (any error message). Instead, if I enter in setup mode the key works fine!! anyone have some ideas of what’s happend?
Answer Question | May 22, 2012 11:16 AM
AS/400, AS/400 terminal
I want to send an email every friday evening at 4PM for reminding them to fill the time sheet…. Please help me out in this how to do this…
Answer Question | May 25, 2012 6:35 PM
AS/400, AS/400 email
How do you reassign important spoolfiles (1000) from one user to another? Example: All spoolfiles owned by userA must now be owned by userB. The SndNetSplf is good for doing a few but not 1000.
Answer Question | May 22, 2012 4:28 PM
IBM i, IBM spool files
Hi all, I’m trying to figure out a way to get multiple subnets to communicate. Here’s the scenario: 2 subnets – 192.168.101.x and 192.168.104.x 1. Router – Linksys RV042. WAN 1 port to internet, LAN port to internal network. Default Gateway with IP of 192.168.101.253. The WAN2/DMZ port is not being used currently. 2. The [...]
Answer Question | June 22, 2012 1:01 PM
LAN port, Linksys Routers
how easy way recover my lost gmail password, email@example.com
Answer Question | May 27, 2012 8:46 AM
I need to edit existing drawings that have been already scanned into our drawing vault, and some of them are saved as .cal file format. Can AutoCAD convert these drawings and open them for editing? There are a lot of them that need to be edited, so I am looking for the most expeditious way [...]
Answer Question | May 18, 2012 8:14 PM
AutoCAD, converting data files, edit, File conversion programs, File formats
Can we do SFTP transfer of files between iseries and Windows. Need the steps to configure the same.
Answer Question | May 18, 2012 12:28 PM
It is alsways a problem to place the logo and title in the correct way while desining a header frame in frameset. Is there a proper solution to do this in a single shot.
Answer Question | May 18, 2012 11:15 AM
Lotus Notes Designer, Lotus Notes Development
I belong to India & have around 5 years of experience in Mainframe. Now i am asked to shift to AS400. I am not able justify this change. Can anyone suggest whether this can have good future prospects?
Answer Question | May 21, 2012 11:07 AM
AS 400, Mainframe
Could you let me know which TCP ports are required to be open for Crystal Reports 2008 please? On the client pc it is installed on.
Answer Question | May 22, 2012 10:30 AM
Crystal Reports 2008, TCP Ports