• QMF issue

    I have my QMF for windows version 8.1 Fix Pack 13, and I try to run this instruction INSERT INTO destination table SELECT * FROM origin table and every time I receive this error message: An error occurred while running the query. destrination table not valid for operation. (SQL code = -7008, SQL...

    Tiburonblanco80 pointsBadges:
  • Changing DB2 Short or Internal Names

    We never drop and recreate tables in production. We do regularly in test. Recently we used the ALTER statement to remove a column in a table. The internal or short name was obviously MAX_P00001 because now we only have a MAX_P00002 and a MAX_P00003(using DSPFFD). In test, the table has MAX_P00001...

    RodVerity20 pointsBadges:
  • Access 2003: Can’t filter Part-no’s by highest $Spend Plant/Site

    I have a file of Part-no with the spend by Plant (or Location).  A given Part-no may have multiple records for the different Plant Locations. I am trying to capture one record for each Part-no that included the Plant with the highest spend and what that amount is. I tried to do a summary query...

    GatorRobNC5 pointsBadges:
  • Procedure Pointer

    How to use a procedure pointer? Other than procedures where pointers concept can be applicable in AS/400?

    Kar425 pointsBadges:
  • SQL query help

    Below is a list of the query that I am working on. There are part numbers that may be match to more than one module number. What I need is to show only the part numbers for the list. These part numbers I need a list of only one part number for each group. PartNo------ Module------ Numbers...

    CompEng1,240 pointsBadges:
  • Having trouble with DB2/400 UDF returning a table.

    I've written a test RPGLE program (not a service program) to return a table that for testing puposes I'm returning 1 row and 1 hard coded return column that is defined as varchar. I'm building the return value by concatonating the input parameters. Anyhow I tried running it using interactive SQL. I...

    Dwk0015 pointsBadges:
  • Oracle acquires SUN: implications ?

    What do you think will be the implications of Oracle's Sun acquisition on: The future of MySql ? The virtualization market ? The hardware market ? The operating systems market ? Other IT fields ?

    carlosdl70,200 pointsBadges:
  • Error message in window subfile

    i have window subfile. Error message is showing behinde the window. It should show within the window. Following is my coding A R SFLMSGW SFL A SFLMSGRCD(15) A MSGKEY SFLMSGKEY A PGMQ SFLPGMQ(10) A R SFLMSGWC SFLCTL(SFLMSGW) A OVERLAY A PUTOVR A 97 SFLDSP A 97 SFLDSPCTL A 97 SFLINZ A 98 SFLEND A...

    Zahidm0 pointsBadges:
  • AS400, SQL and COBOL anomalies

    I coded an update query in COBOL and included COMMIT=NONE so the update could go through. When the COBOL program executed it returned nulls, and coalesced the value to the default. When the query was executed either through qmqry or on-line on the sql screen it worked fine and updated the field...

    matis75 pointsBadges:
  • What are the points to be taken care of when designing a database on Linux?

    What are the points to be taken care of when designing a database on Linux? What are the different replication methods available?

    ITKE351,965 pointsBadges:
  • Database restore

    I'm struggling with when is the right time to do my last transactional log backup before my full database backup. My question is this: if I do a full db backup once a day at 10pm; and a tran log backup every 4 hours (12pm, 4am, 8am, 12am, 4pm, 8pm). If i have to restore the db to a point in time,...

    Thedbaed5 pointsBadges:
  • MS Access – Create Median Aggregate Function

    Is it possible (and has anyone done it yet) to create additional aggregate functions in MS Access (I'm using 2007)? In particular, I want to create "Group By" queries that calculate the Median of each group. I have a median function that works on entire columns (or subsets) individually, but it...

    Cantrell10 pointsBadges:
  • Upgrading ODBC driver for iSeries

    Im running iSeries Access for Windows V5R3. My current iSeries ODBC for Windows driver is v10. I would like to upgrade it to v11. Does anyone know how to do this without updating iSeries Access for Windows client on my pc? I need to leave it at V5R3.

    Nhanold5 pointsBadges:
  • MySQL database size

    Is there a limit on database size for MySQL? my database is getting on the large zise will this effect proformance?

    Worktopm5 pointsBadges:
  • Restoring a dtaq in iseries.

    I need to know if there is a way to save a data queue with some entries in it, and then restore the data queue in the same or other library with its entries included. When i do that, the dtaq is empty. If someone knows how to do that, please tell me. Thanks.

    Moreira0 pointsBadges:
  • How to use SQL to filter columns in a spreadsheet.

    I have a query that is listed below. I need to develop a statement that would filter the month and the year as well as the Phase informaton in the access table.  __________________________________________________________________ Select INMSP300.M3OE# as "OENo", INMSP300.M3OEC as "ComprsOE",...

    CompEng1,240 pointsBadges:
  • AS/400 file transfer window disappears

    as400 file transfer window drops to the bottom never to return.

    Dothendo15 pointsBadges:
  • get a anr record from databse by using max (one Field) and orderby (one filed) desc

    Hi, I have a table. It can have multiple records for the key value. Ex secid   time       source 1       02:04    a 1      02:04    b 2 3 Now i want only one record of secid for a descending orderby of (source) and for a max time stamp. and later i will join the secid with...

  • The most-watched IT questions this week: Oct. 20, 2009

    Here are the 5 most watched questions on ITKE: There's some great discussions going on ranging from SQL to diagnosing app crashes. Go answer a question now and take your shot at winning a TV, or check out the rest of the top 10 on the Community Blog: 1.ORA-31672 in oracle 11g tops the list, with...

    Michael Morisy8,323 pointsBadges:
  • STORED PROCEDURE

    Hi All i search to make procedure in strsql please can anybody help me and search code open text file from the procedure and put data on  it  

    AS400SQL25 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