Questions & Answers

  • The difference between YYYY and RRRR in Oracle SQL

    My partner and I have two different queries in Oracle SQL. Here they are: select trunc(to_date('27-Jul-1987'),'YYYY') FROM dual; And select trunc(to_date('27-Jul-1987'),'RRRR') FROM dual; But both queries are giving us the same result. What's the difference between YYYY and RRRR? We appreciate any...

    ITKE350,300 pointsBadges:
  • General options SAP API / data sync / data query

    Hi everyone! I have a general question concerning SAP API resp. reading SAP data (from transaction queries) and processing in third-party module. Is there a best-practice? Just to make it clear what we need to do I´ll step a little more into detail and our first approaches.. A "mighty" BAPI which...

    LasseKlinger5 pointsBadges:
  • Delphi and Oracle stored procedures

    I'm converting an application from Delphi3 to Delphi5. I have some doubts about Stored procedures. Delphi calling stored procedures in oracle.some parameters value are set as input and passed to oracle. stored procedure in oracle returns some value. in my delphicode when the application reaches the...

    VPL100 pointsBadges:
  • Free IT Book: Mastering the Hype Cycle from Gartner, Inc.

    According to Gartner's 2010 Hype Cycle Report, cloud computing has reached the peak of its hype cycle. This supposedly means that these technologies are heading toward the mainstream, but first is a period of disillusionment for those whose experience didn't match up with their expectations created...

    MelanieYarbrough6,345 pointsBadges:
  • Do I have a virus?

    If I am getting lots of popups coming on most web pages and when I close them down they still appears nothing stops them even Norton's internet security. Also I have been getting phone calls from someone that says my computer is infected and asks me to turn it on so they can talk me through how to...

    AndyAllan15 pointsBadges:
  • How to get different font sizes to print on an iSeries report

    I am trying to change an AS/400 print file so that we can print some fields larger than others. The file is printing to a laser printer via client access print emulation session. I have tried to use the FONT keyword but it's not making a difference. Any ideas how I can accomplish this? Thanks

    Lehanb30 pointsBadges:
  • Outlook 2003 Calendar appointment update failure to invitees

    Appointment manager sends calendar update; Manager's scheduling tab shows that recipients all accepted update; original appointment still shows on recipients' calendar, not the updated appointment that was moved up 2 weeks.

    ExecGirl5 pointsBadges:
  • CRTL + ALT + DEL on a mac running windows

    I have a MACBOOK that i;ve installed windows XP pro on. when I try to get into it by using the FN+CTRL+ALT then backspace keys, it doesn't respond. this is a new mac and I don't know what else I need to try

    Bahlezi140 pointsBadges:
  • Blocking RDP connections to Windows server 2003

    Can I block RDP connections to Windows Server 2003 depending on IP address?

    TeachMeIT975 pointsBadges:
  • Can you force a user input in a SQL statement, then have the statement continue running

    Hi, can one in an SQL statement, when running in SQL, force a user input to be entered and when entered? The SQL continues to complete.

    Bugsy5 pointsBadges:
  • What’s the best external hard drive?

    What's the easiest external hard drive for twice a year backup on lots of photos. 500-750GB.

    Tommm5 pointsBadges:
  • How to import simple spreadsheet into MySQL database?

    I have a simple spreadsheet (only 2 columns) that I need imported into a MySQL database. I can convert the spreadsheet into whatever format I need to (comma delimited), but I need the MySQL commands that will import it. Does anybody know how to do this?

    Ingram871,285 pointsBadges:
  • Database member Cross reference in Qsys? – Where’s it hidden?

    A number of useful objects are in Qsys these days. Items like QADBIFLD are very useful when you want a system wide search for a field. I've been looking for the equivalent for file members. Specifically, I want to search for all occurrences of a given file member name across the system's many...

    Yorkshireman5,580 pointsBadges:
  • Conversion of Oracle trigger to MS SQL

    How can I convert an Oracle trigger into MS-SQL?

    Jannat895 pointsBadges:
  • Benefits of wireless router upgrade

    What are the benefits of upgrading my wireless router to dd-wrt open source firmware? Is it true I can boost my signal? Is it safe? Is there a chance I can brick my router?

    ITKE350,300 pointsBadges:
  • One user in our organization is receiving the same mail twice

    One user in our organization is receiving the same mail twice. What that means is if i send a mail to him he receive it one time and after 5-10 seconds he receives it again. What may be the cause?

    Syntelinc145 pointsBadges:
  • iPhone in Enterprise (Exchange)

    Bleeding edge... I have a 2 server Exchange cluster in the domain. They use shared NAS space to store the mailboxes. I also have a separate server on which the Outlook Web Access is running. (SSL is installed) Where do I setup/configure exchange active sync? And what are the steps to do so?

    Eiorillo25 pointsBadges:
  • Copying/Mirroring 2003 Exchange

    Currently we have a Windows 2003 Server running 2003 Exchange as a domain controller. What we are trying to do is backup and copy our current exchange data to a new server and exchange we have installed. Then mirror the two servers. Shut down the original without having losing email time. Then...

    Dsellari15 pointsBadges:
  • Create a Lotus Notes DB replica for Unique IDs only

    I have a Lotus Notes DB which contains a field populated with a unique id number. I would like an action button to prompt the user for their IDNUm, then once entered it would replicate only those documents where the IDNums match from the server to a local copy. We are currently able to do this...

    IMLearning25 pointsBadges:
  • Exchange 2003/2007 Recipient Policy Problem

    After introducing Exchange 2007 into our 2003 environment we discovered one of our recipient policies was a problem b/c it was created in Exchange 5.5. The recommended solution from MS was to recreate the policy in Exchange 2003 which we did. This created a problem. Once we did what MS said we...

    EastCoastGuy245 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following