Questions & Answers

  • How to edit a view in DB2

    Hi experts, Would I be able to alter / edit a view in DB2? I would like to use System i Navigator. I don't want to delete it because I'll have to create it again. Thanks!

    ITKE977,875 pointsBadges:
  • SAP ABAP debugging skills for SAP MM consultant

    Dear Experts, What ABAP debugging skills you need to know as a SAP MM/WM Functional Consultant? Cheers! SK

    satish100in15 pointsBadges:
  • iSeries DB2 – Have Physical File need to create Logical File to access Member

    I know very little about the iSeries (I can spell it is all). I am working with an ODBC connection to get to DB2 data on the iSeries. Everything is going extremely well other than 2 files that I need to access use members. These are the only ones that do on the entire system. I was told that I...

    mgrady15 pointsBadges:
  • Backup options for DB2 database

    I have a DB2 database that has over 150 GB of data. I'm using the built-in backup option to back it up daily. Here's my issue - it's taking a long time to finish. Is there another backup option I should look into? Thank you.

    ITKE977,875 pointsBadges:
  • How to get DB2 table name from a column

    My apologizes if this question doesn't make sense at first but I'll give it a shot. I'm trying to find the table name from a column name in DB2. I already have the column name but need to figure out the table name (so I can see which column it should belong to). Is there a query for this?

    ITKE977,875 pointsBadges:
  • Cursor error changing sessions in iSeries for Windows

    When changing sessions using the built-in "session x" keyboard function, sometimes the cursor is positioned in the iSeries portion of the screen, and sometimes it jumps to the Windows menu. It seems to do it most often when changing sessions using a combination of alt-tab and alt x (where x is the...

    kscholle5 pointsBadges:
  • DB2: Find special characters in records

    There are millions and millions of records in my DB2 database. I found several fields with special characters that should not be stored. I believe it may be related to wrong/broken data. Is there a way find these records? Thank you.

    ITKE977,875 pointsBadges:
  • Stop DB2 query from finishing

    For the past few weeks, I've been trying to optimize my query in DB2. But whenever I make a change, it takes forever for the query to finish. It's taking way too much time. Can I see the query and possibly stop them? Thanks!

    ITKE977,875 pointsBadges:
  • iSeries client access Copy to clipboard fails

    Hi, I have an intermittent problem with copy and past from client access for system i. I can be happily using copy and paste from client access to word, or Excel, then for some reason it just quits, and all I get is a beep. To reinstate, I have to exit all the way out and kill the session, and kill...

    Asmithsbs15 pointsBadges:
  • Shrink and grow DB2 string dynamically

    For DB2, does anyone if there's a datatype that would shrink / grow a string dynamically? I need something similar to Varchar(Max). Is there anything out there like that?

    ITKE977,875 pointsBadges:
  • DB2: How to insert a date

    Hi all, I need to insert a date in DB2. It has to be under this format: yyyy-mm-dd How can I do this? Perhaps a SQL query?

    ITKE977,875 pointsBadges:
  • Limit number of deleted DB2 table rows

    I need to add some security measures for when I delete several lines on my DB2 table. Basically - I need to limit how many rows are deleted. Something similar to how MySQL works with limiting rows in a deletion. Can anyone help me out?

    ITKE977,875 pointsBadges:
  • Call stored procedures asynchronously on DB2 database

    I'm working on a DB2 database - would I be able to call my stored procedure from another procedure asynchronously? Thanks so much.

    ITKE977,875 pointsBadges:
  • What is NFV-DPI?

    Can anyone tell me what NFV-DPI is?

    Waseemltii5 pointsBadges:
  • Are differencing disks and VMware linked clones implementation the same technically?

    Are differencing Disks, VMware linked clones implementation same technically?

    RajaKT20 pointsBadges:
  • CAD in the Cloud

    I am looking to ritualized by SolidWorks. How can I do that?

    temguthrie5 pointsBadges:
  • How to view .HPG file

    What can I use to view an .HPG drawing?

    perket15 pointsBadges:
  • Inactive on DISA report

    Why is there a inactive on my DISA report?

    facemakers5 pointsBadges:
  • Wi-Fi loaded on Amazon Alexa

    How do I get Wi-Fi on to Amazon Alexa?

    Joslynangus5 pointsBadges:
  • What are the types of resistors?

    Can someone explain to me what are the different types of resistors?

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

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

Following