Questions & Answers

  • How to select Oracle TOP 10 records

    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,...

    ITKE351,905 pointsBadges:
  • Suppressing a Subreport

    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.

    lumina955 pointsBadges:
  • What is EML0023 error message?

    Using ESEND function. Getting EML0023 message.

    Steve4004850 pointsBadges:
  • FTP transfer to a local server

    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?

    rharvey25 pointsBadges:
  • How do I connect to AS/400 Database from Visual Studio

    I would like to connect to AS/400 DB from .Net 3.5. Can anybody help me with this?

    SriramM5 pointsBadges:
  • Find out if a transaction is pending in Oracle

    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...

    ITKE351,905 pointsBadges:
  • AS/400: Load all subfiles

    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.

    chowas400510 pointsBadges:
  • How to create a single admin account for 7 different domino domains?

    Hi, How can we create a single domain admin account for 7 different domino domains in a lotus environment?

    Mohit04130 pointsBadges:
  • Oracle TNS Listener Remote Poisoning

    What is the fix on Oracle TNS Listener Remote Poisoning?

    subahshd5 pointsBadges:
  • Read a file in 2 times in CLLE using POSDBF

    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)...

    chowas400510 pointsBadges:
  • What is Bitcoin?

    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

    AshishSingh10770 pointsBadges:
  • How to store only time in Oracle

    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!

    ITKE351,905 pointsBadges:
  • How to fix “format Error: not a PDF or corrupted”

    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...

    richardgehrig5 pointsBadges:
  • How to repair my Outlook personal folder file?

    How to repair my Outlook personal folder file & fix “Cannot start Microsoft Outlook. Unable to open Outlook window” error?

    oliviaolivia135 pointsBadges:
  • Connecting Visual Basic and SQL Server

    After creating ODBC, what code will connect the front-end Visual Basic and the back-end SQL Server?

    SQL Server Ask the Experts2,585 pointsBadges:
  • What is the AS/400 PCL command for 39 barcode?

    what is PCL command for 39 barcode sent from AS400

    Bamer15 pointsBadges:
  • Is it too late for me to change careers?

    Hello to all, I am new here and I thought this would be a great place to start. I am very interested in programming but have no programming background. I have a background in networking as a network Engineer but would like to jump track and move to developing. I have a little experience with VB but...

    Wannabe310 pointsBadges:
  • Check AS/400 password in PC environment

    I have a VBasic input program on PC which data will eventually be inserted into a physical on AS/400. I would like to make the users to login this PC program. Is it possible to verify their IDs and passwords against those on AS/400? If possible, how am I going to do that? I know it is impossible to...

    Snd2patrick5 pointsBadges:
  • How to I restore Outlook invitation onto my calendar

    I accidentially deleted an outlook invitation I sent to many co-workers. I need to reinstate it in my calendar. Others are able to reply to the invite, but the event no longer exists on my end. I would like to move it back into my calendar without having to send a completely new invite. How do I...

    Vfallavev5 pointsBadges:
  • Store and retrieve image using SQL database

    How can I store and retrieve images using a SQL database?

    RAJA12us285 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