Questions & Answers

  • Converting Data in Excel to PF on DB2/400

    Hi All, I have data in the excel where each column equal to the field of a physical file. I want load this data into the PF on AS/400. Could any one let me know the process on how to do it. Thanks in advance

    rajsubhyd105 pointsBadges:
  • Character set and code page values for printing from iSeries

    I want to print my PRTF (*AFPDS) in Times New Roman font (size 10 or 12). I think I can do this by giving FNTCHRSET values while compiling my PRTF. I'm not able to find what values can be given for character set and code page for Times New Roman. Please suggest.

    AS400 - Ask the Expert485 pointsBadges:
  • Character set and code page values for printing from iSeries

    I want to print my PRTF (*AFPDS) in Courier New font (size 11). I think I can do this by giving keyword FNTCHRSET values in DDS of my PRTF. I'm not able to find what values can be given for character set and code page for Courier New. Please suggest.

    22917515 pointsBadges:
  • Get all the numbers between two numbers in Oracle SQL

    Does anyone know of a way to select the numbers (or integers) that are included between two numbers with SQL in Oracle? I can't create a PL/SQL procedure for this. Here's an example: I need to get the numbers that are between 3 and 10. Obviously, the results would be 3,4,5,6,7,8,9,10. How can I do...

    ITKE351,290 pointsBadges:
  • Lotus Notes Client and emails display old user name

    We are using Lotus Notes 8.5.3FP6 on a Domino server. I have a user who had a name change right when she started. The change was made throughout the system and it shows up correctly everywhere except in her notes client. The user document has the correct name listed. The change name box shows the...

    jlavin15 pointsBadges:
  • How to calculate the difference between two dates in Oracle SQL

    I have the following table in Oracle SQL: Filename - varchar Creation Date - Date format dd/mm/yyyy hh24:mi:ss Oldest cdr date - Date format dd/mm/yyyy hh24:mi:ss So I need to calculate the difference in hours, dates and also minutes between two dates. How can I do that? Thanks.

    ITKE351,290 pointsBadges:
  • Getting ORA-00905 error message: Missing keyword

    I've been trying to do a SELECT INTO using Oracle. Here's my query: SELECT * INTO new_table FROM old_table; But I keep getting this error: SQL Error: ORA-00905: missing keyword 00905. 00000 - "missing keyword" Has anyone seen this before? If so, what should I do? Thank you very much.

    ITKE351,290 pointsBadges:
  • Delete Administration restrictions from Windows 7 laptop

    I want to remove administrative restrictions from a Windows 7 laptop.

    cdb20825 pointsBadges:
  • Outlook 2007 error: Your IMAP server wants to alert you

    Greetings:  I have moved my aol accounts over to Outlook 2007. I have done this before, and everything worked fine. Got a virus, had to clear everything off, and office depot cleaned it and reloaded Vista and outlook. I reloaded my aol accounts back to Outllook, and I seem to be sending/receiving...

    ITKE351,290 pointsBadges:
  • Logging out in Lotus Notes

    How can I log out in Lotus notes, I accidentally logged-in using a different account and server? Thanks

    LeyYoung5 pointsBadges:
  • Oracle: Escape a reversed word

    Would there be a way to escape a reversed word in Oracle? I think I can use something like this to select the column named table. elect [table] from tablename But how can I do that for reversed words in Oracle? I've tried square braces and double quotes but neither worked. Thank you very much.

    ITKE351,290 pointsBadges:
  • Getting started in Agile

    How do I get started in Agile software development?

    jeremycato5 pointsBadges:
  • Getting a textual representation from an Oracle BLOB

    I've been trying to see, from inside my SQL console, what's inside an Oracle BLOB. I already know that it contains a large body of text and I need to see it. But my query only shows that there's a BLOB in the field. Here's the query: select BLOB_FIELD from TABLE_WITH_BLOB where ID = ''; And this is...

    ITKE351,290 pointsBadges:
  • How to create an AS/400 subfile

    I am trying to create a subfile, so that user can enter in what records they want details for. I keep getting the error Incorrect record number in subfile SFLRCDNBR or SFLSIZ field. What Do I need to do

    lgronewold10 pointsBadges:
  • How to break the login password on Windows XP

    How to break the login password of Windows XP, without using Admin account and without formatting the PC. Is there possible to break password in DOS prompt.

    IT Field5 pointsBadges:
  • One my Microsoft Word documents was damaged

    Hi, Got a big problem. One my document (Word) was damaged, doesn't open... - and I need to print it. I've tried and checked everything that thing suggests, and still no avail! I can't simply write it out again either since it has to be in for Friday and this was at least 23 pages long! Does anyone...

    BrandonSour5 pointsBadges:
  • Create Duplicate Object using CRTDUPOBJ

    I have tried to copy the records from 1 physical file TESTING(PF) to another physical file TESTING1 using CRTDUPOBJ. But after using RUNQRY *N TESTING1 I could not see any records in this help. Can anyone help me?

    Sangay635 pointsBadges:
  • Moving Windows 8 to new motherboard and cpu only

    How do I move Windows 8 to a new motherboard and CPU only?

    JManis15 pointsBadges:
  • SAP Printing

    I've been appointed to implement printing in SAP. My company is doing a ERP over to SAP. Any advise from anyone?

    MikeMiddleton5 pointsBadges:
  • Zend Server on V6R1

    Hi! Could anyone tell me how can I install the Zend Server in our iSeries V6R1. How can I proceed with the initial testing programs?

    Sureyz2,475 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