• FTP transfer from iSeries to PC workstation

    Hello everyone! Please help me with this question: Is it possible to send save files from iSeries to PC (Win2000 Server) through some batch program? The idea is to make manual connection and FTP transfer and then to create a batch program which would give possibility to schedule this FTP transfer I...

    Dalibor10 pointsBadges:
  • db2/400

    Hi, on db2 hw to give the output query using webquery and consoal? And what is the meaning of webquery and consol?

    I6195 pointsBadges:
  • How to block AS/400 users from using WinSQL

    How can I block AS/400 users to modify data using WinSQL from the PC? Already I have some users that have insalled into their PCs iSeries Access and WinSQL, they run WinSQL that uses an ODBC to change data using SQL sentences. *** WinSQL is universal database management tool that can be used with...

    Maguito5 pointsBadges:
  • SQL Table Join when the name of a column in Table1 equals the value of a column in Table2

    Does anyone know how to write the SQL to join two DB2 tables when the name of Table1.columnA equals the data values stored in Table2.columnB? In the table structure examples listed below, I'm trying to figure out how to join Table1 and Table2 when the values in Table2.Tag_Name are equal to the...

    Bchat5 pointsBadges:
  • Printer Problems since relocation and client upgrade

    Printer will not start. Recently we moved a PC and a printer to a different desk and once everything was hooked back up we can't get the AS/400 to recognize the printer. I get a message that states: Device PAMPRT1 not available. The status is 'Vary on pending'. The spool writer, labeled P9 shows...

    EventHorizon0 pointsBadges:
  • Equivalent of a Application MAKE file on AS400

    I am trying to port a C App from windows to AS400 as well. I used FTP to get the Code and App specific header files. But when it comes to compiling the code I have road blocks as functions defined in a C program is used in another C program and its all dependent on each other and their is no entry...

    Rekhap0 pointsBadges:
  • DB2 UDB for iSeries: Using CPYTOIMPF to trim blanks

    Mark is looking for an alternative to trimming blanks from the end of a record. He writes: "I would like to use the CPYTOIMPF command only if I can Trim Blanks from end of Record. I found out how to do this in FTP, but would really like to stay on this path and avoid FTP using Override Inputs. I...

    MichelleDavidson435 pointsBadges:
  • CPYTOPCD filename length limitation

    Hi all, Am aware of the limitation of the filename (filename.ext) for CPYTOPCD command. eg: 12345678.123 (8chars and ext 3chars). Is there any command that I could use to have my filename as follows: AA12345678.txt or AA12345678 ? Or maybe additional step that I could insert into my CL after the...

    JechLee5 pointsBadges:
  • 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,185 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 ?

    carlosdl69,590 pointsBadges:
  • External DB2 Database link/trigger

    In Oracle I can register a database link to other data sources. For example, through ODBC I have registered DB2 as a database link. In this way I can read/insert/update from/into DB2 tables.

    r.otto810 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?

    ITKE346,425 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:

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